RE: [PHP-DB] PHP and msql Error

Hi With MySql that means that there is no result returned. Usually SQL error, but could be a setup problem if you have not run any queries succesfuly. Not sure if the same applies to MSql, but try echoing the error, echo msql_error($conn) (if it is the same as MySql) HTH Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net info@sunmaia.net tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: comp boy [mailto:compboy80@hotmail.com] > Sent: 26 June 2002 20:09 > To: php-install@lists.php.net; php-db@lists.php.net > Subject: [PHP-DB] PHP and msql Error > > > I am getting the following error: > > Warning: Supplied argument is not a valid mSQL result resource in > /usr/local/apache/htdocs/inc/listings.inc on line 24 > > listings.inc: 24 > $numRows = msql_numrows( $result ); > > The manual on php.net says that it takes no variables msql_numrows(void) > however it says it is another version of msql_num_rows(int msql); > > The code I am trying to run, runs perfectly fine on another one of our > systems. I was just setting up a development server and now I am getting > this problem. The specs are the same except for the version of Apache > production is 1.3.9 and development is 1.3.26 > > PHP vesrion 4.1.2 > > ./msqladmin version > Version Details :- > msqladmin version 2.0.11 > mSQL server version 2.0.11 > mSQL protocol version 23 > mSQL connection Localhost via UNIX socket > Target platform Linux-2.2.14-5.0-i686 > > PHP was configured: > ./configure --with-apxs=/usr/local/apache/bin/apxs --with-msql > > msql was a default install. > > Does anyone know what I did wrong? Do I need to recompile with some > different options? > > TIA > Jason > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >