Trying to delete rows.

[Vyizis]

I am trying to use php to delete rows for a mysql database table, i am using the following code with $journeyIDToUse being a number that represents a automaticly incrementing primary key.

 

$toDelete = "DELETE FROM journeyData WHERE journeyID='$journeyIDToUse'";
mysql_query($toDelete);

 

This fails to delete the row. I have tried changing $journeyIDToUse to a number and that worked so i thought that the variable might be at fault but the following query works so that rules that out

 

$searchString = "SELECT * FROM journeyData WHERE journeyID='$journeyIDToUse'";
$result = mysql_query($searchString);
$row = mysql_fetch_array($result);

 

I cant work out what is happening here so any help will be more than appriciated.

 

Thanks

Vyizis

[Glyde]

Always check variables using a simple print method.

print $journeyIDToUse;

That would be step 1.  Step 2 is to ensure that the number for which $journeyIDToUse is set to actually corresponds to a row in the table

[Vyizis]

I get the right number and the number does corrispond to a row of the table, this is the first thing i checked.

[Psycho]

You should also always have error handling when running queries. Try this:

 

$toDelete = "DELETE FROM journeyData WHERE journeyID='$journeyIDToUse'";
mysql_query($toDelete) or die (mysql_error());