Correct query

[timmah1]

What is the right way to write this

$time = date("Y-m-d H:i:s");					 
$sql1 = "SELECT * FROM specials WHERE sport = 'ncaab' AND date("Y-m-d H:i:s", strtotime($time)) BETWEEN 'start' AND 'end'";

 

I get the message that the Query was empty

 

Thanks in advance

[timmah1]

Sorry, this code

 

$sql1 = 'SELECT * FROM specials WHERE sport = "ncaab" AND ".date('Y-m-d H:i:s')." BETWEEN "start" AND "end"';
mysql_query($sql)
or die("Sorry, there was a problem creating the specials ".mysql_error());

[twm]

what is the date field name? 

[PFMaBiSmAd]

 

 

If that is your actual query string and your query, it is going to be kind of hard to get mysql to perform a query using $sql, when the variable name you have put the query string in to is named $sql1

[timmah1]

That was a typo PFMaBiSmAd

 

 

I'm trying this, and it isn't working

 

$sql1 = "SELECT * FROM specials WHERE sport = 'ncaab'";
$q1 = mysql_query($sql1);	

while($a = mysql_fetch_assoc($q1)){ 

if($time > $a['start'] "AND" $time <  $a['end']){
	echo $a['name'];
}
else {
	echo Try Again;
}

[mmarif4u]

this:

if($time > $a['start'] "AND" $time <  $a['end']){

 

should be:

if($time > $a['start'] && $time <  $a['end']){

and also make sure that $time holding correct value.

[timmah1]

I have time like this

 

$time = date("Y-m-d H:i:s");

[mmarif4u]

Can you post your complete code.