EPIC Bookstore
query($sql1); $i=0; if ($result1->num_rows > 0) { while($row = $result1->fetch_assoc()) { $id = $row["id"]; $lastname = $row["lastname"]; $firstname = $row["firstname"]; $short_bio = $row["short_bio"]; $photo = $row["photo"]; $member_id = $row["member_id"]; $title = $row["title"]; $buy_link = $row["buy_link"]; $publisher = $row["publisher"]; $year = $row["year"]; $author = $row["author"]; $coverart_filename = $row["coverart_filename"]; $ASIN = $row["ASIN"]; if ($i==0) { echo "".$firstname." ".$lastname."
".$firstname." ".$lastname." ".$short_bio."";
echo "
";
}
echo "\n
";
$i=$i+1;
if (($i==3) || ($i==6) || ($i==9) || ($i==12)) echo "
".$title."
".$publisher." ".$year."
";
else echo "
";
}
}
$conn->close();
?>