Mysql Query Select Multiple Values In Only One Query Database Table



Mysql Query Select Multiple Values In Only One Query Database Table
 (380) Click. Work. Collect
Mysql Query Select Multiple Values In Only One Query Database Table
Post Description:
Post Tags: multi, diferent, different, one, shot, query, database, table, select, multiples, alot, many, in one shot, two, three
This Post Has Been Viewed 355 Times Since Sat Mar 29, 2008 1:05 pm Posted By hostman with 0 replies
Mysql Query Select Multiple Values In Only One Query Database Table
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

Leave Your Comments     [ dejar commentarios ]
  * Name     [nombre]

  * eMail (will not be published)     [coreo electronico]

* Enter Your Reply or Comments:    [commentarios]


Add Picture To Comments         [incluir foto]
YES NO             upload
Receive Replies on my Comments (An email will be sent to you when someone replies to your comments)

     

Comments and replies About Mysql Query Select Multiple Values In Only One Query Database Table




(0) Comments