"; ?> Creating a table

Creating a table

The database server is not available

"); @mysql_select_db("sb", $DBconnect) Or die("

Unable to open the database.

" . "

Error code " . mysql_errno($DBconnect) . ": " . mysql_error($DBconnect) . "

"); $table = "products"; $request = "SELECT * FROM {$table};"; $queryResult = @mysql_query($request, $DBconnect) Or die("

Unable to execute the request.

" . "

Error code " . mysql_errno($DBconnect) . ": " . mysql_error($DBconnect) . "

"); if ($queryResult) print("

The {$table} table already exists.

"); else { $request = "CREATE TABLE {$table} (make VARCHAR(20), model VARCHAR(30), " . "price FLOAT, quantity INT);"; $queryResult = @mysql_query($request, $DBconnect) Or die("

Unable to execute the request.

" . "

Error code " . mysql_errno($DBconnect) . ": " . mysql_error($DBconnect) . "

"); print("

A new table is created.

"); } mysql_close($DBconnect); ?>