Creating a Table

monion

Below is my code. It does not seem to be working. What am I missing? I am trying to create a database table via PHP. It yields a website cannot display the page when run. When I remove the mysql_query portion I get a Error: Query was empty, so I know it is at least doing something.

Expand|Select|Wrap|Line Numbers

 <?php

include("input_cl.php");

@mysql_connect("localhost","?????","?????");

if (!@mysql_connect)

  {

  die('Could not connect: ' . mysql_error());

  }
 
mysql_select_db("inv");
 
mysql_query("CREATE TABLE order(

id INT NOT NULL AUTO_INCREMENT, 

ADHDFU VARCHAR(30), PRIMARY KEY(id))";
 
if (!mysql_query($sql))

  {

  die('Error: ' . mysql_error());

  }

echo "Table Created!";
 
mysql_close()

?>

dlite922

Remove the @ sign and see if you get any other errors.

Dan

thesmithman

First thing I see is you're calling mysql_query twice, once with the query as an argument, and a second time with an undefined variable $sql as the argument. I think you probably meant something like

Expand|Select|Wrap|Line Numbers

 $query = "CREATE TABLE etc.";

if(!mysql_query($query)){

//error reporting goes here

}else{

//success!

}

Best of luck

Creating a Table

re: Creating a Table

re: Creating a Table

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about