check

[interactive]

how do i check to make sure a row doesn't exist before i insert it?

[Anon]

you want to insert a row that doesn't exist?

[interactive]

well i want to insert a row i know how to do that but i need to know how you check it first to make sure it doesn't exist already for instance...im running a userdb and a user will fill out a form and then click next and it will send the data to a php file which will inster it but first it will check to make sure a row doesn't exist if it does then send a error back and cancel inserting it thanx

[Anon]

Assuming that the username is unique in the system, run a query and check the result / rows returned.

If this is mysql - the following should work:

$result=mysql_query($query);
$rows = mysql_num_rows($result);

if ((!$result) || ($rows<1)) {
/ User does not exist /

}
else {
/ Username returned /

}

Hope it helps.

-m.

[Anon]

$row=mysql_fetch_row(mysql_query("SELECT COUNT(*) FROM Table WHERE data=$user_submitted_data"));
if($row[0])
{
// ok, insert the data
}
else
{
// data already in there, yell at the user
}

That help any?

[Anon]

Correction:

$row=mysql_fetch_row(mysql_query("SELECT COUNT(*) FROM Table WHERE data=$user_submitted_data"));
if(!$row[0])
{
// ok, insert the data
}
else
{
// data already in there, yell at the user
}

[interactive]

y'all rule omg im starting to sound like a texan ahh rofl jk...you guys are the bomb thanx that worked a wonder...have a good day