| | |
| | | if ($_GET['_cid']) |
| | | { |
| | | $DB->query("UPDATE ".get_table_name('contacts')." |
| | | SET del='1' |
| | | SET del=1 |
| | | WHERE user_id=? |
| | | AND contact_id IN (".$_GET['_cid'].")", |
| | | $_SESSION['user_id']); |
| | |
| | | // count contacts for this user |
| | | $sql_result = $DB->query("SELECT COUNT(contact_id) AS rows |
| | | FROM ".get_table_name('contacts')." |
| | | WHERE del<>'1' |
| | | WHERE del<>1 |
| | | AND user_id=?", |
| | | $_SESSION['user_id']); |
| | | |
| | |
| | | |
| | | // get contacts from DB |
| | | $sql_result = $DB->limitquery("SELECT * FROM ".get_table_name('contacts')." |
| | | WHERE del<>'1' |
| | | WHERE del<>1 |
| | | AND user_id=? |
| | | ORDER BY name", |
| | | $start_row, |