Tricky Query
| From: | César Aracena | Date: | Mon, 17 Jun 2002 02:17:58 +0000 |
| Subject: | Tricky Query | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-19838@lists.php.net to get a copy of this message | ||
Hi again,
Im 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
wheres the problem is? I dont know if theres a syntax problem, cause
Im 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 thats the
reason why I used string like
'".$cuilcuit1."-".$cuilcuit2."-".$cuilcuit3."' But I dont
know if its
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 doesnt 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