having trouble updating to mysql

[tommy445]

i am getting the error

 

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #1' at line 1

 

I am trying to update client_phone in db through a form input.

 

<?php

 

 

$con = mysql_connect("localhost","xxxxx","xxxxx");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

mysql_select_db("xxxxx", $con);

 

mysql_query(" UPDATE site_clients

SET client_phone = '".$_POST['client_phone']."' WHERE client_first_name= '".$_POST['$client_first_name']."'");

 

if (!mysql_query($con))

  {

  die('Error: ' . mysql_error());

}

mysql_close($con)

?>

 

***One note... Currently the client_phone in the db is blank.  Not sure if this makes a difference.

 

Please help.  Thanks

[revraz]

Your error may be in another query.  The error you get appears to be using a Resource Result as a variable instead of the data.  Put your query into a variable and echo it to see if that is even the right query.

[Mchl]

I think you should change

 

if (!mysql_query($con))

 

to

 

if (!mysql_query(" UPDATE site_clients
SET client_phone = '".$_POST['client_phone']."' WHERE client_first_name= '".$_POST['$client_first_name']."'"))

 

And remove this

 

mysql_query(" UPDATE site_clients
SET client_phone = '".$_POST['client_phone']."' WHERE client_first_name= '".$_POST['$client_first_name']."'");