Wallpapers Forums Login

Mysql Query Select Multiple Values In Only One Query Database Table

Posted On Sat Mar 29, 2008 By hostman In MySQL Forums And Topics Discussions About Open Source Database Forums

if you have multiple selections and instead of making two different queries in mysql you can do one

like this for example:

$sql = "SELECT u.username, p.*, pt.post_text, pt.bbcode_uid, pt.post_subject, p.post_username

FROM phpbb_posts p, users u, phpbb_posts_text pt

WHERE p.topic_id = $topic_id

AND p.poster_id = u.user_id
AND p.post_id = pt.post_id

ORDER BY p.post_time ASC";

this helped me alot i wanted to learn how to do this to select multiples selections in three different tables and fields in my databases

tags: muti multiple

Guest Tue Nov 11, 2008

pretty neat !

Information

Forums »
MySQL Forums And Topics Discussions About Open Source Database »
Mysql Query Select Multiple Values In Only One Query Database Table

Title: Mysql Query Select Multiple Values In Only One Query Database Table

Description: mysql query select multiple values in only one query database table

Tags: multi , diferent , different , one , shot , query , database , table , select , multiples , alot , many , in one shot , two , three

Info: This Post Has Been Viewed 0 Times Since
Date: Sat Mar 29, 2008
Author hostman Received 1 Replies #895

Mysql Sort By Two Fields ORDER By 2

Mysql Query Select Multiple Values In Only One Query Database Table

Related Content

Information

Share