Re: anonymous select error

From: Date: Tue, 15 Jun 2004 13:15:47 +0000
Subject: Re: anonymous select error
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-34792@lists.php.net to get a copy of this message
I'm not sure you need a semi-colon after the table name. $result = mysql_query( 'Select * From newsletter_subscribers', $db ); >> >>To: php-db-digest@lists.php.net >>MIME-Version: 1.0 >>Content-Type: text/plain; charset=us-ascii >> >>I'm trying this query: >> >>$link = mysql_connect( $site, $id, $pass ); >>if (!$link) { >> die('Could not connect: ' . mysql_error()); >>} >>echo 'Connected successfully<br>'; >> >>$db = mysql_select_db( $dbname, $link); >>if( !$db ) { >> echo "DB false<br>"; >> exit; >>} >> >>$result = mysql_query( 'Select * From >>newsletter_subscribers;', $db ); >> >>if (!$result) { >> echo "DB Error, could not list tables<br>"; >> echo 'MySQL Error: ' . mysql_error(); >> exit; >>} >> >> >>with this output: >> >>Connected successfully >>DB Error, could not list tables >>MySQL Error: >> >>I dont understand why there is an error, but it prints >>nothing for the error. Any ideas? Thanks, Josh

« previous php.db (#34792) next »