[SOLVED] a better way to delete rows

[jakebur01]

I am trying to delete all the rows that do not have a value. The fields were originally formated in excel - accounting with 2 decimal places.

 

Is there a better way to get rid of all of the rows that do not have valid prices?

mysql_query("DELETE FROM {$tablename} WHERE $dealer=''");
mysql_query("DELETE FROM {$tablename} WHERE $dealer='$-'");
mysql_query("DELETE FROM {$tablename} WHERE $dealer='-'");
mysql_query("DELETE FROM {$tablename} WHERE $dealer='$0.00'");
mysql_query("DELETE FROM {$tablename} WHERE $dealer='0'");
mysql_query("DELETE FROM {$tablename} WHERE $dealer='0.00'");
mysql_query("DELETE FROM {$tablename} WHERE $dealer='0.0'");
mysql_query("DELETE FROM {$tablename} WHERE $dealer='$0.0'");

 

[premiso]

You could just use the IN statement and have 1 query:

 

mysql_query("DELETE FROM {$tablename} WHERE $dealer IN('', '$-')");

 

Just add the rest to that IN statement following the same format.

[jakebur01]

Cool, thanks.

[Lodius2000]

if you used mysqli or a some of the dba's out there you could use a prepared statement, run it through a foreach and do it all with the same query

 

// this method still makes multiple db queries though