Why am I getting "Resource id #12" when I wanrt text?

seanpaulcail

I'm trying to pull from text from a database and display it on screen. Simple enough, but it doesn't work.

Here, the code on my index page

$homepage_text= get_Homepage_text();

display_Homepage ($homepage_text);

Here's the code for the above functions that are aquired via include

function get_Homepage_text()
{

   $conn = db_connect();
   $query = 'select Homepage_text
             from Homepage where id=1'; 
   $result = @mysql_query($query);
   if (!$result)
     return false;
   $num_cats = @mysql_num_rows($result);
   if ($num_cats ==0)
      return false;  

   return $result; 
}

and

function display_Homepage($homepage_text)
{
  echo '<div id="Homepage_text" style="position:absolute; left:20px; top:300px; width:600px; height:200px; z-index3"> 
<table width = \"100%\" border = 0><tr>';

echo '<td valign="top">';
echo '<span class="details">';
echo $homepage_text;
echo '</div>';
}

But all I get on my screen is "Resource id #12"

why is my code not working? And what is "Resource id #12" ?

thanks in advance

TheDefender

Because that is exactly what you are telling your script to output...

Let's remove the functions, and look at the lines in question:

$query = 'select Homepage_text from Homepage where id=1';  

$result = @mysql_query($query); 
echo $homepage_text; // ( which is essentially echo $result; )

So, you are basically echoing the $result output of the query, and never fetch the array to display it. ([man]mysql_fetch_array[/man])

seanpaulcail

Yes I need to fetch the array

here's a brioef summary of how I made it work:

$conn = db_connect();
$query1 = ('select * from Homepage');
$Homepage_text = mysql_query($query1);
$Homepage_text_final = mysql_fetch_array($Homepage_text);
echo $Homepage_text_final['Homepage_text'];

This code works but it's not how I wanted to program.

I think I can figure it out from here.

thanks again

TheDefender

No Problem... You are on the right track, and I figure you should be able to figure it out from here. Come on back if you need more help with anything.