Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- how to display newly added mysql column
August 20, 2004, 5:30 pm
rate this thread
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");
//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
thanx in advance