Relational database
| From: | Ron | Date: | Thu, 21 Mar 2002 13:32:07 +0000 |
| Subject: | Relational database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17799@lists.php.net to get a copy of this message | ||
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!