Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,151,601 members, 7,812,963 topics. Date: Tuesday, 30 April 2024 at 12:04 AM |
Nairaland Forum / Science/Technology / Programming / Connecting Two Tables N Display Similar Ids (888 Views)
Nairaland Uses Tables!! / How To Add Up Tables Using Php / Thread Closed. (2) (3) (4)
Connecting Two Tables N Display Similar Ids by skyhighweb(m): 7:32pm On May 29, 2017 |
hi i have two tables items and bids items : columns: id car1 car2 4 toyota benz 6 camery lexus bids columns auction bidder 4 james 4 tom 6 steve i want items( id) to connect to bids (auction) and display only it result. |
Re: Connecting Two Tables N Display Similar Ids by badthinds: 9:14pm On May 29, 2017 |
skyhighweb:Your demand is not clear...but it seem clearer than your text. Again please (clearer this time) |
Re: Connecting Two Tables N Display Similar Ids by Dekatron(m): 3:08am On May 30, 2017 |
skyhighweb: If I can understand you well, your tables do not have a mutual columns. . . .Quite rusty in sql. . .Clarify this, then we can continue |
Re: Connecting Two Tables N Display Similar Ids by skyhighweb(m): 11:02am On May 30, 2017 |
ok here is what am trying to accomplish hi thanks for replying, i have this code for menu which displays the right result $query = "SELECT s.team_id, s.teams AS teams1, ss.team_id, ss.teams AS teams2, a.id, a.team1, a.team2 FROM " . $DBPrefix . "auctions a now this is the SUBMENU code which also works but displays all the result in the willwin column instead of rows that are connected via AUCTIONS(id) and BIDS(auction) like in the menu code, ordinary this is suppose to do that.....b.auction = :auc_id... for the submenu but it doesnt work when i introduce it. <?php i even have a pdo version and it has the same issue <?phpsame issue any idea who to solve the issue
|
(1) (Reply)
Remote Developer Readily Available / Hackers Only / Computer Entrepreneurs
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 23 |