Re: Query problem

The problem is that I have a remote "rented" server and I don't have access to these configurations any other ideas are welcome. Thanks any ot ----- Original Message ----- From: "BigDog" <bigdog@venticon.com> To: "Cesar Aracena" <icaam@icaam.com.ar> Cc: "PHP General" <php-general@lists.php.net> Sent: Tuesday, November 12, 2002 11:51 AM Subject: Re: [PHP] Query problem > In your php.ini file you can turn on all the errors have have them > displayed... > > I would suggest doing that and you should see some errors if there are > any. > > Have you verified that dates in the database via mysql command line or > gui application. > > > On Tue, 2002-11-12 at 21:27, Cesar Aracena wrote: > > Hi all, > > > > I came back from vacations and forgot some things about queries... can > > anyone tell me what is wrong with this? of all the error messages I set up > > in the script, none comes back on the page but the record is not saved... > > > > <? > > > > $db = mysql_connect("www.icaam.com.ar", "icaam", > > "********"); > > if (!$db) > > { > > die("No se pudo abrir la base de datos"); > > } > > > > $ok = mysql_select_db("icaam"); > > if(!$ok) > > { > > die("No se pudo acceder a la base de datos"); > > } > > > > $borndate = $bornd . $bornm . $borny; > > $phonenumber = $phone; > > > > $query = "INSERT INTO mararegistro (visitorid, fname, lname, borndate, > > address, city, country, phone, how) VALUES (null, 'c', 'c', 12, > > 'c', 'c', > > 'c', 12, 'c')"; > > $result = mysql_query($query) or die (mysql_errno()); > > if (mysql_affected_rows() != 1) > > { > > die("Fallo al guardar datos"); > > } > > > > echo "Gracias por administrarnos su información."; > > > > ?> > > > > Any thiughts? Thanks in advance, > > > > Cesar > -- > .: B i g D o g :. > > >