PHP - How To Make Sure Minimum Qty Has Been Selected

Hi all.   how can i make the values show like a list. I tried html line break "<br>" and php \n but all to no avail. It just show all the values in one straigth line.   example of what i want is for the values to appear like this:   1234567890 0987654345 4567890675   instead of :   1234567890 0987654345 4567890675   Thanks

 
<form data-abide method="post" action="">
<div>
<select name="">
  <option value="name">
  <?php
$stmt = $pdo->query("SELECT acct_num FROM table order by id desc");
while ( $row = $stmt->fetch(PDO::FETCH_ASSOC) ) {
echo $row['acct_num'];
}
 
  ?>
</option>
</select>
</div>
<div>
    <label>New Password <small>required</small></label>
    <input type="password" name="password" id="password" required>
    <small class="error">New password is required and must be a string.</small>
</div>
<div>
    <label>Confirm New Password <small>required</small></label>
    <input type="password" name="password2" id="password2" required>
    <small class="error">Password must match.</small>
</div>
 

<input name="submit" type="submit" class="button small" value="Change Password">
</form>

Edited by Mr-Chidi, 13 November 2014 - 01:34 AM.

Hi

i need a bit of help. i have toner database which stores, the type, brand, colour, min, max stock. I just want to know if there is anyway of notifying the user when the toner reachs the min level, maybe highligh the row in red or something similar.

many thanks.

Here's the scenario....

A Customer clicks on a product on the product page, this will open up the page for the individual product.
In this example, it's a shirt.

The shirt is available in many sizes and colors.  The Minimum QTY for this product is : 12 .
The customer can select as many sizes and colors as they want, as long they select a total of 12 (all sizes + all colors = total).

After making their selections for this shirt, there is an "Add to Cart" button.

I would like to run a check to make sure that the total is equal to or greater than the minimum QTY.

Here is the form :
Code: [Select]
<?php
session_start();

require("db.php");
require("functions.php");

$validid = pf_validate_number($_GET['id'], "redirect", $config_basedir);

$prodsql = "SELECT * FROM products WHERE id = " . $_GET['id'] . ";";
$prodres = mysql_query($prodsql);
$numrows = mysql_num_rows($prodres);
$prodrow = mysql_fetch_assoc($prodres);

$prodcatsql = "SELECT * FROM categories WHERE id = " . $_GET['id'] . ";";
$prodcatres = mysql_query($prodcatsql);
$bulkcat = mysql_num_rows($prodcatres);

