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