Help with simple query

Discussion in 'PHP' started by frobak, Feb 14, 2012.

  1. #1
    I need help with a simple query, brain is dead today and cant work it out.

    Basically im querying the db for a list of usernames (which are email addresses)

    I then need to get all the found udernames into a variable, which i can then add to my email 'To' variable

    This doesnt work?

    
    $result3 = @mysql_query($sql3,$connection) 
    	or die(mysql_error());
    
    while ($row = mysql_fetch_array($result3)) {  
    $addresses= $row['username'];   
    };  
    
    PHP:
    Any helpers?
     
    frobak, Feb 14, 2012 IP
  2. EricBruggema

    EricBruggema Well-Known Member

    Messages:
    1,740
    Likes Received:
    28
    Best Answers:
    13
    Trophy Points:
    175
    #2
    $saveEmails = $saveEmails .= ';' . $list['username'];

    or something!
     
    EricBruggema, Feb 14, 2012 IP
  3. HuggyEssex

    HuggyEssex Member

    Messages:
    297
    Likes Received:
    4
    Best Answers:
    2
    Trophy Points:
    45
    #3
    
    $result3 = @mysql_query($sql3,$connection) 
        or die(mysql_error());
    $addresses = '';
    while ($row = mysql_fetch_array($result3)) {  
    $addresses .=  $row['username'].';';   
    }
    
    PHP:
    That should work :)
     
    HuggyEssex, Feb 14, 2012 IP
    adityamenon likes this.