Gossamer Forum: General: Databases and SQL: php & mysql

Jun 12, 2003, 5:20 PM

jinwu

Novice (7 posts)

Jun 12, 2003, 5:20 PM

Post #1 of 5

Shortcut

php & mysql

When I use php code
mysql_create_db ('dbCompany');
return true, i.e. I was successful.
But After that, I type SHOW DATABASES; in the mysql command line, this created table does not realy exist

I have mysql and php installed in Mandrake Linux.
I may create database in the command line using root as user.

Jun 12, 2003, 5:28 PM

Andy

Veteran / Moderator (18441 posts)

Jun 12, 2003, 5:28 PM

Post #2 of 5

Shortcut

Re: [jinwu] php & mysql In reply to

Are you returning the error after attempting to create this?

Code:
$error = mysql_error(); 
if ($error) { echo "SQL Error: $error"; exit; }

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jun 12, 2003, 5:30 PM

Paul

Veteran (19537 posts)

Jun 12, 2003, 5:30 PM

Post #3 of 5

Shortcut

Re: [Andy] php & mysql In reply to

Won't php let you do this...

Code:
if (my $error = mysql_error()) { 
    echo "Error: $error"; 
    return; 
}

Jun 12, 2003, 5:36 PM

Andy

Veteran / Moderator (18441 posts)

Jun 12, 2003, 5:36 PM

Post #4 of 5

Shortcut

Re: [Paul] php & mysql In reply to

Not really. Firstly I'm not sure you can declare a variable within an 'if' statement (most likely can, I just havn't done it before), and also, why do a return? An exit; is better because it stops the script dead, so the user doesn't see any more errors (only real problem is that the mysql_close() command is not run).

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jun 12, 2003, 5:37 PM

Andy

Veteran / Moderator (18441 posts)

Jun 12, 2003, 5:37 PM

Post #5 of 5

Shortcut

Re: [Andy] php & mysql In reply to

BTW: Wouldn't this thread be better in the Internet Technologies forum, as its more related to PHP that MySQL Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk