[SOLVED] contact all

[dare87]

Right now I have a statement that will pull all the emails from my table users. I was wondering if there is an easy way to do an all and have the spearated by a comma. aka

name1, name2, name3, ...... so on

 

<select class="required" name="emails">
<option value="NAME1, NAME, NAME3, BLAH BLAH BLAH">ALL</option>';
// Retrieve all the names and add them to the pull-down menu.
require_once('../../pimysql_connect.php');
$query = "SELECT txt, first FROM users WHERE txt IS NOT NULL ORDER BY name ASC";
$results = @mysql_query ($query);
while ($row = mysql_fetch_array ($results, MYSQL_NUM))
echo '<option value="' . $row[0] . '">' . $row[1] . '</option>\n';
echo '</select>';

[darkfreaks]

<?php implode(",", $row);?>

[dare87]

that really doesn't help me... I don't understand what it does or where to put it.

 

But Thanks... any other ideas?

[discomatt]

The easier way to do this would be to just use an option like this:

 

<option value="ALL_ENTRIES">ALL</option>'

 

Then do something like this

 

<?php

if ($_POST['emails'] == 'ALL_ENTRIES')
  $where = '1=1'; // selects all users
elseif ( * validate/sanitize $_POST['emails'] to prevent injection * )
  $where = '`txt` = \''.$_POST['emails'].'\' LIMIT 1'; // selects a specific user

$query = 'SELECT `first`, `email` FROM `users` WHERE ' . $where;


?>

[dare87]

I don't see where the comma gets put in?

[maexus]

http://us.php.net/implode

 

Read this.