Jump to content


Query help

  • Please log in to reply
1 reply to this topic

#1 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

  • 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