| | |
| | | //$image_tag = '<img src="%s%s" alt="%s" border="0" />'; |
| | | |
| | | // count contacts for this user |
| | | $sql_result = $DB->query(sprintf("SELECT COUNT(contact_id) AS rows |
| | | FROM %s |
| | | WHERE del!='1' |
| | | AND user_id=%d", |
| | | get_table_name('contacts'), |
| | | $_SESSION['user_id'])); |
| | | $sql_result = $DB->query("SELECT COUNT(contact_id) AS rows |
| | | FROM ".get_table_name('contacts')." |
| | | WHERE del<>'1' |
| | | AND user_id=?", |
| | | $_SESSION['user_id']); |
| | | |
| | | $sql_arr = $DB->fetch_assoc($sql_result); |
| | | $rowcount = $sql_arr['rows']; |
| | |
| | | $start_row = ($CONTACTS_LIST['page']-1) * $CONFIG['pagesize']; |
| | | |
| | | // get contacts from DB |
| | | $sql_result = $DB->query(sprintf("SELECT * FROM %s |
| | | WHERE del!='1' |
| | | AND user_id=%d |
| | | ORDER BY name", |
| | | get_table_name('contacts'), |
| | | $_SESSION['user_id']), |
| | | $start_row, |
| | | $CONFIG['pagesize']); |
| | | $sql_result = $DB->limitquery("SELECT * FROM ".get_table_name('contacts')." |
| | | WHERE del<>'1' |
| | | AND user_id= ? |
| | | ORDER BY name", |
| | | $start_row, |
| | | $CONFIG['pagesize'], |
| | | $_SESSION['user_id']); |
| | | } |
| | | else |
| | | $sql_result = NULL; |
| | |
| | | // get nr of contacts |
| | | if ($max===NULL) |
| | | { |
| | | $sql_result = $DB->query(sprintf("SELECT 1 FROM %s |
| | | WHERE del!='1' |
| | | AND user_id=%d", |
| | | get_table_name('contacts'), |
| | | $_SESSION['user_id'])); |
| | | $sql_result = $DB->query("SELECT 1 FROM ".get_table_name('contacts')." |
| | | WHERE del<>'1' |
| | | AND user_id=?", |
| | | $_SESSION['user_id']); |
| | | |
| | | $max = $DB->num_rows($sql_result); |
| | | } |