HI All

I have 2 sets of PHP scripts which I combined to execute at once...
- 1...connect to mysql (this is working fine!)
- 2...create tables

Problems:
- when it comes to creating tables (4) only the last one is successfully created and the rest nothing....am i missing something here?

- I would like to include a time out in the script....like once the connection is established, it could print out first something like: Please wait creating tables now...! and then proceed immediately with creating tables.
The timing could be about 5 seconds of delay....how to do that?

here is my script:
<?php
$link = mysql_connect('localhost', 'username', 'password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}

$sql = 'CREATE DATABASE test2';
if (mysql_query($sql, $link)) {
echo "Database test2 created successfully\n";
} else {
echo 'Error creating database: ' . mysql_error() . "\n";
}
// Create tables in test2 database

mysql_select_db("test2", $link);
$sql = "CREATE TABLE car (
title varchar(255) NOT NULL,
description varchar(255) NOT NULL,
priority tinyint(2) NOT NULL default '0'
) TYPE=InnoDB;\n";

//Create links table
$sql = "CREATE TABLE links (
type varchar(20) NOT NULL default '',
resource varchar(255) NOT NULL,
) TYPE=InnoDB;\n";

//Create home table
$sql = "CREATE TABLE home (
name varchar(255) NOT NULL,
title varchar(255) NOT NULL default '',
description varchar(255) NOT NULL default '',
) TYPE=InnoDB;\n";

//Create people table
$sql = "CREATE TABLE people (
name varchar(20) NOT NULL default '',
address varchar(255) NOT NULL
resource varchar(255) NOT NULL,

) TYPE=InnoDB;\n";

echo "car,home,links, & people tables in the relational database (".test2.") have been successfully created!\n";
mysql_query($sql, $link);
mysql_close($link);//Close connection
?>

__________________

---

Your tables will be created so quickly that a delay would be useless and require a lot of code to look nice.

The reason that it's only creating the last table is that that's all you're telling it to create. Each time you say $sql = "..."; something, you erase the previous work, so try adjusting like this:

NOTE: I also took away the semi-colon at the end of all your statements as you don't need them in PHP and then threw in some error reporting.

__________________
Jeremy Miller
Content Farmer - Optimized Automated Blog Posting

---

thank you for the clarification...

I tried running the modified script but I keep getting the following error:

Parse error: syntax error, unexpected T_IF in c:\wamp\test2.php

is it script problem or my side...?
thanks again...

__________________

---

Just a typo. BTW: line numbers matter, so if your system outputs them it's a great help to helping you.

__________________
Jeremy Miller
Content Farmer - Optimized Automated Blog Posting

---

It would be more efficient to concatenate SQL queries and only make one call to the DB. Instead of $sql = "whatever";, use

Notice the period (.) before the equals sign (.=). Also! Make double-sure that your queries are complete! Since they are being concatenated, you'll have to make sure to end each query with ';'.

__________________

---

I'd also recommend to use:

as part of your MySQL query

__________________

---

Why? I'm not familiar with that.

__________________
Jeremy Miller
Content Farmer - Optimized Automated Blog Posting

---

That's useful there's transaction... probably it shouldn't really matter in this case..?

__________________

---

Oh, for InnoDB -- ic now. I never work with InnoDB, just MyISAM.

Thanks.

__________________
Jeremy Miller
Content Farmer - Optimized Automated Blog Posting

---

For one time uses such as creating these tables, it probably won't matter. It's a good habit to get into though.

__________________

---