[RESOLVED] Table Boaders not showing with no data

@r2ksNov 10.2009

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

[CODE]echo “<TABLE BORDER=2 align=center >”; echo “<TR><TD>Username<TD>Password<TD>Name<td>Street<td>City<td>State<td>Zip<td>Phone <td>E-Mail<td>info<td>Admin<TH COLSPAN=3>Options</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>”;[/CODE]

to post a comment

HTML

11 Comments(s) _↴

@FangNov 11.2009 — #Test for 'no data' and add a space character.

@r2ksauthorNov 11.2009 — #How would i test for no Data and add space character ???

@necrojusticeNov 11.2009 — #Add the section in bold to the areas that won't show a border.

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

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

@r2ksauthorNov 11.2009 — #Tried that and all i got was a Couple of "" in the options box and nothing else

@necrojusticeNov 11.2009 — #Try adding this to your CSS

table {

border-collapse: collapse;

}

@FangNov 11.2009 — #

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

or put your document into strict mode

@r2ksauthorNov 11.2009 — #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)[COLOR="Red"] {[/COLOR]

if ($value=='') {

$myrow[$key] = ' ';

}

Found the Problem with your Code

after fixing that No data shows up at all

@FangNov 12.2009 — #I tested the snippet of code and it works correctly. Show how you implemented it.

@r2ksauthorNov 12.2009 — #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..

[CODE]$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>";[/CODE]

Thank you

@FangNov 12.2009 — #

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

@r2ksauthorNov 12.2009 — #AWSOME it worked... Thank you listen this is what i did

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

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

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

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

Also in #HTML _↴

Pressing enter key on a form making a scroll bar in a table?HTML problems in Firefox. Please help

Success!

Help @r2ks spread the word by sharing this article on Twitter...

Tweet This

[RESOLVED] Table Boaders not showing with no data

11 Comments(s) _↴

Also in #HTML _↴

Success!

Social

Version

[RESOLVED] Table Boaders not showing with no data

11 Comments(s) ↴

Also in #HTML ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

11 Comments(s) _↴

Also in #HTML _↴