esiason14 Posted March 19, 2006 Share Posted March 19, 2006 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]);// Connectionmysql_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 More sharing options...
wickning1 Posted March 19, 2006 Share Posted March 19, 2006 Where's your call to mysql_query()? Link to comment https://forums.phpfreaks.com/topic/5271-query-help/#findComment-18749 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.