On Fri, Jun 27, 2003 at 04:22:51PM +0200, anthony wrote:
> Ok,
> I'm horribly tired with SQL I don't know why I'm getting a bad sql statment
> I tried these, but i really don't see the error
>
> $mbx=DBI->connect("dbi:mysql:$db3","$db3log","$db3pass") ||
> ErrTemp::Connect($DBI::errstr);
> $get=$mbx->prepare("SELECT ip,title FROM $ttable2 WHERE open = ?");
> $get->execute(0);
>
> $mbx=DBI->connect("dbi:mysql:$db3","$db3log","$db3pass") ||
> ErrTemp::Connect($DBI::errstr);
> $get=$mbx->prepare("SELECT ip,title FROM $ttable2 WHERE open = 0");
> $get->execute();
>
You have not provided enough information. Please tell us the value of
$ttable2, and the exact text of the error message you are getting.
Ronald
