Pictures displayed in PHP

[Stephen Russell]

Sorry for the cross post if that offends you.

First playing with PHP & MySQL. I want to create a 2 column table. Picture
on one side and multiple MySql columns in the description Column. Like a
shopping cart display page.

Image Descript
XXXXXXXX Table.Col3
XXXXXXXX Table.Col4
XXXXXXXX Table.Col5
XXXXXXXX Table.Col8
XXXXXXXX Table.Col9

Column 6 in my table is the image "015689.JPG"

Can someone give me a reference to how to display that image in a table and
then how to get the various rows in a table.

TIA

__Stephen

srussell at lotmate . com.

[Stephen Russell]

Sorry.

I am have the SQL portion down. My $query has all the data I need. I just
need to get the display rendered like I want.

Within a table of two columns, I want an image in the left side. And in the
right I want to have multiple MySQL columns displayed much like this

Image Description
XXXXXXXX Table.Col3
XXXXXXXX Table.Col4
XXXXXXXX Table.Col5
XXXXXXXX Table.Col8
XXXXXXXX Table.Col9

Where the Table.ColY represent different aspects of $Query.

When I make a for loop my data is more like

Image Description
XXXXXXXX Table.Col3 Table.Col4 Table.Col5 Table.Col8 Table.Col9
XXXXXXXX
XXXXXXXX
XXXXXXXX
XXXXXXXX

TIA

__Stephen


"Darryl Porter" <dporter3@woh.rr.com> wrote in message
news:lN3Va.27485$ib2.8601775@twister.neo.rr.com...

> please provide concise info of what you want to do. Are you talking about
> MySQL tables or HTML tables?
>
> "Stephen Russell" <Stephen.Russell@somewhereovertherainbow.org> wrote in
> message news:4DYUa.95064$X43.17414@clmboh1-nws5.columbus.rr.com...

> > Sorry for the cross post if that offends you.
> >
> > First playing with PHP & MySQL. I want to create a 2 column table.

> Picture

> > on one side and multiple MySql columns in the description Column. Like

a

> > shopping cart display page.
> >
> > Image Descript
> > XXXXXXXX Table.Col3
> > XXXXXXXX Table.Col4
> > XXXXXXXX Table.Col5
> > XXXXXXXX Table.Col8
> > XXXXXXXX Table.Col9
> >
> > Column 6 in my table is the image "015689.JPG"
> >
> > Can someone give me a reference to how to display that image in a table

> and

> > then how to get the various rows in a table.
> >
> > TIA
> >
> > __Stephen
> >
> > srussell at lotmate . com.
> >
> >

>
>

[Dmitry Ruban]

Well,

Very simple decision is
echo "<table>";
while ( $r = mysql_fetch_array ( $rst ) )
{
echo "<tr><td>".$r[0]."</td><td>".$r[0]."</td></tr>";
}
echo "</table>";

If Image is binary data then it won't be correct.

Dima

> Sorry.
>
> I am have the SQL portion down. My $query has all the data I need. I

just

> need to get the display rendered like I want.
>
> Within a table of two columns, I want an image in the left side. And in

the

> right I want to have multiple MySQL columns displayed much like this
>
> Image Description
> XXXXXXXX Table.Col3
> XXXXXXXX Table.Col4
> XXXXXXXX Table.Col5
> XXXXXXXX Table.Col8
> XXXXXXXX Table.Col9
>
> Where the Table.ColY represent different aspects of $Query.
>
> When I make a for loop my data is more like
>
> Image Description
> XXXXXXXX Table.Col3 Table.Col4 Table.Col5 Table.Col8 Table.Col9
> XXXXXXXX
> XXXXXXXX
> XXXXXXXX
> XXXXXXXX
>
> TIA
>
> __Stephen
>
>
> "Darryl Porter" <dporter3@woh.rr.com> wrote in message
> news:lN3Va.27485$ib2.8601775@twister.neo.rr.com...

> > please provide concise info of what you want to do. Are you talking

about

> > MySQL tables or HTML tables?
> >
> > "Stephen Russell" <Stephen.Russell@somewhereovertherainbow.org> wrote in
> > message news:4DYUa.95064$X43.17414@clmboh1-nws5.columbus.rr.com...

> > > Sorry for the cross post if that offends you.
> > >
> > > First playing with PHP & MySQL. I want to create a 2 column table.

> > Picture

> > > on one side and multiple MySql columns in the description Column.

Like

> a

> > > shopping cart display page.
> > >
> > > Image Descript
> > > XXXXXXXX Table.Col3
> > > XXXXXXXX Table.Col4
> > > XXXXXXXX Table.Col5
> > > XXXXXXXX Table.Col8
> > > XXXXXXXX Table.Col9
> > >
> > > Column 6 in my table is the image "015689.JPG"
> > >
> > > Can someone give me a reference to how to display that image in a

table

> > and

> > > then how to get the various rows in a table.
> > >
> > > TIA
> > >
> > > __Stephen
> > >
> > > srussell at lotmate . com.
> > >
> > >

> >
> >

>
>