Posted by Phillip Oertel on 10/24/05 20:49

hi mario,

first of all, make sure that your query works from the mysql console or
phpmyadmin or some other tool (copy-paste the query from the code and
replace $loging with something reasonable).

then try the following:

$query = "SELECT COUNT (login) FROM formacao WHERE login = '$login'";

// check to see if the $login variable has been filled in -
// maybe $login is empty?
echo $query;

$result = mysql_query($query);

if (!$result) {
// mysql will tell you what's wrong
echo mysql_error();
}

mysql_fetch_row($result);

and btw. mysql_fetch_row() doesn't require a connection resource, it
will default to the last opened when none is given.
so you only need to give the 2nd parameter if you have more than one
mysql-db connection open.

regards,
phillip

---

Mário Gamito schrieb:
> Hi,
>
> Why this doesn't work ?
>
> ---
> $query = "SELECT COUNT (login) FROM WHERE login = '$login'";
> $result = mysql_query($query);
> mysql_fetch_row($result);
> ---
>
> It gives me
> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL
> result resource in /var/www/html/registar_action.php on line 22
>
> Any help would be apreciated.
>
> Warm Regards,
> Mário Gamito

[Back to original message]