Unable to fetch from MySQL using PHP

Question

I'm trying to fetch from a MySQL Database using PHP and at the moment having no luck and I'm not sure why.

<?php 

include "base.php";

$CurrentID = 1;

$Message = mysql_query("SELECT Message FROM wall WHERE MessageID = 1");

$MessageFetch = mysql_fetch_assoc($Message);

echo $_MessageFetch['Message']

?>

Database:

alt text http://img204.imageshack.us/img204/844/screenshot20100805at013.png

When echo $Message it returns Resource ID 4

ritch
– ritch

2010-08-05 00:37:28 +00:00
Commented Aug 5, 2010 at 0:37 — ritch
– ritch, Commented Aug 5, 2010 at 0:37

codaddict · Accepted Answer · 2010-08-05 00:40:15Z

2

There is an extra underscore in:

$_MessageFetch

.

echo $_MessageFetch['Message']

should be

echo $MessageFetch['Message']

answered Aug 5, 2010 at 0:40

codaddict

457k83 gold badges501 silver badges537 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to fetch from MySQL using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related