matt.sisto Posted March 20, 2009 Share Posted March 20, 2009 I am trying to build some script that will query the database for events on a specified date. What is wrong with my sql? <?php require "dbconn2.php"; $m = $_POST["month"]; $d = $_POST["day"]; $y = $_POST["year"]; $event_start = $y."-".$m."-".$d." ".$_POST["event_start"]; $sql = "SELECT * FROM calender_events WHERE event_start == "event_start""; $result = mysql_query ($sql, $connection) or die ("Couldn't perform query $sql <br />".mysql_error()); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>List All</title> <style type="text/css"> #top {clear:left} #left {position:absolute; left:5px; max-width: 20%; float:left; padding:5px 5px 5px 5px} ul {list-style: none; position:absolute; left: 1px; top: 0px;} #mid {position:absolute; left:10%;max-width: 50%; float:left; padding:5px 5px 5px 5px} #right {position:absolute; right:5px; max-width: 30%; float:left; padding:5px 5px 5px 5px} </style> </head> <body> <div id="top"> <h1> List Events</h1> </div> <div id="mid"> <table border="1"> <tr> <th align="left">ID </th> <th align="left">Title</th> <th align="left">Short Description</th> </tr> <?php while ($row = mysql_fetch_array($result)) {?> <tr> <td><?=$row['event_id']?></td> <td><?=$row['event_title']?></td> <td><?=$row['event_shortdesc']?></td> </tr> <?php } ?> </table> </div> <div id="left"> </div> </body> </html> Appreciate an help. Link to comment https://forums.phpfreaks.com/topic/150363-solved-check-availability/ Share on other sites More sharing options...
Maq Posted March 20, 2009 Share Posted March 20, 2009 $sql = "SELECT * FROM calender_events WHERE event_start = '$event_start'"; Link to comment https://forums.phpfreaks.com/topic/150363-solved-check-availability/#findComment-789675 Share on other sites More sharing options...
matt.sisto Posted March 20, 2009 Author Share Posted March 20, 2009 Thanks. Link to comment https://forums.phpfreaks.com/topic/150363-solved-check-availability/#findComment-789677 Share on other sites More sharing options...
Maq Posted March 20, 2009 Share Posted March 20, 2009 Thanks. Sure, you just had some SQL syntax errors. mysql_error() should have picked that up... Link to comment https://forums.phpfreaks.com/topic/150363-solved-check-availability/#findComment-789683 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.