How do I combine queries

Anon

$query = "select from storeProduct where productInventory = '042' order by productCategory, productName ASC";
$mysql_result = mysql_query($query, $mysql_link);
$query1 = "select from storeProduct where productInventory = '002' order by productCategory, productName ASC";
$mysql_result1 = mysql_query($query1, $mysql_link);
// I'm not sure how to do this
while($row = mysql_fetch_row($mysql_result + $mysql_result1))

There might be a better way of doing this but i asked yesterday with only one response and no luck. I basically want to combine the queries and then sort them by what's specified

alfoxy

If its only the productInventory that changes you could make a $string = '042 OR 002' ... made on the fly
then
$query = "select * from storeProduct where productInventory = ".$string." order by productCategory, productName ASC";
or something like that ?

Anon

I just can't get it to work. It doesn't search for both values. This seems so basic, but is really stumping me.

I returns a blank page. (and yes..it should return values)

Anon

Not sure about that: don't you mean

$string="productInventory='042' OR productInventory='002";

$query="select * from storeProduct where $string order by productCategory, productName ASC"

And of course for an arbitrary number of productInventory fields:

$array=array('042','002','014');
foreach($array as $key=>$elt)
{ $array[$key]="productInventory='$elt'";
}
$string = implode(' OR ',$array);

Anon

OK, Maybe I'm stupid....but it doesn't work. Here's what I got. I tried it the other way your suggested also, and that didn't seem to fly. Right now i'm getting an error.

I also tried // where productInventory = '.$string.'//

That didn't do any good. Wasn't sure what that would do anyways. Please help if you can

$string = "productInventory='042' OR productInventory='002'";
$query = "select * from storeProduct where productInventory = '$string' order by productCategory, productName ASC";
$mysql_result = mysql_query($query, $mysql_link);

Anon

Is there anybody who can help?

Anon

the quotes are messing up your query,
try this:

<?
$result = mysql_query ("SELECT * FROM storeProduct WHERE productInventory = '042' OR productInventory = '002' ORDER BY productCategory, productName ASC");
?>

Anon

Finally Somebody Who makes sense !!!

Thanks alot.

Thanks for everybody help