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] Quote 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()? Quote Link to comment https://forums.phpfreaks.com/topic/5271-query-help/#findComment-18749 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.