hi guys
im trying to retrieve 5 record each page from my db
my code iz :
$query_nme = "SELECT firstName, lastName, title, summary FROM ctnt_inf
where ctnt_id ORDER BY RAND() LIMIT 5";
$query_result_handle_nme = mysql_query ($query_nme)
or die ('qry failed ! DA tbl must xixt in DA db specifyd bov ....');
echo("<p><font align=RIGHT>");
for ($cnt=0; $cnt<=5; ++$cnt ) {
$row_nme = mysql_fetch_row ($query_result_handle_nme);
echo ("<br><br>");
$tID = $row_id[0];
$tName = $row_nme[0];
echo ( $tID );
echo ( $tName );
} // echo ("<br><br>");
echo("</font></p>");
problem:
it only displays firstName n nothing else .... though 5 random first names
but
i guess i'll ve to make seperate query fo each field in the table
or will i ????
thnx a million .....
toby .....
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
