Re: Newbie? - help inserting into firebird1.0
| From: | (Lutz Brückner) | Date: | Tue, 26 Mar 2002 19:33:46 +0000 |
| Subject: | Re: Newbie? - help inserting into firebird1.0 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17927@lists.php.net to get a copy of this message | ||
Hi Jon-David,
not sure that this is the only problem, but rewrite your query like this
(single quotes araound the values):
$query="insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY,
BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED,
OBSERVED, STATUS, OPENED)
values
('$txtApp','$numVersion','$txtBuild','$txtOs',
'$frmSeverity',
'$numPriority', '$txtState', '$txtUser',
'$txtSteps', '$txtExpected',
'$txtObserved', '$frmStatus', 'NOW');";
Lutz
jdschlough@virtucomcsi.com (Jon-David Schlough) writes:
> $query="insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY,
> BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED, OBSERVED, STATUS,
> OPENED)
> values
> ("$txtApp","$numVersion","$txtBuild","$txtOs",
> "$frmSeverity",
> "$numPriority", "$txtState", "$txtUser",
> "$txtSteps", "$txtExpected",
> "$txtObserved", "$frmStatus", "NOW");";