Re: Advice wanted on Data Structure

2003-07-30 Thread Viorel Dragomir
I try a solution like this. It's kind of a tree [so your warned that this structure will be a waste of time if you have a subkit to a subkit to a... ] KITS kt_id int kt_things. parent_kt_id_fk int constraint fk_KITS foreign key (parent_kt_id_fk) references kits(kt_id) For details consult th

Re: "between A and B" with another condition?

2003-07-22 Thread Viorel Dragomir
- Original Message - From: "Lingua2001" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 10:37 AM Subject: "between A and B" with another condition? > Hi there, > > How can I extract values for "members whose level is below '3', and > their names are between the a

Re: how can I use a subnet mask to limit

2003-07-22 Thread Viorel Dragomir
- Original Message - From: "Liu Yang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 5:00 PM Subject: how can I use a subnet mask to limit > Hello, mysql, > > I have met a problem. Look at the following, please. > > mysql> grant all on school.* to [EMAIL PROTECT

Re: how to limit COUNT(*)

2003-07-22 Thread Viorel Dragomir
- Original Message - From: "Mojtaba Faridzad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 4:40 PM Subject: Re: how to limit COUNT(*) > for example: > > SELECT COUNT(*) as numfound FROM mytable WHERE mycondition; > > in this query, mytable and mycondition are v

Re: Jpg file insertion

2003-07-18 Thread Viorel Dragomir
Don't do that, if it's possible. You'll probably slow down the server. Try to save file in a directory and save to database only the filename. [you may want to rename the file so you won't overwrite diff pics with the same name] vioss - Original Message - From: "Egor Egorov" <[EMAIL PROT

Re: JOIN with php

2003-07-17 Thread Viorel Dragomir
sorry [my unfortunate mistake] disregard the pg_ [stuff] and consider mysql_ instead [mysql_query($query)] - Original Message - From: "Viorel Dragomir" <[EMAIL PROTECTED]> To: "Patricio Gigoux" <[EMAIL PROTECTED]>; "mysql groups" <[EMAIL PROT

Re: JOIN with php

2003-07-17 Thread Viorel Dragomir
Can u apply the standard list of rows to your query. Like: $result = pg_exec($db, $query); while($row = pg_fetch_row($result)) print_r($row); - Original Message - From: "Patricio Gigoux" <[EMAIL PROTECTED]> To: "mysql groups" <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 4:19 PM