Jump to content

already selected dont display


skyhighweb

Recommended Posts


need a help with a PHP/MySQL issue. I have a table named bids and two column named bidder and tagged both using int.

the 4 below appears 2twice in both columns need the code to check both columns not minding where the data is in the row and wont display it in the result

bidder     tagged

4             5

2             0

6             4

thats the code am using below 

$query = "SELECT b.auction, b.bidder, b.bid, b.tagged, u.nick, u.rate_sum FROM " . $DBPrefix . "bids b

LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder) WHERE b.auction = :auc_id

ORDER BY b.bid asc, b.quantity DESC, b.willwin asc"; $params = array(); $params[] = array(':auc_id', $id, 'int');

Edited by skyhighweb
Link to comment
Share on other sites

8 minutes ago, dsonesuk said:

Its no good createing a duplicate topic, it will be deleted. You have mysqli database connection, you have sql query to give you what you want, you just need to integrate into the mysqli method to retrieve those results.

and yet am not getting the issue solved, i dropped down d full code am using for the form i even asked u to assist implement it atleast this way i know what am doing

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...