mysql_num_rows stops script

[ratcateme]

i am making a registration script but when it gets to the mysql_num_rows command it stops. here is my code

<?php
if (isset($_REQUEST['user']) && !empty($_REQUEST['user']) && isset($_REQUEST['pass']) && !empty($_REQUEST['pass']) && isset($_REQUEST['name']) && !empty($_REQUEST['name'])) {
$con = mysql_connect('', '', '') or die(mysql_error($con));
mysql_select_db('mail', $con) or die(mysql_error($con));
$user = mysql_real_escape_string($_REQUEST['user'], $con);
$query = "SELECT * FROM `users` WHERE `user` = '{$user}'";
$result = mysql_query($query, $con) or die(mysql_error($con));
echo "test1";
$count = mysql_num_rows($result) or die(mysql_error($con));
        echo "test2";

all that gets outputted on my screen is "test1" when i should get "test1test2". any ideas i have made scripts like this before no problem i just cant see a problem.

 

Scott.

[cooldude832]

take the or die() off the mysql_num_rows() its only really needed on the query because if they query is valid and it of select nature mysql_num_rows is valid to work on said query resource

[uniflare]

have a look in the error log file in apache and also try putting a @ symbol in front of the function.

 

dont keep the @ symbol though, you shud never really need them, or use them

[ratcateme]

thanks cooldude832 i removed the or die and it works now.

 

Scott.