Mysql Query

[gfmaking]

please some one give me the query format, I will edit the security like password...
I want to get a query of all the fields i a table sorted by a date and the result I want it on a table format instead of comma delimmeted.

Thanks

[wildteen88]

Umm, no offense but could you put that in english? And explain in more detail about what you are trying to achive.

[gfmaking]

Oppppps....OK

I have mysql database built & my Customers put data through HTML form by my pHP file to the database.
Now to diplay the result on an HTML formagain, I want a query but what i want is the result to desplay in a table format instead of just scramble on the sreen. Am i clear now?

Thanks for your help

[Buyocat]

Someone else had a similar question today, so try looking for it...

Anyway in a nutshell you want to do this...

$string = '<table>';
while ($data = mysql_fetc_array($result, MYSQL_NUM))
{
$string .= '<tr><td>' . $data[0] . '</td></tr>';
}
echo $string . '</table>';

I left out a lot, but I hope it is clear enough... that other post goes into more detail.

EDIT
I found the thread, so I'll give you the link. My post was has what you want in more detail, I believe.

[a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=97058\" target=\"_blank\"]http://www.phpfreaks.com/forums/index.php?showtopic=97058[/a]