how to optimise a mysql table using php

[baris22]

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.

when i use OPTIMIZE TABLE item, it does not work.

        // 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);
 
        }
 
        ////////////////////////////////////////////////////

[Atli]

Hey.

What do you mean by "Overhead problems"? Could you elaborate on what the problem is exactly.

Why would you need to "repair" the table after a DELETE? Do you mean that you want to re-use an ID generated by a AUTO_INCREMENT column?
Have you tried using the REPLACE command instead of deleting and inserting manually?

[baris22]

ok. i managed to get it working.

 
[PHP]
 
        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 till "Z001" to this if statement.