I have this as a way to check that no duplication occurs on my database:


mysql_connect ('online.ulst.ac.uk', 'ltsn','ics' );
$sql_email_check = mysql_query("SELECT email FROM italics WHERE email='$email'");

$email_check = mysql_num_rows($sql_email_check);

if(($email_check > 0)){
$error12 = '<font face="Tahoma">Please fix the following errors: <br />';
$error2c = 1;
if($email_check > 0){
$email2 = '<font face="Tahoma"><font color="#FF0000"><strong>Your email address has already been used by another member in our database. Please submit a different Email address!<br /><br />';
$email2c = 1;
unset($email);
}
exit(); // exit the script so that we do not create this account!
}



but it's coughing up this instead:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web2/ltsn-ics/pub/italics/register.php on line 142

First add and "or die" to your query to make sure that you're successfully connecting to the database

PHP Code:

mysql_query("SELECT email FROM italics WHERE email='$email'") or die(mysql_error()); 


Make sure that the email address is being properly assigned to $email

this probably sounds well stupid but it says "no database selected"

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web2/ltsn-ics/pub/italics/register.php on line 142

what i'm working with is one table (italics) in a big database called ltsn and i'm targetting the column email for counting- do i have the select query all wrong?

Why do people put die?????? You could always try 'exit', it works just as well. DIE DIE DIE. Scary.....lol.



mik

Originally Posted by coalduststar

this probably sounds well stupid but it says "no database selected"

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web2/ltsn-ics/pub/italics/register.php on line 142

what i'm working with is one table (italics) in a big database called ltsn and i'm targetting the column email for counting- do i have the select query all wrong?

You connect to the server fine but never use mysql_select_db() to pick which db your going to be using.

ok here we go the whole thing is working except now it doesn't update the database

so it's all backwards now- what am I doing?!?! or not doing?!

by the way- thanks to everyone who's helped me so far- silly mistakes! but this last one's just as annoying- any guesses?