PHP - Pick An Item From Database Based On A Number

I have five names in an array and also numbers 5,2,1,3 and what i want to do is php to look at the numbers and print out the name that corresponds to the number.

so for my example the name it should echo out is 'Lee'

 

 $names = array ("Stan", "John", "Dean", "Sam", "Lee");

here are the five names.

The idea is to learn php with making a little fixture list with these five names.

The problem i have is to make php read the number and then look up the array for the name that corresponds to the number.

I hope this explains what I would like to do?

 

Hey,

I have an array which stores a bunch of numbers lets say:
Code: [Select]
[0] = 1[1] = 6
Now a second array has:
Code: [Select]
[0] = 5 [1] = 6
What im trying to do - is find the first highest number from the second array that is not found in the first array.Both arrays are sorted already by the way using sort().

What is the best way to do this?

I Have the following issue and I spend my whole day looking for it.

I have a database with a simple admin where I add/delete values.

The database structure is the following:

id, zip, email
The database is called zipdatabase

Here is the mailing part:

Code: [Select]
//headers
$headers = "From: <$Email>";
$headers .= "\r\nBcc: <$Bcc>\r\n\r\n";

// send email
$success = mail($EmailTo, $Subject, $Body, $headers);The variable $Bcc must come from the database. I am really ignorant so I only got to a point on how to echo the results I need (and this works):
Code: [Select]
$query  = "SELECT email FROM zipdatabase WHERE zip = '$ZIP'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
   echo "{$r['email']}, ";
}
?>
For a zip I get more than one result so when I tried using this

Code: [Select]
$query  = "SELECT email FROM zipdatabase WHERE zip = '$ZIP'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
   $Bcc = "{$r['email']}, ";
}
echo "Bcc"
?>
It only gives me one result.

What I noticed is I have 2 issues:
- I can't extract the BCC from the database
- I don't know how to add more email addresses to the bcc field, I only managed to add more addresses to the $Emailto like:
Code: [Select]
$EmailTo = "address1@domain.com, address2@domain.com";
$Bcc = "address3@domain.com";
All these variables are defined by a webform and it works flawlessly except the database problem:

Code: [Select]
$Name = Trim(stripslashes($_POST['Name']));
$Phone = Trim(stripslashes($_POST['Phone']));
$ZIP = Trim(stripslashes($_POST['ZIP']));
$Email = Trim(stripslashes($_POST['Email']));
$Message = Trim(stripslashes($_POST['Message']));

// validation
$validationOK=true;
if (!$validationOK) {
  print "<meta http-equiv=\"refresh\" content=\"0;URL=contacterror.htm\">";
  exit;
}

// prepare email body text
$Body = "";
$Body .= "Name: ";
$Body .= $Name;
$Body .= "\n";
$Body .= "Phone: ";
$Body .= $Phone;
$Body .= "\n";
$Body .= "ZIP: ";
$Body .= $ZIP;
$Body .= "\n";
$Body .= "Email: ";
$Body .= $Email;
$Body .= "\n";
$Body .= "Message: ";
$Body .= $Message;
$Body .= "\n";

Sorry for my ignorance and hope someone here can help.
The webform works perfectly except the bcc from the database part.

I have somewhat of a dilemma.

When someone clicks on a Buy Now button and subsequently follows necessary steps to complete process of purchase, when that transaction is completed, in my product table, I want to subtract 1 from whatever value is in the field.

E.g. say product one is being purchased, prior to purchase in product table, there are 5 product one's in stock, when purchase is complete, subtract 1 from 5 (to get 4).

Here is my code

Code: [Select]
<?php

$title = "Like This Product, Buy It NOW!!!";

require ('includes/config.inc.php');

include ('./includes/header.html');

require (MYSQL);

include ('./includes/main.html');

if($id = isset($_GET['prodID']))
{
$query = "SELECT `prodID`, `product`, `prod_descr`, `image`, `price` FROM product WHERE `prodID`='{$_GET['prodID']}'";
$r = mysqli_query($dbc, $query);

$showHeader = true;
echo "<div id='right'>";

while($row = mysqli_fetch_array($r))
{
if($showHeader)
{
            //Display category header
echo "<h1>" . "<span>" . "# " . "</span>" . $row['product'] .  "<span>" . " #" . "</span>" . "</h1>";

echo "<div id='item'>"; // div class 'item'

echo "<div class='item_left'>";

echo "<p id='p_desc'>";
echo $row['prod_descr'];
echo "</p>";

echo "<p>" . "<span>" . "&pound" . $row['price'] . "</span>" . "</p>";

echo "</div>";

echo "<div class='item_right'>";

echo "<img src='db/images/".$row['image']."' />";
$showHeader = false;

echo "</div>";

?>

<p>
<form target="paypal" action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="7UCL9YCYYXL3J">
<input type="hidden" name="item_name" value="<?php echo $row['product']; ?>">
<input type="hidden" name="item_number" value="<?php echo $row['prodID']; ?>">
<input type="hidden" name="amount" value="<?php echo $row['price']; ?>">
<input type="hidden" name="currency_code" value="GBP">
<input type="image" src="https://www.sandbox.paypal.com/en_US/i/btn/btn_cart_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.sandbox.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>
</p>

<p>
<form name="_xclick" action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="me@mybusiness.com">
<input type="hidden" name="currency_code" value="GBP">
<input type="hidden" name="item_name" value="<?php echo $row['product']; ?>">
<input type="hidden" name="amount" value="<?php echo $row['price']; ?>">
<input type="image" src="http://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
</form>
</p>

<?php 

echo "</div>"; // End of div class 'item'

$strSQL = "SELECT prodID, product, price, image FROM product ORDER BY RAND() LIMIT 1";  
$objQuery = mysqli_query($dbc, $strSQL) or die ("Error Query [".$strSQL."]");

while($objResult = mysqli_fetch_array($objQuery))  
{ 
echo "<div class='love'>";
echo "<h6>Like this......you'll love this!!!</h6>";
echo "<ul>";
echo "<li>" . "<img src='db/images/" . $objResult['image'] . "' width='50' height='50' />" . "</li>";
echo "<br />";
echo "<li>" . "<a href='item.php?prodID={$objResult['prodID']}' title='{$objResult['product']}'>" . $objResult['product'] . "</a>" . " - " . "&pound" . $objResult['price'] . "</li>";
echo "</ul>";
echo "</div>";
}

}
}

?>

<?php

echo "</div>";

}

include ('./includes/footer.html');

?>

How is this achievable please?

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=354366.0