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
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
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
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];
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
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
--
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
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]
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