Getting data from database

[wanted420]

How would i get the actual text from the database? When i do this:

$test="SELECT body FROM post WHERE topic = '$topic'";
$test2=mysql_query($test);

echo $test2;

i get a "Resource ID #2" or something close to that everytime. I want it to post the actual text that is held in the column "body" where the topic is $topic.

TIA!!!

Wanted420

[tekky]

$test="SELECT body FROM post WHERE topic = '$topic'";
$test2=mysql_query($test);

$row = mysql_fetch_array($test2)
echo implde(',', $test2);
//or you can use
echo $test2['columnName'];

[wanted420]

I will just ask here instead of a new post. When i use a form and have it the submit button set like this:

<input type="submit" name="submit" value="POST">

why do i get an undefined variable when i do:

if ($submit)
{

}

or

if (!$submit)
{

}

EDIT:
Just incase, it should read:

if ($submit)
{
<input type="submit" name="submit" value="POST">
}

and the same for (!submit)

[tekky]

PHP defaults to REGISTER_GLOBALS = OFF

so you would have to use

$submit = $_POST['submit'];

then you can use if ($submit) (or you can just use the $_POST['submit'] inplace of $submit...

[wanted420]

Ok back to:

$test="SELECT body FROM post WHERE topic = '$topic'"; 
$test2=mysql_query($test); 

$row = mysql_fetch_array($test2) 
echo implde(',', $test2); 
//or you can use 
echo $test2['columnName'];

I have this:

$db = mysql_connect("localhost", "Admin");
mysql_select_db("testy", $db);

$post = "SELECT username,topic FROM post";
$post2 = mysql_query($post);
$num=mysql_numrows($post2);

$i=0;

while ($i<$num)
{
$username="SELECT username FROM post WHERE id='$i'";
$username2=mysql_query($username);
$username3=mysql_fetch_array($username2);

echo $username3['username'];

$i=$i+1;
}

It doesnt give an error but it doesnt output anything either. I know there is something in the table tho. I am thinking it might be the $username="SELECT username FROM post WHERE id='$i'"; but not sure. I have tried diff combinatin but no success.

[tekky]

mysql_num_rows($resultVar).....