Fwd: anonymous select error

Philip Thompson <prthomp@xxxxxxxx> · Tue, 15 Jun 2004 11:15:47 -0500

I agree about the semi-colon: not allowed. But also, specify '$link' in 
your mysql_error(). This tells it explicitly what the error is 
referring to, even though it should be able to figure it out on it's 
own.

echo 'MySQL Error: ' . mysql_error($link);

Hope this helps - seems to work for me.

~Philip

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@xxxxxxxxxxxxx
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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php