MySQL Problem

Anon

I used the following code:
1: $query = "create table users (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY( id ), current_ip char(15), last_visit INT DEFAULT '0' NOT NULL )";
2: $result = mysql_query( $query );
3: $query = "create table admin ( admin_user VAR(30), admin_pass VAR(30) )";
4: $result = mysql_query( $query );
5: $query = "INSERT INTO admin ( admin_user, admin_pass ) values ( '$admin', '$passwrd' )";
6: $result = mysql_query( $query );

but the problem is that is only creates the first table, i'm just learning php and i was making an install script but it doesn't work

Anon

You have one variable trying to do three things. Probably confusing PHP.

Just change your variables..

$query = do something here
$result = mysql_query( $query );

$query2 = do something here
$result2 = mysql_query( $query2 );

and

$query3 = do something else here
$result3 = mysql_query( $query3 );

see if that works.

Anon

i tried that too and doesn't work either

Anon

do I need to wait a moment or something or check if it was saved/created?

Anon

Even if i do this
$result = mysql_query( "whatever" );
$result = mysql_query( "something else" );
$result = mysql_query( "anothing thing" );

it still does only the first one, i don't get this, please help me

Anon

Your SQL looks O.K. for the creation of tables. You could try breaking up the script into multiple programs. Just put the tags around each table creation and see if that works.

<? ?>

Or get yourself "phpmyadmin" and use that to create, drop, select, update etc. tables without having to write the SQL. That's what I use and it's great.

Anon

Each table creation should be a seperate script. That should work. At least that's how it's done in the MySQL book.

You can have as many insert or update statements as you like in a script.