Make my while loop look sexy with HTML

[saltious]

Hi All.

heres my code. i query i pull works and this outputs as it should.

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

printf("ID: %s  Name: %s Logged By: %s", $row["callid"], $row["problem"], $row["userid"]);
echo "\n";
echo "<br>";
echo "<br>";

}

however, this looks very boring.

how can i add HTML formatting in so that the bit that says Name and Logged by could be one typoe for text and then the variables another?

i would also like to have a hyperlink included based around the id.

anyone any good tipe?

many thanks.

[laserlight]

You just add them to the format string ("ID: %s Name: %s Logged By: %s").

If you want to know exactly what to add in, then this becomes a HTML question that should be asked on the client side scripting forum.

[NogDog]

You could do something like this...

$fields = array(
   'ID' => 'callid',
   'Name' => 'problem',
   'Logged By' => 'userid'
);
echo "<ul id='my_list'>\n";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
   echo "<li><ul>\n";
   foreach($fields as $label => $rowKey)
   {
      printf("<li><em>%s:</em> %s</li>\n", $label, $row[$rowKey]);
   }
   echo "</ul></li>\n";
}
echo "</ul>\n";

Then you would use CSS to apply the desired visual appearance via the following selectors, as needed:

#my_list
#my_list li
#my_list li ul
#my_list li ul li
#my_list li ul li em