MySQL Connection = Blank Screen

[unclematty]

I am a real newbis here so this may be a simple question, but...

I am trying to connect to my DB and query it, outputting the results. I believe I am connecting because it is throwing no errors. For the same reason I believe my query is working.

However, I can not seem to print the results. Here is what I have...

<?php

// Set the database access information as constants.
DEFINE ('DB_USER', '######');
DEFINE ('DB_PASSWORD', '######');
DEFINE ('DB_HOST', '######');
DEFINE ('DB_NAME', '########');

// Make the connnection and then select the database.
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() );
mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error() );

$sql = "select * from forum";

$q = mysql_query($sql) OR die("Query Error: ".mysql_error());

echo $q;

?>

obviously i am not posting the db connection values.

Thanks in advance!

[mrhappiness]

output?
nothing?

the result you get from ymsql_query does not contain the data but a resource id

take a look at the manual, especially mysql_fetch_array, mysql_fetch_assoc, ...

[John_Canyon]

try this.

$row = mysql_fetch_array($q);
foreach($row as $key => $value)
{
      echo $key . " - " . $value . "<br>";
}

You can also get the results by using somehting like this.

while($row = mysql_fetch_array($q))
{
      echo $row[field_name] . "<br>"; //replace field_name with the name of the field you wish to retrieve data from.
}

Cheers.

[unclematty]

i am trying this now

so where ASP sticks the returned data into a recordset php sticks it into an array? is that right?

is there a way to stick the results into recordset?

[unclematty]

using mysql_fetch_array, how can i echo all fields.

you instance, if i dont know the name or number of fields that are beng returned, how can i echo all of the results?

thanks you have really been a huge help!

[Pig]

One way would be like this:
while( $row = mysql_fetch_row($result) )
{
foreach($row AS $value) echo($value . "<br>";
}