PHP/MySQL Query Problem in Dreamweaver

[Aeris Leonna]

I am trying to retrieve data from mysql database using php code in
Dreamweaver. It is a simple query that is supposed to list all entries from
mysql database. When I created a recordset in Dreamweaver and tested it
everything was okay, but when I view results in actual php page I am getting
only first row and nothing else.

Does anyone have solution for this problem?

Thanks,
Aeris

[Kman]

My advice would be, Dont use Dreamweaver for back end. Its a good design
tool but it writes unnecesssary codings when it comes to php ( even
javascript!). From what i see you are trying to do, You would probably need
4 or 5 lines of php codes. Try to learn it by handcoding, specially if you
are new to php.

Cheers,
Kumana J
[email]kumana@elinx.ca[/email]



"Aeris Leonna" <petra@aussiemx.com> wrote in message
news:3f9357ad$3@news.unimelb.edu.au...

> I am trying to retrieve data from mysql database using php code in
> Dreamweaver. It is a simple query that is supposed to list all entries

from

> mysql database. When I created a recordset in Dreamweaver and tested it
> everything was okay, but when I view results in actual php page I am

getting

> only first row and nothing else.
>
> Does anyone have solution for this problem?
>
> Thanks,
> Aeris
>
>
>

[Craig Keightley]

Have you added the repeat region server behaviour to your recordset?

In code view, you should have a <? do { ?> at the beginning of your query,
followed by a <? } while $rs.......?> at the end





"Kman" <kman_career@yahoo.com> wrote in message
news:9ASkb.3108$7t3.80513@news20.bellglobal.com...

> My advice would be, Dont use Dreamweaver for back end. Its a good design
> tool but it writes unnecesssary codings when it comes to php ( even
> javascript!). From what i see you are trying to do, You would probably

need

> 4 or 5 lines of php codes. Try to learn it by handcoding, specially if you
> are new to php.
>
> Cheers,
> Kumana J
> [email]kumana@elinx.ca[/email]
>
>
>
> "Aeris Leonna" <petra@aussiemx.com> wrote in message
> news:3f9357ad$3@news.unimelb.edu.au...

> > I am trying to retrieve data from mysql database using php code in
> > Dreamweaver. It is a simple query that is supposed to list all entries

> from

> > mysql database. When I created a recordset in Dreamweaver and tested it
> > everything was okay, but when I view results in actual php page I am

> getting

> > only first row and nothing else.
> >
> > Does anyone have solution for this problem?
> >
> > Thanks,
> > Aeris
> >
> >
> >

>
>