Mysql Query to return 2 columns as 1

Account Login

Latest Articles

The basic usage of PHPTAL, a XML/XHTML template library for PHP

by awuehr on 11-10-2008 in Tips & Tricks

Vulnerable methods and the areas they are commonly trusted in.

by Village Idiot on 11-04-2008 in Classes & Objects

Simple way to protect a form from bot

by codefreek on 10-23-2008 in Basic

The Basics On: How Session Stealing Works

by wiifanatic on 09-12-2008 in Security & Permissions

How to keep your forms from double posting data

by drewbee on 07-03-2008 in Tips & Tricks

IRC Channel

Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.

Associates

TalkPHP » Mysql Query to return 2 columns as 1

LinkBack

Thread Tools

Search this Thread

Display Modes

07-19-2009, 06:25 PM	#1 (permalink)
captainmerton The Acquainted Join Date: May 2009 Posts: 178 Thanks: 9	Mysql Query to return 2 columns as 1 I am looking to return 2 columns from 2 different tables as 1 column - is this possible? eh. Table1 ID DATA1 10 blahblah 15 blahblah Table2 ID DATA2 20 blahblah Say I want to write a query that will return 10,15,20 how would I do this assuming ID is declared the same on both tables?

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stream problem	Tanax	Advanced PHP Programming	9	06-10-2009 12:33 PM
MySQL query help	sjaq	Advanced PHP Programming	4	05-04-2009 10:33 AM
Next class project?	allworknoplay	The Lounge	6	04-18-2009 08:33 PM
[Tutorial] How to organize your classes \| Part 1	Tanax	Advanced PHP Programming	10	03-01-2009 10:08 PM
Problem with mysql_real_escape_string()	ETbyrne	Advanced PHP Programming	0	12-17-2008 10:39 PM

All times are GMT. The time now is 12:18 AM.