delete empty cells

[salman_ahad@yahoo.com]

I have a table "testtable" in MySQL

 

col1 = id //primary key

col2 = text

 

<?php //test.php
..
		$result = mysql_query("SELECT * FROM testtable");
	      if($result)
		      {
//What code shall I write to delete empty text associated with any id 
?>

[mikesta707]

delete FROM testtable WHERE text="" ?

[Mchl]

And if column allows for null values add

OR text IS null

 

`text` is MySQL's reserved word BTW, and should be avoided as identifier

[PFMaBiSmAd]

And then, if you have not already done so, you need to add some validation logic to your form processing code to prevent rows having empty values from being inserted.