Maybe "open" is a reserved word ? Try
"SELECT t.ip,t.title FROM $ttable2i t WHERE t.open = ?" -----Original Message----- From: anthony [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:23 AM To: [EMAIL PROTECTED] Subject: statment 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();
smime.p7s
Description: S/MIME cryptographic signature
