[creepycridler]

I have a mysql query that calls a table to display, but the borders don't want to show around empty fields. How do I implement the "empty-cells: show" function into this script?

Thanks ahead!

PHP Code:

// Connect to Database and execute query ---------



mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");



@mysql_select_db("$DBName") or die("Unable to select database $DBName");



$sqlquery = "SELECT * FROM $table ORDER BY L_name";



$result = mysql_query($sqlquery);





echo "<table border = 1 empty-cells:show>

<tr>

<td nowrap>First Name</td>

<td nowrap>Middle Name</td>

<td nowrap>Last Name</td>

<td nowrap>Spouse's Name</td>

<td nowrap>Nickname</td>

<td nowrap>Address</td>

<td nowrap>City</td>

<td nowrap>State</td>

<td nowrap>Zip Code</td>

<td nowrap>Country</td>

<td nowrap>Phone Number</td>

<td nowrap>Email Address</td>

<td nowrap>Years Rowed</td>

<td nowrap>Club Participation</td>

<td nowrap>Notes</td>

<td nowrap>Designation</td>

<td nowrap>Code</td>

</tr>";



while($row = mysql_fetch_array($result)) {



echo "

<tr><td nowrap>".$row[F_name]."</td>

    <td nowrap>".$row[M_name]."</td>

    <td nowrap>".$row[L_name]."</td>

    <td nowrap>".$row[S_name]."</td>

    <td nowrap>".$row[N_name]."</td>

    <td nowrap>".$row[street]."</td>

    <td nowrap>".$row[city]."</td>

    <td nowrap>".$row[state]."</td>

    <td nowrap>".$row[zip]."</td>

    <td nowrap>".$row[country]."</td>

    <td nowrap>".$row[phone]."</td>

    <td nowrap>".$row[email]."</td>

    <td nowrap>".$row[years]."</td>

    <td nowrap>".$row[participation]."</td>

    <td nowrap>".$row[notes]."</td>

    <td nowrap>".$row[designation]."</td>

    <td nowrap>".$row[code]."</td>    

</tr>";



}



echo "</table>";



if(mysql_num_rows($result)<1){

echo "<font face=Arial size=+0><b>No

Results!</b></font><br>";

}



mysql_free_result($result);

?> 

[NeverMind]

add this foreach() inside the body of the while:

PHP Code:

foreach($row as $field => $value)

   if (empty($value))

       $row[$field] = ' '; 

so your while should be like this:

PHP Code:

while($row = mysql_fetch_array($result)) {

   foreach($row as $field => $value)

      if (empty($value))

         $row[$field] = ' '; //you can change the value from "space" to whatever you want 



  echo "

<tr><td nowrap>".$row['F_name']."</td>

    <td nowrap>".$row['M_name']."</td>

    <td nowrap>".$row['L_name']."</td>

    <td nowrap>".$row['S_name']."</td>

    <td nowrap>".$row['N_name']."</td>

    <td nowrap>".$row['street']."</td>

    <td nowrap>".$row['city']."</td>

    <td nowrap>".$row['state']."</td>

    <td nowrap>".$row['zip']."</td>

    <td nowrap>".$row['country']."</td>

    <td nowrap>".$row['phone']."</td>

    <td nowrap>".$row['email']."</td>

    <td nowrap>".$row['years']."</td>

    <td nowrap>".$row['participation']."</td>

    <td nowrap>".$row['notes']."</td>

    <td nowrap>".$row['designation']."</td>

    <td nowrap>".$row['code']."</td>    

</tr>";



} 

and note that I put quotes in all $row['FIELD'] because this the correct way to do it! other wise you were making php throw notices each time and also waste time looking for constants with the same names of the field..

[creepycridler]

Thanks dude. I appreciate your feedback!