PHP Check for Record Exists

[mahmud]

Hi,

I have tried to get some PHP code to check if a record exists before posting to a table, followed another example, but it posts even when it is not supposed to; when $rcount <> NULL. The code:

Code: Select all

function CheckRowSave(){
    $sqlCheckRow =  "SELECT COUNT(*) FROM hrectemp
JOIN hrecord ON hrecord_classid = '#RECORD_ID#' AND hrecord_date = hrectemp_date;" ;
nuRunQuery($sqlCheckRow);
$rcount = mysqli_num_rows($sqlCheckRow);
    nuDebug($rcount); //This will place the SQL query into the zzzsys_debug table for viewing.
    if (empty($rcount)) {
    savehrec();
    }
}

What am I doing wrong please?

[mahmud]

Forgot to mention, this is in the "Before Save" window of a form.

[admin]

mahmud,

You might be better off doing something simpler like this..

Code: Select all

if('#this_field#' == ''){
   nuDisplayError("This Field cannot be left blank..");
}

If there are any error messages a record will not be updated or deleted.

http://wiki.nubuilder.net/index.php/PHP ... message.29

Here is more about where you can use hash variables.

http://wiki.nubuilder.net/index.php/Hash_Variables

Steven

[mahmud]

Thanks for your response, but if you look at the code, I am trying to determine if a record already exists in a table so a user doesn't post it twice.

Mahmud

[admin]

Mahmud,

I have no idea what you are attempting to do in you code.

The point I was trying to make is if you want nuBuilderPro to not save a record, have it create an error message.

Steven