[PHP-DB] Gathering data from a database
I have been having this problem for a while now, and I cant figure it out. the code is: ? $host = localhost; $uname = sniper; $pass = starcraft; $database = sha; $tablename = members; $connect = mysql_connect ($host, $uname, $pass); $select = mysql_select_db ($database); $query = SELECT * from $tablename; $result = mysql_query ($query, $connect); while ($row = mysql_fetch_array($result)) { print_r( $row ); echo mysql_error(); } ? mysql has an error on line 19. Line 19 is while ($row = mysql_fetch_array($result)). What am I doing wrong? Thanks for your help, Mike
Re: [PHP-DB] Gathering data from a database
on 3/22/03 8:26 PM, Mike Delorme at [EMAIL PROTECTED] appended the following bits to my mbox: $select = mysql_select_db ($database); Remove the quotes around this. Actually, there is no reason to do the variable assignment either. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Gathering data from a database
Hi, $select = mysql_select_db ($database); like Mike said you don't need to have this in and no need for a var to be assigned... Then when you want to print out the data print_r( $row ); you can use $row['table_row_name']; :) Adam At 08:26 PM 3/22/2003 -0500, you wrote: I have been having this problem for a while now, and I cant figure it out. the code is: ? $host = localhost; $uname = sniper; $pass = starcraft; $database = sha; $tablename = members; $connect = mysql_connect ($host, $uname, $pass); $select = mysql_select_db ($database); $query = SELECT * from $tablename; $result = mysql_query ($query, $connect); while ($row = mysql_fetch_array($result)) { print_r( $row ); echo mysql_error(); } ? mysql has an error on line 19. Line 19 is while ($row = mysql_fetch_array($result)). What am I doing wrong? Thanks for your help, Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php