| Bastien Koert 2005-03-24, 3:55 am |
| um, the errors might be helpful
bastien
>From: "NIPP, SCOTT V (SBCSI)" <sn4265@sbc.com>
>To: <php-db@lists.php.net>
>Subject: [PHP-DB] MySQL query problems...
>Date: Wed, 23 Mar 2005 17:18:44 -0600
>
> 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
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
|