"toby -" <[EMAIL PROTECTED]> wrote on 09.07.2002 11:35:40:
Hi Toby,
>
>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
^^
I think you should include "id," to get the row id
>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];
^^^^^^^^^^
If you include id in the query this should read $row_nme[0]
> $tName = $row_nme[0];
^^^^^^^^^^
If you include id in the query this should read $row_nme[1]
You can retrieve the other fields by using an increasing index (i.e.
$row_nme[2], $row_nme[3]...)
> 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 .....
Bye Oliver
--
Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5%
attention to detail.
Oliver Six, CEO
CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen
Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42
---------------------------------------------------------------------
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
