PHP - Displaying Database Data In Three Vertical Columns

Hi,
This has been baffling me for a couple hours now and i cant seem to figure it out.
I have some code which creates an array and gets info from a mysql database and then displays in a list. This works great but after adding more and more rows to my database the list is now becoming quite large and doesnt look great on my site.
Is it possible to split the list into multiple columns of about 25 and if possible once 3 or 4 columns have been created start another column underneath.
To help explain i would be looking at a layout as follows:
Code: [Select]
line 1      line 1      line 1
line 2      line 2      line 2
...      ...      ...
line 25      line 25      line 25

line 1      line 1      line 1
line 2      line 2      line 2
...      ...      ...
line 25      line 25      line 25Im guessing there should be some sort of if statement to check how many items are being displayed and to create a new column if necessary. Is this correct?

Thanks,
Alex

Hi,
I'm trying to joing two tables together, in the resulting PHP coding (See below)  the issue I'm having the coding saying select the colour from the colour table where the model of car is the same as the model in the cars table. For example, if the car model is KA and in the table it is KA show the colours.

I know this manual fix does the trick.

[
$test = "KA";
$query_cols = "SELECT * FROM colours WHERE colours.model = '$test' ";
]



But not the soultion any help would be much appericated thank you.


[
include "connections/dbconnect.php";
               $manfactures = "Ford";
               $car_query = "SELECT * FROM cars WHERE make = '$manfactures'";                  
               $car_result = mysql_query($car_query) or die ("Error in query: $car_query. ".mysql_error());
               
               setlocale(LC_MONETARY, 'en_GB');
               $fmt = '%i';
               if (mysql_num_rows($car_result) > 0)
               {
                  
                  
                  
                  while ($car_row = @ mysql_fetch_array($car_result))
                  {
                     
                     $test = "KA";
                     $query_cols = "SELECT * FROM colours WHERE colours.model = cars.model";
                     $cols_result = mysql_query($query_cols) or die ("Error in query: $query_cols. ".mysql_error());
                     print "
                           <table class='details'>
                              <tr>
                                 <td rowspan='2'>
                                    <img src=\"". $car_row["image"] ."\" alt='" . $car_row["image_alt"] . "' />
                                 </td>
                                 <td colspan='2'>
                                    <a href='" . $car_row["what_link"] . "'>
                                       " . $car_row["model"]." ".$car_row["model_details"] . "
                                    </a>
                              </tr>
                              <tr>
                                 <td>
                                    <p class='info'>
                                       RRP:<br/>
                                       What Price:<br/>    
                                       Our Price:<br/>
                                       Savings of:<br/>
                                       Delivery Time:
                                       
                                    </p>
                                 </td>
                                 <td>
                                    <p class='info1'>
                                 ";
                                       echo money_format($fmt, $car_row["rrp"] );
                             print "<br/>";
                           
                                       echo money_format($fmt, $car_row["what_price"] );
                             print "<br/>";
                           
                                       echo money_format($fmt, $car_row["our_price"] );
                           
                             $savings = $car_row["rrp"] - $car_row["our_price"];
                             print "       <br/>
                                       <font color=\"red\">";
                                          echo money_format($fmt, $savings );
                             print "       </font><br/>
                                       " . $car_row["delivery_time"] . "
                                    </p>
                                 </td>
                              </tr>
                              <tr>
                                 <td>
                                 ";
                                    while ($cols_row = @ mysql_fetch_array($cols_result))
                                    {
                              ?>
                                               

                                                <a href='#' onmouseout='hideTooltip()' onmouseover='showTooltip(event,"<?php print "" . $cols_row["colour"] . ""; ?>");return false'>
                                      <?php
                                          print "                                                
                                                <img src=\"". $cols_row["colour_img"] ."\" alt='" . $cols_row["colour_img_alt"] . "' />
                                               ";
                                    }
                          print "
                                 </td>
                              </tr>
                              ";   
                  }                           
               }
               
   
               else
               {
                  echo "Aids!";
               }
               print "</table>";                     

                        
                           ?>]

So I have an simple account centre up, and i'm wanting to display their 'Name' 'Username' and 'Email' as part of their details. But I have one problem... My code doesn't seem to be getting the data from my database...

It may be messy to some people, just warning you!

Code: [Select]
<?php

session_start();

