Try this:
SELECT Description, Impact, Isolation FROM ccsd NATURAL JOIN log
or
SELECT Description, Impact, Isolation FROM ccsd LEFT JOIN log USING(logccsd)
Just add on a WHERE conditional to get the required results if necessary.
- Original Message -
From: Ron [EMAIL PROTECTED]
To:
mysql_affected_rows(int resource_id);
This will return the number of rows that were affected by the last
operation, so you could do something like this:
if(mysql_affected_rows($connection) == 1){
//insert, update or delete succeeded
}else{
//operation failed
}
- Original Message
I tested this and it seems to work:
$n = 1.90;
for($i=strlen($n);$i0;$i--){
if(substr($n,$i,1) == 0){
$n = substr($n,0,(strlen($n))-1);
}else{
break;
}
}
No charge...this time. =)
Regards,
Mike
- Original Message -
From: Thomas Murphy [EMAIL PROTECTED]
To:
Go download PHPMyAdmin.
- Original Message -
From: Morten Nielsen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 8:34 AM
Subject: [PHP-DB] MySQL
Hi,
Is there an easy way to see the data in a table?
I made a table that contains information about people. How
From Windows Help:
You can use Data Sources Open Database Connectivity (ODBC) to access data
from a variety of database management systems. For example, if you have a
program that accesses data in a SQL database, Data Sources (ODBC) will let
you use the same program to access data in a Visual
From Windows Help:
You can use Data Sources Open Database Connectivity (ODBC) to access data
from a variety of database management systems. For example, if you have a
program that accesses data in a SQL database, Data Sources (ODBC) will let
you use the same program to access data in a
The dl() function does not work on multi-threaded servers (ie Apache(win32)
and IIS). You'll have to add it in your php.ini file.
- Original Message -
From: aiQa [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 01, 2002 3:20 AM
Subject: [PHP-DB] Oracle Dll
Hi,
I installed
Dll
Hi again,
When I include php_oracle.dll my .php pages hangs. IE world turns and turns
around. No error log is displayed. Do you have any idea?
Thanks,
aiQa
- Original Message -
From: Mike Maltese [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 01, 2002 1:35 PM
Subject
I'm trying to figure out a way to do a more efficient join on four tables.
The main table is products, with the other tables being common options for
the products. It's pretty well normalized, but am I doing these joins
properly or is there a more efficient way? This looks pretty ugly to me.