Change code as follows:

<?
$msgcre = "SELECT msg FROM creators WHERE id='0'";
$result = mysql_query($msgcre);
$row = mysql_fetch_array($result);
echo "<FONT color='#000000' style='font-size: 10pt; font-weight:
bold'>".$row['msg']."</font>";
 ?>

-----Original Message-----
From: Andrew Duck [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 28, 2001 7:00 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Resource id #2


I am trying to select a message from a table in a database. the message will
will be in column 'msg' and will be in same row as id='0'.
I need that msg put to the screen. With the code below I get the error:
Resource id #2

Can someone please explain how I can fix this..

Thankyou in advance.

<?
$msgcre = "SELECT msg FROM creators WHERE id='0'";
$msg = mysql_query($msgcre);
echo "<FONT color='#000000' style='font-size: 10pt; font-weight:
bold'>$msg</font>";
 ?>




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to