cbielich
asked on
INSERT IGNORE SQL STATEMENT mysql php
When using a statement like INSERT IGNORE INTO table VALUES ('1','2','3') in php
How can I determine if the record was inserted or ignored?
for instance when I want to know if a sql statement executed correctly I would use something like
if ($sql) {
echo "ok";
} else {
echo "Not ok";
}
but since the sql statement executes correctly whether it is skipped or ignored how can I differentiate the two?
How can I determine if the record was inserted or ignored?
for instance when I want to know if a sql statement executed correctly I would use something like
if ($sql) {
echo "ok";
} else {
echo "Not ok";
}
but since the sql statement executes correctly whether it is skipped or ignored how can I differentiate the two?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.