Re: SQL causing 500 error (was: What's Wrong With This?)

you need to use:


$sth->do( SQL STATEMENT HERE );
[download]

for one liners and


$SQL = " SQL STATEMENT HERE ";
$sth->prepare($SQL);
[download]

for statements you want to prepare and execute over and over again.

Comment on Re: SQL causing 500 error (was: What's Wrong With This?) Select or Download Code

Replies are listed 'Best First'.
Re: Re: SQL causing 500 error (was: What's Wrong With This?) by Anonymous Monk on Oct 07, 2002 at 06:11 UTC
Sorry, forgot a line. you need to use: `$dbh->do( SQL STATEMENT HERE );` [download] for one liners and `$SQL = " SQL STATEMENT HERE "; $sth->prepare($SQL); $sth->execute;` [download] for statements you want to prepare and execute over and over again.	[reply] [d/l] [select]