RE: [PHP-DB] MySQL query problems...

OK. I think I have resolved this issue. The problem I am having now is that I have a simple table that is a list of systems to exclude from the display. I am having trouble figuring out how to structure my query to actually exclude the systems in this table. Here is what I tried, and it gives me 13 instances of every entry, 13 is the number of hostnames in the exclusion table. $query = "SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, exclusion WHERE AllMid_Data.CPU_IN_SVC = \"Y\" AND AllMid_Data.CPU_DNS = \"sbcld.sbc.com\" AND AllMid_Data.CPU_Hostname != exclusion.hostname ORDER BY CPU_Hostname ASC"; $results = mysql_query($query, $Prod) or die(mysql_error()); $system = mysql_fetch_assoc($results); Additionally, what I am actually working towards is that if a system shows up in either of the other queries it gets excluded from this one. I have not tried anything to make that happen yet. I will tackle that challenge once I can resolve this part. Thanks again. Scott Nipp Phone: (214) 858-1289 E-mail: sn4265@sbc.com Web: http:\\ldsa.sbcld.sbc.com -----Original Message----- From: J. Connolly [mailto:web@jozef.info] Sent: Thursday, March 24, 2005 7:36 AM Cc: php-db@lists.php.net Subject: Re: [PHP-DB] MySQL query problems... yeah...errora are important. I do not escape my quotation marks in a query. I use single quotes within my insert and select statements. If it says "No valis MySQL resource then you are returning 0 records which may be caused by escaping the quotations. I follow this pattern $sql ="INSERT INTO <table> VALUES ('some value','another value','etc')"; NIPP, SCOTT V (SBCSI) wrote: > 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