RE: [PHP] Tricky Query <---SOLVED
| From: | John Holmes | Date: | Mon, 17 Jun 2002 02:52:49 +0000 |
| Subject: | RE: [PHP] Tricky Query <---SOLVED | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-102460@lists.php.net to get a copy of this message | ||
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,
> > >
> > > 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
> > >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php