LEFT JOIN'ing 2 tables a particular way

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 » LEFT JOIN'ing 2 tables a particular way

LinkBack

Thread Tools

Search this Thread

Display Modes

01-24-2008, 04:08 PM	#1 (permalink)
Nor The Addict Join Date: Nov 2007 Posts: 282 Thanks: 61	LEFT JOIN'ing 2 tables a particular way Sa if I have two mysql tables and the 1st one is the 'topic' table and the other is a 'reply', there are many replies and one topic for each set of replies, How could I LEFT JOIN the last reply to te topics query (when selecting the topics data from the database), without having 2 queries, is this possible, if so how would I do this. __________________ PHP/XHTML Freelancer: Cleanscript.com v3 - Programming starting at just $5 act now!

« 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

All times are GMT. The time now is 11:31 AM.