Well,  we have a word for myself that over looks things and takes things
literal.  Its called "pencil smoke"  It means dump, dunce, and lost.

Jennifer was right, their was an error in my SQL query.

SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y')
 as timestamp FROM custlogon;

not as formatted_ts.....

It worked fine even on zeus it tested fine.

Thanks for your help!!!!

Sincerely,
Daniel


----- Original Message -----
From: "Dan J. Rychlik" <[EMAIL PROTECTED]>
To: "Cody Phanekham" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; "Chris W. Parker" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, September 23, 2003 7:50 PM
Subject: Re: [PHP] SQL statement


> I tried this, and it failed.  Thank you for the suggestion!
>
> ----- Original Message -----
> From: "Cody Phanekham" <[EMAIL PROTECTED]>
> To: "Dan J. Rychlik" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>; "Chris W. Parker" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Tuesday, September 23, 2003 7:43 PM
> Subject: RE: [PHP] SQL statement
>
>
> > http://www.mysql.com/doc/en/Reserved_words.html
> >
> > [snip]
> > 6.1.7 Is MySQL Picky About Reserved Words?
> >
> > A common problem stems from trying to create a table with column names
> that use the names of datatypes or functions built into MySQL, such as
> TIMESTAMP or GROUP. You're allowed to do it (for example, ABS is allowed
as
> a column name). However, by default, in function invocations no whitespace
> is allowed between the function name and the following `(' character, so
> that a function call can be distinguished from a reference to a column
name.
> > [/snip]
> >
> > try renaming the field timestamp to something else and see if that
helps?
> >
> >
> >
> > > -----Original Message-----
> > > From: Dan J. Rychlik [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, 24 September 2003 10:32
> > > To: [EMAIL PROTECTED]; Chris W. Parker;
> > > [EMAIL PROTECTED]
> > > Subject: Re: [PHP] SQL statement
> > >
> > >
> > > This didnt work as well.
> > > SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y')
> > > as formatted_ts
> > > FROM custlogon;
> > >
> > > It caused my script to die and not execute at all....
> > >
> > > ----- Original Message -----
> > > From: "Jennifer Goodie" <[EMAIL PROTECTED]>
> > > To: "Dan J. Rychlik" <[EMAIL PROTECTED]>; "Chris W. Parker"
> > > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > Sent: Tuesday, September 23, 2003 7:15 PM
> > > Subject: RE: [PHP] SQL statement
> > >
> > >
> > > > > Ive used this
> > > > > $query = ("SELECT username, password, DATE_FORMAT(timestamp,
> > > > > '%d%m%y')  FROM
> > > > > custlogon");
> > > > >
> > > > > But I recieve unknown index timestamp.  *shrug*
> > > > >
> > > > >
> > > > You are receiving the error on an array returned by
> > > fetch_array?  If so,
> > > it
> > > > is because the index is "DATE_FORMAT(timestamp, '%d%m%y')",
> > > not timestamp,
> > > > which isn't so great.  You can see this by doing a print_r
> > > on the array to
> > > > see what is actually in it.  Use aliasing in your query to give it a
> > > better
> > > > index.
> > > > "SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y') as
> > > formatted_ts
> > > > FROM custlogon" or something like that.
> > > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
> >
> >
>
****************************************************************************
> *********
> > This e-mail, including any attachments to it, may contain confidential
> and/or personal information.
> > If you have received this e-mail in error, you must not copy,
distribute,
> or disclose it, use or take any action
> > based on the information contained within it.
> >
> > Please notify the sender immediately by return e-mail of the error and
> then delete the original e-mail.
> >
> > The information contained within this e-mail may be solely the opinion
of
> the sender and may not necessarily
> > reflect the position, beliefs or opinions of Salmat on any issue.
> >
> > This email has been swept for the presence of computer viruses known to
> Salmat's anti-virus systems.
> >
> > For more information, visit our website at  www.salmat.com.au.
> >
>
****************************************************************************
> *********
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to