Hi, can someone help me here! :( I can't query the data on my sql from php. db is fine, i couldnt see the prob in php! pls help, ty.
# MSQL ####################################################### mysql> desc members; +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | id | tinyint(5) | | PRI | NULL | auto_increment | | ircname | varchar(30) | YES | | NULL | | | email | varchar(30) | YES | | NULL | | | realname | varchar(40) | YES | | NULL | | | asl | varchar(30) | YES | | NULL | | | info | varchar(70) | YES | | NULL | | +----------+-------------+------+-----+---------+----------------+ # PHP ######################################################## <html> <body> <?php $db = mysql_connect("my_db_host", "my_db_user", "my_db_pass") or die("Could not connect"); mysql_select_db("mydb",$db); $result = mysql_query("SELECT * FROM members",$db); 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]