if($_SESSION['username']){

$connect = mysql_connect("****","****","****") or die("Could not connect to database.");
mysql_select_db("****") or die ("Could not find database!");

$sql = mysql_query("SELECT * FROM login");

$username = $rows['username'];
$email = $rows['email'];
$rows = mysql_fetch_assoc($sql);

echo "<p>";
}
else
header("location: suggestion.html");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
body {
background-color: #CCC;
}
body,td,th {
color: #000;
font-family: "MS Serif", "New York", serif;
}
</style>
</head>
<body>
<div id="wrap">
<!--Header-->
    <div id="header_member">
   
    </div>
   
    <!--Log out and time-->
        <div id="info">
<div id="date"><script type="text/javascript">
var currentDate = new Date()
  var day = currentDate.getDate()
  var month = currentDate.getMonth() + 1
  var year = currentDate.getFullYear()
  document.write("<b>" + day + "/" + month + "/" + year + "</b>")
  var currentTime = new Date()
  var hours = currentTime.getHours()
  var minutes = currentTime.getMinutes()</script>
     </div>
             
           
             
        <div id="time"><script type="text/javascript">
var suffix = "AM";
  if (hours >= 12) {
  suffix = "PM";
  hours = hours - 12;
  }
  if (hours == 0) {
  hours = 12;
  }

  if (minutes < 10)
  minutes = "0" + minutes

  document.write("<b>" + hours + ":" + minutes + " " + suffix + "</b>")</script>
          </div>
          </div>
         <div id="logout"><center><?php echo "<a href='logout.php'>Log out.</a>";?></center></div>
         
  <!--Main section which will contain everything else-->
  <div id="member_main">
             
           <div id="member_right"><center>
             <p><img src="images/accountinf.png" width="175" height="30" /></p>
             <p>Name: <?php echo $username;?></p>
             <p>Email: <?php echo $email;?></p>
               </center>

        </div>
               
   <div id="member_top"><center><?php echo "Welcome, ".$_SESSION['username'];?></center></div>
                   
               <div id="member_left" align="center"><img src="images/navigation.png" width="105" height="30" /><img src="images/home_member.png" width="105" height="30" /><img src="images/account.png" width="105" height="30" /></div>
          </div>
             
<!--Footer-->         
<div id="footer_member"></div>           
</div>

</body>
</html>

PHP Code
Code: [Select]

<?php
$username="";
$password="";
$database="";

mysql_connect("","","");
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tablename";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$field1-name=mysql_result($result,$i,"id");
$field2-name=mysql_result($result,$i,"Location");
$field3-name=mysql_result($result,$i,"Property type");
$field4-name=mysql_result($result,$i,"Number of bedrooms");
$field5-name=mysql_result($result,$i,"Purchase type");
$field6-name=mysql_result($result,$i,"Price range");

echo "<b>$field1-name 
$field2-name2</b><br>$field3-name<br>$field4-name<br>$field5-name<hr><br>";

$i++;
}

?>

HTML code for the form
Code: [Select]

<table id="tb1">
<tr>
<td><p class="LOC">Location:</p></td>
<td><div id="LC">
<form action="insert.php" method="post">
<select multiple="multiple" size="5" style="width: 150px;" >
<option>Armley</option>
<option>Chapel Allerton</option>
<option>Harehills</option>
<option>Headingley</option>
<option>Hyde Park</option>
<option>Moortown</option>
<option>Roundhay</option>
</select>
</form>
</div>
</td>

<td><p class="PT">Property type:</p></td>
<td><div id="PS">
<form action="insert.php" method="post">
<select name="property type" style="width: 170px;">
<option value="none" selected="selected">Any</option>
<option value="Houses">Houses</option>
<option value="Flats / Apartments">Flats / Apartments</option>
</select>
</form>
</div>
</td><td>
<div id="ptype">
<form action="insert.php" method="post">
<input type="radio" class="styled" name="ptype" value="forsale"/> For Sale

<p class="increase">
<input type="radio" class="styled" name="ptype" value="forrent"/> To Rent
</p>
<p class="increase">
<input type="radio" class="styled" name="ptype" value="any"/> Any
</p>
</form>
</div>
</td>
</tr>

</table>

<div id="table2">
<table id="NBtable">
<tr>
<td><p class="NBS">Number of bedrooms:</p></td>
<td><div id="NB">
<form action="insert.php" method="post">
<select name="number of bedrooms">
<option value="none" selected="selected">No Min</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select> to

