DOH! mysql_fetch_array($data

decibel.places — Mon, 01 Sep 2008 15:45:09 +0000

DOH!

mysql_fetch_array($data)

only returns one row from the db at a time...

so you need a "while" loop to loop through all the rows in the db..

<?php

$con = mysql_connect("localhost","communit_508dev","commUNIT");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("communit_508prov", $con);


$sql = 'SELECT ptext FROM  provisions';

$data = mysql_query( $sql, $con );

while($row = mysql_fetch_array($data))
  {
  $arr .= $row['ptext'] . "<br />";
  }

print_r($arr);

mysql_close($con);
?>