repeated
values, I would be okay.
Thanks again!
Jason
- Original Message -----
From: Jason Soza <[EMAIL PROTECTED]>
Date: Tuesday, August 19, 2003 11:18 am
Subject: JOINs
> I may be trying to do too much in a single query here, but it
> would be nice if I could get it workin
Patrick,
Thanks! But - same result... It was worth a shot, however I still got 12 instances of
'amend' instead of 1.
If I can't work it out, I'll just split up this one query into two and see about using
PHP to do the math. Not something I wanted to do, but it should work just as well.
Thanks
I may be trying to do too much in a single query here, but it would be nice if I could
get it working! Apparently, the version of MySQL used by my work does not support the
WITH ROLLUP feature, otherwise I think that would work.
What I have are 3 tables: gc_info, amends, payments.
'gc_info' con
en DB question instead of MySQL, but I'd
appreciate any help.
Jason Soza
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
er, which gives me the access
denied.
The weird thing is, this works with -just- mysql_connect(), and the
user/pass combos I'm using I use just fine to maintain and update the
database, i.e. these are known good user/pass combos.
Any idea what's happening?
Jason Soza
-
Hoping someone can help me here:
I've made a column using SET("y","n") NOT NULL - I want the default value in
that column to be "n", so if no data is entered for that column, it'd be "n"
automatically.
How do I do that? Not sure what to search
now. Ooops! It works now, though! Yay!
This is pretty cool. I'll have to let you know when I finish all of this -
I'll be using PHP to display all this info via HTML. That'll be another fun
project...
Thanks again for your help!
Jason
-----Original Message-
From: Jason Soza [
TED]]
Sent: Thursday, May 23, 2002 9:34 PM
To: Jason Soza; [EMAIL PROTECTED]
Subject: RE: Query Problem
Other than it is uglier than a Hut?
The higest ideals of a database is to separate data into tables that keep
track
of data for the same objects. Some databases break these rules (oh and h
Or is this actually a little more efficient than the
current way?
Jason Soza
- Original Message -
From: "Opus" <[EMAIL PROTECTED]>
Date: Thursday, May 23, 2002 4:50 pm
Subject: RE: Query Problem
> Jason,
>
> First, as to the structure of the database. I agree
my own, and searches
of the manual are not turning up much.
Thanks,
Jason Soza
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
lto:[EMAIL PROTECTED]]On Behalf Of Sammy Lau
Sent: Wednesday, May 22, 2002 8:18 PM
To: Jason Soza
Cc: [EMAIL PROTECTED]
Subject: Re: Query Problem
to make it easier for others to help you. you should have posted the
create table statement, insert statement for a small set of data so that
anyone of
rom an album have been listed, sometimes only 3
of 5 or 7 of 10 are missing.
Any help would be greatly appreciated. Thanks in advance.
Jason Soza
Jason Soza
'92 Twin Classic Red Miatae
Juneau, Alaska
http://www.phrog-net.com/sparkles/
12 matches
Mail list logo
