Re: showing any mysql query in a table, help!
| From: | Chris | Date: | Sun, 19 Mar 2006 06:43:57 +0000 |
| Subject: | Re: showing any mysql query in a table, help! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-232211@lists.php.net to get a copy of this message | ||
You could fetch the rows in an associate array. Then loop over each element in the array printing it out inside <td></td> tags..
print out <tr> before the columns, </tr> after.
To get the header just loop through the keys of the associative array. Whenever you want to show the header.
Unless I'm misunderstanding you that should work.
Chris
pgaio@portugalmail.pt wrote:
Ok... it has to be a way to do such a thing. I do i get the column names? I can get the number of columns using mysql_num_fields() right? but what if i want to get the columns name? Wich functtion and how should i use? the goal is to make a function that prints a table that prints the result of any query in a html table. thx Pedro