[SOLVED] quick little bit of help.

[seany123]

is there a way to remove a row via a php query.... for example:

 

 

$salequery3 = $db->execute("update `points_market` remove row where `id`=?", array($seller['id']));

 

or something like that?

[SetToLoki]

is there a way to remove a row via a php query.... for example:

 

 

$salequery3 = $db->execute("update `points_market` remove row where `id`=?", array($seller['id']));

 

or something like that?

 

you mean DELETE?

 

<?php
$sql = sprintf("DELETE FROM points_market WHERE id='%s'", $seller['id']);
$salequery3 = $db->execute($sql);
?>

[Maq]

What do you mean remove a row?  Why don't you just set the value to the default value, null, blank, etc...?

[seany123]

because... im echoing all rows in a table... and once one row becomes invalid.. i want it completely removed.

[SetToLoki]

because... im echoing all rows in a table... and once one row becomes invalid.. i want it completely removed.

 

delete will delete it from your database, but sounds like you just don't want invalid rows to print to your page but remain in database?

 

It might be because I am tired but I don't think I understand what you are trying to do

[seany123]

i just want the row to be deleted from the database.

 

 

its fixed now thanks.