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. Quote Link to comment 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'"; Quote Link to comment Share on other sites More sharing options...
matt.sisto Posted March 20, 2009 Author Share Posted March 20, 2009 Thanks. Quote Link to comment 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... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.