<select name="number of bedrooms">
<option value="none" selected="selected">No Max</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</form>
</div>
</td>

<td><p class="PR">Price range:</p></td>
<td><div id="PR">
<form action="insert.php" method="post">
<select name="price range">
<option value="none" selected="selected">No Min</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>
</select> to

<select name="price range">
<option value="none" selected="selected">No Max</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>

</select>
</form>
</div>
</td>


</tr>

</table>

</div>
<form id="submit" action="">
      <input type="submit" value="search" />
      </form>

I am trying to display data from a database from a form entry

here is the php

<?php
include('dbconnect.php');

@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM child_info";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$field1-name=mysql_result($result,$i,"file_number");
$field2-name=mysql_result($result,$i,"first_name");
$field3-name=mysql_result($result,$i,"middle_name");
$field4-name=mysql_result($result,$i,"last_name");
$field5-name=mysql_result($result,$i,"birthdate");
$field6-name=mysql_result($result,$i,"gender");
$field7-name=mysql_result($result,$i,"features");
$field8-name=mysql_result($result,$i,"diagnosis");
$field9-name=mysql_result($result,$i,"description");
echo "<b>$field1-name
$field2-name2</b><br>$field3-name<br>$field4-name<br>$field5-name<hr><br>";

$i++;
}

?>

here is the form I am using

<form name="child_info" action="selectdata.php" method="post"  id="child_info">
                       <table width="444" align="center" >
         <tr>
                                    <td>
                                       Search by Name:
                                    </td>
                                    <td>
                                       First Name:<input type="text" class="form-textbox " id="first_name" name="first_name" size="20" /><br />
                                        Last Name:<input type="text" class="form-textbox " id="last_name" name="last_name" size="20" />
                                    </td>
                                </tr>
                               <tr>
                                   <td width="208">
                                       Choose Male or Female:                                    </td>
                                <td width="224">
                                    <input type="radio" name="gender" value="male" />
                 Male
                 <input type="radio" name="gender" value="Female" />
                 Female                                  </td>
                            </tr>
                            <tr>
                               <td>
                                   Choose age range:                               
                                </td>
                                <td>
                                   <select name="first_age" id="first_age">
                                  <option value="00">From</option>
                                  <option value="1">1</option>
                                  <option value="2">2</option>
                                  <option value="3">3</option>
                                  <option value="4">4</option>
                                  <option value="5">5</option>
                                  <option value="6">6</option>
                                  <option value="7">7</option>
                                  <option value="8">8</option>
                                  <option value="9">9</option>
                                  <option value="10">10</option>
                                  <option value="11">11</option>
                                  <option value="12">12</option>
                                  <option value="13">13</option>
                                  <option value="14">14</option>
                                  <option value="15">15</option>
                                  <option value="16">16</option>
                                  <option value="17">17</option>
                                  <option value="18">18</option>
                                </select>
                                 <select name="second_age" id="second_age">
                                  <option value="00">To</option>
                                  <option value="1">1</option>
                                  <option value="2">2</option>
                                  <option value="3">3</option>
                                  <option value="4">4</option>
                                  <option value="5">5</option>
                                  <option value="6">6</option>
                                  <option value="7">7</option>
                                  <option value="8">8</option>
                                  <option value="9">9</option>
                                  <option value="10">10</option>
                                  <option value="11">11</option>
                                  <option value="12">12</option>
                                  <option value="13">13</option>
                                  <option value="14">14</option>
                                  <option value="15">15</option>
                                  <option value="16">16</option>
                                  <option value="17">17</option>
                                  <option value="18">18</option>
                                </select>
                              </td>
                            </tr>
                            <tr>
                               <td>
                                </td>
                                <td>
                                </td>
                            </tr>
                            <tr>
                               <td>
                                </td>
                                <td>
                                    <div align="right">
                                      <input type="submit" name="submit" id="submit" value="submit" />
                                      <input type="reset" name="reset" id="reset" value="reset" />
                                       </div></td>
                            </tr>
                          </table>
                    </form>

first problem is getting the form to use the php

second problem is when i try to use the php alone is I get this error

Parse error: syntax error, unexpected '=' in /home/fathersh/public_html/selectdata.php on line 17   17 is highlighted above in the php