Programming Forums - View Single Post

dmorales · Apr 27th, 2005, 9:12 AM

I haven't got it working quite right. I assigned the post value to a variable. but now I get this error:

Syntax error close to 'david' to the line 1

and here's the code again:

(Toggle Plain Text)

$woClient = $_POST['add_work_order_client'];
$add_master = "select id from client_name where match (company) against $woClient";
$master_id = mysql_query($add_master) or die (mysql_error());

First let me make sure I got this right, id is a field I want to choose from. client_name is the table I'm choosing the field from. Match is the other field in that table that must be of equal value to the against which is the post value input by the user.

Is this right?

Apr 27th, 2005, 9:12 AM	#6
dmorales Programmer Join Date: Feb 2005 Posts: 74 Rep Power: 4	I haven't got it working quite right. I assigned the post value to a variable. but now I get this error: Syntax error close to 'david' to the line 1 and here's the code again: (Toggle Plain Text) $woClient = $_POST['add_work_order_client']; $add_master = "select id from client_name where match (company) against $woClient"; $master_id = mysql_query($add_master) or die (mysql_error()); $woClient = $_POST['add_work_order_client']; $add_master = "select id from client_name where match (company) against $woClient"; $master_id = mysql_query($add_master) or die (mysql_error()); First let me make sure I got this right, id is a field I want to choose from. client_name is the table I'm choosing the field from. Match is the other field in that table that must be of equal value to the against which is the post value input by the user. Is this right? __________________ Lorem ipsum dolor sit amet...