count query rows (probally simple)

count rows if number =1 cancel some script

[Twisted Mind]

Hey i have this page where u can add some kind of users

i want it to look up if the same email adress is already in list so it would be like
Query select email from mytable where email= $_postemail
countrows = blahblah

if blah blah!= >0{
postitintable

}

so in this script you wont keep sending them when u press refresh...

its all on 1 page grtz

[arran]

mysql_num_rows() [us3.php.net]

Alternatively, you could count in the SQL:

select count(email) from mytable where email = '$_postemail'

arran.

[Twisted Mind]

k ill try that

[Twisted Mind]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Fluke_Mambo\administrator\components\com_managers\defaultpage.php on line 14

this is query:

$result = mysql_query("Select * FROM mos_managers WHERE Manager = $v2");
$rows = mysql_num_rows($result);
echo $rows;

[arran]

If Manager is a (var)char, you'll need to quote it:

SELECT * FROM mos_managers WHERE Manager = '$v2'

[Twisted Mind]

ah a new thing learned :)

[Twisted Mind]

works like a charm thanks guys ^^