[RESOLVED] Using a MySQL Field as a Table Title (Cheesy Picture Included)

suttercain

I first would like to thank obsidian for helping me to get the alternating row colors!

What I am trying to do

Right now my page looks like this:
http://www.supermandatabase.com/arb/row1.gif

Where it says DIVISION I would like it to be populated from a a MySQL Column to be the name of the Vehicle" instead. It would look as such:
http://www.supermandatabase.com/arb/row2.gif

Further details. In MySQL table I have a column named div (Division) and I would like to fetch "Acura" and use it as a table title. But only once. Since there are numerous Acura I only want it listed the single time with all the Acuras listed below that title (see second picture). Once it is done with Acura it will move to the next vehicle and use that as a title (see second pic).

Here is the code I am using to generate my page now (see picture one):

<?php
//Connect to the Database via the Include File!
require ('get_connected.inc');

// Begin your table outside of the array
echo "<table width='100%' border='0' cellpadding='1' cellspacing='0'>
    <tr>
        <td><b>DIVISION</b></td>
		<td><b>DISPLACEMENT</b></td> //<----THIS IS WHERE I WAS THE MySQL TITLE
		<td><b>FUEL</b></td>
		<td><b>CLASS</b></td>
		<td><b>EMISSION STD</b></td>
		<td><b>TEST GROUP</b></td>
		<td><b>EO NUMBER</b></td>
    </tr>";

// Perform an statndard SQL query:
$res = mysql_query("SELECT sub_model, disp, fuel, veh_class, arb_std, test_group, eo FROM vlist_2007 ORDER BY division ASC") or die (mysql_error());

// Assuming $res holds the results from your query:
$class = 'even';
while ($row = mysql_fetch_assoc($res)) {
  $class = $class == 'even' ? 'odd' : 'even';
  echo "<tr class=\"$class\">\n";
  echo "<td>$row[sub_model]</td>\n";
  echo "<td>$row[disp]</td>\n";
  echo "<td>$row[fuel]</td>\n";
  echo "<td>$row[veh_class]</td>\n";
  echo "<td>$row[arb_std]</td>\n";
  echo "<td>$row[test_group]</td>\n";
  echo "<td>$row[eo]</td>\n";
  echo "</tr>\n";
}
?>

I was able to get the DIVISION replaced by a value in the title header... but I need to break it in groups as seen in Photo 2.

bpat1434

Here's a basic example, see if it helps:

<?php

// Your query stuff....
$current = '';
while($row = mysql_fetch_array($result)) {
  if($current != $row['div']) {
    $current = $row['div'];
    echo '<tr>
  <th>' . $current . '</th>
  <th>Displacement</th>
  <th>Fuel</th>
  <th>Class</th>
  <th>Emmission Standard</th>
  <th>Test Group</th>
  <th>EO Number</th>
</tr>';
  }
  // The rest of the info for the car(s)...
}

Hope that helps.

suttercain

I ran the following code:

<?php
//Connect to the Database via the Include File!
require ('get_connected.inc');

// Begin your table outside of the array
echo "<table width='100%' border='0' cellpadding='1' cellspacing='0'>
    <tr>
        <td><b>DIVISION</b></td>
        <td><b>DISPLACEMENT</b></td>
        <td><b>FUEL</b></td>
        <td><b>CLASS</b></td>
        <td><b>EMISSION STD</b></td>
        <td><b>TEST GROUP</b></td>
        <td><b>EO NUMBER</b></td>
    </tr>";

// Perform an statndard SQL query:
$res = mysql_query("SELECT sub_model, disp, fuel, veh_class, arb_std, test_group, eo FROM vlist_2007 ORDER BY division ASC") or die (mysql_error());

// Assuming $res holds the results from your query:
$class = 'even';
$current = '';
while($row = mysql_fetch_array($result)) {
  if($current != $row['div']) {
    $current = $row['div'];
    echo '<tr>
  <th>' . $current . '</th>
  <th>Displacement</th>
  <th>Fuel</th>
  <th>Class</th>
  <th>Emmission Standard</th>
  <th>Test Group</th>
  <th>EO Number</th>
</tr>';
  }

}
?>

And got the following error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\ARB\pio\vlist_2007.php on line 31

leatherback

while($row = mysql_fetch_array($result)) {
should be:
while($row = mysql_fetch_array($res)) {

as $res it the reference you got from the database

bpat1434

The code i gave you was not meant to be cut & paste. You won't learn that way. The error means that the variable you used in the function call mysql_fetch_array does not hold a mysql result object. If you look 5 lines up, you'll fix this problem.

suttercain

Hello,

Thanks for the replies. I tried the code and fixed $result to $res. No when I run the code I just get the header titles....

DIVISION DISPLACEMENT FUEL CLASS EMISSION STD TEST GROUP EO NUMBER

The list is no longer being populated like it was in the first image I posted.

bpat1434

Because my code was not COOKIE CUTTER CODE. You have to actually apply what was given to you. This is the ending of the while() loop:

  } 
  // The rest of the info for the car(s)... 
}

You have to replace the "// The rest of the info for the car(s)..." with whatever code you want displayed like you had in the first post.

suttercain

Okay, I nested a while loop within another

<?php
//Connect to the Database via the Include File!
require ('get_connected.inc');

// Perform an statndard SQL query:
$res = mysql_query("SELECT division, sub_model, disp, fuel, veh_class, arb_std, test_group, eo FROM vlist_2007 ORDER BY division ASC") or die (mysql_error());


// Assuming $res holds the results from your query:
$class = 'even';
while ($row = mysql_fetch_assoc($res)) {
echo "<table width='100%' border='0' cellpadding='1' cellspacing='0'>
    <tr>
        <td><b>$row[division]\n</b></td>
		<td><b>DISPLACEMENT</b></td>
		<td><b>FUEL</b></td>
		<td><b>CLASS</b></td>
		<td><b>EMISSION STD</b></td>
		<td><b>TEST GROUP</b></td>
		<td><b>EO NUMBER</b></td>
    </tr>";

while ($row = mysql_fetch_assoc($res)) {
  $class = $class == 'even' ? 'odd' : 'even'; //CSS Style Sheet Class for Alternating 
  echo "<tr class=\"$class\">\n";
  echo "<td>$row[sub_model]</td>\n";
  echo "<td>$row[disp]</td>\n";
  echo "<td>$row[fuel]</td>\n";
  echo "<td>$row[veh_class]</td>\n";
  echo "<td>$row[arb_std]</td>\n";
  echo "<td>$row[test_group]</td>\n";
  echo "<td>$row[eo]</td>\n";
  echo "</tr>\n";
}
}
?>

and got pretty darn close to my goal (see image 2) this is now my result

IMAGE 3

As you can see the DIVISION has been replaced by the MySQL DIVISION name in this case Acura... but only the first four are acuras, I then need it to list the column titles again, but then this time say AUDI where it's AUDI... etc. Picture is exactly what I am looking to achieve.

Should I be using a foreach loop instead?

Thanks for your time.

Shannon

bpat1434

No. You need to remove the inner while() loop. You only need one. remove the inner while, and you should be set.

suttercain

Yah! I got it working. Took a couple of hours, but I am still learning. I wanted to thank you for your help. Here is the final code for anyone that may want it:

<?php
//Connect to the Database via the Include File!
require ('get_connected.php');

// Begin your table outside of the array
echo "<table width='100%' border='0' cellpadding='4' cellspacing='0'>
    <tr>
    </tr>";

// Perform an statndard SQL query:
$res = mysql_query("SELECT * FROM cars ORDER BY vehicle ASC") or die (mysql_error());

// Assuming $res holds the results from your query:
$class = 'even';
$current = '';
while($row = mysql_fetch_array($res)) {
  if($current != $row['vehicle']) {
    $current = $row['vehicle'];
    echo "<tr>
        <td width='110'><b>$current</b></td>
		<td width='110'><b>FUEL</b></td>
		<td width='110'><b>DISPLACEMENT</b></td>
</tr>";
  }
  $class = $class == 'even' ? 'odd' : 'even';
  echo "<tr class=\"$class\">\n";
  echo "<td>$row[sub_class]</td>\n";
  echo "<td>$row[disp]</td>\n";
  echo "<td>$row[fuel]</td>\n";
  echo "</tr>\n";
}
?>

Thanks again and have a great weekend!

bradgrafelman

Don't forget to mark this thread resolved.