[RESOLVED] table loop results

gene02

<?php require("dbapp.php"); ?>

the line a bove is the connection to DB

<?php
/* start to display trailers transport moves */
// first, lets  see if there are any loads are in the database
    $query1 = "SELECT *  FROM loads ";
    $result = mysql_query($query1);	
// if there aren't any loads, then generate  notice that there aren't any	
	if ($result <0){
	print("<p style=\"font-weight: bold; color: red;\">There Are Currently No Loads In The Database</p>");
}
$query2 = "SELECT Load_ID, origin_city, origin_state, dest_city, dest_state 
	           FROM loads";
	$result = mysql_query($query2);	

// Define colors for the alternating rows 

$color1 = "#CCFFCC";  

$color2 = "#BFD8BC";  

$row_count = 0; 
$row_color = ($row_count % 2) ? $color1 : $color2; 

/* Begin display table */
echo '<table width="100%" border="0" cellpadding="4" cellspacing="0">'.
    '<tr> 
        <td width="110"><b>Order Munber </b></td>;
        <td width="71"><b> Origin City </b></td> ;
        <td width="89"><b>Origin State</b></td>;
        <td width="73"><b>Dest. City</b></td>;
        <td width="277"><b>Dest. State</b></td>;
    </tr>'.

HERE IS MY BIG ERROR T_ECHO in BLA BLA line 41

	 
	 echo <tr>
     <td width="110" bgcolor=$row_color nowrap>
     $Load_ID</td>
     <td bgcolor="$row_color">$origin_city</td>
     <td bgcolor="$row_color">$origin_state</td>
     <td bgcolor="$row_color">$dest_city</td>
     <td bgcolor="$row_color">$dest_state</td>
     </tr>


// Add 1 to the row count 

$row_count+1;   
 // Close out your table. 
?>
</table>

leatherback

If you have a literal string, you need to put quotes around them:

echo "<tr>";

echo "<tr>
     <td width=\"110\" bgcolor=\"$row_color nowrap\">
     $Load_ID</td>
     <td bgcolor=\"$row_color\">$origin_city</td>
     <td bgcolor=\"$row_color\">$origin_state</td>
     <td bgcolor=\"$row_color\">$dest_city</td>
     <td bgcolor=\"$row_color\">$dest_state</td>
     </tr>";

edit: Have you considered using CSS for the coloring of your table etc?

gene02

Hi Leather thanks for your time.
I am still getting the same error T_ECHO in directory line 47
and no I have not concidered CSS for color after I get it working I will.

leatherback

hi,

in the first section:
echo '<table width="100%" border="0" cellpadding="4" cellspacing="0">'.
'<tr>
<td width="110">Order Munber </td>;
<td width="71"> Origin City </td> ;
<td width="89">Origin State</td>;
<td width="73">Dest. City</td>;
<td width="277">Dest. State</td>;
</tr>'.

The . should be ;
Order Munber should be Order Number (Although that wouldn't affect the query.

If you still have trouble, please post line 1-> 50 as one post.

gene02

got it taking out the . and changing to ; made it happen thanks again for your time.