Join 3 Tables On MySQL
Posted by: Nanta on: August 17, 2007
This Article have been moved at Show Data with Join 3 Tables MySQL
9 Responses to "Join 3 Tables On MySQL"
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
September 9, 2008 at 2:43 pm
wow,.. great post I should say. Was looking for join and after reading your post and add in some join with your left join, my sql are working!
Again, Thanks = )
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!!!!!
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….
I`m sorry, the error was only title_post and post that showed up on the browser. But the title_topic, intro and title_category was blank. Something wrong with my query???
I`m very sorry about the error….
The error was not:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\work\showpost.php on line 8
July 13, 2010 at 5:37 am
I need to write a query which get array of data from one table and then search in second table at basis of result..Please help me..I can forward my code its only return me one record and search that one rec in second table ..I wanna get more then one rec Please Please Please help me out..
Leave a Reply
My !Yahoo
Community
Balikpapan blogger
Recent Comments
Foto2
|
Peta-Pengunjung
Digg
- Space Shuttle and 747 Mating: In Depth Look | Video
- Soviet Moon Lander Discovered Water on The Moon in 1976 - Technology Review
- Three 'Genetic Zip Codes' Laid Foundation for Evolution of Human Brain
- The 10 Most Awesome Pools In the World
- Iran claims to have beaten 'Flame' computer virus - Telegraph
- Arctic Ecology Provides Clues to Life on Jupiter's Moon, Europa
- Dharun Ravi Says He's Sorry For "Thoughtless, Insensitive, Immature" Acts
- The three actors rumored for Hunger Games' Finnick Odair
- The Only Thing Better than a Restaurant is a Breastaurant (PICS)
- Church cheers as 4-year-old sings ‘ain’t no homos gonna make it to heaven’ | The Raw Story
ComputerWorld
- Microsoft launches Office 365 edition for U.S. gov't customers
- Cisco: Global 'Net traffic to surpass 1 zettabyte in 2016
- TED head: Online video, education platform are the future
- Global business services net big returns
- Cisco takes its lumps, keeps developing video meeting tools
- FCC ruling on 800MHz band a boon for Sprint
- More Networking News
NetworkWorld
- Oracle prepares to enter PaaS wars
- Facebook Phone: Why Facebook May Join the Effort to Own Your Digital Soul
- Google to face fresh ICO scrutiny over WiFi snooping
- Academia joins in battling Android malware
- Chrome to take world's top browser spot for May
- Experts question the need for a Facebook smartphone
- Anonymous India calls for non-violent protests against censorship
- Opera is Facebook's best browser play
- Cisco takes its lumps, keeps developing video meeting tools
- NASA denies Iranian cyberattack
InfoWorld
- HP: Net-Zero Energy Data Center cuts power usage by 30 percent
- Zurmo open source CRM app pins its hopes on gamification
- Development timeline key to linking Stuxnet, Flame malware
- FAQs: The Flame virus
- White House launches coordinated effort to battle botnets
- Juniper packs 30 new features into Web security software
- Apple's operating systems: Fortresses or prisons?
- 10 keys for building private clouds
- Security startup Vaultive tackles cloud-based encryption
- Nearly a fifth of U.S. PCs have no virus protection
June 11, 2008 at 5:53 pm
good help