Re: MSSQL ?
| From: | Erin's Fan Club© | Date: | Sun, 13 Aug 2000 15:02:21 +0000 |
| Subject: | Re: MSSQL ? | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-1759@lists.php.net to get a copy of this message | ||
Hi Jeroen:
> > If my page is called I get an error...
> > <<snipped>>
> > I'll attach the source, can someone help me out quickly ?
> Attach it, send it, feel free.
This >> symbol means code continues next line
This line is your problem....
$query = "INSERT INTO tblWebRMA
>>(CustCode,ProdCode,SerialNr,Acc,PropPack,Bil,ProbDescr, >>
PurDate,Special,Host1,Host2,DateIn) values
>>('$txt_custcode','$txt_product', '$txt_serialnr', >>
'$chk_accesinc','$chk_proppack','$chk_invoice','$txt_probdesc',
>>
'$txt_purchdate','$txt_special', '$host1', '$host2',
'GETDATE()');"
Fisrtly some debugging tips...
1) Put an 'echo "<something>";' in after every line of code. PHP will
print the numbers till it quits. If you use different <somethings> you
can easily see where PHP bugs out.
2) If PHP quits at line 15, look at line 14. That'll probably be where
the error is!!!
3) Comment out any new lines of code. Run the script, if all is
well, uncomment each line till you get the error. There lies the
problem.
Anyway, your problem is here ,'GETDATE()');"
It should read 'GETDATE()')";
The " and ; were backwards. It runs with that changed.
Regards, EF
webmaster@ixion.org
Not everything in black and white makes sense