hello mysl php help

mullet · 03-01-2007, 11:31 AM

hia all

i have created a rat profile system using phpbb as the user system.

i have all parts in place but i have a lot of empty html tables.

what i need to do is if the result ( i.e. $vars[column]) doesn't exists then it doesn't show the area on the page that it would be displayed.

can any-one help? i have done this before on an old site but i have forgotten.

an example would be cool.
thanks, Mullet

StupidScript · 03-02-2007, 05:42 PM

Here're a couple of examples ... don't quite know how deep the issue is:

1) Basic example that will use a space character when the value is empty:

Code:

..do query..id,name,address..
while($row=mysql_fetch_array($result)) {
extract($row);
if (!$name) { $name="&nbsp;"; }
if (!$address) { $address="&nbsp;"; }
}

2) Basic example to eliminate column from one-row result:

Code:

..do query..id,name,address..
while($row=mysql_fetch_array($result)) {
extract($row);
if (!$name) {
 $namecol="";
 $nameval="";
}
else {
 $namecol="<th>Name</th>";
 $nameval="<td>".$name."</td>";
}
if (!$address) {
 $addresscol="";
 $addressval="";
}
else {
 $addresscol="<th>Address</th>";
 $addressval="<td>".$address."</td>";
}
print "<table>\n";
print "<tr><th>ID</th>".$namecol.$addresscol."\n";
print "<tr><td>".$id."</td>".$nameval.$addressval."\n";
print "</table>\n";
}

There're lots of ways to do this ... it depends on what you want. You could use foreach($row as $key => $val) and test for empty $vals ... stuff like that.

mullet · 03-02-2007, 07:39 PM

thank you,

thats exactly what i need