RE: [PHP] 1 is not a valid MySQL-Link resource in /home/guestbook.php on line 112

2001-12-04 Thread Nicolas Guilhot 

Check that you have not already close the connection to the mysql database.
Or maybe, the mysql_connect returned an error !

-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 4 décembre 2001 08:42
À : [EMAIL PROTECTED]
Objet : [PHP] 1 is not a valid MySQL-Link resource in
/home/guestbook.php on line 112


any one here can help my problem?
(I 'am using hypermart.net hosting, so i am not sure which php version that
they
provided)

Here are the problems:

$sqlshow = SELECT * FROM $table ORDER BY id DESC LIMIT $show, $maxshow;
$result = mysql_db_query($database, $sqlshow);

 produce: 1 is not a valid MySQL-Link resource in /home/guestbook.php on
line
112

while (($myrow = mysql_fetch_array($result)))

 produce: Supplied argument is not a valid MySQL result resource in
/home/guestbook.php
on line 116

mysql_close();

 produce: 1 is not a valid MySQL-Link resource in /home/guestbook.php on
line
126

thanks.
hendro.



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP] 1 is not a valid MySQL-Link resource in /home/guestbook.php on line 112

2001-12-04 Thread Mark Roedel 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, December 04, 2001 1:42 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP] 1 is not a valid MySQL-Link resource in 
 /home/guestbook.php on line 112
 
 
 any one here can help my problem? 
 (I 'am using hypermart.net hosting, so i am not sure which 
 php version that they 
 provided) 
 
 Here are the problems:
  
 $sqlshow = SELECT * FROM $table ORDER BY id DESC LIMIT 
 $show, $maxshow; 
 $result = mysql_db_query($database, $sqlshow); 
  
  produce: 1 is not a valid MySQL-Link resource in 
 /home/guestbook.php on line 
 112 

Where is your $database variable getting its value?
  
---
Mark Roedel   | Nothing in life is so bad that it cannot be
Systems Programmer|   made much, much worse by the addition of
LeTourneau University |lots of spikes and razors.
Longview, Texas, USA  |-- Sean Kozma 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP] 1 is not a valid MySQL-Link resource in /home/guestbook.php on line 112

2001-12-04 Thread Richard Lynch 

 any one here can help my problem?

Eventually.

 (I 'am using hypermart.net hosting, so i am not sure which
 php version that they
 provided)

?php phpinfo();?

will tell you the version number, and a bazillion more things or varying 
importance.

 $sqlshow = SELECT * FROM $table ORDER BY id DESC LIMIT
 $show, $maxshow;
 $result = mysql_db_query($database, $sqlshow);
  
  produce: 1 is not a valid MySQL-Link resource in
 /home/guestbook.php on line
 112
 
 Where is your $database variable getting its value?

That's definitely your next step -- Figure out what the heck is in 
$database, and how it got there.

-- 
Like music?  http://l-i-e.com/artists.htm


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]