|
|
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
Navigation:
[Reply to this message]
|