[SOLVED] PHP Install Script

[jjacquay712]

im trying to make an install script to set up a database. I want to forward them to my index page if they haven't competed the install script. How could i check to see if the user has ran the install script? i was thinking of using a database to hold a boolean value to check to see of the user installed, but if the user didn't install, it would make a mysql zero rows returned error. Any ideas?

[DarkWater]

There is no "zero rows returned error" because it's not an error... =/

[jjacquay712]

ill give you an example:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/johnj/public_html/test.php on line 2

[DarkWater]

That just means that you either:

 

[*]Used the wrong, non-resource variable in mysql_fetch_*() functions

[*]You disconnected from MySQL or some other rare failure like that.

[*]You had a bad query.  This does NOT mean no rows were returned, it just means you had a syntax error.  This is the most common issue.

 

Has nothing to do with 0 rows.

[jjacquay712]

will that error come up if the table doesn't exist?

[PFMaBiSmAd]

will that error come up if the table doesn't exist?

 

It would have taken you about a minute to test this yourself -

 

mysql_error() - Table 'your_database_name.your_table_name' doesn't exist

 

mysql_errno() - 1146

[jjacquay712]

<?php
//Connect
mysql_connect("localhost", "*****", "*******");
mysql_select_db("******");
//End Connect
$rows = mysql_num_rows(mysql_query("SELECT * FROM cvbxcbxcb"));
echo $rows;
?>

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/johnj/public_html/test.php on line 6

 

it prints that warning when the table doesn't exist