[thelist] PHP Newbie Stuck....try this

Sean Preston razorwise at yahoo.com
Fri Jun 1 13:41:23 CDT 2001


Sandy,

I'm just learning PHP myself, but I encountered this very same error a week ago.  The solution is
ticks.  I double checked this by removing them from one of my queries and duplicated your error.

My suggestion is to try this--->

$sql2 = "select * from CLIENTS where company_name = '$cname' ";
 
Instead of this--->

$sql2 = "select * from CLIENTS where company_name = $cname";
 
and it should work.  It's a SQL thing, that was clarified for me by Anthony Baratta (in the
following quote)--->  "Access will not accept SQL commands that have numerical fields 
surrounded by ''. MS SQL will accept '' around almost anything. By habit I 
always surround my values with '', just to make sure."

Let me know if that works for you.  We PHP newbies have to stick together!  :)

-Sean




__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/




More information about the thelist mailing list