Good day, morning, night? It's dark, so that makes it sleepy bye time. Bit before I do, I'm trying to work this out. I have a little bit of code to print Next n>> articles in my database. Can someone help me straighten out these lines of code, pretty please ... before I go fleeping nuts :)
if(!$rendu) { $rendu = 0; } $nombre = 10; $news = mysql_query("select * from $table ORDER by DT desc"); $num_rows = mysql_num_rows($news); $nouveau = $rendu + $nombre; if ($nouveau < $num_rows) { if ($nombre < $num_rows) { $nouveau = $num_rows - $nombre; #when there are 23 articles, and I am number 20 on the screen, I want to display the remaining 3, not ten. } $myinsert = " <font face=\"arial\" size=2><A HREF=\"index.html?rendu=".$nouveau."\">Next ".$nouveau." Articles >></a></font>\n"; } John ################################################################################ <?php if(!$rendu) { $rendu = 0; } $nombre = 10; ################################################################ #$myconnection = mysql_pconnect($server,$user,$pass); $myconnection = mysql_connect($server,$user,$pass); mysql_select_db($db,$myconnection); $news = mysql_query("SHOW TABLE STATUS FROM ".$db." LIKE '$table'"); while ($news_story = mysql_fetch_array($news)) { $table_comment = $news_story['Comment']; } $news = mysql_query("select * from $table ORDER by DT desc"); $num_rows = mysql_num_rows($news); $news = mysql_query("select * from $table ORDER by DT desc LIMIT $rendu,$nombre"); $old_WHO = ""; while ($mydata = mysql_fetch_object($news)) { $mydata->RQ = str_replace("\r", "", $mydata->RQ); $mydata->RQ = str_replace("\n", "<br>", $mydata->RQ); $mydata->RQ = str_replace("<br><br>", "<p>", $mydata->RQ); $mydata->CM = str_replace("\r", "", $mydata->CM); $mydata->CM = str_replace("\n", "<br>", $mydata->CM); $mydata->CM = str_replace("<br><br>", "<p>", $mydata->CM); ############### Display WHO Once ######## if ($old_WHO != $mydata->WHO) #when WHO occurs the first time, echo it once only. { $old_WHO = $mydata->WHO; $body .= "<b>From ".$mydata->WHO.":</b>"; } ############## Description ############### if($mydata->RQ) $body .= "<ol>".$mydata->RQ."</ol>\n"; ############## Description ############### if($mydata->CM) $body .= "<ol><small>".$mydata->DT." - <font color=\"blue\"><i>".$mydata->CM."</i></font></small></ol><br>\n"; }#end of while mysql_close($myconnection); ##################################################### $nouveau = $rendu + $nombre; if ($nouveau < $num_rows) { if ($nouveau < $num_rows) { $nouveau = $num_rows - $nouveau ; } $myinsert = " <font face=\"arial\" size=2><A HREF=\"index.html?rendu=".$nouveau."\">Next ".$nouveau." Articles >></a></font>\n"; } ##################################################### echo "<h2 align=center>".$table_comment."</h2> <ul> <h3>$course_description</h3> .. $myinsert<br> .. $num_rows<br> .. $nouveau = $rendu + $nombre<br> if ($nouveau < $num_rows)<br> <ol> $body </ol> <hr> </ul>"; ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php