if table exists?

[pyro.699]

whats the php code, for

'If this table exists... do this'?

[Zachariah]

CREATE TABLE IF NOT EXISTS `table_name`

IF NOT, IF

[pyro.699]

what if its not a table? i need to make a coloum in the user table

[akanevsky]

ALTER TABLE IF EXISTS `table_name` ADD `column_name`...

[pyro.699]

PHP Code:

$db->query_write(
"ALTER TABLE IF EXISTS user ADD top_game_sites INT( 1 ) NOT NULL"); 


that dosent really work...

[Marco van Herwaarden]

To test if a column exists, you cna use the following query:
[sql]SHOW COLUMNS FROM <tablename> WHERE field = '<columnname>';[/sql]
Alternative you could disable error reporting and just run the query to add the column.

[pyro.699]

could i have the exact code? i need to add a feild to the 'user' table, called 'xtreme_top_100' and thats it

[Marco van Herwaarden]

turn off error reporting:

PHP Code:

$db->reporterror = false;
$db->query_write(".....");
$db->reporterror = true; 


The other option for first testing, i think you can figure that our yourself.

[pyro.699]

lol :P

and thanks ^^