Recordset returning inconsistent results

[RichardOMarketing]

I am developing a php site using mysql and apache.

I have finally managed to get a database connection and am trying now to
create some recordsets.

This is where the difficulties lie.....

I have 14 tables, the majority of which are for drop down menus. - All these
(Single columns) return recordsets with no problems.

The two main relational tables have multiple columns.

If I select a the majority of single selected columns, I have no problem but
there are two columns where no recordset is returned. I have tried renaming
these columns with no effect. The sql query seems fine and does work with all
but two columns.

Can ayone explain this inconsistency?

Is it something to do with field definition?

I am really dying for any help here.

[Murray *ACE*]

> I am really dying for any help here.

Yes - we can see that. Please put this on the correct forum (appdev), and
let it stand for some time before reposting it. Or pick up on David Powers'
reply to this post on the DW forum.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================


"RichardOMarketing" <webforumsuser@macromedia.com> wrote in message
news:ejf41t$fqh$1@forums.macromedia.com...

>I am developing a php site using mysql and apache.
>
> I have finally managed to get a database connection and am trying now to
> create some recordsets.
>
> This is where the difficulties lie.....
>
> I have 14 tables, the majority of which are for drop down menus. - All
> these
> (Single columns) return recordsets with no problems.
>
> The two main relational tables have multiple columns.
>
> If I select a the majority of single selected columns, I have no problem
> but
> there are two columns where no recordset is returned. I have tried
> renaming
> these columns with no effect. The sql query seems fine and does work with
> all
> but two columns.
>
> Can ayone explain this inconsistency?
>
> Is it something to do with field definition?
>
> I am really dying for any help here.
>

[RichardOMarketing]

many apologies - it is my first time here - I will indeed pick up on David Power's reply.

Thank you