2 | andrew jebose
August 7, 2008 at 9:58 am

i need a support on how to join 3 to four tables in a database using mysql select but it keeps repeating 1 no throughout..i need the query to do that..like am joining these four tables together now
account payment,account trxn,savings_trxn_details and the relationship among them is the account id but one of them does not have the account id and i want the details on the other to appear on the same table with them..
thanks
andrew

4 | Anon
November 17, 2008 at 12:22 am

Oh, you are the man! It took me a while to google if 3 joins were even possible!

Thanks!!!!!

6 | joe
July 7, 2009 at 8:08 pm

[quote]
$sql=mysql_query(“SELECT title_post, post, id_category, id_topic FROM posting_forum
LEFT JOIN topic_forum ON posting_forum.id_topic = topic_forum.id_topic
LEFT JOIN category_forum ON posting_forum.id_category = category_forum.id_category ORDER BY id_post”);

$x=mysql_fetch_array($sql);

echo “Topik: $x[title_topic]“;
echo “”;
echo “Intro: $x[intro]“;
echo “”;
echo “Category: $x[title_category]“;
echo “”;
echo “Title: $x[title_posting]“;
echo “”;
echo “Post: $x[post]“;
[/quote]

My DataBase:

tbl>1 posting_forum

id_post
id_category
id_topic
title_posting
post

tbl>2 category_forum

id_category
title_category

tbl>3 topic_forum

id_topic
title_topic
intro

———————————————————————————-
I have an error in result :

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\work\showpost.php on line 8

I also rename the fetch_array function to num_rows but still got the same error. Please help me wats wrong with my query or script?

Thank for the help….