Simple Solution Please

[samgeorge]

<?php 
$user = $HTTP_POST_VARS['Player1'];

mysql_select_db($database_ktcsc, $ktcsc);
$query_Selector = "SELECT UNID, Name, Email, Telephone FROM HockeyMembers WHERE `UNID` = '$user'";
$Selector = mysql_query($query_Selector, $ktcsc) or die(mysql_error());
$row_Selector = mysql_fetch_assoc($Selector);
$totalRows_Selector = mysql_num_rows($Selector);
?>

<?php if($row_Selector['Email'] != "") { ?>
<?php
$email = $row_Selector['Email'];
$subject = "Hello";
$mailMessage = "Example Email";
mail($email,$subject,$mailMessage,"Wrom: UNNYCGPKYLEJGDGVCJ
echo 'Mail Sent To '.$row_Selector['Name'].'.';
?>
<?php } ?>
<?php if($row_Selector['Email'] == "") { ?>
<?php echo $row_Selector['Name']; ?> Has No Email Please Ring For Confirmation on <?php echo $row_Selector['Telephone']; ?>
<?php } ?>

i ma using this to send a mail to a selected member if they have been select to play at the weekend. (end of crap)

How? can i crteate this script to loop 16 times changing the

$user = $HTTP_POST_VARS['Player1'];

to 2,3,4,5,6,7,8,9,10 etc

[bubblenut]

<?php 
for($i=1;$i<11;$i++) {
$user = $HTTP_POST_VARS['Player'.$i];

mysql_select_db($database_ktcsc, $ktcsc);
$query_Selector = "SELECT UNID, Name, Email, Telephone FROM HockeyMembers WHERE `UNID` = '$user'";
$Selector = mysql_query($query_Selector, $ktcsc) or die(mysql_error());
$row_Selector = mysql_fetch_assoc($Selector);
$totalRows_Selector = mysql_num_rows($Selector);
?>

<?php if($row_Selector['Email'] != "") { ?>
<?php
$email = $row_Selector['Email'];
$subject = "Hello";
$mailMessage = "Example Email";
mail($email,$subject,$mailMessage,"Wrom: UNNYCGPKYLEJGDGVCJ
echo 'Mail Sent To '.$row_Selector['Name'].'.';
?>
<?php } ?>
<?php if($row_Selector['Email'] == "") { ?>
<?php echo $row_Selector['Name']; ?> Has No Email Please Ring For Confirmation on <?php echo $row_Selector['Telephone']; ?>
<?php }} ?> 

HTH
Bubble

[philipolson]

Assuming you may not always have 16 user post values, and that you want this to be dynamic and beautiful... consider the following tips:

a) Use an array in your form for the player value. Example:

<input type="text" name="players[]">
<input type="text" name="players[]">
<input type="text" name="players[]">

This way you will have an array full of player values and won't have to guess or worry about one at a time.

b) Once submitted, you can do:

// Simply make sure it's an array, and that some players exist
if (is_array($_POST['players']) && count($_POST['players']) > 0) {
// A simply loop example
foreach ($_POST['players'] as $player) {
    print "Player #$player";
}

c) Use one MySQL query using the IN statement to select all the users and their information. The following queries are identical:

$sql = "SELECT foo FROM bar WHERE id = 1 OR id = 2 OR id = 3";
$sql = "SELECT foo FROM bar WHERE id IN (1,2,3)";

So you could dynamically create this with your new players array:

$query_Selector = "SELECT UNID, Name, Email, Telephone 
    FROM HockeyMembers 
    WHERE UNID IN (" . explode(",", $_POST['players']) . ")";