I have put together a simple form to add jobs to a career database. However, I have been getting an SQL error, no matter what I try. I used code that worked previously, but now get the error. The only time it works is when I replace the values with actual data, rather than the php code. I get the following error:
When I remove the error handler and add the echo to view the info, I get the following:PHP Code:
Couldn't execute query.
RESULT=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 'Consultant, Blue Bell , $38,000 , 610-555-1212 , 610-555-6666 ,
It seems it is carrying the data through, so I am not sure what the issue is. Help would be much appreciated!PHP Code:
INSERT INTO `OS` ( `date_posted` , `title` , `location` , `salary` , `phone` , `fax` , `email` , `description` , `require` , `id` ) VALUES (11/7/2005 , Marketing Consultant, Blue Bell , $38,000 , 610-555-1212 , 610-555-6666 , firstname.lastname@example.org , Assist client Account Managers to increase sales by expanding business with existing customers. Provides healthcare professionals with value-added services and product information. Builds strong rapport and relationship with Account Manager/s to facilitate marketing efforts. Profiles and manages targeted list and provides value-added benefits to accounts in order to help Account Manager grow volume Builds rapport with Account Managers / Clients. Attends comprehensive training programs gaining knowledge of products, product application and regulations. Completes required data entry, including details of the targets response, rep notes and follow up action necessary (if appropriate). Maintains phone time and call productivity as well as other measures required by the Company. Provides seamless coordination/integration with Account Manager/s and customer accounts. Provides ongoing communication with Account Manager/s , Develops and maintains strong customer relationships with client Minimum of 2 years previous Account Management experience. Projects a professional and polished image that inspires confidence and trust. Handles complex problems effectively. Separates key issues and generates multiple solutions. Effective verbal communication and rapport building skills. Good organizational skills and the ability to prioritize accurately and manage multiple tasks. Experience informing clients, superiors, peers, and direct reports based on their information needs. Ensures that the customer receives a superior product or service. Listens attentively and responds effectively to client. Is team-oriented and works collaboratively to achieve team goals. Committed to exceeding quality standards and providing exceptional products and services. Make sure customers expectations are met. Combines phone etiquette and marketing skills to get results. , OS27);