RE: [PHP] Tricky Query

Use MySQL_error() to see what the problem is... $result = MySQL_query($query) or die(MySQL_error()); ---John Holmes... > -----Original Message----- > From: César Aracena [mailto:icaam@icaam.com.ar] > Sent: Sunday, June 16, 2002 10: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 >