Creating a Table to line query results in php?

Hi everyone!

How can I create a table...or even something similar...to line information up?

The information is coming from an mysql database and there are 5
columns of data.

Of course I am using php to call the data out of the database.

A simple example:

while ($data = mysql_fetch_array($res))
{
$idfield = $data['IDFIELD'];
$name = $data['Name'];
$effect = $data['Effect'];
$category = $data['Category'];
$origin = $data['Origin'];
$image = $data['Image'];

echo ", $name, $effect, $category, $origin
";
}

The echo is the stuff I want to line up under the headings of the
columns when they are displayed.

So there are 5 headers and under the 5 headers is the resulting
display of info and I want it lined up, centered, under the headers.

Does that all make sense?

Thanks for all of your time!

S

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Creating a Table to line query results in php?

Scott wrote:
> Hi everyone!
>
> How can I create a table...or even something similar...to line
> information up?

Use a table? http://www.w3schools.com/html/html_tables.asp

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Creating a Table to line query results in php?

Thanks....I was trying to do that but was not working for me. I think
I was over thinking it.

The obvious is never obvious :)

On 2/25/07, Matt Anderton wrote:
> why not just create a table?
>
> echo "

wrote:
> >
> > Hi everyone!
> >
> > How can I create a table...or even something similar...to line information
> up?
> >
> > The information is coming from an mysql database and there are 5
> > columns of data.
> >
> > Of course I am using php to call the data out of the database.
> >
> > A simple example:
> >
> > while ($data = mysql_fetch_array($res))
> > {
> > $idfield = $data['IDFIELD'];
> > $name = $data['Name'];
> > $effect = $data['Effect'];
> > $category = $data['Category'];
> > $origin = $data['Origin'];
> > $image = $data['Image'];
> >
> > echo ", $name, $effect, $category, $origin
";
> > }
> >
> > The echo is the stuff I want to line up under the headings of the
> > columns when they are displayed.
> >
> > So there are 5 headers and under the 5 headers is the resulting
> > display of info and I want it lined up, centered, under the headers.
> >
> > Does that all make sense?
> >
> > Thanks for all of your time!
> >
> > S
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>


--
Scott Burcky
AOL IM: Jestrix1

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Creating a Table to line query results in php?

Scott wrote:
> Thanks....I was trying to do that but was not working for me. I think
> I was over thinking it.
>
> The obvious is never obvious :)
>
> On 2/25/07, Matt Anderton wrote:
>> why not just create a table?
>>
>> echo "

Re: Creating a Table to line query results in php?

You could also just use CSS. Make each column in a div and line them up
that way. Might not be as simple as a table right off-the-bat, but if you
have to make any changes later, its often easier.

A quick google search shows tons of tutorials on tables in css.
http://css.nu/articles/table-in-css.html


"Scott" wrote in message
news:c96bd0160702250352q15e0b18fob823c681a7e756e7@mail.gmail .com...
> Hi everyone!
>
> How can I create a table...or even something similar...to line information
> up?
>
> The information is coming from an mysql database and there are 5
> columns of data.
>
> Of course I am using php to call the data out of the database.
>
> A simple example:
>
> while ($data = mysql_fetch_array($res))
> {
> $idfield = $data['IDFIELD'];
> $name = $data['Name'];
> $effect = $data['Effect'];
> $category = $data['Category'];
> $origin = $data['Origin'];
> $image = $data['Image'];
>
> echo ", $name, $effect, $category, $origin
";
> }
>
> The echo is the stuff I want to line up under the headings of the
> columns when they are displayed.
>
> So there are 5 headers and under the 5 headers is the resulting
> display of info and I want it lined up, centered, under the headers.
>
> Does that all make sense?
>
> Thanks for all of your time!
>
> S

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Creating a Table to line query results in php?

Hello,
You can use HTML

tag. if you change your echo line in the
code below, may be your problem will be fixed :)

--
Haydar TUNA
Republic Of Turkey - Ministry of National Education
Education Technology Department Ankara / TURKEY
Web: http://www.haydartuna.net

"Scott" , haber iletisinde sunlari
yazdi:c96bd0160702250352q15e0b18fob823c681a7e756e7@mail.gmai l.com...
> Hi everyone!
>
> How can I create a table...or even something similar...to line information
> up?
>
> The information is coming from an mysql database and there are 5
> columns of data.
>
> Of course I am using php to call the data out of the database.
>
> A simple example:
>
> while ($data = mysql_fetch_array($res))
> {
> $idfield = $data['IDFIELD'];
> $name = $data['Name'];
> $effect = $data['Effect'];
> $category = $data['Category'];
> $origin = $data['Origin'];
> $image = $data['Image'];
>
> echo ", $name, $effect, $category, $origin
";
> }
>
> The echo is the stuff I want to line up under the headings of the
> columns when they are displayed.
>
> So there are 5 headers and under the 5 headers is the resulting
> display of info and I want it lined up, centered, under the headers.
>
> Does that all make sense?
>
> Thanks for all of your time!
>
> S

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: Creating a Table to line query results in php?

>How can I create a table...or even something similar...to line information
> up?


echo "

Header1	Header2	Header N
	$name	$effect	$category	$origin