Re: [PHP-DB] INSERT Question

2003-03-31 Thread Mustafa Ocak
You can't perform update like this. You should loop through rows you want to update if they have different key values. UPDATE tbl_ib_articles SET col_name=new_value WHERE key_column=key_value; You can change the condition part, which can include non-key columns, HTH, Mustafa - Original

Re: [PHP-DB] Sharing variable values among PHP files

2003-03-31 Thread Mustafa Ocak
You can store the value in a session variable session_start(); if (isset($_HTTP_SESSION_VARS['your_variable_name'])) { $value=$_HTTP_SESSION_VARS['your_variable_name']; //get the value }else{ $_HTTP_SESSION_VARS['your_variable_name']=new value; } You can use this script to pass values between

Re: [PHP-DB] MSSQL VIRTUAL TABLES

2003-06-26 Thread mustafa ocak
Hi I think the problem is in the where part of your SQL if AgentRef is a varchar column then you should rewrite the where part as WHERE Order_Details.Qref = Order_Header.Qref AND Order_Header.AgentRef like '48976' or WHERE Order_Details.Qref = Order_Header.Qref AND Order_Header.AgentRef

Re: [PHP-DB] Query Case In-sensitive

2003-11-19 Thread mustafa ocak
Use LIKE clause instead of = SELECT item_number FROM item WHERE item_code LIKE 'M1234' ; This will perform case-insensitive matching on all databases I used before (Including Oracle, MySQL, SQL-Server) - Original Message - From: ramki [EMAIL PROTECTED] To: [EMAIL PROTECTED];

Re: [PHP-DB] works on production server but not on localhost

2003-11-19 Thread mustafa ocak
You are probably right, it looks like a permission problem. What is the OS (win, Linux) of your machine? It's not about PHP.INI, If your operating system is Windows give write permission to the directory these text files reside. You can do it by using Internet Services Manager If it is a unix

Re: [PHP-DB] works on production server but not on localhost

2003-11-19 Thread mustafa ocak
but it never seemed to work. is there a free chmod tool? or a simple way to do it in windows? again, i am sure i sound noob, and am... thanks for the response. -paul -Original Message- From: mustafa ocak [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:32 AM To: [EMAIL

Re: [PHP-DB] Query Case In-sensitive

2003-11-19 Thread mustafa ocak
-- External: (919) 483-0266 Internal: 703-0266 Fax: (919) 315-6842 Office: RC2 - 2005 Email: [EMAIL PROTECTED] -- http://usphdba.gsk.com/ - USPHARMA Database Site mustafa ocak [EMAIL PROTECTED] 19

Re: [PHP-DB] Multiple deletes and updates...

2004-03-04 Thread mustafa ocak
You can use checkboxes to do it : input type=checkbox name=delrec[] value=?=$recid? and in the code foreach($_POST[delrec] as $ccc) { $res=mysql_query(delete from table_name where id= $ccc); } HTH Mustafa - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]

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