I think you need while loop here.

>
> $result = mysql_query("SELECT * FROM members",$db);

while ( $row =mysql_fetch_object($result))
{

>
> printf("ircname: %s<br>n", mysql_result($result,0,"ircname"));
> printf("email: %s<br>n", mysql_result($result,0,"email"));
> printf("realname: %s<br>n", mysql_result($result,0,"realname"));
> printf("asl: %s<br>n", mysql_result($result,0,"asl"));
> printf("info: %s<br>n", mysql_result($result,0,"info"));
>
}


> ?>
>
> </body>
> </html>
>
>
> # ERROR ############################################################
>
>
>   Warning: Supplied argument is not a valid MySQL result resource in
> /mnt/host-users/cavite/irc/members/t2.php on line 13
> ircname:
> n
> Warning: Supplied argument is not a valid MySQL result resource in
> /mnt/host-users/cavite/irc/members/t2.php on line 14
> email:
> n
> Warning: Supplied argument is not a valid MySQL result resource in
> /mnt/host-users/cavite/irc/members/t2.php on line 15
> realname:
> n
> Warning: Supplied argument is not a valid MySQL result resource in
> /mnt/host-users/cavite/irc/members/t2.php on line 16
> asl:
> n
> Warning: Supplied argument is not a valid MySQL result resource in
> /mnt/host-users/cavite/irc/members/t2.php on line 17
> info:
> n
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to