Jump to content

Query help


esiason14

Recommended Posts

I have this this small script to find players salaries. Im trying to update a players row with salary info where their First Name and Last name in the db match the results above: Can anyone see why this isnt working for me...It says its updating the records, but its not.

:
[code]
preg_match('@(?<="player"\>)([0-9]+)\s([^<]+)\s([^<]+),\s([^<]+)<br>@', $input, $info);
preg_match('@<b>.*Salary.*</b>\s([^<]+)<br>@', $input, $salary);


$first = ($info[2]);
$last = ($info[3]);
$ns = ($salary[1]);

// Connection
mysql_connect("ghghgh", "hghgh", "hghgh") or die(mysql_error());
mysql_select_db("dfdfdfd") or die(mysql_error());

// Insert
$sql= "UPDATE players SET salary='$ns' WHERE fname='$first' and lname='$last'";

printf ("Updated records: %d\n", mysql_affected_rows());

}
[/code]
Link to comment
https://forums.phpfreaks.com/topic/5271-query-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.