[RESOLVED] Table Boaders not showing with no data

[r2ks]

Table Boaders are not showing in IE7 with no data from the database they show in fire fox fine Ant help would be Great

echo "<TABLE BORDER=2 align=center  >";
	echo "<TR><TD><B>Username</B><TD><B>Password</B><TD><b>Name</b><td><b>Street</b><td><b>City</b><td><b>State</b><td><b>Zip</b><td><b>Phone </B><td><b>E-Mail</b><td><b>info</b><td><b>Admin</b><TH COLSPAN=3><b>Options</b></TH>
	</TR>";
	while ($myrow = mysql_fetch_array($result))
	{
	echo "<TR><TD>".$myrow["username"]."<td>".$myrow ["password"]."<td>".$myrow["name"]."<td>".$myrow["street"]."<td>".$myrow["city"]."<td>".$myrow["state"]."<td>".$myrow["zip"]."<td>".$myrow["phone"]."<td>".$myrow["email"]."<td>".$myrow["info"]."<td>".$myrow["admin"];
	// "<TD><a href=\"_view.php?id=".$myrow['id']."\"> <img src= ".$img_view." ></a>";
	echo "<TD><a href=\"_deleteparticipant.php?id=".$myrow['id']."\"> <img src= ".$img_delete.">  </a>";
	echo "<td><a href=\"updateparticipant.php?id=".$myrow['id']."\"> <img src= ".$img_edit.">  </a>";
		
	}
	echo "</TABLE>";

[Fang]

Test for 'no data' and add a space character.

[r2ks]

How would i test for no Data and add space character ???

[necrojustice]

Add the section in bold to the areas that won't show a border.

echo "<td><a href=\"updateparticipant.php?id=".$myrow['id']."\"> <img src= ".$img_edit.">  </a>" .'&nbsp;';

Something similar for that with each section of the table will force a border in IE even if no data is available.

[r2ks]

Tried that and all i got was a Couple of "" in the options box and nothing else

[necrojustice]

Try adding this to your CSS

table {
border-collapse: collapse;
}

[Fang]

while ($myrow = mysql_fetch_array($result))
	{
foreach ($myrow as $key => $value) {
    if ($value=='') {
        $myrow[$key] = ' ';
    }
.
.

or put your document into strict mode

[r2ks]

Thank you for your Replay
I placed your Code in there and this is what i get
Parse error: syntax error, unexpected $end in /var/www/virtual/eventtracker/adminparticipants.php on line 115

There is no $end on line 115
foreach ($myrow as $key => $value) {
if ($value=='') {
$myrow[$key] = ' ';
}
Found the Problem with your Code
after fixing that No data shows up at all

[Fang]

I tested the snippet of code and it works correctly. Show how you implemented it.

[r2ks]

Thank you for your Willingness to keep helpin me.
as i said all the fields are blank with the Code here is the way i have it..

$result = mysql_query("SELECT * FROM users ",$con);
	echo "<TABLE BORDER=2 align=center> ";
	echo "<TR><TD><B>Username</B><TD><B>Password</B><TD><b>Name</b><td><b>Street</b><td><b>City</b><td><b>State</b><td><b>Zip</b><td><b>Phone </B><td><b>E-Mail</b><td><b>info</b><td><b>Admin</b><TH COLSPAN=3><b>Options</b></TH>
	</TR>";
	while ($myrow = mysql_fetch_array($result))
	foreach ($myrow as $key => $value) 
    if ($value=='') {
        $myrow[$key] = '&nbsp;';
    }

	{
	echo "<TR><TD>".$myrow["username"]."<td>".$myrow ["password"]."<td>".$myrow["name"]."<td>".$myrow["street"]."<td>".$myrow["city"]."<td>".$myrow["state"]."<td>".$myrow["zip"]."<td>".$myrow["phone"]."<td>".$myrow["email"]."<td>".$myrow["info"]."<td>".$myrow["admin"];
	 "<TD><a href=\"_view.php?id=".$myrow['id']."\"> <img src= ".$img_view." ></a>";
	echo "<TD><a href=\"_deleteparticipant.php?id=".$myrow['id']."\"> <img src= ".$img_delete.">  </a>";
	echo "<td><a href=\"updateparticipant.php?id=".$myrow['id']."\"> <img src= ".$img_edit.">  </a>";
		
	}
	echo "</TABLE>";
	 "<table width=\"23%\" border=\"1\" align=\"center\">
	  <tr>
    	//<td><a href=\"_add.php\">CREATE NEW RECORD</a></td>
	  </tr>
	</table>";

Thank you

[Fang]

echo "<TABLE BORDER=2 align=center  >";
	echo "<TR><TD><B>Username</B><TD><B>Password</B><TD><b>Name</b><td><b>Street</b><td><b>City</b><td><b>State</b><td><b>Zip</b><td><b>Phone </B><td><b>E-Mail</b><td><b>info</b><td><b>Admin</b><TH COLSPAN=3><b>Options</b></TH>
	</TR>";
	while ($myrow = mysql_fetch_array($result))
	{
foreach ($myrow as $key => $value) {
    if ($value=='') {
        $myrow[$key] = '&nbsp;';
    }
	echo "<TR><TD>".$myrow["username"]."<td>".$myrow ["password"]."<td>".$myrow["name"]."<td>".$myrow["street"]."<td>".$myrow["city"]."<td>".$myrow["state"]."<td>".$myrow["zip"]."<td>".$myrow["phone"]."<td>".$myrow["email"]."<td>".$myrow["info"]."<td>".$myrow["admin"];
	// "<TD><a href=\"_view.php?id=".$myrow['id']."\"> <img src= ".$img_view." ></a>";
	echo "<TD><a href=\"_deleteparticipant.php?id=".$myrow['id']."\"> <img src= ".$img_delete.">  </a>";
	echo "<td><a href=\"updateparticipant.php?id=".$myrow['id']."\"> <img src= ".$img_edit.">  </a>";
		
	}
	echo "</TABLE>";

[r2ks]

AWSOME it worked... Thank you listen this is what i did

foreach ($myrow as $key => $value) {
    if ($value=='') {
        $myrow[$key] = ' ';
    }
}

I had to add a second Closeing Bracket when i placed the code in like this

foreach ($myrow as $key => $value) {
    if ($value=='') {
        $myrow[$key] = ' ';
    }

I would Get a Error

Parse error: syntax error, unexpected $end
in /var/www/virtual/pledges/adminparticipants.php on line 111
THANK YOU SO MUCH for your Help have a Blessed Day