₦airaland Forum

Welcome, Guest: RegisterLoginWith GoogleTrendingRecentNew

Stats: 3,326,376 members, 8,426,265 topics. Date: Sunday, 14 June 2026 at 12:21 AM

Toggle theme

Help Database Probs - Webmasters - Nairaland

Nairaland ForumScience/TechnologyWebmastersHelp Database Probs (596 Views)

1 Reply

Help Database Probs by Nobody: 11:02pm On Jul 04, 2011
<?php
$query = "SELECT b.*, u.nick, u.rate_sum FROM " . $DBPrefix . "bids b
LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder)
WHERE b.auction = " . $id . " ORDER BY b.bid DESC, b.quantity DESC, b.id DESC";
$result_numbids = mysql_query($query);
$system->check_mysql($result_numbids, $query, __LINE__, __FILE__);
?>

plz help i need to add another table how do i do this let say table name is buyers dbprefix is the same as users
Re: Help Database Probs by ogzille(m): 7:14am On Jul 05, 2011
do you want to select a column from another table?

is the any similar column between the two tables?
Re: Help Database Probs by Nobody: 10:31am On Jul 05, 2011
Yes i want to select another column from table buyer
1 Reply

Help! Database Invasion!!!Having Probs Installing Fireboard Forum In Joomla 2.5.4Probs Hosting My Site Via Ftp!234

Od&#347;nie&#380;anieTutorial: How To Use Coupon Codes To Reduce The Cost Of WebhostingYahoo Ceo - Carol Bartz Fired!