Partly Solved

[TJaaaay]

I am attempting to test a database to see if a table exists.

Using Mambo and writing from there I can by pass connectors and simply refer to the database with a global $database

Using this

<?php
global $database;

$database->setQuery("SHOW TABLES");
$database->query();
$rows = $database->loadObjectList();
echo $rows;
?>

When I use this echo returns Array

So now I need to loop through the array and test for a value "table_name"

Can someone point me to something that would help

Thanks

TJay

[Installer]

To test for a certain key: array_key_exists()
To test for a certain value: in_array()

[TJaaaay]

that would work, except for some reason this is returning an array populated wit "Object"
Not actually a list of the table names.

So I am back at square 1
I would have thought Mysql or PHP would have had a function called
table_name_exists

There is a create if not exisits, and that is far more complex.

Sheeeesh, I will keep digging thanks for the help

[TJaaaay]

I have solved this problem with this

$dataset = mysql_query('SHOW TABLES') ;
while( $row = mysql_fetch_row($dataset) )
{

if ( $row[0] == "mos_tbd_tags" ) {
[My code here]
break;
}
}

Now that works great to catch that the table exists, and sends the srcipt on its way.

Now I need to send it to a different place if the table does not exist. If I use a else statement the loop will not work.
Break breaks ou if it finds it.
Now I need to set some code for if it does not find it.

I would have thought that I could have put my code at the bottom and instead of break, ( wich if I understand just breaks out of the loop. but falls to other code in the script.
Is there and end or kill command that would jump completely out of the script?

[Installer]

exit, aka die