Fwd: Re: [PHP] dumb mysql_connect issue

2001-07-31 Thread CGI GUY

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

2001-07-31 Thread Alexander Wagner

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]