Re: showing any mysql query in a table, help!

From: 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


« previous php.general (#232211) next »