MYSQL Query: Create Table AND Row

[BlackList]

Howdy,

I am trying to create a table and a row at the same time.

Right now my create table code works, I just want to know how I should add the row?

Here is my create table code:

$query="CREATE TABLE IF NOT EXISTS `".$compname."pages` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 255 ) NOT NULL ,
`content` LONGTEXT NULL ,
`incname` VARCHAR( 255 ) NOT NULL 
) TYPE = MYISAM";

mysql_query($query);

How should I add a code like this?

INSERT INTO `".$compname."pages` ( `id` , `name` , `content` , `incname` ) 
VALUES (
NULL , 'spacer', NULL , 'spacer'
);

[rincewind456]

By checking that the result from the table creation is true, then if it is do another mysql_query call. Something like

<?php
$query="CREATE TABLE IF NOT EXISTS `".$compname."pages` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , 
`name` VARCHAR( 255 ) NOT NULL , 
`content` LONGTEXT NULL , 
`incname` VARCHAR( 255 ) NOT NULL 
) TYPE = MYISAM"; 

$result = mysql_query($query);

if ($result==true) {

$query = "INSERT INTO `".$compname."pages` ( `id` , `name` , `content` , `incname` ) VALUES ( NULL , 'spacer', NULL , 'spacer' )";

$result = mysql_query($query);
// some erorr catching here like
if ($result==false) {
	//error message
}
} else {
	//error catching here
}