Posted by Lag on 02/24/06 05:23

I added a count ($count) to see if or how many rows were being
affected.............even though I am tagging them by id, which auto
increments for each new event. I am not selecting any row, even though
I know the id is correct. I went into the database to make sure.

This is the code and the result of running the code.

//---UPDATE ENTRY IN DATABASE---
$result = mysql_query("SELECT * FROM calendar_events WHERE
id='.$event'",$conn);
$count = mysql_num_rows($result);
$query = "UPDATE calendar_events SET event_title = '$title',
event_start = '$date', event_shortdesc = '$desc' WHERE id = '$result'";
mysql_query($query) or die(mysql_error());

//LIST ITEMS
echo "$event $title $date $desc";

echo "<br>Record Updated! Rows Affected: $count";
mysql_close();

?>

This is the result....

test2 2006-02-23 01:00:00 test
Record Updated! Rows Affected: 0

[Back to original message]