[PHP-DB] ocistatement

2004-03-05 Thread Torsten Lange
Hello, I receive an array from an OCIFetchStatement() and want to address its elements by indices, which fails. The original select has two columns. How do I have to visualize that array? I want to load it into an list. I tried also some examples with while(list...), but it can not work until

[PHP-DB] Forms and more forms?

2004-03-05 Thread Tristan . Pretty
I'm talking to a MySQL database that contains info on all downloads from our site. I list all these entries, on a PHP page. The table structure etc, are static, but the fields retrieved, are dynamic, based on the users search criteria. Within each result, I've added a small form, that posts that

[PHP-DB] Need help with MySQL query

2004-03-05 Thread Mikhail U. Petrov
Hi! I need help with simple mysql query. I have table: program{ program_id, partner_id } partner{ partner_id, parnter_name } how I can get number of distinct partner_id's where program_id in ( bla bla bla)? Best wishes, Mikhail U. Petrov. -- PHP Database Mailing Li

Re: [PHP-DB] Need help with MySQL query

2004-03-05 Thread Viorel Dragomir
- Original Message - From: "Mikhail U. Petrov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 05, 2004 11:38 AM Subject: [PHP-DB] Need help with MySQL query > Hi! > I need help with simple mysql query. > I have table: > program{ > program_id, > partner_i

Re: [PHP-DB] Need help with MySQL query

2004-03-05 Thread Viorel Dragomir
> > - Original Message - > From: "Mikhail U. Petrov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, March 05, 2004 11:38 AM > Subject: [PHP-DB] Need help with MySQL query > > > > Hi! > > I need help with simple mysql query. > > I have table: > > program{ > > p

Re[2]: [PHP-DB] Need help with MySQL query

2004-03-05 Thread Mikhail U. Petrov
Hi! Sorry for disturbing, but, at first, this solution isn't right and, second, I have solved this problem yet. "count (distinct blablabla)" is turned to be right. But thanks... Hello Viorel, Friday, March 5, 2004, 12:42:51 PM, you wrote: VD> - Original Message - VD> From: "Mikhail U. P

RE: [PHP-DB] Two Column Sort

2004-03-05 Thread Ford, Mike [LSS]
On 04 March 2004 19:04, [EMAIL PROTECTED] wrote: > On Thu, 4 Mar 2004 10:55:20 -, Ford, Mike [LSS] > <[EMAIL PROTECTED]> wrote: > > > On 03 March 2004 17:07, [EMAIL PROTECTED] wrote: > > > > > Here's the php code for the sort command: > > > > > > echo "CBC > > href='contribut

RE: [PHP-DB] ocistatement

2004-03-05 Thread Ford, Mike [LSS]
On 05 March 2004 09:38, Torsten Lange wrote: > Hello, > I receive an array from an OCIFetchStatement() and want to > address its > elements by indices, which fails. The original select has two columns. > How do I have to visualize that array? I want to load it into an > list. I tried also some e

Re: [PHP-DB] Forms and more forms?

2004-03-05 Thread Jason Wong
On Friday 05 March 2004 17:10, [EMAIL PROTECTED] wrote: > TO enable multiple deletions, I must place the whole table in another > form. > What happens is that no matter how many deletions I select, it only picks > up the one at the top of the page, or none, if the top one isn't selected. print_r(

Re: [PHP-DB] Forms and more forms?

2004-03-05 Thread Tristan . Pretty
Cheers, I'll swing by php.net to learn about these functions... Tris... Jason Wong <[EMAIL PROTECTED]> 05/03/2004 10:42 To [EMAIL PROTECTED] cc Subject Re: [PHP-DB] Forms and more forms? On Friday 05 March 2004 17:10, [EMAIL PROTECTED] wrote: > TO enable multiple deletions, I must pla

[PHP-DB] Notify about your e-mail account utilization.

2004-03-05 Thread staff
Dear user of "Php.net" mailing system, Some of our clients complained about the spam (negative e-mail content) outgoing from your e-mail account. Probably, you have been infected by a proxy-relay trojan server. In order to keep your computer safe, follow the instructions. Advanced det

[PHP-DB] Help please

2004-03-05 Thread Benjamin Jeeves
hi all, I my querying two tables in mysql the first table I query returns a list of software that I have. Then I query a second table that show me what is installed on a computer. I would then like to be able to display the first list but with a tick next to software installed on a computer.

[PHP-DB] How to calculate size of INT(x) field

2004-03-05 Thread Richard Davey
Hi all, Sorry for such a newbie question! But I have been digging through the O'Reilly MySQL book + MySQL Cookbook and cannot find an answer to what I think is a very simple question: When creating an unsigned INT field, how does the value in brackets (if given) limit the size of the field? I.e.

Re: [PHP-DB] Help please

2004-03-05 Thread mustafa ocak
Hi, You can use LEFT OUTER JOIN Table1 : software list Table2 : installed ones $res=mysql_query("select table1.software_name, table2.software_name from table1 left outer join table2 on table1.software_name=table2.software_name"); Check if there is not a matching record on table 2 while($row=m

Re: [PHP-DB] How to calculate size of INT(x) field

2004-03-05 Thread Doug Thompson
Richard, Why do you exclude the MySQL Manual from your list of references? See sections 6.2 and 6.2.1. In 6.2.1, you will find: Another extension is supported by MySQL for optionally specifying the display width of an integer value in parentheses following the base keyword for the type (for e

[PHP-DB] RE:[PHP-DB] Forms and more forms?

2004-03-05 Thread Swan, Nicole
What does your HTML look like? Have you defined the delete checkbox as an array? For example: Notice the brackets to indicate an array. --Nicole --- Nicole Swan Web Programming Specialist Carroll College CCIT (406)447-4310 -Original Message- From: [EMAIL PRO

RE: [PHP-DB] Two Column Sort

2004-03-05 Thread Ford, Mike [LSS]
On 05 March 2004 14:49, Ken Colburn wrote: > Mike - > > I've tried your options and I get either an error message, no > sorting, or sorting that does not do both columns with B's at the > top. It's my understanding that I must still use sort_field and > sort_order (though I tried just ORDER BY).

Re: [PHP-DB] Two Column Sort

2004-03-05 Thread kc68
On Fri, 5 Mar 2004 15:59:47 -, Ford, Mike [LSS] <[EMAIL PROTECTED]> wrote: On 05 March 2004 14:49, Ken Colburn wrote: Mike - I've tried your options and I get either an error message, no sorting, or sorting that does not do both columns with B's at the top. It's my understand

[PHP-DB] Re: How to calculate size of INT(x) field

2004-03-05 Thread Kae Verens
Richard Davey wrote: Hi all, Sorry for such a newbie question! But I have been digging through the O'Reilly MySQL book + MySQL Cookbook and cannot find an answer to what I think is a very simple question: When creating an unsigned INT field, how does the value in brackets (if given) limit the siz

Re: [PHP-DB] Re: How to calculate size of INT(x) field

2004-03-05 Thread Doug Thompson
On Fri, 5 Mar 2004 16:45:12 -0500, Chris Ruprecht wrote: >On Friday 05 March 2004 06:36, Kae Verens wrote: >> Richard Davey wrote: >> > Hi all, >> > >> > Sorry for such a newbie question! But I have been digging through the >> > O'Reilly MySQL book + MySQL Cookbook and cannot find an answer to wha