Hi Ronneil,
It's working now, thanks! :)
--gene
On Wed, 29 Mar 2000, Ronneil Camara wrote:
> Ok, then do this
>
> add these line after $result = MYSQL_QUERY($query);
>
> $number = MYSQL_NUMROWS($result);
> i = 0;
>
> IF ($number == 0) :
> PRINT "<CENTER><P>No records found!</CENTER>";
> ELSEIF ($number > 0) :
> PRINT "<CENTER><P>There are $number records<BR><BR>";
> WHILE ($i < $number):
> $name = mysql_result($result,$i,"field1");
> PRINT "Record $i is $name<BR>";
> PRINT "<BR><BR>";
> $i++;
> ENDWHILE;
> PRINT "</CENTER>";
> ENDIF;
>
> NOTE:
>
> 1. Be sure that field1 exist as a column. Para huwag kang malito, I changed
> variable $field1 into $name
>
> Hope this helps. The code I gave you is working fine with my mysql & php.
-
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
