skyhighweb Posted May 4, 2017 Share Posted May 4, 2017 (edited) 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 May 4, 2017 by skyhighweb Link to comment Share on other sites More sharing options...
dsonesuk Posted May 4, 2017 Share Posted May 4, 2017 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. Link to comment Share on other sites More sharing options...
skyhighweb Posted May 4, 2017 Author Share Posted May 4, 2017 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 More sharing options...
justsomeguy Posted May 4, 2017 Share Posted May 4, 2017 Let's keep it to one topic. Link to comment Share on other sites More sharing options...
Recommended Posts