Compare an array to a string

[Anon]

I am trying to list out tables in my mysql db, from this list(the array) find if a db exists(the string). If it does break out, if it does not exist create the table. I have listed out the tables using mysql_tables_list and feeding that result into an array. Is there a way to compare this result and add the conditions easily ?

Thanks,
Eric

[roel_v]

$found_table = 0;
$dp = mysql_list_tables("database");
while ($i < mysql_num_rows ($result)) {
if(mysql_tablename ($dp, $i) == $table_name_you_are_looking_for) {
found_table = 1;
}
}

if($found_table == 0){
create_table($table_name_you_are_looking_for);
}

No need for an array. This is what you want, right?

[Anon]

Rather new to php, where is $i defined?

Thanks,
Eric

[Anon]

got it working thanks!!

$date = getdate();
$tw1 = $date[month].$date[yday].$date[year];
$found_table = 0;
$dp = mysql_list_tables("database");
$i = 0;
while ($i < mysql_num_rows ($dp)) {
if(mysql_tablename ($dp, $i) == $tw1) {
$found_table = 1;
}
$i++;
}

if($found_table == 0){
mysql_query ("CREATE TABLE $tw1 (id TINYINT (2) not null AUTO_INCREMENT, dpid VARCHAR (50) not null ,
vdpid VARCHAR (50) not null , vote TINYINT (3) not null , PRIMARY KEY (id))");
}

Eric

[Anon]

eric, what mean with the
$tw1 = $date[month].$date[yday].$date[year];

I still canot get It?

[Anon]

Leo,
$tw1 was define as a partial datestamp which I was using as the table name. Examine the create table line, value $tw1 is assigned there. It resulted in 052101 if used today.

$date = getdate();
$tw1 = $date[month].$date[yday].$date[year];
$found_table = 0;
$dp = mysql_list_tables("database");
$i = 0;
while ($i < mysql_num_rows ($dp)) {
if(mysql_tablename ($dp, $i) == $tw1) {
$found_table = 1;
}
$i++;
}

if($found_table == 0){
mysql_query ("CREATE TABLE $tw1 (id TINYINT (2) not null AUTO_INCREMENT, dpid VARCHAR (50) not null ,
vdpid VARCHAR (50) not null , vote TINYINT (3) not null , PRIMARY KEY (id))");
}