₦airaland Forum

AntiWailer:
Check your database table design structure.


This is how i will rather implement it.

I will have 2 tables.

- Bidder ===== To store details of every eligible bidder in my system

- BidderTags ==== To store all biddings and Tags.


Now each of the table will have the following fields :

== > BidderTable
BidderId - A unique Id of bidders {Primary Keys}
BidderName -- Full Name of the bidder
....... All other bidder related fields/data


==> BidderTagTable
BidderTagId ===AutoNumber that can act as Primary Key
BidderId === The Unique of the bidder in the system. a Foriegn Key to the BidderId in the Bidder Table.
BidderTagged === The Id of the bidder that was tagged
Active === A boolean value that indicates if this record is still ok or not
......... Other information related to the BidderTag (Dates, amount etc )

So when a bidder tags another bidder, you just drop a record in your BidderTag Table.

To know the number of tags a bidder have, run : "SELECT count(*) FROM BidderTagTable WHERE BidderTagged = 00005 AND Active = true"


You can even join the table to know the names of those who tagged him. You dont have to keep updating any row so you can keep logs for audit purpose.


Try read up on Database Normalization and understand the concept, you will not be having this kind of problem.


I hope this helps.

Mopricelezz:
Ikr.. Emerald City is wack. Rubbish series

amosunmd:
i hope the phone is pocket friendly cos am on my way to pick one

asuustrike2009:
If tecno are producing substandard phones then why are most Nigerians buying it? the so called standard phones have low sales over here haven't considered the reason behind it?

donhils:
But it has 64gb storage . No so bad.

Sphilip1:
I laugh in spanish... In as much as am disappointed in Innjoo's act, i think NCC is pushing its luck.

They have made it a hobby to lay fines on companies.

My favourite president is coming for them

emmanuelike:
I saw 1gb, 8gb Room, nothing about camera was shown on d front.

So I was like since d phone d get such heavy configuration, e go get at least 5.0 camera!

fleshbone:
What are yoU using.

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

yorex2011:
post the table structures lets fully see..

If you can

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...

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!

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.

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.

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

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.

roadsta:
Try to be more elaborate in your questions(detailed information) if you want an elaborate answer.
O.k Lets see an example :

From your initial post,i understaood that you have a list of names like "array(mike, jacob, steve, David); right?

If so, all you have to do is iterate through the list, grab the selected element in the list and remove with the unset fuction passing in the key :

As an example:

$users = [mike, jacob, steve, david];

foreach($users as $key=>$val)
{
if ($val==david) unset($names[$key]);
}
print_r($users);

I hope this should help solve the problem.

roadsta:
In that case all you need to do is :

- grab the value from the array
- then call unset($value) to remove it

vicsrael:
Explain better than

vicsrael:
Select unique columnname from table or if u need more than one column and u don't want a particular column to repeat value use select * from table group by norepeatcolumnname