Search the Community
Showing results for tags 'exist already'.
-
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');
-
Am using php MySQL and i have a table which get filled, i want to be able to remove already selected data from list(frontend) automatically to avoid multiple selection and not having two of the same data in the column how do i go about this, thanks. for example, if on the drop menu we have mike Jacob Steve David if someone already selected steve i don't want him to show up on the list plz note i have already exist code, i dont want to use that, thanks