multiple sql queries

[nem]

Ok, my code is like this

$sql = "CREATE TABLE `table2` (
`id` INT( 8 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
`image` VARCHAR( 225 ) NOT NULL ,
`cat` VARCHAR( 225 ) NOT NULL ,
`subcat` VARCHAR( 225 ) NOT NULL ,
`description` VARCHAR( 225 ) NOT NULL ,
`date` VARCHAR( 225 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);";
echo 'Creating table: \'gs_photo\'....';
mysql_query( $sql, $conn );


$sql = "CREATE TABLE `table1` (
`id` INT( 9 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
`cat` VARCHAR( 225 ) NOT NULL ,
`catdesc` VARCHAR( 225 ) NOT NULL ,
`subcat` VARCHAR( 225 ) NOT NULL ,
`subcatdesc` VARCHAR( 225 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);";
echo 'Creating table: \'gs_photogallery\'....';
mysql_query( $sql, $conn ); 

the above works perfectly, tested it.

then i also add:

//legends
$ip = $_SERVER["REMOTE_ADDR"]; 
$user = $_POST["user"] ; 
$pass = md5($_POST['pass']); 

//insert
$sql = "INSERT INTO `gs_admin` ('ip', 'lastvisit', 'user', 'pass') VALUES ('$ip', 'NOW()', '$user', '$pass')";
echo 'Creating admin account';
mysql_query( $sql, $conn ); 

and of course there is a form with the inputs "user" and "pass". But it just dont work.

so altogether its:

$sql = "CREATE TABLE `table2` (
`id` INT( 8 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
`image` VARCHAR( 225 ) NOT NULL ,
`cat` VARCHAR( 225 ) NOT NULL ,
`subcat` VARCHAR( 225 ) NOT NULL ,
`description` VARCHAR( 225 ) NOT NULL ,
`date` VARCHAR( 225 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);";
echo 'Creating table: \'gs_photo\'....';
mysql_query( $sql, $conn );


$sql = "CREATE TABLE `table1` (
`id` INT( 9 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
`cat` VARCHAR( 225 ) NOT NULL ,
`catdesc` VARCHAR( 225 ) NOT NULL ,
`subcat` VARCHAR( 225 ) NOT NULL ,
`subcatdesc` VARCHAR( 225 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);";
echo 'Creating table: \'gs_photogallery\'....';
mysql_query( $sql, $conn ); 

//legends
$ip = $_SERVER["REMOTE_ADDR"]; 
$user = $_POST["user"] ; 
$pass = md5($_POST['pass']); 

//insert
$sql = "INSERT INTO `table5` ('ip', 'lastvisit', 'user', 'pass') VALUES ('$ip', 'NOW()', '$user', '$pass')";
echo 'Creating admin account';
mysql_query( $sql, $conn ); 

i used table 5 as an example, as if it has fields like ip lastvisit and user etc etc

and nothing shows.... i even tried adding "$query" instead of "$sql" on the INSERT query.

and yes, before all this the database has been connected.

[tsinka]

Hi,

replace all mysql_query lines by e.g.

mysql_query( $sql, $conn ) or die ("SQL error: ".mysql_error());

Maybe the problem is

'NOW()'

Replace it by just

NOW() without '

and remove the ' chars around the column names, like

INSERT INTO table5 (ip, lastvisit, user, pass) ...

Thomas

[nem]

so like this?

//insert
$sql = "INSERT into `gs_admin` WHERE (user, ip, lastvisit, pass) VALUES ('$user', '$ip', NOW(), '$pass')";
echo 'Creating admin account';
} else {
die('could not create your admin account');
mysql_query( $sql, $conn ) or die ("SQL error: ".mysql_error());  

[nem]

no luck mate. 🙁

[TheDefender]

Remove the WHERE clause.... You don't use the WHERE clause since you are inserting a new row. The WHERE clause is used in UPDATE, DELETE and SELECT statements to determine specific conditions to meet before UPDATING, DELETING or SELECTING.

$sql = "INSERT into `gs_admin` (user, ip, lastvisit, pass) VALUES ('$user', '$ip', NOW(), '$pass')"; 

[nem]

i tried that too... no luck

[tsinka]

Ok,

so do you get an error message ?

This code snipplet you sent.

//insert 
$sql = "INSERT into `gs_admin` WHERE (user, ip, lastvisit, pass) VALUES ('$user', '$ip', NOW(), '$pass')"; 
echo 'Creating admin account'; 
} else { 
die('could not create your admin account'); 
mysql_query( $sql, $conn ) or die ("SQL error: ".mysql_error());

There is a die just in front of the mysql_query so the query won't be executed at all.

It might be a good idea to post that script as attachment or to post some more code.

Thomas