Stuart Felenstein wrote:
First time setting something like this up. So probably
making some major mistakes.
Anyway I get this message : mysql_error(Resource id
#2)
[snip]
echo . mysql_error($link);
Read the above line or use an editor that does syntax highlighting.
Also, you'll want to get the
]
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql error and resource ID:
Quote as in string or quote as in 'string' ?
Those two confuse me.
Stuart
--- [EMAIL PROTECTED] wrote:
If any of the variables used to insert data are
strings ($f1a, $f2a,
etc...), you'll need to have quotes
Anyone see something wrong here :
My error message is :
0: 1064: 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
'd',1,'d',1,1, 31, 33,10/15/2004))' at
line 5
Code:
$query = INSERT INTO MainTable
single
quotes around the whole date, like '10/15/2004'.
dave
Stuart Felenstein [EMAIL PROTECTED]
10/14/2004 10:02 AM
To:
Stuart Felenstein [EMAIL PROTECTED]
cc:
[EMAIL PROTECTED]
Subject:
RE: [PHP-DB] mysql error and resource ID:
Anyone see something