displaying data

[182x]

Hey guys, sorry for all the n00bie questions however this time I am wondering how to display a set of data from a database. For example if the database has 4 columns cId, ty, dId, am and I would like to display all the information in a table where session id = dId. I can create the query but how do you actually display this information?

Thanks.

[danmahoney245]

First off no question is a noobie question.  Here is what you want:

[code]

<?php

include( "header.php" );

$sql = "SELECT * FROM database_name";

$query = mysql_query( $sql );

  while ( $row = mysql_fetch_array( $sql ) ) {

            $data = "".$row["data"]."";

            print "Here is $data<br><br>";

  }

?>

[/code]

Tell me if it works, and good luck!

-Dan

[182x]

Hey thanks for your reply.

I have tried the method you have suggested but it turns up the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in Ne\tr.php on line 11