Simple database query

Anon

This should be incredibly simple, but I am completely stuck! I have connected to the database and made the following query:

mysql_select_db("sls99d");

$query = "select Question 
	  from Questions 
	  where Question_no = 'Q1'";

$result = mysql_query( $query );

$num_results = mysql_num_rows($result);

echo "<p>."$result".</p>";

The query is correct, the database is connected, but it returns "resource #2" instead of the question from the database.

Why does it do this, what does 'resource #2' mean?

Thanks.

Anon

Your code should look mike this :
$db =mysql_connect("YourHostName, "UserName");
mysql_select_db("sls99d",$db );

$query = "select Question
from Questions
where Question_no = 'Q1'";

$result = mysql_query( $query );

$num_results = mysql_num_rows($result);

//Good luck

Anon

Sarah,

Your variable $result is actually a handle / pointer to the database results recordset / cursor (depends on the db system you're using).

You done 2 out of the 3 steps that you need to get PHP to display the result data.

Step 1: Build your query (i.e. the $query variable)
Step 2: Send that query to the db and get a handle on where the db has the results (i.e. the $result variable)
Step 3: Fetch the data from the results set (i.e. from where $results is pointing at).

There are a number of possible statements for this, but they all begin mysql_fetch_.

As an example, try adding this line before your echo statement.

$row = mysql_fetch_row($result);

and then changing your echo statement to:

echo "<p>."$row[0]".</p>";

HTH

Justin

Anon

I hope that there is connection to the Server(localhost or www.xx.yy or ... and your Database is sls99d.

$query = "select Question from Questions where Question_no = 'Q1'";
$result = mysql_query($query);
print "<table>",
echo "<tr><th>Question</th></tr>";
while ($record->mysql_fetch_object($result)){
echo "<tr><td>$record->Question</td></tr>";
}
print "</table>";

This might solve your problem;
solomon