[SOLVED] SQL Quickie

[eits]

Hi I am using:

$query_conn = "SELECT * FROM tblcustomer WHERE clientname = 'zoe'";   

 

It works to get user zoe details out of DB - however, if I try and get data from a selectbox using:

 

$query_conn = "SELECT * FROM 'tblcustomer' WHERE 'clientname' = " . $_POST['clientdd'];

 

I get the 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 '' at line 1

[beboo002]

$query_conn = "SELECT * FROM 'tblcustomer' WHERE 'clientname' = " . $_POST['clientdd'];

 

code some thing like

 

$query_conn = "SELECT * FROM 'tblcustomer' WHERE 'clientname' =  ' ". $_POST['clientdd']." ' ";

[eits]

This still gives me:

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 ''tblcustomer' WHERE 'clientname' = ' '' at line 1

 

It may be worth noting that the code that works:

//$query_conn = "SELECT * FROM tblcustomer WHERE clientname = 'zoe'";

 

doesn't work if i put  ' and ' either side of tblcustomer.

[beboo002]

put this

$query_conn = "SELECT * FROM tblcustomer WHERE clientname =  ' ". $_POST['clientdd']." ' ";

[Yesideez]

The error in the syntax was having ' surrounding the field names instead of `

 

$query_conn="SELECT * FROM `tblcustomer` WHERE `clientname`='".$_POST['clientdd']."'";