MySQL errors on slack server.

caged · 10-29-2004, 08:53 AM

Hi im having some problems copying my web pages over from my windows with php-triad computer to my slackware computer running the same three programs but not all pre-config-d. the problem (this time) is with sql.
MySQL is having problems on the slackware machine that its not having on the windows comp i made the pages on.

I copied the databases across using phpmyadmin and i can see the database there and export it from there to.

the error mysql is spitting at me on the slackware comp is:

Code:

Warning: mysql_fetch_array(): supplied argument is not a 
valid MySQL result resource in /var/www/htdocs/blah/scan.inc on line 9

im not really sure where to start looking can anybody tell me what this error suggests?

cheers,
Ben.

Mara · 10-29-2004, 01:08 PM

What's the command you're trying to run?

caged · 10-29-2004, 11:41 PM

sure.

Code:

  <?
  {
  $db = mysql_connect("localhost", "changed", "changed");
  mysql_select_db("maindb",$db);
  $ip = getenv("REMOTE_ADDR");
  if($loginName){

    $result = mysql_query("SELECT * FROM users",$db);
->  if ($myrow = mysql_fetch_array($result)) {
        do {

cheers.

Mara · 10-30-2004, 07:05 AM

It looks absolutely OK. Maybe check the value of $result after mysql_query(), but it should be correct. Or...not?

m_shroom · 10-30-2004, 10:37 PM

For debuging you should add to your code, in case your not connecting

PHP Code:



 $db = mysql_connect("localhost", "changed", "changed") or die ("can not connect to server"); 
  mysql_select_db("maindb",$db) or die ("can not select DB") ;