Posted by Jerry Stuckle on 04/03/06 15:46

Dejan wrote:
> Hi
>
> Sorry for my terreble english.
>
> On my local (win) comp i have apache+mysql+php 4.05
> I'm counting rows using mysql_num_rows function, and everything works fine.
> When i upload php file on server it says:
>
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
> resource in /home/optikara/public_html/crosun/izn/insert_form.php on line 80
> Server runs php 5.0.5
>
> Code is:
> --------------------------
> //connect to database code goes here
>
> $result_v_smjestaj = mysql_query("select * from v_smjestaja order by
> v_smjestaja_naziv ASC", $db);
> // some other html code goes here
>
> if (mysql_num_rows($result_v_smjestaj)) {
> print "<select name=\"v_smjestaja\">\n";
> while ($qry = mysql_fetch_array($result_v_smjestaj)) {
> print "<option
> value=\"$qry[id_smjestaja]\">$qry[v_smjestaja_naziv]</option>";
> }
> print "</select>\n";
> }
> --------------------------
>
> On my local comp this works. Plz any solution, in plain simple code:)))
> tnx in advance.
> Dejan
>
>
>

1. Always check the result from mysql_query (and all similar mysql_ calls).
2. When it fails, check the error message with mysql_error().

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]