mysql_affected_rows

[adam525]

I have one mysql linkid in an include.

 $dbcon1=mysql_connect("localhost","root","pass") or die(mysql_error);
 mysql_select_db("ttsalescom")or die(mysql_error);

The PHP manual says that to use mysql_affected_rows, you run your query, then use the mysql_affected_rows function as follows...

$arupdate1 = mysql_query("UPDATE PROFIT SET addretgamt = '{$aramount2}', type = '{$x}' WHERE mid = '{$armid2}' AND ReportDate = '{$arprocdate1}'");
$logquery1 = mysql_affected_rows($dbcon1);

I have many more queries using the same linkid. What do I do?

Thanks,

Adam

[laserlight]

I have many more queries using the same linkid. What do I do?

Just run those queries. mysql_affected_rows() is concerned with the most recent INSERT, DELETE, UPDATE or REPLACE statement executed that is associated with the given link id.

Incidentally, if you have more than one link id in a given script, you should provide it as an argument to mysql_select_db() and mysql_query() as well.

Furthermore, I suggest switching to the MySQLi extension or PDO extension as they allow you to use functionality available in MySQL 4.1+ and also provide an object based interface with prepared statement support.

[halojoy]

adam525 wrote:

$arupdate1 = mysql_query("UPDATE PROFIT SET addretgamt = '{$aramount2}', type = '{$x}' WHERE mid = '{$armid2}' AND ReportDate = '{$arprocdate1}'");

$logquery1 = mysql_affected_rows($dbcon1);

I have many more queries using the same linkid. What do I do?

If you want an easy way to create an array LOG of your Queries
using this as array name: $logquery
... then you can do this way

<?php
// Log ALL num_aff_rows, into an array

//first query
$arupdate1 = mysql_query("UPDATE PROFIT SET addretgamt = '{$aramount2}', type = '{$x}' WHERE mid = '{$armid2}' AND ReportDate = '{$arprocdate1}'");
// store number of aff rows
$logquery[] = mysql_affected_rows($dbcon1);

// next query
$arupdate1 = mysql_query("UPDATE PROFIT SET addretgamt = '{$aramount2}', type = '{$x}' WHERE mid = '{$armid2}' AND ReportDate = '{$arprocdate1}'");
// store number of aff rows
$logquery[] = mysql_affected_rows($dbcon1);

// and so on


// To display LOG Array
foreach($logquery AS $kn => $numaff){
    echo $kn . ': ' . $numaff . '<br />';
}

?>

Reggars 🙂
halojoy

[adam525]

Thank you very much. Not sure where the option is to mark as resolved, but that did it...

[halojoy]

See menu:
Thread Tools
...glad you can use my code

regars 🙂
halojoy