SQL Question

[Nij.UK]

Im not sure if i have put this in the right section.....

 

I am wanting to do an query on a database, im using mysql.

 

i want to query 3 fields on a single table but want the results to comeout as just one field. it was a long shot but i tried the following which didnt work, but might explain what i want to do

 

SELECT dt7 AS year7, ict7 AS year7, art AS year7 WHERE sID=1;

 

this didnt work, can anyone shed some light as to how i can do this

 

Thanks

 

Nij

[Geoff]

What is the data? numbers? do you want to add them up?

[Nij.UK]

the data is alphanumeric data...... i want to query 3 fields form the table return the results as if it was 3 entries from a single field in the table...

 

so i would want them returned as year7 and the result would be 3 individual rows from the fields ict7, dt7, art7 etc.....

[Geoff]

SELECT dt7 + ict7 + art AS year7 WHERE sID=1;

[Nij.UK]

that adds the values together..... i want the results from each field as 3 individual results. individual rows

[Geoff]

Then do 3 selects?

[Nij.UK]

it would just make it easier to handle in PHP if i could get it to work like that, as i could just use the array....

 

Im trying to get my script to generate dynamic graphs

[Iain]

Hows about.....

(SELECT dt7 AS year7 WHERE sID=1)
UNION ALL
(SELECT ict7 AS year7 WHERE sID=1)
UNION ALL
(SELECT art7 AS year7 WHERE sID=1);

 

Should give you one table with one column named year7 containing the data from the 3 SELECT queries.

[Nij.UK]

thanks Iain.... i think u just hit the nail on the head, just what i was looking for and works aswell!

 

Cheers mate!