RE: [PHP] Tricky Query
| From: | Martin Towell | Date: | Mon, 17 Jun 2002 02:29:24 +0000 |
| Subject: | RE: [PHP] Tricky Query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-102454@lists.php.net to get a copy of this message | ||
BTW: you can leave out the ". and ." bits, like:
$query = "INSERT INTO socios VALUES ('$numsocio', '$nivelsocio',
'$apellido', '$nombre', '$nac1-$nac2-$nac3', '$tipodoc',
'$docnum',
'$profesion', '$cuilcuit1-$cuilcuit2-$cuilcuit3', '$nacionalidad',
'$estcivil', '$domicilio', '$codpostal', '$localidad',
'$provincia', '($tel1) $tel2', '($telemer1) $telemer2',
'($cell1) $cell2', '$email', '$apellcony', '$nomcony',
'$tipodoccony',
'$doccony', '$naccony1-$naccony2-$naccony3', '$empresuc',
'$categoria',
'$fechaingreso1-$fechaingreso2-$fechaingreso3',
'$fechabaja1-$fechabaja2-$fechabaja3')";
-----Original Message-----
From: César Aracena [mailto:icaam@icaam.com.ar]
Sent: Monday, June 17, 2002 12:18 PM
To: 'PHP DB List'; 'PHP General List'
Subject: [PHP] Tricky Query
Hi again,
I'm trying to deal with this INSERT query for MySQL, but when I run it
under PHP... nothing happens... Anyone cares to read it and try to figure
where's the problem is? I don't know if there's a syntax problem, 'cause
I'm dealing with new stuff here:
$query = "INSERT INTO socios VALUES ('".$numsocio."',
'".$nivelsocio."',
'".$apellido."', '".$nombre."',
'".$nac1."-".$nac2."-".$nac3."',
'".$tipodoc."', '".$docnum."',
'".$profesion."',
'".$cuilcuit1."-".$cuilcuit2."-".$cuilcuit3."',
'".$nacionalidad."',
'".$estcivil."', '".$domicilio."',
'".$codpostal."', '".$localidad."',
'".$provincia."', '\(".$tel1."\) ".$tel2."',
'\(".$telemer1."\)
".$telemer2."', '\(".$cell1."\) ".$cell2."',
'".$email."',
'".$apellcony."', '".$nomcony."',
'".$tipodoccony."', '".$doccony."',
'".$naccony1."-".$naccony2."-".$naccony3."',
'".$empresuc."',
'".$categoria."',
'".$fechaingreso1."-".$fechaingreso2."-".$fechaingreso3."',
'".$fechabaja1."-".$fechabaja2."-".$fechabaja3."')";
There are fields that I need stored as 12-3456789-0 and that's the
reason why I used string like
'".$cuilcuit1."-".$cuilcuit2."-".$cuilcuit3."' But I
don't know if it's
all right. Also, there are others in which the data must be stores like
(0299) 4466621 (like phone entries) and I used things like:
'\(".$tel1."\) ".$tel2."'
Is this OK?? 'cause it sure doesn't do anything to the DB.
Any help will be MOST appreciated.
<mailto:webmaster@icaam.com.ar> Cesar Aracena
CE / MCSE+I
Neuquen, Argentina
+54.299.6356688
+54.299.4466621