[RESOLVED] php and mysql UNION query problem

spyril

hey guys
i'm having some problem with php and mysql UNION query
here is my code:

$result= mysql_query(" SELECT FROM table1 WHERE Post Code <=2000 AND State = 'NSW' ORDER BY Post Code DESC LIMIT 5

UNION
SELECT FROM table1 WHERE Post Code >=2000 AND State = 'NSW' ORDER BY Post Code ASC LIMIT 5 ");

if (!$rec = mysql_fetch_array($result)){
echo ("Sorry, no records found");
}
else {
do{
echo ($rec["Post Code"]);
}
while ($rec = mysql_fetch_array($result));
}

what i'm trying to do is search for post code that's in the database, and display all the postcode that is "<" then and ">" then postcode number 2000, and then limit the result to 5.

the above SQL statement works fine in mysql, but when i put it into php it's not working anymore,
i can get code above UNION working fine, but once include UNION and the code below union i get errors

can anyone help me

thanks

Weedpacket

What are the errors that you get?

spyril

this is the error message i get:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\database\stockists\search.php on line 90
Sorry, no records found

if i remove the UNION from code and write as following:

$result = mysql_query(" SELECT * FROM table1 WHERE Post Code <=2000 AND State= 'NSW' ORDER BY Post Code DESC LIMIT 5 ") ;

i get no error at all and it display postcode that's <= to 2000

spyril

hey i just figuer out the problem,

here is my working code.

$result = mysql_query(" (SELECT FROM table1 WHERE Post Code <=2000 AND State = 'NSW' ORDER BY Post Code DESC LIMIT 5) UNION
(SELECT FROM fill_detail WHERE Post Code >=2000 AND State = 'NSW' ORDER BY Post Code ASC LIMIT 5) ") ;

if (!$rec = mysql_fetch_array($result)){
echo ("Sorry, no records found");
}
else {
do{
echo ($rec["Post Code"]);
echo "<br />";
}
while ($rec = mysql_fetch_array($result));
}

this will display all the postcode that is <= and >= to postcode number 2000, of course you can put variable insteade of '2000' and 'NSW'