NYCPHP Meetup

[John W. Markert]

Thanks to Hans and Dan for responding in my time of blindness. Yes, it was a
misspelling and I do have to conform the variable names that I used at
differnt times.

----- Original Message ----- 
From: "Analysis & Solutions" <danielc at analysisandsolutions.com>
To: "NYPHP Talk" <talk at nyphp.org>
Sent: Wednesday, June 04, 2003 2:04 PM
Subject: Re: [nycphp-talk] mysql question


> On Wed, Jun 04, 2003 at 12:15:05PM -0400, John W. Markert wrote:
> >
> >      $query = "select * from advlistings, valsec, valprim
> >       where ((advlistings.advId=$advId)
> >       and (valsec.SecID=advlistings.secId)
> >       and (valprim.primeId=valsec.primeID))";
> >
> > the error that I get is:
> >     Unknown column 'valprim.primeId' in 'where clause'
>
> Why are you using different capitalization on field names?
>
>    SecID is not the same as secId
>    primeId is not the same as primeID
>
> If you retyped this rather than cutting/pasting your code, you just proved
> why it's important to use the actual code.
>
> If you did use the actual code here, did you mistype the cases of field
> names in your query?
>
> If those are the actual field name cases in the table structures, you
> really should make your life easier in the long run and come up with a
> field naming convention.
>
> --Dan
>
> -- 
>      FREE scripts that make web and database programming easier
>            http://www.analysisandsolutions.com/software/
>  T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
>  4015 7th Ave #4AJ, Brooklyn NY    v: 718-854-0335   f: 718-854-0409
>
>
> --- Unsubscribe at http://nyphp.org/list/ ---
>
>