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:
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
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";
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 !
Related Content
Information
Forums »
MySQL Forums And Topics Discussions About Open Source Database »
Mysql Query Select Multiple Values In Only One Query Database Table
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
Date: Sat Mar 29, 2008
Author hostman Received 1 Replies #895
Share
URL: 

Embed: 

To embed this topic, just copy the code from the "Embed" box. Once you've copied the code, just paste it into your website or blog to embed it
BBCODE:: 

BBCODE is use on forums. You can put this code on all your BBCODE enabled forums like PhpBB, vBulletin® and others. Just Copy and Paste this code on your Posts and Replies on your forums
wallpaperama | Wallpapers | Forums | Terms Of Service
copyright © 2013 wallpaperama - All Rights Reserved - Last Updated Mon May 06, 2013 (-8 GMT)
Powered by: Webune Forums V5
copyright © 2013 wallpaperama - All Rights Reserved - Last Updated Mon May 06, 2013 (-8 GMT)
Powered by: Webune Forums V5