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 " Subject:<b><font color='red'> " . $row2['Subject'] . "</font></b>";
echo "<br />Message: <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!
No comments posted yet
Your Answer:
Login to answer
119 
50 
Other forums
small inaccuracies
I have this code to convert fractional base 10 into base 2:
while($num > 0)
PHP & Java
Hello,
can PHP code be used inside java code?
Code: [Select]<SCRIPT LANGUAGE=&q
the problem with str_replace
$str="hahahahahahahahahahahahahaha";
$nn=1;
$str=str_replace('ha','MyGod',$str,$nn);
frame help
on the bottom frame is menu.html
Code: <body><form action='link.php' met
If a form submits back to same page do you need to use $get
IM trying to pass page number and year that was selected back to the same page.
i have this c
IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying
phpMailer will not connect using SMTP
I am trying to use phpMailer with smtp:
Code: [Select]$mailer = new PHPMailer();
$mailer-&
Problem with umlauts and UTF-8
Hello every1,
I'm creating my own little CMS at the moment and got some problems with the cha
Help with explandable category tree
I have the below query:
SELECT l1.id as lev1_id,l2.id as lev2_id,l3.id as lev3_id,l1.categ
rand() function
just a general question guys a girls, is the rand() function 100% random or is it based on time?
