Simple SQL question

Serbaside

What I am trying to do is to create a SQL driven "image viewer" of sorts, very basic.
I have set up the database and have successfully imported the data. Heres the problem, I cannot figure out how to go to the next "row" (thats the term I will use).

Actual page (http://www.namelesscreations.com/new/work.php)

Here is how I am trying to do it, when the user click the back or next it increase or decreases a counter:

echo " <input type=submit name=submit value=> onclick=&counter++ >" ;

yes, this does not work, that is my problem.

This counter adjusts the query:
$query="select * from gallery where number=$counter";

Since each "row" has its own number (starting with one) then the user can click through each "row".

Am I not even going about this correctly? Is there a easy fix that am I just over looking?

I've been messing with this for days and cannot figure it out, if you could please help that would be great.

Thanks, Jeff McKinney.

Weedpacket

You're confused about the difference between running programs on the server and programs on the client. PHP doesn't run on the browser.

Try something like this:

<form action="---the name of this page---">
<input type="hidden" name="currentrow" value="<?php echo $counter?>" />
<input type="submit" name="submit" value="&gt;" />
<input type="submit" name="submit" value="&lt;" />
</form>

And then in your PHP script

if($_GET['submit']=='>')
{
  $new_row = $_GET['current_row']+1;
}
elseif($_GET['submit']=='<')
{
  $new_row = $_GET['current_row']-1;
}

Serbaside

I understand what you mean now about the processing but the script does not want to increment the $new_row variable, it stay 1 if counter is 1.

EDIT - Ok I got it to increment. You had put a underscore on one and not the other...I think I'm almost there.

EDIT #2 - The problem now looks to be that the page is not updating. I echoed variables on the script page and everything increments but as it reloads the orginial page, the same data is there.

Weedpacket

Well, you'd use for "$new_row" whatever it is you're using to decide which row to display, however it is you're using it to display it.

Serbaside

I'm still not doing something right, it does go to the next row on the processing side. But the browser side doesn't see a change as it returns.

I am using:

$counter=1;

if($_GET['submit']=='>')
{
  $counter = ($_GET['currentrow']+1);
}
elseif($_GET['submit']=='<')
{
  $counter = $_GET['currentrow']-1;
} 


$query="select * from gallery where number=$counter";

$result = mysql_query($query);
$r=mysql_fetch_array($result);

   $number=$r["number"];
   $name=$r["name"];
   $created=$r["created"];
   $height=$r["height"];
   $length=$r["length"];
   $width=$r["width"];
   $type=$r["type"];

header("location:work.php");

to return to the browser. Is that not what I should do?

My other problem might be I am including the processing page in the header

<head>
...
<?php include ("content.php"); ?>
</head>

<body>
...
	<td width="420" bgcolor="#E5E5E5" align="center">
	<?php	 	
	echo "<img src=gallery/$number.jpg>";
   	echo "<br> $name <br> $created <br> $height x $length x $width";
   ?>
</td>
    <td width="40" bgcolor="#E5E5E5" align="left">
		<form action="content.php">
			<input type="hidden" name="currentrow" value="<?php echo $counter ?>" />
			<input type="submit" name="submit" value="&gt;" />
			<input type="submit" name="submit" value="&lt;" />
		</form>
	</td>
...
</body>

I'm doing the so the browser can echo the values