Code: Select all
select `org_id` from `table_name` where `person_id` = '$person_id' && `orgname` = '$orgname' && `web_url` = '$web_url' && `notes` = '$notes'atleast one Of The person_id, orgname, web_url, notes is/are Unique Fields
Moderator: General Moderators
Code: Select all
select `org_id` from `table_name` where `person_id` = '$person_id' && `orgname` = '$orgname' && `web_url` = '$web_url' && `notes` = '$notes'Code: Select all
$sql = "INSERT INTO organisations (org_id,person_id, orgname, web_url, notes ) VALUES ('$org_id','$person_id','$orgname','$web_url', '$notes')";Code: Select all
SELECT `org_id` FROM `table_name` WHERE `person_id` = '$person_id' && `orgname` = '$orgname' && `web_url` = '$web_url' && `notes` = '$notes'