MySQL query problems...
| From: | NIPP, SCOTT V \(SBCSI\) | Date: | Wed, 23 Mar 2005 23:18:44 +0000 |
| Subject: | MySQL query problems... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-39016@lists.php.net to get a copy of this message | ||
I am getting errors for the following queries. This query seems
to work fine in phpMyAdmin.
$query2 = "SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, accounts
WHERE AllMid_Data.CPU_IN_SVC = \"Y\"
AND AllMid_Data.CPU_DNS = \"sbcld.sbc.com\"
AND accounts.sbcuid = $sbcuid
AND accounts.system = AllMid_Data.CPU_Hostname
AND accounts.ctime IS NULL
ORDER BY CPU_Hostname ASC";
$results2 = mysql_query($query2, $Prod) or die(mysql_error());
$system2 = mysql_fetch_assoc($results2);
$query3 = "SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, acct_db
WHERE AllMid_Data.CPU_IN_SVC = \"Y\"
AND AllMid_Data.CPU_DNS = \"sbcld.sbc.com\"
AND acct_db.key1 LIKE \"$sbcuid%\"
AND acct_db.key1 LIKE \"%\".AllMid_Data.CPU_Hostname
ORDER BY CPU_Hostname ASC";
$results3 = mysql_query($query3, $Prod) or die(mysql_error());
$system3 = mysql_fetch_assoc($results3);
I am assuming that I have an issue with query3. Thanks in
advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: sn4265@sbc.com
Web: http:\\ldsa.sbcld.sbc.com