Display 3 records at a time
I'm trying to display the newest 3 news posts and than give the user the option to press a button to display the next 3 and so on
I've been at this for hours and I'm pretty sure my php is good i think I'm getting confused with the action script on the button so ill post both my php and button code see if anyone else has a fresh view
$records_displayed = 3;
if ( !isset($low)){
$low = 0;
}
if (!isset($high) ){
$high = $records_displayed;
}
$conn = db_connect();
$sql = "SELECT * FROM news_post ORDER BY id DESC";
$max_results = mysql_query($sql, $conn) or die(mysql_error());
$count = mysql_num_rows($max_results);
print "&max_records=";
print "$count";
$sql = "SELECT * FROM news_post ORDER BY id DESC LIMIT $low, $high ";
$result = mysql_query($sql, $conn) or die(mysql_error());
if (($low < 0) || ($low > $count)){
print "&left=No More Entries.";
}
else { print "&left=";
}
print "&news=";
while ($newArray = mysql_fetch_array($result)) {
// give a name to the fields
$id = $newArray['id'];
$name = $newArray['name'];
$headline = $newArray['headline'];
$post = $newArray['post'];
$date = $newArray['date'];
print "<P><b><font color=\"#000000\">[$id] $headline <br> <font color=\"#CC6600\">$post <br><font color=\"#000000\">By: $name Posted: $date <br><font color=\"#CC6600\">§§§§§§§§§§§§§§§§ §§§§§§§§§§§§§</P>";
}
on (press) {
low = Number(low)+Number(3);
high = Number(high)+Number(3);
loadVariables("http://MYSITE/MYFOLDER/news.php?low="+low+"&R="+random(999) , POST);
}
I don't get any errors just nothing happens when i press the button
and as u can see in the php code i added prints to make sure the data was even spitting out
Thnx in advance