I am trying to use the following code to do so but it isn't working at all. It still prints the full list.
Code: Select all
$query = "SELECT * FROM scml_contacts WHERE NOT address='' AND user_group='".$_SESSION['group']."' ORDER BY lastname ASC";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$needle= $row['first'].','.$row['last'].',';
$pos = strpos($labeldata,$needle);
if($pos == false) {
$labeldata = $row['id'].','.$row['firstname'].','.$row['lastname'].','.$row['nickname'].','.$row['address'].','.$row['zipcode'].','.$row['city'].','.$row['country'].','.$row['web'].','.$row['mail'].','.$row['icq'].','.$row['msn'].','.$row['ym'].','.$row['homephone'].','.$row['workphone'].','.$row['mobilephone'].','.$row['comments'].','.$row['user_group'].','.$row['state'].','.$row['day'].','.$row['month'].','.$row['year']."\n";
fwrite($fh, $labeldata);
}
}