On Saturday 13 November 2004 20:25, GH wrote:
Explain Bind Vars please... Thanks
It is a technique for preparing an SQL statement with placeholders which can
then be substituted with values when the statement is executed. It will be
unavailable to you unless you are using MySQL 4.1.3 or above
what mysql version are you running? versions under 4.1 DONT support
subqueries
bastien
From: GH [EMAIL PROTECTED]
Reply-To: GH [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Problem with an insert query
Date: Sat, 13 Nov 2004 01:29:58 -0500
In my mySQL database I have the following
You also appear to have a quote in the value that contains the word
members'
You will need to escape this or use bind vars.
Simon
On Saturday 13 November 2004 06:29, GH wrote:
In my mySQL database I have the following tables:
+-+
| Tables_in_AHRC |
+-+
|
Explain Bind Vars please... Thanks
On Sat, 13 Nov 2004 19:08:59 +, Simon Rees [EMAIL PROTECTED] wrote:
You also appear to have a quote in the value that contains the word
members'
You will need to escape this or use bind vars.
Simon
On Saturday 13 November 2004 06:29, GH wrote:
In my mySQL database I have the following tables:
+-+
| Tables_in_AHRC |
+-+
| Attendance |
| Participants|
| ProgressNotes |
| Sessions|
| Staff |
| StaffAttendance |
+-+
I am trying to insert data in the ProgressNotes