₦airaland Forum

hi programmer i have an issue here.
so let me explain better, if david place a bid but doesnt tag any one the column looks like this

bidder......tagged
david ..... 0

and if someone else(mike), place a bid and tag david

the column look like this

bidder......tagged
Mike ..... david

this shows both mikes and david rows
bidder......tagged
david ..... 0
mike ..... david

u can see david row doesnt update, it should show mike and not 0, hope u understand.

below is the code am using to fill the form

// tag someone
$query = "SELECT b.*, u.nick FROM " . $DBPrefix . "bids b
LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder)
WHERE b.bidder NOT IN ('b.tagged') and b.tagged IN ('b.bidder') and b.auction = :auc_id ";
$params = array();
$params[] = array(':auc_id', $id, 'int');
$db->query($query, $params);

$i = 0;
while ($row = $db->fetch())
{
$template->assign_block_vars('tag_bidder', array(
'ID' => $row['bidder'],
'NAME' => $row['nick'],
'TAGGED' => $row['tagged']
));
$i++;
}

It can't update now since its not David that tagged but was tagged

cbrass:
It can't update now since its not David that tagged but was tagged

yeah anyway one can update it?

skyhighweb:
yeah anyway one can update it?

did you write this code your self?

cbrass:
did you write this code your self?

rewrote em from an existing code

skyhighweb:
rewrote em from an existing code

OK Now create a separate table to hold tags, create two columns named the tagger and the tagged . Let's say David is ID 1 and Mike is ID 2 , when David tags Mike is I'd 1 should be insert in tagger while 2 which is for Mike goes into tagged, that way you can use the data in anyway you want

to add to what the user above said,

make both foreign keys in your new table, composite keys this will remove repeating rows