Will This work

[Curwe Support]

Hi all,

I was wondering if it is possible to format variables from within the VALUES
section of a mysql INSERT string.

I have some variables that are passalong from a script and get deposited to
a mysql db.

since end users can submit in all uppercase or lower case, i was looking for
some data normalization.

so I am going to apply ucwords(strtolower($variable1));

but in the name of keeping the script as small and sweet as possible can i
do

mysql_query ("INSERT INTO 10m (firstname, lastname, zipcode, email, 10mdate,
entrydate, termsagree)
VALUES ('ucwords(strtolower($firstname));',
'ucwords(strtolower($variable1));', '$zipcode', '$email',
'$month--$day-$year', '$entrydate', '$termsagree')");

etc etc.

or do i have to do

$fixed_variable1=ucwords(strtolower($variable1));
$fixed_variable2=ucwords(strtolower($variable2));

mysql_query ("INSERT INTO 10m (firstname, lastname, zipcode, email, 10mdate,
entrydate, termsagree)
VALUES ('$fixed_firstname', '$fixed_lastname', '$zipcode',
'$email', '$month--$day-$year', '$entrydate', '$termsagree')");

i think you get the idea.

i would prefer the former vs the latter since there are about 10 variables
to rewrite....

Cheers,

Gary
Curwe.com

[Jon Kraft]

Curwe Support <support-nntp@curwe.com> wrote:

> I was wondering if it is possible to format variables from within the
> VALUES section of a mysql INSERT string.
>
> mysql_query ("INSERT INTO 10m (firstname, lastname, zipcode, email,
> 10mdate, entrydate, termsagree)
> VALUES ('ucwords(strtolower($firstname));',
> 'ucwords(strtolower($variable1));', '$zipcode', '$email',
> '$month--$day-$year', '$entrydate', '$termsagree')");

Hi Gary,

Not quite in this form, but there is a solution. I suggest though you
construct the statement string beforehand. Gives a much cleaner code layout
and more control. And in case you use an editor with highlighting you'll
see another benefit.

$SQL = "INSERT INTO 10m (firstname, lastname, zipcode, email, " .
"10mdate, entrydate, termsagree) VALUES (" .
"'".ucwords(strtolower($firstname))."', " .
"'".ucwords(strtolower($variable1))."', " .
"'".$zipcode."', " .
"'".$email."', " .
"'".$month."-".$day."-".$year."', " .
"'".$entrydate."', " .
"'".$termsagree."')";

mysql_query($SQL) or die (mysql_error()."<br />".$SQL);

HTH;
JOn

[JimmyUK]

[url]http://www.macromedia.com/cfusion/exchange/index.cfm?view=sn111&extID=1029986#lo[/url]
c=en_us&view=sn111&extID=1029986&viewName=Flash%20 Extension&avm=1

hi this is probably a stupid question but i was looking at this and wondered
would it work in Dreamweaver MX i know it's not the most up to date dreamweaver
and as it requires flash 8 for it to work i take it won't work on my
dreamweaver version but just wondered please help many thanks Jimmy