That's a very good point,
but since I use postgres that's one point that doesn't affect me and as
such didn't cross my mind at the time.
(Postgres uses schemas where mysql uses databases, a different database
on postgres usually means a different database machine. And joining
tables from differe
I would keep the db names and/or schema names in your queries.
It clarifies what you are doing with the query making it easier for
someone else to debug, improve, ... Certainly for those not familiar
with your db structure.
I am not aware of any drawbacks that can result from this. (Ok, maybe
y
merce/
---
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 2:07 PM
To: 'Matthew Moldvan'; 'Damir Dezeljin'; PHP-db list
Subject: RE: [PHP-DB] QUERY question (group by) - please help
Just a side no
ility.
> -Original Message-
> From: Matthew Moldvan [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 1:57 PM
> To: 'Damir Dezeljin'; PHP-db list
> Subject: RE: [PHP-DB] QUERY question (group by) - please help
>
>
> Try mysql_num_rows() ...
> h
Try mysql_num_rows() ...
http://www.php.net/manual/en/function.mysql-num-rows.php for the
documentation.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce/
--
PROTECTED]
-Original Message-
From: L Melville [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2001 14:54
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] query question
yeh this would work, how can I assign the rows to a new array? Is each row
accessed as an element?
"Jon Farmer&quo
; From: L Melville [mailto:[EMAIL PROTECTED]]
> Sent: 28 August 2001 14:41
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] query question
>
>
> I want to loop round $result fetching rows and if the current row is not
> needed then removing it from $result, $result will then get used
]
-Original Message-
From: L Melville [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2001 14:41
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] query question
I want to loop round $result fetching rows and if the current row is not
needed then removing it from $result, $result will then get used again but
I want to loop round $result fetching rows and if the current row is not
needed then removing it from $result, $result will then get used again but
with the said rows removed. I am trying to do this to avoid some major code
changes with what I am working with.
"Rick Emery" <[EMAIL PROTECTED]> w
What exactly are you trying to do? Do you want to delete certain rows from
$result? Or delete ALL rows, in which you'd use:
mysql_return_result($result);
If you want to delete certain rows, you can't. You just have to make your
selection criteria more precise. Then, fetch row by row to weed o
sorry I wasn't very clear, I do not actually want to delete anything from
the database, I need to remove some of the query elements before it is used
elsewhere (before fetch array ect), but I cannot alter the way the select
query works.
"Dave Watkinson" <[EMAIL PROTECTED]> wrote in message
[EM
instead of SELECT all_records WHERE some_condition, and then DELETE
certain_rows, couldn't you just do a DELETE FROM WHERE?
-Original Message-
From: L Melville [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2001 14:21
To: [EMAIL PROTECTED]
Subject: [PHP-DB] query question
Hi,
If I run
12 matches
Mail list logo
