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 --
Whoops, had a little typo in there.
$n = substr($n,0,(strlen($n))-1);
should be
$n = substr($n,0,(strlen($n)-1));
Mike
- Original Message -
From: "Mike Maltese" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 5:58 AM
Subject: Re
I tested this and it seems to work:
$n = 1.90;
for($i=strlen($n);$i<0;$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
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 peop
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 Visua
>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 Fo
:49 AM
Subject: Re: [PHP-DB] Oracle 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 PR
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 inst
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.
10 matches
Mail list logo
