php/mysql error
| From: | jon | Date: | Tue, 20 Nov 2001 17:10:28 +0000 |
| Subject: | php/mysql error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14473@lists.php.net to get a copy of this message | ||
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.
begin 644 test2.php
M/&AT;6P^/&)O9'D^"CP_"F5C:&\@)W1E<W1I;F<@=&AE(&UY<W%L(&-O;FYE
M8W1I;VXG.PIE8VAO(#L*)'-E<G9E<CTG,3DR+C$V."XQ+C0G.PHD=7-E<CTD
M<'<])R<["B1D8CTG<75I8VMT97-T)SL*)'-Q;#TG4T5,14-4H"J@1E)/3:!T
M97-T)SL*;7ES<6Q?8V]N;F5C="@D<V5R=F5R+"1U<V5R+"1P=RD["FUY<W%L
M7W-E;&5C=%]D8B@D9&(I.PHD<G,];7ES<6Q?<75E<GDH)'-Q;"D["G=H:6QE
M("@D<F]W(#T@;7ES<6Q?9F5T8VA?<F]W*"1R<RDI('M]"C\^"CPO8F]D>3X\
'+VAT;6P^"CT@
`
end