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
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
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
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
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
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