I am trying to create a photo rating system, in which a new picture is associated with a id and page. So I can click next/previous buttons to get to a new picture. I am close, but when I try to display the picture it comes out all jibberish.
[php]<?php
$connect = mysql_connect(“localhost”,“drewgarc_drewman”,“fakepw”) or die(mysql_error());
mysql_select_db(“drewgarc_videocontest”) or die(mysql_error());
if (isset($_GET[‘page’]))
{
$page=$_GET[‘page’];
$page=mysql_real_escape_string($page);
}
else
$page = 1;
?>
<?php $result = mysql_query("SELECT * FROM Users", $connect); $rows = mysql_num_rows($result); $per_page = 1; $total_pages = ceil($rows/$per_page); echo "You are on page $page of $total_pages"; if ($page != 1) { echo " First "." "; $previous = $page-1; echo " Previous "; } if (($page != 1) && ($page != $total_pages)) echo " | "; if ($page != $total_pages) { $next = $page+1; echo " Next "." "; echo " Last "; } echo "
"; $x=($page - 1) * $per_page; $sql = "SELECT * FROM Users limit $x , $per_page"; $result = mysql_query($sql, $connect); while ($myrow = mysql_fetch_array($result)) { echo "Picture ID:"; echo $myrow['id']."
"; echo "Rating:"; echo $myrow['rating']."
"; header("Content-type: image/jpeg"); echo $myrow['image']; } mysql_free_result($result); ?> [/php]
Heres a picture of what I mean:
