RE: [PHP] Tricky Query <---SOLVED
| From: | César Aracena | Date: | Mon, 17 Jun 2002 02:41:51 +0000 |
| Subject: | RE: [PHP] Tricky Query <---SOLVED | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-19840@lists.php.net to get a copy of this message | ||
> 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,
> >
> > 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
> >