Jump to content

Archived

This topic is now archived and is closed to further replies.

gfmaking

Mysql Query

Recommended Posts

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

Share this post


Link to post
Share on other sites
Umm, no offense but could you put that in english? And explain in more detail about what you are trying to achive.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.