[SOLVED] php mysql_query

[anthony-needs-you]

Can somebody help me to know where to put this

 

mysql_query("SELECT * FROM test WHERE expireDate > CURDATE()"); 

 

into this

 

$query = "SELECT id, destination, airport, resort, hotel, board, duration, departureDate, expireDate, price, description, stars,  customerRef FROM test ORDER BY price";

$result = mysql_query($query) or die('Error : ' . mysql_error());

while(list($id, $destination, $airport, $resort, $hotel, $board, $duration, $departureDate, $expireDate, $price, $description, $stars,  $customerRef) = mysql_fetch_array($result, MYSQL_NUM))
{

 

Thanks everyone 

[JonnoTheDev]

Take the query string out of the mysql_query() function and put it into the $query variable replacing the old query:

$query = "SELECT * FROM test WHERE expireDate > CURDATE()"; 

[anthony-needs-you]

Cheers have followed your instruction and it works! Thanks a lot!

 

$query = "SELECT id, destination, airport, resort, hotel, board, duration, departureDate, expireDate, price, description, stars,  customerRef FROM test WHERE expireDate > CURDATE()";[code]