select help..please

davieboy

hey (again)

ok using the scripting:

$query = "SELECT * FROM flights WHERE example = '$example' AND arrival = '$stage2' AND ardate<'".$date2."' AND deptdate>'".$date1."'";
print $query;

i get:

SELECT * FROM flights WHERE example = 'DEPART' AND arrival = 'ARRIVAL' AND ardate<'1147219200' AND deptdate>'1144540800'

In my db my date stamps are:
depdate: 1073433600
ardate: 1241654400

I believe the script bit >= is greater than or equal to, and <= mean less than or equal to.

so the part from $date1 (1173312000) is more than the depdate above, and $date2(1178668800) is less than ardate.

My question is, why is the result not showing?

tsinka

Hi,

please post the complete code that executes the query.

Thomas

davieboy

<?php 
$dday = $day;
$dmonth = $month;
$dyear = $year;
$aaday = $aday;
$aamonth = $amonth;
$aayear = $ayear;
$date1 = mktime(0,0,0,$dday,$dmonth,$dyear);
$date2 = mktime(0,0,0,$aaday,$aamonth,$aayear);
include "config.php";
mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db ($db_name) or die (mysql_error()); 
$query = "SELECT * FROM flights WHERE example = '$example' AND arrival = '$stage2' AND deptdate > '".$date1."' AND ardate < '".$date2."' LIMIT 10";
print $query;
$sql = mysql_query($query)or die (mysql_error());
while($r=mysql_fetch_array($sql))
{
$id=$r["id"];
$flightno=$r["flightno"];
$depart=$r["example"];
$arrival=$r["arrival"];
$dtime=$r["dtime"];
$atime=$r["atime"];
$cost=$r["cost"];
$deptdate=$r["deptdate"];
$ardate=$r["ardate"];
}
?>

to get the info i am jsut using echos

David

tsinka

After reading your post a second time you might want to flip $date1 and $date2.

Look at your query ...

ardate<'1147219200' => ardate=1241654400
deptdate>'1144540800' => deptdate=1073433600

$query = "SELECT * FROM flights WHERE example = '$example' AND arrival = '$stage2' AND ardate<'".$date1."' AND deptdate>'".$date2."'"; 
print $query;

Thomas

davieboy

ardate<'1147219200' => ardate1=1241654400
deptdate>'1144540800' => deptdate1=1073433600

the ardate1 and deptdate1 are the max and min values that the ardate and deptdate must be in between

so does this not mean my origional code is correct?

tsinka

In your first post you had

SELECT * FROM flights WHERE example = 'DEPART' AND arrival = 'ARRIVAL' AND ardate<'1147219200' AND deptdate>'1144540800'

and

In my db my date stamps are:
depdate: 1073433600
ardate: 1241654400

If I insert that into that query it looks like:

SELECT * FROM flights WHERE example = 'DEPART' AND arrival = 'ARRIVAL' AND 1241654400<'1147219200' AND 1073433600 >'1144540800'

That will return nothing with the given date stamps since
1241654400>'1147219200' and
1073433600 <'1144540800'

Thomas

davieboy

cheers for the help

got in a bit of a pickle there but now got it sorted
😃