not a valid MySQL-Link resource

phpnewbie · #1 17-Jun-2005, 10:44

Thanks to many of you I have been able to connect the MySql database, and retrieve "part" of the database. I am now getting the error below, along with a couple of others, you can see them at http://resource.library.tmc.edu/Cart/index0610.php

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/html/Cart/index0610.php on line 17

I'm sure the seasoned PHP/MySQL person this is an easy answer, but I am new. Can you tell me what I'm missing. The database, file & column names are all correct and spelled correct. ;-)

PHP Code:


<?
require("Cart0527.php");
DBinfo();
Brand();
Root();
//connection to mysql host
$conn = @mysql_connect("$DBHost","$DBUser","$DBPass")or die (mysql_error());
//calling database to connect to within Mysql 
$db = mysql_select_db("$DBName");
$old=date("z")-1;
$query = "DELETE FROM Users WHERE Date < $old" ;
$query = "SELECT CartItemsID,Date FROM CartItems" ;
//line 17
$mysql_result = mysql_query("$DBName", "DELETE FROM Users WHERE Date < $old");
$mysql_result = mysql_query("$DBName","SELECT CartItemsID,Date FROM CartItems");

while ($row = mysql_fetch_row ($mysql_result)) {
$CII=$row[0];
$CDa=$row[1];
$pieces=explode(":",$CDa);
$DCHK=$pieces[1];
if ($DCHK < $old)

lukeyj · #2 24-Jun-2005, 20:11

I'm assuming all information is in the required file.

I'm not sure if it will help but if you've selected database i don't think you need to do it in every mysql query.

On functions list it shows this:

mysql_query ( string query [, resource link_identifier] )

No mention of DB name. So maybe your passing the string query as resource link_identifier. So therefore it could quite possibly like this:

$mysql_result = mysql_query("DELETE FROM Users WHERE Date < $old");
$mysql_result = mysql_query("SELECT CartItemsID,Date FROM CartItems");

I can't remember whether it's $conn or $db as resource link_identifier. If it's $conn then:

$mysql_result = mysql_query("DELETE FROM Users WHERE Date < $old", "$conn");
$mysql_result = mysql_query("SELECT CartItemsID,Date FROM CartItems", "$conn");

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
High quality link building	spogg	Search Engine Optimization Forum	7	23-Aug-2006 12:41
Windows: From only £20p/y,Linux: from $10p/m. ASP, ASP.NET, PHP, Free MySQL, +More	EyotaHosts	Web Hosting Advertisements & Offers	0	28-Jun-2003 14:54
gzwrite(): supplied argument is not a valid stream resource in	JdS	MySQL / PHP Forum	2	24-Mar-2003 08:57