I did include "or die()"s, just neglected to put them into the email. No SQL
syntax errors come back.
The only kinds of errors I'm getting are that sql results are not being freed.
Tried passing the SQL into mysql_query as a separate string, too. No luck.
On Thu, 07 Dec 2006 22:34:04 -0500, Ken
At 10:58 PM 12/7/2006, [EMAIL PROTECTED] wrote:
After a lot of trial and error I've narrowed down the offending
query in my problem with sql results not freeing themselves up:
$query = mysql_query("SELECT activeID FROM activeAI WHERE
locationID='$locationID' AND activeID <> '$activeID' AND isU
After a lot of trial and error I've narrowed down the offending query in my
problem with sql results not freeing themselves up:
$query = mysql_query("SELECT activeID FROM activeAI WHERE
locationID='$locationID' AND activeID <> '$activeID' AND isUndead=0");
$numOtherAI = mysql_num_rows($query);
m
Aaron, et al,
Does nyphp need a digg.com style social news and voting
site? lemme know.. i'd be happy to build one for our community.
see: http://digg.com and
http://wimax-coverage.com
and
http://iptv-coverage.com
On 12/7/06, Aaron Deutsch <[EMAIL PROTECTED]> wrote:
I'm trying to figure out h
Message: 2
Date: Thu, 7 Dec 2006 01:38:05 -0600
From: "Anthony Papillion" <[EMAIL PROTECTED]>
Subject: Re: [nyphp-talk] xAjax anyone?
To: "NYPHP Talk"
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="iso-8859-1"
Hi Susan,
I've just started looking into using xAJAX and absolut
On 12/7/06, Aaron Deutsch <[EMAIL PROTECTED]> wrote:
I'm trying to figure out how to map servers in such a way so I can use a php
script on one server to manipulate files on another without using ftp
functions. For example: I have a file upload form on one server that will
use move_uploaded_file
I'll check that out too, thanks David!
-A
David Mintz wrote:
The MySQL Cookbook (O'Reilly) is also loads of fun.
---
David Mintz
http://davidmintz.org/
En Nueva York el tránsito de la belleza a la desolación sucede
siempre expeditivamente, como si el principio universal
de máxima eficiencia
The MySQL Cookbook (O'Reilly) is also loads of fun.
---
David Mintz
http://davidmintz.org/
En Nueva York el tránsito de la belleza a la desolación sucede
siempre expeditivamente, como si el principio universal
de máxima eficiencia hubiera aconsejado la supresión de
gradaciones intermedias.
--
I'm trying to figure out how to map servers in such a way so I can use a php
script on one server to manipulate files on another without using ftp
functions. For example: I have a file upload form on one server that will
use move_uploaded_file and put it on another server. I'm not the
networkin
Thanks Timothy, I'll check out that book. The next thing(s) to add to
my library is one or two good books on SQL/MySQL.
Sounds like a good holiday present to myself!
Cheers,
-Aaron
Timothy Boyden wrote:
I don't have a code solution for you, but Google the CHECK and UNIQUE
predicates for th
At 11:59 AM -0500 12/7/06, jessica kelly wrote:
Ted here is a site that has a brief mention of the two calendars.
http://www.kencollins.com/calendar.htm
As you may/may not know the system was changes somewhere in the ?1600's?
or so. One October lost several days when the change over occured from
Yeah... support for 4.0 was just dropped, so 4.1 is now the oldest
current version. 5.1 is now available. Version 5 adds many features
(triggers, views, stored procedures, etc) that makes it more similar to
Oracle. I've heard there's a little performance loss between 4.1 and 5,
however.
-Ro
It's great working with the Intelligent Design people, you don't have
to worry about dates before 6000 BC. What a relief. Save all those
zeros.
:-) ed
On 12/7/06, Kenneth Downs <[EMAIL PROTECTED]> wrote:
tedd wrote:
> On Mon, Dec 04, 2006 at 11:06:27AM -0500, Phil Duffy wrote:
>> I underst
Ted here is a site that has a brief mention of the two calendars.
http://www.kencollins.com/calendar.htm
As you may/may not know the system was changes somewhere in the ?1600's?
or so. One October lost several days when the change over occured from
Julian to Georgian so you need to take that into
I did a mysql_get_server_info and it returns as 3.23.58, so I guess
that's why Andy's query was returning errors.
I guess 3.23.58 is a bit older? Seems like most people are on version 4
and some are on version 5?
-Aaron
Rob Marscher wrote:
If you're using a MySQL version earlier than 4.1,
tedd wrote:
On Mon, Dec 04, 2006 at 11:06:27AM -0500, Phil Duffy wrote:
I understand that MySQL does not have the ability to store B.C.
dates, but
that PostgreSQL does.
Considering the history of calendars, I wonder how they did that?
It's one thing to estimate that 2000 years ago was 0006
On Mon, Dec 04, 2006 at 11:06:27AM -0500, Phil Duffy wrote:
I understand that MySQL does not have the ability to store B.C. dates, but
that PostgreSQL does.
Considering the history of calendars, I wonder how they did that?
It's one thing to estimate that 2000 years ago was 0006 -- but, it's
That's exactly why it doesn't work in Oracle. I'm working against 9i right
now. Maybe they added that ability in 10g.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Rob Marscher
Sent: Thursday, December 07, 2006 11:27 AM
To: NYPHP Talk
Subject: Re: [nyp
If you're using a MySQL version earlier than 4.1, subqueries aren't
available. Maybe that's why you got an error with Andy's query.
That's interesting about the query not working in Oracle. I wonder if
it's because field_name isn't specifically listed in the SELECT - like
it doesn't like the
That did it, thanks Rob and Andy.
Rob's query did the trick. I was getting a MySQL error with Andy's that
I hadn't been able to figure out.
Cheers,
-Aaron
Rob Marscher wrote:
I'm pretty sure the subquery is redundant... I think this will work...
SELECT * FROM table_name GROUP BY field_na
Hi Phil:
On Mon, Dec 04, 2006 at 11:06:27AM -0500, Phil Duffy wrote:
> I understand that MySQL does not have the ability to store B.C. dates, but
> that PostgreSQL does.
This may be helpful to you or others:
http://www.analysisandsolutions.com/code/dates.htm
> However, I have not been able to d
yipes! Kung Fu programming!
"I believe your answer lies within..."
:-) ed
On 12/7/06, Timothy Boyden <[EMAIL PROTECTED]> wrote:
I don't have a code solution for you, but Google the CHECK and UNIQUE
predicates for the SQL language, I believe your answer lies within...
Also a good SQL refere
I don't have a code solution for you, but Google the CHECK and UNIQUE
predicates for the SQL language, I believe your answer lies within...
Also a good SQL reference book that has been a trusty partner for me is
the SQL Instant Reference by Sybex.
---
Timothy Boyden
Net
You know, I thought that too. I had an Oracle window open at the time and
not a MySQL one. Oracle won't let you do it, but I just checked and MySQL
will.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Rob Marscher
Sent: Thursday, December 07, 2006 10:34
I'm pretty sure the subquery is redundant... I think this will work...
SELECT * FROM table_name GROUP BY field_name HAVING COUNT(*) > 1
Andy Dirnberger wrote:
SELECT * FROM table_name WHERE field_name IN (SELECT field_name FROM
table_name GROUP BY field_name HAVING COUNT(*) > 1)
-Origina
SELECT * FROM table_name WHERE field_name IN (SELECT field_name FROM
table_name GROUP BY field_name HAVING COUNT(*) > 1)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Aaron Fischer
Sent: Thursday, December 07, 2006 10:10 AM
To: NYPHP Talk
Subject: [nyphp
Greetings,
I'm not sure how to do the following, any tips?
I have a column in a MySQL table that contains varchars. I would like
to select all records where there are instances of more than one record
for any given varchar.
So in plain language, the SQL statement would look something like:
Anthony Papillion wrote:
Hi Susan,
I've just started looking into using xAJAX and absolutely love it.
Granted, I've not done anything useful with it yet but it seems to hav
a LOT of promise. Looks like it might have really nailed the "easy to
use" thing on the head.
Yeah, its one of things
28 matches
Mail list logo
