fleshbone:
Fetch both table as an associative array. Then use:

For each element in array 1;
Use in_array() to check if it appears in array2




Goodluck skyhighweb.

skyhighweb:
plz how do i go about that?

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

buyer
--------------
8
5
2

tagged
--------------
5
4
1
I'm trying to detect multiple same entry number. I want if a number appears on both of the columns it shouldnt display on the menu list anymore, like the 5 above hope yo understand.

Any tip?

code below

$query = "SELECT b.auction, b.buyer, 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');

vicsrael:
have my SQL query for that no duplicate select from multiple tables

fleshbone:


Its being a while I did php/mysqli.

Assuming u hav ur db connection setup already!


$select_statement = "select * from table_name";
$result_statement = mysqli_query($db_connection, $select_statement);

If(mysqli_num_rows($result_statement) > 0){

$all_table = mysqli_fetch_assoc($result_statement);


}

Else{
Echo "Zero Rows in table1"

}


$select_statement2 = "select * from table_name2";
$result_statement2 = mysqli_query($db_connection, $select_statement2);

If(mysqli_num_rows($result_statement2) > 0){

$all_table2 = mysqli_fetch_assoc($result_statement2);


}

Else{
Echo "Zero Rows in table2"

}


Foreach ($all_table1['column_name'] as $data_held){

If in_array($data_held, $all_table2['column_name']){
Echo 'yes' //this will echo yes each time it encounter any.
}
Else{
Echo 'No' // for each that wasn't found.
}

}





Try this, I hope it helps, I haven't tried it though.

skyhighweb:
hi thanks for the effort but am talking more of columns here not two tables but too columns

fleshbone:


The code should be shorter then:


$select_statement = "select * from table_name";
$result_statement = mysqli_query($db_connection,
$select_statement);
If(mysqli_num_rows($result_statement) > 0){
$column1 = mysqli_fetch_assoc($result_statement['column_name1']);

$column2 = mysqli_fetch_assoc($result_statement['column_name2']);



}
Else{
Echo "Zero Rows in table1"
}





Foreach ($column1 as $data_held){
If in_array($data_held, $column2){
Echo 'yes' //this will echo yes each time it encounter any.
}
Else{
Echo 'No' // for each that wasn't found.
}
}








Try this then.

skyhighweb:


hi sorry for bugging u and i tried the above didnt getting any output i guess am doing something wrong, heres the code am using
heres the ccomplete code

$query = "SELECT b.auction, b.buyer, 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');

$i = 0;
$hbidder_data = array();
foreach ($db->fetchall() as $bidrec)
{
if (!isset($bidderarray[$bidrec['nick']]))
{
if ($system->SETTINGS['buyerprivacy'] == 'y' && (!$user->logged_in || ($user->user_data['id'] != $auction_data['user'] && $user->user_data['id'] != $bidrec['bidder'])))
{
$bidderarray[$bidrec['nick']] = $bidrec['nick'];
$bidderarraynum++;
}

}

$template->assign_block_vars('tag_bidder', array(
'BGCOLOUR' => (!($i % 2)) ? '' : 'class="alt-row"',
'NAME' => $bidderarray[$bidrec['nick']],
'ID' => $bidderarray[$bidrec['id']]

));
$i++;
}


that display users name but when they show up in both columns (buyer and tagged) i dont want them to show up on the list, so u like comparing two columns in a table. thanks

fleshbone:




Am not good with object oriented aspect of mysqli.

Am sorry I don't understand some few syntax above!

fleshbone:




Am not good with object oriented aspect of mysqli.

Am sorry I don't understand some few syntax above!

skyhighweb:


hi ok i implemented where buyer != tagged, but it isnt working right it only works if the number are on the same roll eg

wont work like this

buyer tagged

4 5

2 0

6 4

the 4 above appears like that in the column need the code to check both columns not minding where the data is in the row

but works like this i altered it just to check and it works but not the way it should(works cause i put 4 in the same roll

buyer tagged

4 4

2 0

6 5

yorex2011:
skyhighweb
try This SQL Statement for the first part


SELECT `buyer`, `tagged`, `auction`, `bidder`, `willwin` FROM `bids` WHERE `buyer` NOT IN (SELECT `tagged` FROM `bids`) AND `tagged` NOT IN (SELECT `buyer` FROM `bids`)

This code will return only rows that do not have values of buyers in tagged..it will also ignore rows where the duplication occured

ie
8 0
2 0
5 0
7 5
8 4
9 1

would return
8 0
2 0
8 4
9 1


Full code should then be
SELECT `buyer`, `tagged` FROM `bids` WHERE `buyer` NOT IN (SELECT `tagged` FROM `bids`) AND `tagged` NOT IN (SELECT `buyer` FROM `bids`)
LEFT JOIN " . $DBPrefix . "users u ON (u.id = bids.bidder) WHERE bids.auction = :auc_id
ORDER BY bids.bid asc, bids.quantity DESC, bids.willwin asc



Always try to use SQL to get data, avoid using php to do stuff that SQL can do, its faster and better,

just imagine if you had 1million rows lol...

skyhighweb:
hi i just implemented urs didnt work (sad face)

skyhighweb:
hi i just implemented urs didnt work (sad face)

yorex2011:


post the table structures lets fully see..

If you can

fleshbone:
Its sad I couldn't help. I have no idea about PDO.

skyhighweb:
am not using pdo

fleshbone:




What are yoU using.