[SOLVED] PHP&MYSQL Question

[nathanmaxsonadil]

I was wondering how to display a column  from a mysql table?

[trq]

A simple example....

 

<?php

  $sql = "SELECT columnname FROM tablename";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      while ($row = mysql_fetch_assoc($result)) {
        echo $row['columnname'] . "<br />";
      }
    }
  }

?>