Re: MySQL query problems...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Not quite correct, "No valis MySQL resource" means the query and/or link failed in connection in some way. A correct and proper query MAY easily return 0 rows and that is correct and will give you a valid resource (handle) and simply no data.

Bastien

From: "J. Connolly" <web@xxxxxxxxxx>
CC: php-db@xxxxxxxxxxxxx
Subject: Re:  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 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@xxxxxxx
Web:  http:\\ldsa.sbcld.sbc.com




-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux