how to display newly added mysql column

[kindermaxiz]

hi there

i have a mysql table and i want the user to add columns using a php
interface and then display the table with the newly added column. I
was thinking about putting all the columns names in a special table
but there must be another more efficient way.

as an example this is my query to display the table:
$result = mysql_query("select * from news");
while($r=mysql_fetch_array($result))
{
$title=$r["title"];
$message=$r["message"];
//display the row
echo "$title <br> $message <br>";
}

now if the user alter the table and add a column "rank", how can i
update my query automatically so it can display the newly added row
(or column)?
thanx in advance

patricio

[Elliott C. Bäck]

ki*********@yahoo.com wrote:

now if the user alter the table and add a column "rank", how can i
update my query automatically so it can display the newly added row
(or column)?

You can use the SQL "SHOW COLUMNS FROM table" to get all of the columns
in your table, and then loop on that array.
--
Elliott C. Bäck
http://elliottback.com/

[Andy Hassall]

On 20 Aug 2004 12:30:06 -0700, ki*********@yahoo.com wrote:

hi there

i have a mysql table and i want the user to add columns using a php
interface and then display the table with the newly added column. I
was thinking about putting all the columns names in a special table
but there must be another more efficient way.

as an example this is my query to display the table:
$result = mysql_query("select * from news");
while($r=mysql_fetch_array($result))
{
$title=$r["title"];
$message=$r["message"];
//display the row
echo "$title <br> $message <br>";
}

now if the user alter the table and add a column "rank", how can i
update my query automatically so it can display the newly added row
(or column)?

As you're doing "select *" you've already got it in the $r array. Use a
foreach loop to loop over the columns.

--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool