Query won't work- but when tested in phpmyadmin, it fetches results.. ?

[kernelgpf]

Very simple code-

 

$tdate=date('h:00:00');
$tday=date('Y-m-d');


$queryed=mysql_query("select bondID,requestingdragon,requesteddragon,outcome from dragonsbonding where endbondingtime='$tday tdate'")or die(mysql_error());
$number=mysql_num_rows($queryed);

 

I've already got a connection to the DB, and tested the variables by printing them out- they are what they should be, and when I test this query in the DB with what the variables are supposed to be, the query fetches results.. but in my script, $number == "0", and I can't figure out why.

 

Any opinions/ideas? Thanks!

[redarrow]

<?php
$tdate=date('h:00:00');
$tday=date('Y-m-d');
$queryed=mysql_query("select bondID,requestingdragon,requesteddragon,outcome 
from dragonsbonding where endbondingtime='$tday $tdate'")or die(mysql_error());
$number=mysql_num_rows($queryed);
?>

[kernelgpf]

..I omitted by PHP opening and closing for brevity's sake. I know it needs to be there.

[kernelgpf]

Bump.

[kernelgpf]

...please help, someone.

[redarrow]

are you sure that this in the database are not a timstamp

 

$tdate=date('h:00:00');

$tday=date('Y-m-d');

 

 

$tdate=date('h:i:s');<<<< dont you mean this atleast man lol.

[kernelgpf]

It is a timestamp- is that a problem?

[redarrow]

<?php

$date=strtotime(date("y-m-d h:i:s"));
$queryed=mysql_query("select bondID,requestingdragon,requesteddragon,outcome 
from dragonsbonding where endbondingtime='$date')or die(mysql_error());
$number=mysql_num_rows($queryed);
?>

 

<?php
$date=strtotime(date("y-m-d h:i:s"));

echo date("y-m-d h:i:s" ,$date);
?>

[Barand]

..I omitted by PHP opening and closing for brevity's sake. I know it needs to be there.

 

Did you also notice you omitted the $ from "$tdate" which redarrow included for you?

[kernelgpf]

Ah, that fixed it, thanks.