positioning data on your webpage pulled from a mysql database
<p>I am trying to position the data pulled from my mysql database using the following php code on my webpage;</p>

<pre><code>&lt;?php
    require "connect.php";
    $query =  "select * from item LIMIT 0, 1";
    $result = @mysql_query($query, $connection) 
    or die ("Unable to perform query&lt;br&gt;$query");
?&gt;

&lt;?php
while($row= mysql_fetch_array($result))
{
?

//call each item from the database, and nest in div or html table

&lt;?=$row['item']?&gt;
&lt;?=$row['description']?&gt;
&lt;?=$row['brand']?&gt;
</code></pre>

<p>When I view the webpage it creates the row for each item however each field is empty?</p>

<p>The conection to the database is fine as I ran another piece of code which simply displayed all the info in 1 block. However this is not what I want I want to be able to position each item where I want it on the site.</p>

<p>I wrote this when I had php version 4.1 running on IIS I am now running the latest version of php 5 and after doing some reading it says there are chnages in the syntax including global variables disabled by default so not sure if this is the issue?</p>
