[Resolved] Another dumb question

vaavi8r

OK I have my data showing up in a table but I have a couple other questions.

1) How do I get the & nbsp inserted so that the fields with no data display better?

2) I want to have a total of two of the columns show at the top of the table (outside of the table)

3) How do I get the dates to show up as mm-dd-yyyy format?

Here is my script:

<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM flightlog WHERE macid='MAC100' ORDER BY date DESC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

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

?>
<table border="2" cellspacing="2" cellpadding="2">
<tr>
<th>MACID</th>
<th>Name</th>
<th>Date</th>
<th>Type</th>
<th>Departure</th>
<th>Destination</th>
<th>Time</th>
<th>Charter #</th>
<th>Charter Pay</th>
<th>Comment</th>

</tr>

<?
$i=0;
while ($i < $num) {
$macid=mysql_result($result,$i,"macid");
$date=mysql_result($result,$i,"date");
$name=mysql_result($result,$i,"name");
$type=mysql_result($result,$i,"type");
$departure=mysql_result($result,$i,"departure");
$destination=mysql_result($result,$i,"destination");
$hours=mysql_result($result,$i,"hours");
$charterno=mysql_result($result,$i,"charterno");
$charterdoll=mysql_result($result,$i,"charterdoll");
$comment=mysql_result($result,$i,"comment");
?>

<html>
<a href="http://www.margaritaair.com/index.html">MAIN PAGE</a> 
<A href="http://www.margaritaair.com/roster.html">ROSTER</a>

You can view the table at http://www.margaritaair.com/flightlog/index.php

Thanks again for all the greeat help!

maxpup979

there are two easy ways to do the   thing--you can use an if statement (if($value==""){print " ;}else{print $value}

or when you print your field, do it like:

print "<td> ".$value."</td>";
Im not sure what you are looking for in the second question...and the third, you can use date--its in the manual

vaavi8r

1) If I use the if statement, where does it go?
2) As for the second question, I want to get the SUM of the data in a column and display that total at the top of the page.
3) going back to the manual and re-reading about dates.

Thanks🆒

kellog

Question1

<td><font face="Arial, Helvetica, sans-serif"><? if (!$macid) { echo "&nbsp;"; } else { echo $macid; } ?></font></td>

Question2

while ($i < $num) {
   $total = $total + mysql_result($result,$i,"WhatEver");
   ++$i
}

Then just echo $total where you want the sum to be printed.

Originally posted by vaavi8r
1) If I use the if statement, where does it go?
2) As for the second question, I want to get the SUM of the data in a column and display that total at the top of the page.
3) going back to the manual and re-reading about dates.

Thanks🆒

vaavi8r

THANKS KELLOG.....I WILL GIVE IT A TRY😃