Recordset sometimes works - sometimes doesn't!

[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*]

The Appdev forum would be the best place to post this, Richard!

--
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:ejf3gn$f6o$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.
>