[SOLVED] wont display results or else statement

[runnerjp]

i really cant figure out what im doing wrong here

in my db i have a time set as:04-15-2009...

 

my sql output is:SELECT * FROM events WHERE date=04-15-2009

 

but when i look on the page i get nothing

<?php
include 'settings.php'; 
$yes=$_GET['month'];

$sql = "SELECT * FROM events WHERE date=$yes";

$postsresult = mysql_query($sql);
// IF mysql_query() RETURNS FALSE, THERE IS DIAGNOSTIC INFORMATION AVAILBALE
$num = mysql_num_rows($postsresult);

while($row = mysql_fetch_assoc($postsresult)) {
if($num < 1)
    { 
echo $row['event'];}
else
{ echo 'no events';}
}
?>

[Maq]

You need single quotes around $yes:

 

$sql = "SELECT * FROM events WHERE date='$yes'";

 

If you put or die at the end of your query execution you would have seen this.

[The Little Guy]

Try this, it will echo out your $yes and a row (if the row exists)

 

<?php
include 'settings.php'; 
$yes=$_GET['month'];

$sql = "SELECT * FROM events WHERE date='$yes'";
$postsresult = mysql_query($sql);
$row = mysql_fetch_array($postsresult);
echo $yes;
echo '<br>';
echo $row['event'];
?>

[soak]

Your date is a string so needs to be in quotes. Whilst you're doing that at least put in a mysql_real_escape_string() as well:

 

<?php
include 'settings.php'; 
$yes=mysql_real_escape_string($_GET['month']);

$sql = "SELECT * FROM events WHERE date='$yes'";

[runnerjp]

i put it in quotes and still nothin...

 

<?php
include 'settings.php'; 
$yes=$_GET['month'];

$sql = "SELECT * FROM events WHERE date='$yes'";
$postsresult = mysql_query($sql);


// IF mysql_query() RETURNS FALSE, THERE IS DIAGNOSTIC INFORMATION AVAILBALE
if (!postsresult)
{
   $errmsg = mysql_errno() . ' ' . mysql_error();
   echo "<br/>QUERY FAIL: ";
   echo "<br/>$sql <br/>";
   die($errmsg);
}
$row = mysql_fetch_array($postsresult);
echo $yes;
echo '<br>';
echo $row['event'];
?>

 

the output said nothin of errors :S

[runnerjp]

got it workin...thnaks guys

[The Little Guy]

include 'settings.php'; 
$yes=$_GET['month'];

$sql = "SELECT * FROM events WHERE date='$yes'";
$postsresult = mysql_query($sql);
echo 'Rows Found: '.mysql_num_rows($postsresult);