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