Topic: mysql UNION | warning mysql_fetch_array !!

[subash85]

Code: [Select]

<?php
$i = 0;
$query1="SELECT * FROM `products` WHERE `division`='$f_usr_div' ORDER BY `pname` UNION  SELECT `stock_close` FROM `stockiest_entry` WHERE `user_id`='$user_id' AND `stockiest_id`='$stckst_id' AND `month`='$f_month' AND `user_div`='$title_div' AND `fiscal_year`='$st_year'";
$result1=mysql_query($query1);
$i=0;
while($a_row=mysql_fetch_array($result1))  // line 89
{
                            global $i;
  $i++;
$db_id=$a_row['id'];
$db_pname=$a_row['pname'];
$db_pcode=$a_row['pcode'];
$db_packing=$a_row['packing'];
$db_type=$a_row['ptype'];
$db_unit=$a_row['unit'];
$db_stock_close=$a_row['stock_close'];

print "$db_id, $db_pname, $db_pcode , $db_packing, $db_type, $db_unit, $db_stock_close";



i got error.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /domains/55373/web/ipharma/form_header_final.php on line 89

[Buddski]

It means your query has failed to execute..
Use mysql_error() to find out the error

[subash85]

Code: [Select]

<?php
$i = 0;
$query1="SELECT * FROM `products` WHERE `division`='$f_usr_div' ORDER BY `pname` UNION  SELECT `stock_close` FROM `stockiest_entry` WHERE `user_id`='$user_id' AND `stockiest_id`='$stckst_id' AND `month`='$f_month' AND `user_div`='$title_div' AND `fiscal_year`='$st_year'";
$result1=mysql_query($query1);
$i=0;
while($a_row=mysql_fetch_array($result1))  // line 89
{
                            global $i;
  $i++;
$db_id=$a_row['id'];
$db_pname=$a_row['pname'];
$db_pcode=$a_row['pcode'];
$db_packing=$a_row['packing'];
$db_type=$a_row['ptype'];
$db_unit=$a_row['unit'];
$db_stock_close=$a_row['stock_close'];

print "$db_id, $db_pname, $db_pcode , $db_packing, $db_type, $db_unit, $db_stock_close";



i got error.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /domains/55373/web/ipharma/form_header_final.php on line 89

Execute MySql Error: Incorrect usage of UNION and ORDER BY


what is wrong with my codin.. please any one help me out..!

[fenway]

Wrap your queries in parens.

[subash85]

how to do that i didnt get ya.... em juz newbie to php so need some example helpps..

[subash85]

please anyone can help me to solve my problem... thank you... i will so greatful to you all... and the phpfreaks.com family...

[roopurt18]

From my experience, you can not order the individual statements that constitute the UNION.

Code: [Select]

select * from table1
order by col1 <-- BAD (and pointless anyways)
union
select * from table2
order by col1 <-- Applies to entire result set, meaning all statements in the union

Someone correct me if I'm wrong please.

[fenway]

Write them as though they were sub-selects.

[subash85]

mysql_error(Resource id #10)

[fenway]

Great... what error, what query?