Re: [PHP-DB] Re: Quik.com?? Spam?

2004-05-08 Thread Fernando Soto
I have an account with Quik Internet (www.quik.com) and I guess that's a message from my spam filter. I've have been problems with it.   Sorry for the inconveniences it causes.   Fer.    ---Mensaje original---   De: Uzi Klein Fecha: 05/08/04 10:00:30 Para: [EMAIL PROTECTE

RE: [PHP-DB] Modify MySQL Record

2003-09-05 Thread Fernando Soto
lies it by giving examples where rows are inserted into tables with an autoincrement column, I could not find a spot where it explicitly states that you don't have to provide a value for that column in an INSERT query.   Probably just falls into the personal preference category.   -Origina

Re: [PHP-DB] Modify MySQL Record

2003-09-05 Thread Fernando Soto
When you have an auntoincremente field in your table, you don't have to especify the field name in the query, as the following:     $query = "INSERT INTO cnrl_db (kwo, lsd, date, well, field, uni, license, formation, perfs, event, fluid, mode, type, vhd, file, kb, grd, open, sour, tube, lande

Re: [PHP-DB] DISTINCT not working

2003-08-22 Thread Fernando Soto
I have looking the MySQL manual for "distinctrow" and I didn't find it, i think you should change for "distinct"    $query="CREATE TABLE IF NOT EXISTS temp3TEMP   SELECT DISTINCT ROUND($tbl2.Net*.175,2) AS ExpNet175,   CONCAT($tbl2.Journal,$tbl2.Description) AS CON175   FROM $tbl2   WHERE $t

RE: [PHP-DB] Sorting issue

2003-08-14 Thread Fernando Soto
This would happens if you have defined the data type of the columns as char or varchar.     ---Original Message---   From: Aaron Wolski Date: Viernes, 08 de Agosto de 2003 08:51:04 a.m. To: 'Jeff'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Sorting issue   Seeing code might help us.   A

Re: [PHP-DB] Sorting issue

2003-08-11 Thread Fernando Soto
  You have to change   kwo VARCHAR(10) NOT NULL,   for  kwo int(10) NOT NULL,   Hope this helps   Fernando Soto       From: Jeff Date: Viernes, 08 de Agosto de 2003 10:36:33 a.m. To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Sorting issue   Yes duh...   I didn't realize numbers we