ansaurus

Question

Answer 1

+2 A:

Those are not Mysql errors. They are PHP errors. Basically you are most likely attempting to use variables without declaring them first. Be sure to always declare your variables before using them. It makes you less like to have errors.

John Conde 2010-01-15 19:07:32

hi thanks for pointing..http://pastebin.com/m4fbf313dPlease look ,,,

Bharanikumar 2010-01-15 19:20:31

Answer 2

A:

In a UNION query, the column names must be the same for all rows. So it uses the column names from the first query in the union. Column names in subsequent queries in the union are ignored.

In other words, in this query:

select id,cHospital from med_patient where cHospital is not null union 
select id,cHospital1 from med_patient where cHospital1 is not null union 
select id,cHospital2 from med_patient where cHospital2 is not null order by 1

The column names on all rows are: id and cHospital.

So in your PHP code, when you fetch the result as an object and try to reference a field of the object like this:

$cHospital1 = $row->cHospital1;
$cHospital2 = $row->cHospital2;

The object doesn't have fields by those names. It only has $row->cHospital, even for rows that came from the second and third queries in the union.

Bill Karwin 2010-01-15 19:27:13

the column count is same know , what i have to changes here

Bharanikumar 2010-01-15 19:30:49

Just use `$row->cHospital` for all rows.

Bill Karwin 2010-01-15 19:34:23

Query is perfect now, u see i got , 1st row as null , how to eliminate that..

Bharanikumar 2010-01-15 19:38:16

NULL is not the same as an empty string `''` in SQL. If you want to restrict against rows where the hospital is blank, put that condition in the `WHERE` clauses.

Bill Karwin 2010-01-15 19:54:10

Answer 3

A:

MY problem fixed...

Thanks to team...

Bharanikumar 2010-01-15 19:50:31

It is the custom on StackOverflow to give an upvote for answers that helped you, and to mark as the accepted answer the answer that helped you the most.

Bill Karwin 2010-01-15 20:45:14

ansaurus

tags:

views:

answers:

mysql select query Error

related questions