Code To Loop Through Tables And Execute Query

[JustinK101]

Hello,

 

I have a database that has many tables. How can I write php code to loop through all tables and run the following query:

 

LOOP THROUGH ALL TABLES {
     DELETE FROM {table_name} WHERE deleted = 1;
}

[trq]

<?php

  // connect to and select database.

  if ($result = mysql_query("SHOW_TABLES")) {
    if (mysql_num_rows($result)) {
      while ($table = mysql_fetch_row($result)) {
        if (mysql_query("DELETE FROM {$table[0]} WHERE deleted = 1")) {
          echo "Row deletd from {$table[0]}<br />";
        }
      }
    }
  }

?>