combining 2 fields in a single mysql select query

mrjameer · #1 28-Sep-2006, 19:04

hi,

i want to combine 2 fields in a single select query

fields. pageheader name
values. abcd <div id="d"></div>

i want to merge/combine the pageheader and name in a single select query so that it can retrieve the pageheader with some styles which i have stored in another table

thanks
mrjameer

TurboPT · #2 28-Sep-2006, 20:38

try:

Code:

SELECT concat( <field1>, ' ', <field2> ) AS single FROM <your_table>

I named the concat result as 'single', but call it what you want.

Also, did you get your radiobutton post(s) figured out?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tricky MySQL query involving multiple primary keys...	TreyAU21	MySQL / PHP Forum	6	29-Mar-2009 21:45
Cpanel downgrade MYSQL 4.1.X to MySQL 4.0.xx	Webhosting-live	Web Hosting Forum	1	01-Sep-2006 03:54
MySQL Query Problem	eRIC	MySQL / PHP Forum	1	18-May-2004 05:49
Integrate a mysql query into another	norok	MySQL / PHP Forum	2	22-Jul-2003 07:25

combining 2 fields in a single mysql select query

Re: combining 2 fields in a single mysql select query