bluedot Posted December 13, 2006 Share Posted December 13, 2006 Hi I have an Events database that displays a list of upcoming events. I would like members of my site to be able to edit the events in the database. I currently have:mysql_query("UPDATE Events (date, Times, Title, moreinfo) VALUES('$date', '$time', '$title', '$moreinfo') WHERE eventid='$id' ") or die(mysql_error()); I have an html form with:<form id="form1" name="form1" method="post" action="eventsedit.php">that sends the form data to eventsedit.php as you can see.eventsedit.php is were the above query is.When this runs nothing happens. I know im connecting the the database correctly. Im pretty new to PHP and very new to mysql. So any suggestions would be great. Link to comment https://forums.phpfreaks.com/topic/30518-updating-database-with-php/ Share on other sites More sharing options...
timmah1 Posted December 13, 2006 Share Posted December 13, 2006 [code]$query="update events set date='$date', time=$time', title='$title', moreinfo='$moreinfo' WHERE eventid='$id'";[/code] Link to comment https://forums.phpfreaks.com/topic/30518-updating-database-with-php/#findComment-140485 Share on other sites More sharing options...
bluedot Posted December 13, 2006 Author Share Posted December 13, 2006 if you made a religion.. i'd join it.Thank you very much, works now :) Link to comment https://forums.phpfreaks.com/topic/30518-updating-database-with-php/#findComment-140497 Share on other sites More sharing options...
timmah1 Posted December 13, 2006 Share Posted December 13, 2006 your welcome Link to comment https://forums.phpfreaks.com/topic/30518-updating-database-with-php/#findComment-140499 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.