Jump to content

Archived

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

esiason14

Query help

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]

Share this post


Link to post
Share on other sites

×

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.