Jump to content


Photo

Query help


  • Please log in to reply
1 reply to this topic

#1 esiason14

esiason14
  • Members
  • PipPipPip
  • Advanced Member
  • 58 posts

Posted 19 March 2006 - 04:26 AM

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.

:
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());

}


#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 19 March 2006 - 06:55 AM

Where's your call to mysql_query()?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users