RE: [PHP] Tricky Query <---SOLVED

Yeah... thanx a lot. > -----Original Message----- > From: John Holmes [mailto:holmes072000@charter.net] > Sent: Sunday, June 16, 2002 11:53 PM > To: 'César Aracena'; 'PHP DB List'; 'PHP General List' > Subject: RE: [PHP] Tricky Query <---SOLVED > > So does that solve your other problem with MySQL_insert_id(), also? > > ---John Holmes... > > > -----Original Message----- > > From: César Aracena [mailto:icaam@icaam.com.ar] > > Sent: Sunday, June 16, 2002 10:42 PM > > To: holmes072000@charter.net; 'PHP DB List'; 'PHP General List' > > Subject: RE: [PHP] Tricky Query <---SOLVED > > > > > Use MySQL_error() to see what the problem is... > > > > > > $result = MySQL_query($query) or die(MySQL_error()); > > > > > > ---John Holmes... > > > > [César L. Aracena] It was a NOT NULL field which I was trying to put > no > > data in... Thanks. Also learn what the error checking is for ;-) > > > > > > > -----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 > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php