[PHP] dumb mysql_connect issue
Is there anything (add. parameters, etc.) that I'm missing that would possibly explain why the following code won't execute? ?php $connection = mysql_connect(hostname,username,password) or die (Couldn't connect to server); $db = mysql_select_db(database, $connection) or die (Couldn't select database); $sql = SELECT * FROM table_name.column_name1, table_name.column_name2; $sql_result = mysql_query($sql,$connection) or die (Couldn't execute query); ? Thanks in advance. This mailing list rules!!! __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- PHP General 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]
Re: [PHP] dumb mysql_connect issue
CGI GUY wrote: Is there anything (add. parameters, etc.) that I'm missing that would possibly explain why the following code won't execute? What does it say? Any errors? Are any of your messages printed? regards Wagner -- Madness takes its toll. Please have exact change. -- PHP General 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]
Re: [PHP] dumb mysql_connect issue
Try putting mysql_error() in your die statements so : or die(mysql_error()); and see what it tells you. Regards, Philip On Tue, 31 Jul 2001, CGI GUY wrote: Is there anything (add. parameters, etc.) that I'm missing that would possibly explain why the following code won't execute? ?php $connection = mysql_connect(hostname,username,password) or die (Couldn't connect to server); $db = mysql_select_db(database, $connection) or die (Couldn't select database); $sql = SELECT * FROM table_name.column_name1, table_name.column_name2; $sql_result = mysql_query($sql,$connection) or die (Couldn't execute query); ? Thanks in advance. This mailing list rules!!! __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- PHP General 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 General 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]
Re: [PHP] dumb mysql_connect issue
or, echo $sql and copy/paste it into an sql client and see what it tells you. on 7/31/01 4:21 PM, Philip Olson at [EMAIL PROTECTED] wrote: Try putting mysql_error() in your die statements so : or die(mysql_error()); and see what it tells you. Regards, Philip On Tue, 31 Jul 2001, CGI GUY wrote: Is there anything (add. parameters, etc.) that I'm missing that would possibly explain why the following code won't execute? -- mike cullerton -- PHP General 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]
Re: [PHP] dumb mysql_connect issue
on 7/31/01 4:10 PM, CGI GUY at [EMAIL PROTECTED] wrote: Is there anything (add. parameters, etc.) that I'm missing that would possibly explain why the following code won't execute? snip in FROM table_name.column_name1,table_name.column_name2 table_name.column_name1 is a column, but FROM expects a table. try select table_name.column_name1,table_name.column_name2 from table_name -- mike cullerton -- PHP General 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]
Fwd: Re: [PHP] dumb mysql_connect issue
Okay, well I used the mysql_error() print-out, and it returned something weird: Access denied for user: 'username@hostname' to database 'tablename' This is incongruous because: 1. The uid/password set I am using has full privileges. 2. *tablename* is not a database (the code I listed in my previous email is syntactically identical to the script)-- it's a table. Why is this happening to me?!?! ;) Note: forwarded message attached. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ or, echo $sql and copy/paste it into an sql client and see what it tells you. on 7/31/01 4:21 PM, Philip Olson at [EMAIL PROTECTED] wrote: Try putting mysql_error() in your die statements so : or die(mysql_error()); and see what it tells you. Regards, Philip On Tue, 31 Jul 2001, CGI GUY wrote: Is there anything (add. parameters, etc.) that I'm missing that would possibly explain why the following code won't execute? -- mike cullerton -- PHP General 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 General 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]
Re: Fwd: Re: [PHP] dumb mysql_connect issue
CGI GUY wrote: Access denied for user: 'username@hostname' to database 'tablename' 1. The uid/password set I am using has full privileges. 2. *tablename* is not a database (the code I listed in my previous email is syntactically identical to the script)-- it's a table. Why is this happening to me?!?! ;) FROM table_name.column_name is interpreted as FROM database.table_name Hence the confusion of database and table-names. FROM table_name will suffice. regards Wagner -- Madness takes its toll. Please have exact change. -- PHP General 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]
Re: Re: [PHP] dumb mysql_connect issue
Is the error coming from a mysql_query() line or a mysql_select_db() line? Data Driven Design P.O. Box 1084 Holly Hill, Florida 32125-1084 http://www.datadrivendesign.com http://www.rossidesigns.net - Original Message - From: CGI GUY [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 6:47 PM Subject: Fwd: Re: [PHP] dumb mysql_connect issue Okay, well I used the mysql_error() print-out, and it returned something weird: Access denied for user: 'username@hostname' to database 'tablename' This is incongruous because: 1. The uid/password set I am using has full privileges. 2. *tablename* is not a database (the code I listed in my previous email is syntactically identical to the script)-- it's a table. Why is this happening to me?!?! ;) Note: forwarded message attached. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- PHP General 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 General 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]