\n"); print("
\n"); print("\n"); print("\n"); print("\n"); print("
Delete A Category
Name"); $db_link = SQL_connect(); // form the select statement $statement = "SELECT name FROM categories"; // output it... helpful for debugging purposes... //print("

SQL Statement: $statement

"); // do it, damn it =) $db_result = SQL_query($statement, $db_link); // find out how many results there were... $aff_rows = SQL_get_aff_rows($db_link, $db_result); //print("
There are currently $aff_rows categories.

\n"); if ($aff_rows == 0) { print("

No categories found in this database... have you created them in the admin interface?\n"); SQL_close($db_link); include $inc_dir . "footer.php3"; exit; } // get each row for ($db_row = 0; $db_row < $aff_rows; $db_row++) { $row = SQL_fetch_array($db_result, $db_row); $table = $row["name"]; print("$table
\n"); } print("

\n"); SQL_close($db_link); include $inc_dir . "footer.php3"; ?>