Re: [PHP-DB] Relational database

[Andrey Hristov]

Otidi tuk : http://www.php.net/unsub.php i vig kak se pravi Unsubscribe

Andrey

- Original Message - 
From: Stefan [EMAIL PROTECTED]
To: 'Andrey Hristov' [EMAIL PROTECTED]; 'Ron' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 22, 2002 10:37 AM
Subject: RE: [PHP-DB] Relational database


 Dear friends at [EMAIL PROTECTED],
 
 I am an innocent guy from Bulgaria and somehow I got in to your mailing
 list ([EMAIL PROTECTED]  [EMAIL PROTECTED]). Now I got all of your
 mails and I am sure this is a mistake.
 

 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Relational database

[Cirstoiu Aurel Sorin]

test



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Relational database

[Hunter, Ray]

Try this:

SELECT ccsd.Description, ccsd.Impact, ccsd.Isolation FROM ccsd, log WHERE
ccsd.logccsd=log.logccsd;

You cannot specify a database is = to a row...


Thank you,

Ray Hunter
Firmware Engineer

ENTERASYS NETWORKS


-Original Message-
From: Ron [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 6:32 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Relational database


I am trying to get fields from 2 different tables that have the same field
name to pull the records from one table For example
mysql_connect($DBhost,$DBuser,$DBpass) or die(Unable toconnect to
database);
@mysql_select_db($DBName) or die(Unable to select database $DBName);
$sqlquery1 = mysql_query(SELECT Description, Impact, Isolation . FROM
ccsd, log WHERE ccsd=log.logccsd);

while ($query = mysql_fetch_array($sqlquery1)) {
 $CCSD = $query[CCSD];
 $Description = $query[Description];
 $Impact = $query[Impact];
 $Isolation = $query[Isolation];
}
This code is not working.help please.yes I am a newbie!



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Relational database

[Mike Maltese]

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: [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 5:32 AM
Subject: [PHP-DB] Relational database


 I am trying to get fields from 2 different tables that have the same field
 name to pull the records from one table
 For example
 mysql_connect($DBhost,$DBuser,$DBpass) or die(Unable toconnect to
 database);
 @mysql_select_db($DBName) or die(Unable to select database $DBName);
 $sqlquery1 = mysql_query(SELECT Description, Impact, Isolation .
 FROM ccsd, log WHERE ccsd=log.logccsd);

 while ($query = mysql_fetch_array($sqlquery1)) {
  $CCSD = $query[CCSD];
  $Description = $query[Description];
  $Impact = $query[Impact];
  $Isolation = $query[Isolation];
 }
 This code is not working.help please.yes I am a newbie!



 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php