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

2005-03-24 Thread NIPP, SCOTT V \(SBCSI\)
c.com -Original Message- From: J. Connolly [mailto:[EMAIL PROTECTED] 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 inser

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

2005-03-24 Thread Bastien Koert
t;[EMAIL PROTECTED]> CC: php-db@lists.php.net Subject: Re: [PHP-DB] MySQL query problems... Date: Thu, 24 Mar 2005 08:35:56 -0500 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 va

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

2005-03-24 Thread J. Connolly
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 V

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

2005-03-23 Thread Bastien Koert
um, the errors might be helpful bastien From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> To: 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. $

[PHP-DB] MySQL query problems...

2005-03-23 Thread NIPP, SCOTT V \(SBCSI\)
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\"