Combining two sql queries with different data

Question

I want to combine two queries to make them act as single query

there are NO unique columns in both the tables

My two queries

SELECT * from admin WHERE name != 'xyz'
Select goods from good_items where userid=$userid

with single query I am getting the results fine . but two queries combined i get this error

mysql_fetch_array() expects parameter 1 to be resource, boolean given in

I am combining the queries like this

 $sqlofferadmin=mysql_query("SELECT name,task,prize from admin WHERE name != 'xyz' 
    UNION ALL 
    SELECT goods from good_items WHERE userid=$userid");

I want to display out like this

<?php 
 while($row = mysql_fetch_array($sqlofferadmin))  
{

    echo "<tr> ";
    echo "<td>" .$row[name] . "</td>";
    echo "<td> ".$row[task] . "</td>";
    echo "<td>" .$row[goods] . " </td>";
 }
     echo "</tr> " ;
  ?>

Start with running this query in console or phpmyadmin for example. — u_mulder, Feb 28 '16 at 18:58
@nasima for `union all` the select columns in both the queries has to be the same. What is it that you are trying to get from both the queries? — Fakhruddin Ujjainwala, Feb 28 '16 at 19:01
@FakhruddinUjjainwala , Please suggest a work around for this problem, I need to collecy all data from table admin and single colum from table good_items with WHERE userid=$userid — nasima, Feb 28 '16 at 19:03
@nasima instead of union all try merging to tables on unique column — Fakhruddin Ujjainwala, Feb 28 '16 at 19:04
@nasima in order to help further I need to know the unique column you have in both the tables that identifies your single row. — Fakhruddin Ujjainwala, Feb 28 '16 at 19:05
@Fakhruddin Ujjainwala thats what i have written in question section, that both tables are diffrenet. with nothing unique in them. — nasima, Feb 28 '16 at 19:08
@nasima on what basis are you selecting goods then? There has to be a relation! — Fakhruddin Ujjainwala, Feb 28 '16 at 19:10

score 0 · Answer 1 · answered Feb 28 '16 at 19:09

0

This should help you:

    $sqlofferadmin=mysql_query("SELECT name,task,prize,goods from admin a, 
goods g WHERE a.unique_column = g.unique_column and name != 'xyz' and userid=$userid");

But the above is only valid if you have a relation in 2 tables.

answered Feb 28 '16 at 19:09

Fakhruddin Ujjainwala

2,463
16
26

nope, I dont have any unique column in them – nasima Feb 28 '16 at 19:11
what are 2 tables ment for? Because if you are displaying data together there has to be some relation. – Fakhruddin Ujjainwala Feb 28 '16 at 19:12
one coloum from goods contains a total amount for name field. that will be displayed againist userid . i.e name , task , prize , goods(with user id ) I hope it makes sense. – nasima Feb 28 '16 at 19:15
@nasima so each goods will be associated with a user correct? – Fakhruddin Ujjainwala Feb 28 '16 at 19:16
thats right. but i dont have any matching columns in both the tables. – nasima Feb 28 '16 at 19:18
@nasima then I would say its bad database architecture. You should normalize database first. – Fakhruddin Ujjainwala Feb 28 '16 at 19:20
Thanks for the suggestion, I cant modify the database, That Why I am looking for some work around for this problem – nasima Feb 28 '16 at 19:21
@nasima there is no work around I guess. – Fakhruddin Ujjainwala Feb 28 '16 at 19:26

Combining two sql queries with different data

1 Answers1