Need Help With A Looping Problem

chelsea7

Hello again folks,

I'm still having problems retrieving records. What I'm trying to do is have one image display on the screen at a time. In other words lets say record 1 has the link to an image. The image is displayed. I would then like to have the user modify the record and then the next record is displayed. (I.E. voting on artwork.). I have no problem with modifing records.

I came to the conclusion based on my situation that I would like to have a loop command. Something like the script below;

$count=1;

$query = ("SELECT * FROM myimagexx where ID=$count" );

$result = mysql_query($query) or die("Query failed : " . mysql_error());

$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

/ Printing results in HTML /
print "<br>";

while ($row= mysql_fetch_array($result))

{
print "<table width=75% border=1>\n";
print "<td width=8%>";
echo '<img src=' .$row['imagefilepath']. '>';

 print "</td>";

 }

What I want this script to do is simply give me the total number of rows in the database, which it already does. Then do a comparison with the where or limit command. Something like total number of records is lets say 123. Now if the count is less than the total number of records, then loop,wait for user interaction then display the next record and so forth until it reaches the last record.

Is there a simple way to do this? I know that if I could loop it, I could pass the increments of $count to the where or limit command. This would advance the record. It's just a question of how to code it correctly.

I've been trying to look this on up for some time.

Any assistance would greatly be appreciated,

Thank you.

helz

like you said if the loop is only bringing up one result then you could include:
$count=$count++;
into the loop to do some incrementing
then using the form to change the record of the image you just loop it back onto itself so that the new $count loads up the next image.
then use an if statement to find out whether its at the end of the list:
if ($count==$num_rows) {
echo "You have completed the survey.";
} elseif ($count < $num_rows) {
//image viewing / editing script here
}

hope this helps

=========new edit===============
also the submit button would have to point to ".$PHP_SELF."?count=$count

so that the incremented count will be selected not the one at the top of the page.

actually i think it would work, not sure tho, whether it will choose the one at the top of the script or the incremented one at the bottom.

steadyguy

chelsea, unless I'm misunderstanding you, the loop you described will have to call the page repeatedly. In simplified terms: the user clicks on a link, then sees a single photograph. Now, unless you want to use JavaScript to swap the photo out for another, they will need to click on another link - or be JavaScript redirected to the next photo. (In the latter case, it'd be good to have a link, too, for usability reasons - some people don't like JavaScript).
But this leaves you with the question of the structure for your PHP page.

This is a rough sketh of what I would do:

$_GET['page'] ? $page = $_GET['page'] : $page = 1;
$query = "SELECT filename FROM myimagexx WHERE ID='$page'";

$conn = @mysql_connect('localhost', 'user', 'pass');
if ($conn) {
    mysql_select_db('dbName');
    $result = mysql_query($query);
    $extract($result);
    print '<img src="$filename" />';
    $page++;
    print "<a href=\"yourscript.php?page=\"$page\">Next Photo </a>";
}

This script checks for a GET variable called page (the one that tells you which photo you want), and if it doesn't find it, sets $page to the first page: 1.
Then it gets the filename from the db, and prints the photo, increments $page, and finally, prints a link to the next photo.

Is that what you were looking for?

(NOTE: Be sure to check that $_GET['page'] is a series of 0 or more digits with a ctype_digit() (if the ctype functions are installed), or a regex function, before you assign it - otherwise someone could come along, and do some really mean stuff ....)