[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