Re: [PHP-DB] Problem with an insert query

2004-11-15 Thread Simon Rees
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

RE: [PHP-DB] Problem with an insert query

2004-11-13 Thread Bastien Koert
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

Re: [PHP-DB] Problem with an insert query

2004-11-13 Thread Simon Rees
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 | +-+ |

Re: [PHP-DB] Problem with an insert query

2004-11-13 Thread GH
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:

[PHP-DB] Problem with an insert query

2004-11-12 Thread GH
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