Re: HELP insert still dosn't work

On Tue, 20 Mar 2001, David Robley wrote: > On Tue, 20 Mar 2001 03:32, Rudolf Frint wrote: > > > > I want to insert the Values into my Database like this > > > > $handle = ora_logon("iusr@test","kiwi1"); > > $cursor1 = ora_open($handle); > > $query = "insert into internet_tmp select > > rv_ret($FF),$FF,$sesid,(sysdate+0.0021) from dual"; > > ora_parse($cursor1,$query) or die; > > ora_exec($cursor1); > > ora_close($cursor1); > > > > tring the insert query on sql-plus works fine what do I do wrong?? > > > > oh yea error msg is like this > > Warning: Ora_Parse failed (ORA-00923: FROM keyword not found where > > expected -- while processing OCI function OPARSE) in test2.php on line > > 40 > > > > line40 is parse line > > > > plaese help is very urgent > > rudi > > I'm not an Oracle person, but it sounds like you may have a syntax error > in your SQL. Try echo-ing $query and see how it looks. > > -- > David Robley | WEBMASTER & Mail List Admin > RESEARCH CENTRE FOR INJURY STUDIES | > http://www.nisu.flinders.edu.au/ > AusEinet | > http://auseinet.flinders.edu.au/ > Flinders University, ADELAIDE, SOUTH AUSTRALIA > I've had a few troubles with PHP/MySQL with requests like that... Maybe you could try that (it worked for me) : $query = "insert into internet_tmp select rv_ret(\"$FF\"),\"$FF\",$sesid,(sysdate+0.0021) from dual"; the \"$var\" are important : ".$var." won't do, even if with an echo $query, you _seem_ to get the same results... -- Ben As well look for a needle in a bottle of hay. Miguel de Cervantes