Re: php/mysql error

I think you can get this error when you sql query fails. Try copy and pasting the $sql query to the mysql command line and see what response you get (it looks as though this would work though unless you haven't got a table called "test"). I guess it might be that you are not successfully logging on (although I can't recall whether that would then generate this error when you try and issue a query or not). You should set up a "die" error path as well to help you see if you fail to log in. -torrent "Jon" <jons@dotnet.com> wrote in message news:Usenet.ipsiitnr@localhost... > please review my script > > I have already had it said that the script is fine, please check. IF > it is then I have a set up proiblem which I would also like help to > solve. BUT mysql outside of apache works fine. > > I started with an already set up apache so I don't know if mysql was > installed in right, but the staements before the error seem to work so > I would think so. > > I running my web server under red hat 7.0, I am new to apache/php and > mysql. > > Thanks > > ---------------------------- > > I get an error when it hits the line > > while ($row = mysql_fetch_row($rs)) {} > > I know it won't do anything, just checking each command. > > For a moment I thought this means that the mysql wan't compiled in but - > then how comes the other mysql_ statements don't error. > > anyway the error I get is this > Supplied argument is not a valid MySQL result resource ....... > > Now I am a C++ programmer so I am estimating here, it sounds like $row - > is wrong, do I need to set this up as an array (I believe that is what - > it is supposed to be) > > The $rs is right I am pretty sure and the command should do what I want- > it to do. > > > > >