Formatting Form Checkboxes

nascarjunky

I would greatly appreciate any help with the following. I have a form with checkboxes which are populated with descriptions from a database table. The form works as desired in that it creates the checkbox and provides the description I want.

Please click here to see the form.

My desire is to format this form into a table so the driver names and salaries are in a column of their own to make things look nice and tidy. I would also like to use a number format for the values. Please see the partial code below.

  include("nascarconnect.php");

   echo "<html>
      <head><title>All Drivers</title></head>
      <body>";


  $query = "SELECT * FROM AllDrivers 
                ORDER BY salary DESC";
  $result = mysql_query($query)
       or die ("Couldn't execute query.");

  echo "<div style='margin-left: .5in'>
  <p>&nbsp;
  <p><b>Please Select 15 Drivers From The List Below.</b>
  <p>Be Sure And Select 15:\n";


  /* create form containing checkboxes */
  echo "<form action='15manrosterselection.php' method='POST'>\n";

  while ($row = mysql_fetch_array($result))
  {
     extract($row);
     echo "<input type='checkbox' name='driver'value='$drid'>$name $salary";
     echo "<br>\n";
  }
echo "<p><input type='submit' value='Submit 15 Man Roster'>
        </form>\n";
?>
</div></body></html>

Thanks in advance for any and all help.

wilku

Ask Google for "html tables" and you'll learn how to build tables in html.
Ask Google for "php format number" and you'll learn how to format number in php (that's easy one as there is a function called [man]number_format[/man]).

As for your code. Outputting records to your form is handled here (comments to help you understan what's going on):

while ($row = mysql_fetch_array($result))//fetch one row from the result into an associative array (like $row['name'] = "Driver Name")
  {
     extract($row);//each key of array $row is transformed into independent varible, like $name = "Driver Name"
     echo "<input type='checkbox' name='driver'value='$drid'>$name $salary"; //send to browser html which will render checkbox, driver name and his salary from the record in the database
     echo "<br>\n";//line break in html and in source code of the page
  }

And how to change it:

//hint: echo table header here
while ($row = mysql_fetch_array($result))
  {
     extract($row);
     //hint: format your number here
     echo "<input type='checkbox' name='driver'value='$drid'>$name $salary";//another hint: change this line to reflect table structure (one row)
     echo "<br>\n";//hint: you won't need this
  } 
//yet another hint: echo table footer here