how to optimize a mysql table from php

hello,

I am deleting rows before inserting new one and i get Overhead problems. what can i do do repair the table after i delete the row. i have been trying for ages but i could not do it. this is the code for inserting.

		// delete before inserting //////////////////////////
		
		$query = "SELECT COUNT(*) as num FROM orderr WHERE order_reference_number='".$newReference."' ";
	    $total_pages = mysql_fetch_array(mysql_query($query));
		$total_pages = $total_pages[num];
		
		if ($total_pages = "1")
		
		{
		
		$sql="DELETE FROM orderr WHERE order_reference_number='".$newReference."' ";
	   //echo $sql;
	    mysql_query($sql);
		
		$sql="DELETE FROM item WHERE order_reference_number='".$newReference."' ";
	   //echo $sql;
	    mysql_query($sql);

		}
		
		////////////////////////////////////////////////////

PHP:

 

OPTIMIZE TABLE tbl_name 

Code (markup):

Perform this statement from time to time or whenever needed or write a simple script to do it for you, this is basic database maintenance.
This should remove overhead.

 

ok. i managed to get it working.

        if ($newReference == "A001")
        {
        $opt = "OPTIMIZE TABLE item";
        $opt_table = mysql_query($opt); 
        }

PHP:

I have got another small question. how can i add "B001" , "C001" , "D001" , "E001" .....and so on ...... "Z001" to this if statement.