Add 5 to a variable when a button is clicked, and re-run a for loop

Posted on 16th Feb 2014 07:03 pm by admin

So I'm making a feedback sort of section on a website with MySQL and PHP, I've gotten the script to do everything I want except for this. I want the script to only show 5 at a time (which i have accomplished no problem), but I'm also trying to make it so that when the user clicks a button it will show the next 5 records in the database so they can view all records, but only 5 at a time. (I hope this makes sense). So I need the button to add 5 to my $start variable, and then re-run my for loop.


$start = 0;
echo $start . "<br /><br />";
$result2 = mysql_query("SELECT * FROM testtable LIMIT $start,5") or die(mysql_error());
$row2 = mysql_fetch_array($result2);

for($counter = 1; $counter <= 5; $counter += 1)
{

echo $row2['ID'] . "<br />";
echo "&nbsp;&nbsp;Subject:<b><font color='red'>&nbsp;" . $row2['Subject'] . "</font></b>";
echo "<br />Message:&nbsp;<b>" . $row2['Message'] . "</b><br /><br />";
$row2 = mysql_fetch_array($result2);

}

mysql_close($con)
?>


<br />

<form>
<input type="button" value="submit" onclick="<?php $start += 5; ?>" />
</form>

<?php echo $start; ?>

Any help would be greatly appreciated!

Your Answer:

Login to answer

Other forums

can i optmize image to 50% quality before uploading 2 server
Hi there

i have jus written a php program to upload and display images but when i try to uplo

Is STL important?
I'm just starting programming and I've made it until the Standart Template Library. But the chapter

How to display objects in a row
I have 7 codes that i want to display in a row one next to another.
The first is {$ads->ad

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system

How to clone an SAP ECC using bacup tape on z/os?
We want to clone our production to a different SID using backup tape.

remove trailing slash from array
I have the following array which contains trailing slashes I need to remove. What is the best way to

Amend code to allow multiple attachments
Hi

I have a php page that allows the user to browse to a file (image) then sumbit, the confi

Undefined offset when using a flat file with pipe symbols
Hi, I've got a flat file/text file which I'm currently using as a member database for my site (not a

UDS 4.0 Datatype issue
UDS 4.0.322 -- connecting to NI Labview 9.0

When using connection method: Cache with live