Guys, just wanted to thank you again for helping me with
the sql statement that I needed. I was able to sorted using
php and I was able to display the correct result.
Thanks again!!1
Nestor :-)
On Nov 6, 2007 7:37 AM, Néstor [EMAIL PROTECTED] wrote:
You guys are correct, that is exactly what
--- [EMAIL PROTECTED] wrote:
Néstor wrote:
I think you'd best begin by normalising your
database. Something along
these lines:
very true indeed, that would save you major headaches
when right after finishing the demo, someone would
say, can we add a 18 gallon pledge? what about a 25?
You guys are correct, that is exactly what happened.
I must thing of this in the future.
At this moment I have a lot of other projects to take care, that it is
eaiser for me to read the information into an associative array with
the columns and the values and sort the array and then print the
I can do simple select statements but I need your brains to create query
statment.
I am using mysql 4.0 in my 1and1 site.
I have a table that has 8 fields, one is the agency field and the other 7
are
*tip* values on saving water and the value of this field is either 0 or an
amount.
--- Enrique Sanchez Vela [EMAIL PROTECTED]
wrote:
Date: Mon, 5 Nov 2007 15:01:59 -0800 (PST)
From: Enrique Sanchez Vela [EMAIL PROTECTED]
Subject: Re: Need help creating query statement
To: Néstor [EMAIL PROTECTED]
--- Néstor [EMAIL PROTECTED] wrote:
I can do simple select
Enrique that is pretty good and close to what I need.
On top of what you have generously provide, I guess I can just put
each gallon field into an array an then sort the array to display the
first 5 gallon fields per agency. Is there an easier way?
Thanks,
Nestor :-)
On 11/5/07, Enrique
Néstor wrote:
I can do simple select statements but I need your brains to create query
statment.
I am using mysql 4.0 in my 1and1 site.
I have a table that has 8 fields, one is the agency field and the other 7
are
*tip* values on saving water and the value of this field is either 0 or an
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
:= 'TRUE'
CREATE PROCEDURE cart_items_validate
(IN mcustid INT ,IN mprodid varchar(10),
OUT mvalidate varchar(10))
BEGIN
DECLARE rowexists
madderla sreedhar [EMAIL PROTECTED] wrote on 05/02/2005 03:10:07 AM:
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
:= 'TRUE'
CREATE PROCEDURE cart_items_validate
(IN mcustid INT
Madderla,
1. Var assignments need SET, ie SET mvariable = ...
2. Missing semicolon after 'TRUE'
PB
-
madderla sreedhar wrote:
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
:= 'TRUE'
Shawn, Madderla,
Don't you need to DECLARE the variable "mvalidate" before you can
use it?
It's declared as OUT mvalidate varchar(10).
PB
-
[EMAIL PROTECTED] wrote:
madderla sreedhar [EMAIL PROTECTED] wrote on 05/02/2005 03:10:07 AM:
Can u please execute the following
At 4:20 -0500 7/7/03, Anthony Scism wrote:
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL |
|
| observing_site |
Hi Antony,
Eventually key is a reserved word ?? ;-)
nice one !!
Best regards
Nils Valentin
Tokyo/Japan
2003 7 7 18:20Anthony Scism :
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time
:
Thank you very much, I should have thought of that.
-Original Message-
From: Nils Valentin [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 4:34 AM
To: Anthony Scism; [EMAIL PROTECTED]
Subject: Re: need help with select statement
Hi Antony,
Eventually key is a reserved word
Dear Sir,
I have looked in the manual but could not find any clue so I am seeking your
assistance. I have a table with 25 fields and I use most of these fields but
not all in different DBI scripts. Currently I use:
SELECT field_1, field_4, ...getting tired typing field names... FROM myTest;
Thanks Rolf
From: "Rolf Hopkins" [EMAIL PROTECTED]
To: "David Jacobowitz" [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: Need help with select statement.
Date: Tue, 27 Feb 2001 09:21:57 +0800
No it's not possible but you can just read in all tables anyway and ignore
t
17 matches
Mail list logo