if($numrows == 0)
{
header("Location: " . $config_basedir);
}
else
{
if($_POST['submit'])
{
if(!$_SESSION['SESS_ORDERNUM'])
{
if($_SESSION['SESS_LOGGEDIN'])
{
$sql = "INSERT INTO orders(customer_id, registered, date) VALUES(" . $_SESSION['SESS_USERID'] . ", 1, NOW())";
mysql_query($sql);
session_register("SESS_ORDERNUM");
$_SESSION['SESS_ORDERNUM'] = mysql_insert_id();
}
else
{
$sql = "INSERT INTO orders(registered, date, session) VALUES(0, NOW(), '" . session_id() . "')";
mysql_query($sql);
session_register("SESS_ORDERNUM");
$_SESSION['SESS_ORDERNUM'] = mysql_insert_id();
}
}

foreach ($_POST as $name => $value) {
if (substr($name, 0, 4) == 'qty_' && $value != '' && is_numeric($value)) {
$arrOptions = explode('_', $name);

$sizeid = $arrOptions[1];
$colorid = $arrOptions[2];
$quantity = $value;

$itemsql = "INSERT INTO orderitems(order_id, product_id, size_id, color_id, quantity) VALUES (" . $_SESSION['SESS_ORDERNUM'] . ", " . $_GET['id'] . ", " . $sizeid . ", " . $colorid . ", " . $quantity . ")";
mysql_query($itemsql);
}
}

$totalprice = $prodrow['price'] * $_POST['amountBox'] ;

$updsql = "UPDATE orders SET total = total + " . $totalprice . " WHERE id = " . $_SESSION['SESS_ORDERNUM'] . ";";
mysql_query($updres);

header("Location: " . $config_basedir . "showcart.php");
}
else
{
require("header.php");
echo "<div id='adminhome'>";
echo "<form action='addtobasket.php?id=" . $_GET['id'] . "' method='POST'>";

echo "<table cellpadding='10' border='0'>";

echo "<tr>";
if(empty($prodrow['image2'])) {
echo "<td width='205'><img src='store-images/no-image-large.jpg' width='200' alt='" . $prodrow['name'] . "'>";
}
else
{
echo "<td width='205'>
<img src='store-images/" . $prodrow['image2'] . "' width='200' alt='" . $prodrow['name'] . "'>";
}
echo "</td>";

echo "<td>";
echo "<h1>";echo $prodrow['name'];echo "</h1>";
echo "<h2>";echo $prodrow['description'];echo "</h2>";
//echo "<pre>" . wordwrap( $prodrow['description'] , 30 ) . "</pre>";
echo "<p>";echo $prodrow['details'];echo "</p>";

echo "<br>";


if($bulkcat==0)
{
echo "<div id='bulk1'>";
echo "<table cellpadding='2' border='0'>";
echo "<tr>";
echo "<td>Quantity</td>";
echo "<td>12</td>";
echo "<td>24+</td>";
echo "<td>48+</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Price</td>";
echo "<td>$" . money_format('%i', $prodrow['price']) . "</td>";
echo "<td>$" . money_format('%i', $prodrow['price2']) . "</td>";
echo "<td>$" . money_format('%i', $prodrow['price3']) . "</td>";
echo "</tr>";
echo "</table>";
echo "</div>";

echo "<div id='bulk2'>";
echo "<table cellpadding='2' border='0'>";
echo "<tr>";
echo "<br><div align='center'><strong>For Sizes 2XL - 5XL</strong></div>";
echo "</tr>";
echo "<tr>";
echo "<td>Quantity</td>";
echo "<td>12</td>";
echo "<td>24+</td>";
echo "<td>48+</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Price</td>";
echo "<td>$" . money_format('%i', $prodrow['price4']) . "</td>";
echo "<td>$" . money_format('%i', $prodrow['price5']) . "</td>";
echo "<td>$" . money_format('%i', $prodrow['price6']) . "</td>";
echo "</tr>";
echo "</table>";
echo "</div>";
}
else
{
echo "<div id='bulk1'>";
echo "<table cellpadding='2' border='0'>";
echo "<tr>";
echo "<td>Quantity</td>";
echo "<td>12</td>";
echo "<td>24+</td>";
echo "<td>48+</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Price</td>";
echo "<td>$" . money_format('%i', $prodrow['price']) . "</td>";
echo "<td>$" . money_format('%i', $prodrow['price2']) . "</td>";
echo "<td>$" . money_format('%i', $prodrow['price3']) . "</td>";
echo "</tr>";
echo "</table>";
echo "</div>";
}




echo "</td>";
echo "</tr>";
echo "</table>";

echo '<div id="basketmatrix">';
echo '<table cellpadding="1" border="1">';
echo '<tr>';
echo '<td></td>';

$arrsizes = array();
$i = 0;
$result = mysql_query("SELECT DISTINCT s.id, s.size FROM sizes s INNER JOIN productoptions p ON s.id = p.sizeid WHERE p.productid = '" . $_GET['id'] . "' ORDER BY s.id");

while ($row = mysql_fetch_assoc($result)) {
echo '<td class="heading">' . $row['size'] . '</td>';

$arrsizes[$i] = $row['id'];

$i++;
}

echo '</tr>';

$i = 0;
$result = mysql_query("SELECT DISTINCT c.id, c.color FROM colors c INNER JOIN productoptions p ON c.id = p.colorid WHERE p.productid = '" . $_GET['id'] . "' ORDER BY c.id");

while ($row = mysql_fetch_assoc($result)) {
echo '<tr>';
echo '<td class="heading">' . $row['color'] . '</td>';

foreach ($arrsizes as $sizevalue) {
echo '<td><input type="text" name="qty_' . $sizevalue . '_' . $row['id'] . '" size="5" /></td>';
}
echo '</tr>';
}

echo '</table>';
echo '</div>';

echo "<br>";
echo "<br>";

echo '<table>';
echo '<tr>';
echo '<td>';
echo '<p>You MUST order a total of <font color="#ff0000"><strong>(' . $prodrow['minimum'] . ')</strong></font> or more to add this item to your cart.<br>';
echo '(all colors + all sizes = total)</p>';
echo '</td>';
echo '<tr>';
echo '<td>';
echo"<input type='submit' name='submit' value='Add To Cart'>";
echo '</td>';
echo '</tr>';
echo '</table>';

echo "</form>";
echo "</div>";
 

}  
}

require("footer.php");
?>

ok here is my code:
it has a counter variable $i at the start which basically acts as a maximum cutoff for how much data can be output. i have this variable set at 5.

how can i make it so that it doesnt cut off the results (outputs the full 7 days worth of results if available), but ALWAYS outputs a minimum of 5 results?



$now = $now-(7*24*60*60); // Display 7 Days of Results
$query = mysql_query("SELECT * FROM table WHERE date >= '$now' ORDER BY max(date) desc");
$i = 0;
while ($row = mysql_fetch_assoc($query)) {
$cid = $row['cat_id'];
$title = $row['name'];
$seoname = cleanurl($title,0);

$img = 'images/'.$seoname.'.jpg';
if (!file_exists($img)) {
$img = '';
} else {
$img = 'images/'.$seoname.'.jpg';
}

if (!empty($img)) {
$i++;
}

if (!empty($img) && $i <= 5) { // Always show ATLEAST 5 results
echo '<img src="'.$img .'" style="width:528px;" alt="" />' . "\n";
}
}


Please help and look at my code..thanks.

I need help this problem seem too tricky for me right now.

I got an array with decimal numbers and behind it says Yes/No. The min() function works magically and still is able to correctly give me the lowest value.
But how do i make a while loop that loops until it pops a value that is lowest and has Yes behind it?

For example:

Array => ('11,64|No', '209,81|Yes', '533,42|Yes', '27,90|No', '93,01|Yes')

So this function should return '93,01|Yes'