Code: Select all
mysql_query("IF NOT EXISTS (INSERT INTO users (firstName, lastName, id2, gender) VALUES ('Nick', 'AAAA', '4', 'm')) ELSE (UPDATE users SET firstName='Nick', lastName='AAAA', id2='4', gender='m' WHERE ID='4')") or die (mysql_error());
//or
mysql_query("IF EXISTS (UPDATE users SET firstName='Nick', lastName='AAAA', id2='4', gender='m' WHERE ID='4') ELSE (INSERT INTO users (firstName, lastName, id2, gender) VALUES ('Nick', 'AAAA', '4', 'm'))") or die (mysql_error());