<div>
Use mysql_num_rows<br />
<br />
<a href="http://se.php.net/mysql_num_rows" rel="ugc">http://se.php.net/mysql_num_rows</a><br />
<br />

<pre><code id="code-192786">if(mysql_num_rows($result) &gt; 0){
//Record exists
}
else{
//No record with that id exists
}
</code></pre>
</div>


Use mysql_num_rows

http://se.php.net/mysql_num_rows [http://se.php.net/mysql_num_rows]



if(mysql_num_rows($result) > 0){
//Record exists
}
else{
//No record with that id exists
}


<div>
many thanks, seems to work!
</div>


<div>
<div class="content wysiwyg-content">
Hi, I am starting to use a recordExists Function (shown below) to check for existing records in a database before adding a new one. Could someone help me out with the correct way in using this:<br />
<br />
I tried the following but it didn't seem to work:<br />
<br />
recordExists(fld_email,$em<wbr />ail,tbl_us<wbr />ers,$db);<br />
if (recordExists == &quot;1&quot;);<br />
else<br />
{<br />
//stuff here<br />
}<br />

<pre><code id="code-192775">&lt;?
function recordExists($id,$idval,$table,$db) {//check for id=idval in table and return TRUE or FALSE
$result = mysql_query(&quot;SELECT * FROM &quot;.$table.&quot; WHERE &quot;.$id.&quot;='&quot;.$idval.&quot;'&quot;, $db) or die(mysql_error());
if($row = mysql_fetch_array($result)) {//if we did return a record
return 1;
}//end if row
return 0;
}//end function recordExists
?&gt;
</code></pre>
</div>
</div>


Hi, I am starting to use a recordExists Function (shown below) to check for existing records in a database before adding a new one. Could someone help me out with the correct way in using this:

I tried the following but it didn't seem to work:

recordExists(fld_email,$email,tbl_users,$db);
if (recordExists == "1");
else
{
//stuff here
}

recordExists Function - correct use

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.