update the rows the query found

canabatz

i got this query that finds me the duplicate rows

Expand|Select|Wrap|Line Numbers

 $duplicates = mysql_query("SELECT bid_price, count(*) FROM bidding_details where bid_id= '1128' and sortbid = '1' GROUP BY bid_price having count(*) > 1");

$count = mysql_num_rows($duplicates);

if ($count > 0) {

    while ($row = mysql_fetch_assoc($duplicates)) {

        $bid_price = $row["bid_price"];

    }

    echo $count;
 
    mysql_free_result($duplicates);

}

what i need is to update those rows ,i want to update those rows to be SORTBID='0'

please help ,thanx

Markus

Well, using the same WHERE clause, just do an UPDATE instead of a SELECT.

canabatz

sorry for not trying it ,im afraid to do something wrong :)?

Expand|Select|Wrap|Line Numbers

 <?php

include('conn.php');

$duplicates = mysql_query("SELECT bid_price, count(*) FROM bidding_details where bid_id= '1128' and sortbid = '1' GROUP BY bid_price having count(*) > 1");

$count = mysql_num_rows($duplicates);

if ($count > 0) {

    while ($row = mysql_fetch_assoc($duplicates)) {

        $bid_price = $row["bid_price"];
 
    $duplicates1 = mysql_query("UPDATE bidding_details SET sortbid='0' where bid_id= '1128' and sortbid = '1' GROUP BY bid_price having count(*) > 1");
 
    }
 
    mysql_free_result($duplicates);

}

?>

thanx

canabatz

is it going to work?

Markus

You don't need the while loop, just run the query; because you're using a WHERE clause, all affected rows will be updated by the query.

canabatz

Expand|Select|Wrap|Line Numbers

 $duplicates = mysql_query("SELECT bid_price, count(*) FROM bidding_details where bid_id= '1128' and sortbid = '1' GROUP BY bid_price having count(*) > 1");

$count = mysql_num_rows($duplicates);

if ($count > 0) {

    $duplicates1 = mysql_query("UPDATE bidding_details SET sortbid='0' where bid_id= '1128' and sortbid = '1' GROUP BY bid_price having count(*) > 1");

    }

canabatz

can you explain for me please ,what i need?

can i do it with one row of a code?

please ,im not so good in php ,im learning from examples !

thank you

Markus

That _should_ work.

Gives me 10 minutes (just got in from doing some work with my pa, gotta cool down) and I'll explain it for you.

Mark.

update the rows the query found

re: update the rows the query found

re: update the rows the query found

re: update the rows the query found

re: update the rows the query found

re: update the rows the query found

re: update the rows the query found

re: update the rows the query found

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about