problem getting 2 queries to work together ...

[Frank100]

Hi,

when I try to create 2 tables through a .php file like this it doesn’t work. Can somebody give me a hint ? It’s only the 2 querys which make problems, the rest of the file (not shown here) works … when I use just 1 query the .php file works fine and creates the desired table.

 

Regards,

Frank

 

 

 

 

$query = "

 

CREATE TABLE company (

company_id INT(10) unsigned NOT NULL auto_increment primary key ,

company_registerdate TIMESTAMP NOT NULL

) ENGINE = innodb";

 

 

$query = "

 

CREATE TABLE lessor (

lessor_id INT(10) unsigned NOT NULL auto_increment primary key ,

lessor_registerdate TIMESTAMP NOT NULL ,

) ENGINE = innodb";

 

 

 

[AndyB]

lessor_registerdate  TIMESTAMP  NOT NULL  ,

 

Remove that final comma ... and execute each query separately of course.

[Frank100]

Hi + thx for reply,

 

sure, the comma has to go but how do I execute the queries separately in one p.p file ?

[AndyB]

// establish connection to database, select database, then ...
$query = ".... first query ...";
$result = mysql_query($query); // execute first query

$query = ".... second query ...";
$result = mysql_query($query); // execute second query
... 

[Frank100]

Hi Andy,

thx again ! I've tried it out but it seems that I still make a mistake ... no tables are created.

Here's my whole .php file.

 

Regards,

Frank

 

 

 

<?php

 

/* connect database */

 

$link = mysqli_connect("localhost", "root", "abc", "test");

 

/* check connection */

 

if (!$link) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}

 

// establish connection to database, select database, then ...

 

$query = "

CREATE TABLE placesx (

 

place_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,

place_picture_01 VARCHAR(30) NOT NULL ,

place_picture_02 VARCHAR(30) NOT NULL

) ENGINE = innodb";

 

$result = mysql_query($query); // execute first query

 

 

 

 

$query = "

CREATE TABLE renterx (

renter_id INT(10) unsigned NOT NULL auto_increment primary key ,

renter_first_name VARCHAR(30) NOT NULL ,

renter_last_name VARCHAR(30) NOT NULL

 

) ENGINE = innodb";

 

$result = mysql_query($query); // execute second query

...

 

 

 

/* check query */

 

if (mysqli_query($link, $query)=== TRUE) {

 

    printf("Table successfully created.\n");

 

}

 

/* disconnect database */

 

mysqli_close($link);

 

 

?>

 

 

 

 

 

 

[Frank100]

have tried it again in different variations but have not enough knoledge to find out why it doesn't work ... does somebody know ?

 

Regards,

Frank