Re: Fw: Insert strtoupper
| From: | Bastian Vogt | Date: | Mon, 09 Dec 2002 10:35:17 +0000 |
| Subject: | Re: Fw: Insert strtoupper | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23922@lists.php.net to get a copy of this message | ||
Hi,
in your query "strtoupper" is treated as a string and not as a function.
You have to write this:
mysql_query ("INSERT INTO anagrafe (codice,nome, cognome, codicefiscale)
VALUES
('".strtoupper($codicefiscale)."','$NOME','".strtoupper($cognome)."','".strtoupper($codicefiscale)."',
...
Regards,
Bastian
Antonio Bernabei schrieb:
> > Hi,
> >
> > I want to insert the upper case of the strings written in the forn, so I
> put
> > on the php file called these lines
> >
> > $NOME=strtoupper($nome);
> >
> > mysql_query ("INSERT INTO anagrafe (codice,nome, cognome, codicefiscale)
> >
> > VALUES
> >
>
> ('strtoupper($codicefiscale)','$NOME','strtoupper($cognome)','strtoupper($co
> > dicefiscale)', ...
> >
> > but if $codice if for example abc in field codice I don't get ABC but
> > uppercase(abc)
> > while if $nome is mario in the filed nome I get MARIO
> >
> > Can I avoid to write extra lines for the conversion?
> > Thanks
> > Antonio
> >
> >