RE: [PHP-DB] Problem connecting to db on Linux

so, you probably have something like, right? If not, change your code to: $query = "SELECT DISTINCT Nickname, HEI_ID FROM customers WHERE Nickname <> ORDER BY Nickname"; $result = mysql_query($query) or die("error: ".mysql_error()); show us your code. I ask, because you appear to have an extra " in fron of ORDER BY -----Original Message----- From: George Pitcher [mailto:fmdev@yahoo.co.uk] Sent: Monday, February 18, 2002 9:53 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Problem connecting to db on Linux Rick, Sorry, here it is: Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/HERONweb/home.php on line 32 I have 'echo mysql_errno();' just after the query is called but no number is being displayed. George ----- Original Message ----- From: "Rick Emery" <remery@excel.com> To: "'George Pitcher'" <fmdev@yahoo.co.uk>; <php-db@lists.php.net> Sent: Monday, February 18, 2002 3:46 PM Subject: RE: [PHP-DB] Problem connecting to db on Linux > what is the error message you get? > do you print otu mysql_error() ? > > -----Original Message----- > From: George Pitcher [mailto:fmdev@yahoo.co.uk] > Sent: Monday, February 18, 2002 9:42 AM > To: php-db@lists.php.net > Subject: Re: [PHP-DB] Problem connecting to db on Linux > > > Greg, et al, > > Now the re-installation is complete, I am getting past the original error -- > only to hit another. > > My query is as follows (echoed to web page): > > SELECT DISTINCT Nickname, HEI_ID FROM customers WHERE Nickname <> '' ORDER > BY Nickname > > I have checked case against db an it is correct. Am I missing something else > which is obvious? > > George > > ----- Original Message ----- > From: "Rick Emery" <remery@excel.com> > To: "'George Pitcher'" <fmdev@yahoo.co.uk>; "Rick Emery" <remery@excel.com>; > "Greg Donald" <greg@ascendantmedia.com>; <php-db@lists.php.net> > Sent: Monday, February 18, 2002 3:19 PM > Subject: RE: [PHP-DB] Problem connecting to db on Linux > > > > Do you have your error messages crossed? I ask, because I would think > your > > "cannot select" message would go with your mysql_select_db() and your > > "cannot connect" would go with your mysql_connect() > > > > -----Original Message----- > > From: George Pitcher [mailto:fmdev@yahoo.co.uk] > > Sent: Monday, February 18, 2002 8:48 AM > > To: Rick Emery; Greg Donald; php-db@lists.php.net > > Subject: Re: [PHP-DB] Problem connecting to db on Linux > > > > > > Rick, > > > > I snipped the code from my windoze system. I did have to change the case > of > > the dbname to reflect the Linux version (all lc). > > > > The error message I got (not displayed on screen but visible on 'view > > source') was 'Could not connect' which, to me means that it got past the > > login to server and stalled on the select db part? > > > > George > > ----- Original Message ----- > > From: "Rick Emery" <remery@excel.com> > > To: "'George Pitcher'" <fmdev@yahoo.co.uk>; "Greg > > Donald" > > <greg@ascendantmedia.com>; <php-db@lists.php.net> > > Sent: Monday, February 18, 2002 2:31 PM > > Subject: RE: [PHP-DB] Problem connecting to db on Linux > > > > > > > Have you spelled the name of the database correctly, including case > > > sensitivity? > > > > > > What error message are you getting to indicate failure? > > > > > > -----Original Message----- > > > From: George Pitcher [mailto:fmdev@yahoo.co.uk] > > > Sent: Monday, February 18, 2002 8:21 AM > > > To: Greg Donald; php-db@lists.php.net > > > Subject: Re: [PHP-DB] Problem connecting to db on Linux > > > > > > > > > Greg, et al, > > > > > > This is the contents of the include file: > > > > > > <?php > > > > > > $link = mysql_connect ('localhost', 'root', '*****') or > > > die ("Could not > > > select db"); > > > > > > mysql_select_db ('Heronsql') or die ("Could not connect"); > > > > > > ?> > > > > > > I have also tried it with the following: > > > > > > <?php > > > > > > $link = mysql_connect ('localhost', 'root', '*****'); > > > > > > echo mysql_errno().": ".mysql_error()."<BR>"; > > > > > > mysql_select_db ('Heronsql'); > > > > > > echo mysql_errno().": ".mysql_error()."<BR>"; > > > > > > ?> > > > > > > Te results for this were: > > > 0:0 > > > 0:0 > > > > > > I have reinstalled my Mandrake (MySQL/PHP4.0.6/Apache) and I am about to > > > retest so I'll report back soon. > > > > > > George > > > ----- Original Message ----- > > > From: "Greg Donald" <greg@ascendantmedia.com> > > > To: <php-db@lists.php.net> > > > Sent: Monday, February 18, 2002 2:08 PM > > > Subject: Re: [PHP-DB] Problem connecting to db on Linux > > > > > > > > > > > I've been working with PHP/MySQL on Win NT and Win 2000 for a few > > weeks. > > > > > I've now set up a Linux machine (Mandrake 8.1 on Dell laptop) and > have > > > > moved > > > > > my files across. > > > > > > > > > > I use an include file which logs on to the MySQL server and then > > > connects > > > > to > > > > > the database. It performs the login ok but not the select db part. > > > > > > > > > > I tried creating a db using a php script and then selecting it and > got > > > the > > > > > same problem. > > > > > > > > > > I'm new on Linux so it might be something in the configuration which > > > needs > > > > > working on. > > > > > > > > > > Any suggestions? > > > > > > > > Well, if you had posted some code, someone might have seen the > error... > > > :( > > > > > > > > Anyway, here is how i do it: > > > > > > > > if($db = mysql_pconnect($dbhost, $dbuser, $dbpasswd)){ > > > > mysql_select_db($dbname, $db); > > > > } else { > > > > echo mysql_error(); > > > > exit; > > > > } > > > > > > > > > ------------------------------------------------------------------------ > > > > Greg Donald - http://destiney.com/ > > > > http://phprated.com/ | > > > > http://phplinks.org/ | http://phptopsites.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 > > > > > > -- > > > 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 > > > -- > 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