[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 option list. I tried also some examples with while(list...), but it can not work

[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

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_id }

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,

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.

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 tddiv align='center'font size='3'bCBC a

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 option list. I tried also some

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 place

[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

[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

[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

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: quote 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

[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: input type=checkbox name=select[] value=rowid / Notice the brackets to indicate an array. --Nicole --- Nicole Swan Web Programming Specialist Carroll College CCIT

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). It

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

[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

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 what I think is