MySQL Select multiple columns as one
Posted on 2004-11-22
Hi, I have a table with the following fields in:
I want to select them all as one column and loop through them all populating a single listbox with them.
I tried combining them all using syntax like
"SELECT (image1, image2, image3) AS image FROM tblimages"
but this didn't work, it just gave me an error. I also tried:
"SELECT image (image1, image2, image3) FROM tblimages"
but this also gave me an error. Lastly I tried
"SELECT image1 AS image, image AS image, image3 AS image FROM tblimages"
This didn't give me an error but it stil returned 3 seperate columns but all with the same name.
I know this is going to be really simple isn't it! Please help!