What function are you calling on $result when it returns the error?
Try doing this, all in one place:
$db = mysql_connect("localhost", "username");
mysql_select_db("subsurface_net", $db);
$result = mysql_query("SELECT * FROM customer_genre", $db);
echo mysql_num_rows($result);
When you use a SELECT query the function "mysql_affected_rows" is not valid.
When using an UPDATE, INSERT, or DELETE query, "mysql_num_rows" is invalid.
That may be your problem, because the code you paste in seems not to have
anything wrong with it.
--
Plutarck
Should be working on something...
...but forgot what it was.
""Andrew Durk"" <[EMAIL PROTECTED]> wrote in message
9b9n47$7ej$[EMAIL PROTECTED]">news:9b9n47$7ej$[EMAIL PROTECTED]...
> I can get connected to my host's MySQL database w/o error, but I cannot
seem
> to do anything after that.
>
> I do:
> $db = mysql_connect("localhost", "username");
> mysql_select_db("subsurface_net",$db);
>
> No problem, but if I do this:
> $result = mysql_query("SELECT * FROM customer_genre",$db);
>
> I eventually get:
> Warning: 0 is not a MySQL result index in /test.phtml on line 35
>
> And customer_genre _is_ a table in my database...
>
> Help, anyone!?
> --
> Andrew Durk
> [EMAIL PROTECTED]
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
