hi i have a php script that pulls data from a sql database,
each time it querys the database it pulls 1 entry from each of the 3 fields.

how can I delet just the one set of records?

I tryed using

PHP Code:

$delete = DELETE FROM `$username`
WHERE id='4'; 


however, this requiers me to state the id to be deleated, but i need it to just deleate whatever information was just pulled.

please help!!!!!!!!

Originally Posted by atomicshockwave

hi i have a php script that pulls data from a sql database,
each time it querys the database it pulls 1 entry from each of the 3 fields.

how can I delet just the one set of records?

I tryed using

PHP Code:

$delete = DELETE FROM `$username`
WHERE id='4'; 


however, this requiers me to state the id to be deleated, but i need it to just deleate whatever information was just pulled.

please help!!!!!!!!

What is the name of the table? First of all you dont have quotes around your statement. But here is what i how i would do.

PHP Code:

$result=mysql_query("DELETE FROM `username` WHERE `id`='4'"); 


If ID is numeric you should NOT have single quotes around it