RE: [PHP-DB] Another question
I've tried to use this function, but it doesn't work on IE 5.0
On Opera 7.21 it works.
So on what browser you've tested it?
Mike U. Petrov
-Original Message-
From: Duane Lakoduk [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 4:18 PM
To: 'Constantin Brinzoi'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Another question
You can avoid the prompt when using javascript to close the window if you
use this:
function closeit(){
window.opener = top;
window.close();
}
Now, window will close without prompting.
hth,
Duane
> -Original Message-
> From: Constantin Brinzoi [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 15, 2003 6:15 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Another question
>
>
> Is there a php function that closes a browser window?
>
> I know there is a javascript function (window.close), but I
> can't use it
> because it complains that the window is not opened by javascript
> (window.open).
>
> I looked over the function reference but I didn't find anything about
> this problem.
>
> TIA
> Constantin Brinzoi
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Another question
I think no. IMHO PHP can't have effect on user's programs. If I'm not right correct me. But window.close can close window opened not by javascript. It just ask user is he want to close or no. Mike U. Petrov PHP-programmer. -Original Message- From: Constantin Brinzoi [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 3:15 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Another question Is there a php function that closes a browser window? I know there is a javascript function (window.close), but I can't use it because it complains that the window is not opened by javascript (window.open). I looked over the function reference but I didn't find anything about this problem. TIA Constantin Brinzoi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Very complex query
I tried to use GROUP BY and it worked almost right but i need to return user_id and mysql generated an error that notes.user_id isn't used in GROUP BY... Mike U. Petrov -Original Message- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 11:25 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Very complex query Mike U. Petrov wrote: > First, sorry my starnge way to post new thread. > Second: > I want to specify some features: > in my table notes I've a lot of user_id's for each object_id and I don't > want to find unique user_id, I only want to find one user_id for each > object_id, so unique(user_id) doesn't match. Do u have any other ideas? > > Mike U. Petrov > > > -Original Message- > From: Justin Patrin [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 11, 2003 10:53 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: Very complex query > > Use unique(user_id). And please don't reply to a previous post when > posting a new threadit screws up threading. > > -- > paperCrane > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php Oops, sorry about that. What you could do is: GROUP BY object_id or GROUP BY object_id, other_field, other_field2, etc Just don't group by user_id. -- paperCrane -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Very complex query
No, DISTINCT isn't match my purpose cause of it rerurns unique rows but I
need ONE user_id per one object_id.
Mike U. Petrov
-Original Message-
From: Muhammed Mamedov [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 11:01 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Very complex query
You can also DISTINCT command instead.
UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am
using)
Hope this helps,
M.Mamedov
- Original Message -
From: "Justin Patrin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 9:52 AM
Subject: [PHP-DB] Re: Very complex query
> Mike U. Petrov wrote:
>
> > Hi every1!
> > Excuse me for maybe offtopic but I need help on mysql database.
> > I have 4 tables, and here are some important extractions from 'em:
> > objects{
> > object_id;
> > name;
> > }
> > users{
> > user_id;
> > nick;
> > date;
> > }
> > notes{
> > user_id;
> > object_id;
> > }
> > object_properties{
> > object_id;
> > property_name;
> > property_value;
> > }
> > I need to get EACH object_id from notes with ONLY ONE of corresponding
> > user_id's. Also for each object I need it's name from objects and
property
> > from object_properties where property_name = 'foo'. And for each of
obtained
> > user_id I need it's nick and it's date.
> > Does anyone know how to do it just by one mysql query?
> >
> > Thanx...
> > Mike U. Petrov
>
> Use unique(user_id). And please don't reply to a previous post when
> posting a new threadit screws up threading.
>
> --
> paperCrane
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Very complex query
First, sorry my starnge way to post new thread. Second: I want to specify some features: in my table notes I've a lot of user_id's for each object_id and I don't want to find unique user_id, I only want to find one user_id for each object_id, so unique(user_id) doesn't match. Do u have any other ideas? Mike U. Petrov -Original Message- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 10:53 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Very complex query Use unique(user_id). And please don't reply to a previous post when posting a new threadit screws up threading. -- paperCrane -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Very complex query
Hi every1!
Excuse me for maybe offtopic but I need help on mysql database.
I have 4 tables, and here are some important extractions from 'em:
objects{
object_id;
name;
}
users{
user_id;
nick;
date;
}
notes{
user_id;
object_id;
}
object_properties{
object_id;
property_name;
property_value;
}
I need to get EACH object_id from notes with ONLY ONE of corresponding
user_id's. Also for each object I need it's name from objects and property
from object_properties where property_name = 'foo'. And for each of obtained
user_id I need it's nick and it's date.
Does anyone know how to do it just by one mysql query?
Thanx...
Mike U. Petrov
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PostgreSQL on Windows
I think yes. For more information see http://techdocs.postgresql.org/guides/InstallingOnWindows Mike U. Petrov -Original Message- From: Rosen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 6:50 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PostgreSQL on Windows Hi, Can I start PostgreSQL server and client on Windows machine ? Thanks in advance! Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
