PHP - Unsuccessfull Attempts At Trying To Create A Simple Product List Output

Hi,

I am just wondering if there is any way that I can link Google Maps which will then link to my product stocklist - see attachment for what I am trying to achieve.

Please let me know if this is possible.

Thanks,

This topic has been moved to MySQL Help.

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

I would like to customize my product-list page to display all my products in a grid with an ADD TO CART option for each product. That means i have two ADD TO CART button on the site, in productDetail.php there is a ADD TO CART button original from the tutorial, i need customize another ADD TO CART button on productList.php. Does anyone know how to accomplish this customization? . Please help because I am stuck with the coding for 3weeks 
Tutorial site: http://www.phpwebcommerce.com/plaincart/index.php

productDetail.php:
Code: [Select]
<?php
if (!defined('WEB_ROOT')) {
exit;
}

$product = getProductDetail($pdId, $catId);

// we have $pd_name, $pd_price, $pd_description, $pd_image, $cart_url
extract($product);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="10">
 <tr>
  <td align="center"><img src="<?php echo $pd_image; ?>" border="0" alt="<?php echo $pd_name; ?>" width="230" height="170"></td>
  <td valign="middle">
<strong><?php echo $pd_name; ?></strong><br>
Price : <?php echo displayAmount($pd_price); ?><br>
<?php
// if we still have this product in stock
// show the 'Add to cart' button
if ($pd_qty > 0) {
?>
<input type="button" name="btnAddToCart" value="Add To Cart &gt;" onClick="window.location.href='<?php echo $cart_url; ?>';" class="addToCartButton">
<?php
} else {
echo 'Out Of Stock';
}
?>
  </td>
 </tr>
 <tr align="left">
  <td colspan="2"><?php echo $pd_description; ?></td>
 </tr>
</table>

productList.php:
Code: [Select]
<?php
if (!defined('WEB_ROOT')) {
exit;
}

$productsPerRow = 2;
$productsPerPage = 8;

//$productList    = getProductList($catId);
$children = array_merge(array($catId), getChildCategories(NULL, $catId));
$children = ' (' . implode(', ', $children) . ')';

$sql = "SELECT pd_id, pd_name, pd_price, pd_thumbnail, pd_qty, c.cat_id
FROM tbl_product pd, tbl_category c
WHERE pd.cat_id = c.cat_id AND pd.cat_id IN $children 
ORDER BY pd_name";
$result     = dbQuery(getPagingQuery($sql, $productsPerPage));
$pagingLink = getPagingLink($sql, $productsPerPage, "c=$catId");
$numProduct = dbNumRows($result);



// the product images are arranged in a table. to make sure
// each image gets equal space set the cell width here
$columnWidth = (int)(100 / $productsPerRow);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="20">

<?php 
if ($numProduct > 0 ) {

$i = 0;
while ($row = dbFetchAssoc($result)) {

extract($row);
if ($pd_thumbnail) {
$pd_thumbnail = WEB_ROOT . 'images/product/' . $pd_thumbnail;
} else {
$pd_thumbnail = WEB_ROOT . 'images/no-image-small.png';
}

if ($i % $productsPerRow == 0) {
echo '<tr>';
}

// format how we display the price
$pd_price = displayAmount($pd_price);

echo "<td width=\"$columnWidth%\" align=\"center\"><a href=\"" . $_SERVER['PHP_SELF'] . "?c=$catId&p=$pd_id" . "\"><img src=\"$pd_thumbnail\" border=\"0\" width=\"230\" height=\"170\"><br>$pd_name</a><br>Price : $pd_price<br>";



// format display add to cart 
echo "<input type=\"button\" name=\"btnAddToCart\" value=\"Add To Cart &gt;\" onClick=\"window.location.href='<?php echo $cart_url;?>';\" >";


// if the product is no longer in stock, tell the customer
if ($pd_qty <= 0) {
echo "<br>Out Of Stock";
}

echo "</td>\r\n";

if ($i % $productsPerRow == $productsPerRow - 1) {
echo '</tr>';
}

$i += 1;
}

if ($i % $productsPerRow > 0) {
echo '<td colspan="' . ($productsPerRow - ($i % $productsPerRow)) . '">&nbsp;</td>';
}

} else {
?>
<tr><td width="100%" align="center" valign="center">No products in this category</td></tr>
<?php
}
?>
</table>
<p align="center"><?php echo $pagingLink; ?></p>

Product-functions.php:
Code: [Select]
<?php
require_once 'config.php';

/*********************************************************
*                 PRODUCT FUNCTIONS 
**********************************************************/


/*
Get detail information of a product
*/
function getProductDetail($pdId, $catId)
{

$_SESSION['shoppingReturnUrl'] = $_SERVER['REQUEST_URI'];

// get the product information from database
$sql = "SELECT pd_name, pd_description, pd_price, pd_image, pd_qty
FROM tbl_product
WHERE pd_id = $pdId";

$result = dbQuery($sql);
$row    = dbFetchAssoc($result);
extract($row);

$row['pd_description'] = nl2br($row['pd_description']);

if ($row['pd_image']) {
$row['pd_image'] = WEB_ROOT . 'images/product/' . $row['pd_image'];
} else {
$row['pd_image'] = WEB_ROOT . 'images/no-image-large.png';
}

$row['cart_url'] = "cart.php?action=add&p=$pdId";

return $row;
}


?>

any help will be greatly appreciated 

hi

i have generated a product list from a mysql table called product_list, once i enter a new product in to the table the product will be shown in the generated list and the list will grow and the table grows.  and i want to allow user the edit/delete/save the products from the generated table, i have no idea how to do it and what is the algorithmic idea to do it so. here is the php and the html code.

<!--Body container  for creating a new product in to the list-->
<div class="body_orderviewform">
  <form name="form1" method="post" action="upload_file.php" enctype="multipart/form-data">
    <p>
      <label for="user_id">User ID:</label>
      <input type="text" name="user_id" id="user_id">
      <label for="customer_name">Customer Name:</label>
      <input type="text" name="customer_name" id="customer_name">
      <label for="customer_family">Customer_family</label>
      <input type="text" name="customer_family" id="customer_family">
      <label for="freelancer_name">Purchaser:</label>
      <input name="freelancer_name" type="text" id="freelancer_name">
     
      <? if (isset($_COOKIE['picAdd'])) echo $_COOKIE['picAdd'];?>
     
    </p>
 <!------------------------------------------------------------------------------------------------------- for generating the list -->
   
<div  class="div.neworder_list" >   

   <div  class="div.neworder_listheader" align="center">
   
    <table width="637" border="1" >
      <tr>
        <td width="193"><label for="link">link:</label>
          <label for="link_new"></label>
          <input type="text" name="link_new" id="link_new"></td>
        <td width="202"><label for="unitprice">Unit Price:</label>
          <label for="Unit_price_new"></label>
          <input type="text" name="Unit_price_new" id="Unit_price_new"></td>
        <td width="220"><label for="qty">Quantity:</label>
          <label for="quantity_new"></label>
          <input type="text" name="quantity_new" id="quantity_new"></td>
      </tr>
      <tr>
        <td><label for="express">Express Fee:</label>
          <label for="express_new"></label>
          <input type="text" name="express_new" id="express_new"></td>
        <td><label for="commission_new">Commission:</label>
          <input type="text" name="commission_new" id="commission_new"></td>
        <td><label for="customer_description">Description</label>
          <label for="description_new"></label>
          <textarea name="description_new" id="description_new" cols="45" rows="5"></textarea></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">Picture Upload:
              <input type="hidden" name="<?php echo ini_get("session.upload_progress.name");?>" value="123" />
              <input name="file" type="file" autofocus="autofocus"/>
              <br />


      </tr>
      <tr>
        <td colspan="3"><input type="reset" name="reset" id="reset" value="Reset">
        <input type="submit" name="submit" id="submit" value="Submit The Product"></td>
      </tr>
    </table>

 
</form>   
</div>
   
<div class="neworder_listview">
  <p>
  <form action="" method="post" name="list">
    <input type="submit" name="del" id="del" value="Save">
    <input type="submit" name="save" id="save" value="Del">
  </p>
  <table width="1022" border="1" align="center">
    <tr>
      <th width="24" scope="col">&nbsp;</th>
    <th width="24" scope="col">Row#</th>
    <th width="137" scope="col">Manager</th>
    <th width="137" scope="col">Purchaser Desc</th>
    <th width="40" scope="col"><p>Link</p>
      <p>/Ссылки</p></th>
    <th width="53" scope="col">ФОТО</th>
    <th width="50" scope="col">Unit Price/Цена за еденицу товара</th>
    <th width="46" scope="col">Quantity/ Кол-во</th>
    <th width="138" scope="col">Total Unit Price/ Общая цена</th>
    <th width="89" scope="col">Express/Доставка по Китаю</th>
    <th width="119" scope="col">Description/Описание</th>
    <th width="89" scope="col">ADDITIONAL LINKS/ЗAMЕНЫ</th>
    </tr>
   


<?php

   $username = "my username";
   $password = "my pass";
   $database = "userinfo";
   $link = mysql_connect("localhost", "$username", "$password");
   
   if(!$link) {echo("Failed to establish connection to mysql server");
               exit();}

   $status = mysql_select_db($database);
   $query = "SELECT * FROM order_list";
   $result = mysql_query($query);
   $num = mysql_num_rows($result);
   $i=0;
 
 
 
  while ($i < $num) {
   $field1_name=mysql_result($result,$i,"admin_st");
   $field2_name=mysql_result($result,$i,"freelancer_st");
   $field3_name=mysql_result($result,$i,"link");
   $field4_name=mysql_result($result,$i,"picture");
   $field5_name=mysql_result($result,$i,"unitprice");
   $field6_name=mysql_result($result,$i,"qty");
   $field7_name=mysql_result($result,$i,"express");
   $field8_name=mysql_result($result,$i,"customer_st");
   $i++;
    }
 
?>







<?php
$i=0;
$row=1;
while ($i < $num) {

$f1=mysql_result($result,$i,"admin_st");
$f2=mysql_result($result,$i,"freelancer_st");
$f3=mysql_result($result,$i,"link");
$f4=mysql_result($result,$i,"pic_address");
$f5=mysql_result($result,$i,"unitprice");
$f6=mysql_result($result,$i,"qty");
$f7=mysql_result($result,$i,"express");
$f8=mysql_result($result,$i,"customer_st");
$totao_unit_price = $f5*$f6;
?>
  <tr>
    <td><input type="checkbox" name="del_chbox" id="del_chbox">
   <td><p><font face="Arial"><input name="row_txtbox" type="text" id="row_txtbox" size="2" value="<?php echo $row; ?>"></font></td>
   <td><p><font face="Arial"> <textarea name="manager_txtbox" cols="10" id="manager_txtbox"><?php echo $f1; ?></textarea></font></td>
   <td><p><font face="Arial">        <textarea name="purchase_txtbox" cols="10" id="purchase_txtbox"><?php echo $f2; ?></textarea>
</font></td>


   <td><font face="Arial"><a href="<?php $f3 ?>" target="_blank"><?php echo $f3; ?></a></font></td>
   <td><font face="Arial"><img src="<?php echo $f4;?>" width="100" align="middle"100></font></td>
   <td><font face="Arial"><input name="unitprice_txtbox" type="text" id="unitprice_txtbox" size="2" value="<?php echo $f5; ?>"></font></td>
   <td><font face="Arial"> <input name="qty_txtbox" type="text" id="qty_txtbox" size="2" value="<?php echo $f6; ?>"></font></td>
   <td><p><font face="Arial"><?php echo $totao_unit_price; ?></font></td>
   <td><p><font face="Arial"><input name="express2" type="text" id="express3" size="2" value="<?php echo $f7; ?>"></font></td>
   <td><p><font face="Arial"> <textarea name="custdesc_txtbox" cols="20" id="custdesc_txtbox"><?php echo $f8; ?></textarea></font></td>
    <td><input name="express2" type="text" id="express3" size="2" value="<?php echo "new link" ?>"></td>
   </tr>

  <p>
    <?php
$i++;
$row++;
}
?>
</table>
   
  </p>
  <p>&nbsp;</p>
  </form>

Hi, I need a quick tip. I want this script to produce an output of "Table created" if it succesfully creates a table.

<?php
$con = mysql_connect("localhost","****","****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create table
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE People
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";

// Execute query
mysql_query($sql,$con);

mysql_close($con);
?> 

I tried to do it on my own, but I guess I'm still completely new to php 
I tried:
<?php
$con = mysql_connect("localhost","****","****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create table
if (mysql_select_db("my_db", $con))
  {
  echo "Table created";
  }
else
  {
  echo "Error creating Table: " . mysql_error();
  }
$sql = "CREATE TABLE People
(
FirstName varchar(15),
LastName varchar(15),
Age int
)"


// Execute query
mysql_query($sql,$con);

mysql_close($con);
?> 

It gave me an error with the last two lines
mysql_query($sql,$con);

mysql_close($con);

 I removed them and it really did give the output "Table created" yet it didn't create the table in the database. I'm having a feeling that I need to add an "if" statement, something of the sort.

if (sql(CREATE TABLE Persons))

But I'm also getting the feeling something there is wrong, I still haven't tried it. 

Help?

create_ckeditor.php

<?php

session_start();
date_default_timezone_set('Asia/Manila');
if($_SESSION['login']['Ad_UserName']==""||$_SESSION['login']['Ad_ExWrite']=="0"){
@header("Location:error.php");
}elseif($_SESSION['login']['Ad_ExWrite']!="1"){
echo "<script type='text/javascript'>alert('You don\'t have rights to access this panel. Please contact the Global Administrator!')</script>";
echo '<script type="text/javascript">history.go(-1)</script>';
}
?>
<?php
if($_SESSION['login']['Ad_ExWrite']=="1"){include("create_ckeditor_script.php");};
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="en-gb" dir="ltr" id="minwidth" >
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />

<title>SRG Online Nursing Review</title>
<script language="JavaScript" src="calendar_us.js"></script>
<link rel="stylesheet" href="calendar.css">
<script type="text/javascript" src="js/calendar/calendar.js"></script>

<link href="css/images/boss.ico" rel="shortcut icon" type="image/x-icon" />
<script type="text/javascript" src="js/tools.js"></script>
<script type="text/javascript" src="js/validate.js"></script>
<script type="text/javascript" src="js/deleteall.js"></script>
<script type="text/javascript" src="js/clock.js"></script>
<script type="text/javascript" src="js/popup/popup.js"></script>

<link rel="stylesheet" type="text/css" href="css/main_import.css" />
<script type="text/javascript" src="js/menu.js"></script>
</head>
<body id="minwidth-body" onLoad="goforit()">


<?php include("includes/menu.html");?>


<?php @include_once("class/class.php");
@$db=new DB();
@$db->connect();
$sql="SELECT * FROM tbl_coursecategory WHERE Course_IsAvailable=1 ORDER BY Course_Name ASC ";
@$array=$db->get_as_array($sql);


?>





<!---


menubar border STARTS

--->
<div class="clr"></div>
</div>
<div id="content-box">
<div class="border">
<div class="padding">
<div id="toolbar-box">
    <div class="t">

<div class="t">
<div class="t"></div>
</div>
</div>
<div class="m">


                    <!---


*********************

title bar menu

*********************


--->   

     
<div class="toolbar" id="toolbar">
  
  
 
</div>


<div class="header addexaminee48">Create Lecture</div>

<div class="clr"></div>
  </div>

  <div class="b">
<div class="b">
<div class="b"></div>
</div>
</div>
</div>
<noscript></noscript>
  <div class="clr"> </div>
  </div>
</div>
</div>
<div id="border"><div><div></div></div></div>




<!--- Error Message--->
<div class="m" style="margin-bottom:-10px;">
<?php
if ($sw==1){
echo "<div class='errorMessage'><div class='error32'></div>";
echo "<div class='errorTxt'>";
echo "$msg</div></div><br />";
$sw=0;
}
?>
</div>
<!--- End Error Message--->



<!---


Menu Border Ends!

--->







 
<!---


main Border STARTS

--->
<div class="clr"></div>
</div>
<div id="content-box">
<div class="border">
<div class="padding">
<div id="toolbar-box">
    <div class="t">

<div class="t">
<div class="t"></div>
</div>
</div>
<div class="m" style="padding-left:20px; padding-right:20px;" >

<br /><div style="font-size:12px"><b>Title of Lecture</b></div>
<hr/><br />

   

 <?php echo implode(file("http://localhost/SRG_MAIN/admin/ckeditor/_samples/srg.html")); ?>
     
                           
 <?php include ("includes/menu_footer.html");?>
 
 </div> <div class="clr"></div>
  </div>

  <div class="b">
<div class="b">
<div class="b"></div>
</div>
</div>
</div>
<noscript></noscript>
  <div class="clr"> </div>
  </div>
</div>
</div>
<div id="border-bottom"><div><div></div></div></div>
    
<!---


main Border ENDS 

--->    
    
    

 
 
 
 
 
 
 
 
 
 
    
    
<?php include("includes/footer.html");?>
</body>



<!--java script prompting sucessfully added!-->
<?php

if($_GET['popup']==1){

echo "<script type='text/javascript'>window.location='create_examinee.php';alert('Examinee Sucessfully Added!');</script>";
}

?>






</html>



create_ckeditor_script.php

<?php
@session_start();
@include_once("class/class.php");
@$db=new DB();
@$db->connect();
$sql="INSERT INTO tbl_lecture(
orno,
lecture
) VALUES(
'$_POST[ORNo]',
'$_POST[lecture]'
)";
@$db->add_account($sql);
@$db->close();

?>






I really need to change may table in database can someone guide mo how to enable a chapter or category each time i will save a content

if i will save a content, it will only output continuously
i wanted to make it per chapter or per category
what do i need to do from here 

In this output table, I would like to be able to click on any number in the ama row, add .html to that value and then execute the link.

Example: If the ama number in row 3 is 890543, add .html to the number = 890543.html, then click on it to link to that web page.


<?php // Connect to database =========================================

include("connect_db.php");
$table1='passwords';
$table2='airplanes';

// send query ===================================================

$result = mysql_query("SELECT * FROM $table2") or die(mysql_error());  

if (!$result) {
    die("Query to show fields from table failed");
}

echo "<table border='10' cellpadding='3' cellspacing='2'>";
echo "<p>View All Airplanes</p>";

echo "<tr> <th>ID</th> <th>AMA #</th> <th>Model Name</th> <th>Model MFG</th><th>Wingspan</th><th>Engine</th><th>Decibels</th></tr>";

// keeps getting the next row until there are no more to get ================

while($row = mysql_fetch_array( $result )) {

// Print out the contents of each row into a table ==========================

echo "<tr><td>";

echo $row['id'];

echo "</td><td>"; 

echo $row['ama']; // Append .html to this number

echo "</td><td>"; 

echo $row['model_name'];

echo "</td><td>"; 

echo $row['model_mfg'];

echo "</td><td>"; 

echo $row['wingspan'];

echo "</td><td>"; 

echo $row['engine'];

echo "</td><td>"; 

echo $row['decibels'];

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

echo "</table>";

?>

In the browser when I open the file I  need to see the output of the ifconfig linux command on the server.

This is the index.php

<?
$iplist = shell_exec("ifconfig");
print "<pre>$iplist</pre>";
?>

but when I open the index.php in a browser I can see only the first couple of lines, nothing more. Can someone help me what to do?

The strange thing is when I run the index.php from the command line with "php index.html" it shows the correct result.

Any help..?

Thanks,

Hi there, I'm trying to get the full Product Name in the <title> of each of the product pages - I can't seem to figure out what to put in the product_info.php...  I've tried a few different options but I'm not great with php
Here's what I have currently but it creates errors...

<script language="javascript"><!--
document.write('<title><?php echo TITLE; ?> : <?php echo $product_info['products_name']; ?> </title>');
//--></script>

Hope someone can help - thanks so much!

Hi guys,

I want to create a simple database and use PHP to output the database to certain positions on a HTML page.

I am basically trying to recreate this: http://bit.ly/dX4byI

I want to have a form where the event info is selected from drop down box such as: Venue and Date then the the rest of the form data (event name, artists, opening times) will go into the right box depending on this.

Does anyone have any pointers? Am I even going about this the right way?!

Hi, I have a chunk of text I am pulling from a mysql db like below.
                           
Air conditioning in rooms
24 Hour Reception
Smoking rooms available

How can I write this into -

<ul>                           
<li>Air conditioning in rooms</li>
<li>24 Hour Reception</li>
<li>Smoking rooms available</li>
</ul>

Many thanks.

Trying to do something that I think should be very simple. Let's assume that I have an array populated with the numbers 1 to 24 for this example.

I need to output these items in 4 columns to accomodate my CSS layout but still have them read from left to right, top to bottom. I also want this to be somewhat dynamic - I'm okay hardcoding it to split into 4 columns, but need it to handle any number of items in the array.

I'm not sure if the best way to do this would be to split the original array into an array for each of the 4 columns, or to loop through the original array 4 times and output items 1+4, 2+4, and so on. Or maybe I should be using array_filter with some custom callback functions. I'm fine with any solution.

The end result is echoing the array in the following groupings so I can surround each column with the appropriate column HTML for layout (in this case the array actually contains IMG urls):

Column 1: 1, 5, 9, 13, 17, 21
Column 2: 2, 6, 10, 14, 18, 22
Column 3: 3, 7, 11, 15, 19, 23
Column 4: 4, 8, 12, 16, 20, 24

Any help would be appreciated! This one is driving me nuts and I know it should be relatively easier. Guess I should stick to HTML + CSS.

How to create Dependent Dropdown List?

 

                    <div class="form-group">
                            <label class="control-label col-sm-2" for="i_have">I have :</label>
                            <div class="col-sm-10">  
                                <select id="old" class="form-control" placeholder="Select I have" name="i_have">
        
                                    <option value = "select_option">Select Option</option>
                                    <option value = "three_compact">3 Compact</option>
                                    <option value = "three_regular">3 Regular</option>
                                    <option value = "three_triple">3 Triple</option>
                                    <option value = "five_compact">5 Compact</option>
                                    <option value = "five_regular">5 Regular</option>
                                    <option value = "five_triple">5 Triple</option>
                                    <option value = "seven_compact">7 Compact</option>
                                    <option value = "seven_regular">7 Regular</option>
                                    <option value = "seven_triple">7 Triple</option>
                                    <option value = "nine_compact">9 Compact</option>
                                    <option value = "nine_regular">9 Regular</option>
                                    <option value = "nine_triple">9 Triple</option>   
                                </select>
                            </div>
                        </div>
        
        
        
        
                        <div class="form-group">
                            <label class="control-label col-sm-2" for="i_want">I want :</label>
                            <div class="col-sm-10">  
                                <select id="new" class="form-control" placeholder="Select I want" name="i_want">
        
                                    <option value = "select_option">Select Option</option>
                                    <option value = "three_compact">3 Compact</option>
                                    <option value = "three_regular">3 Regular</option>
                                    <option value = "three_triple">3 Triple</option>
                                    <option value = "five_compact">5 Compact</option>
                                    <option value = "five_regular">5 Regular</option>
                                    <option value = "five_triple">5 Triple</option>
                                    <option value = "seven_compact">7 Compact</option>
                                    <option value = "seven_regular">7 Regular</option>
                                    <option value = "seven_triple">7 Triple</option>
                                    <option value = "nine_compact">9 Compact</option>
                                    <option value = "nine_regular">9 Regular</option>
                                    <option value = "nine_triple">9 Triple</option>   
                                </select>
                            </div>
                        </div>
                    

 

If the first dropdown "3 Compact " is selected second dropdown should not be able to select "3 Compact" & if first dropdown "5 Regular" is selected second dropdown should not be able to select below values of 5 Regular  like "3 Compact, 3 Regular, 3 Triple, 5 Compact.

The logic is, if first dropdown value selects like 5, second dropdown value must select above 5 not 4 or 3 or 2 or 1.

I have the following code which works (thanks to PHP Freaks members)

    foreach ($swap["sims"] as $swap) 
    		{
                    echo $swap['voice'] . "</br>";
			}

But I can't figure out why the following doesn't work

<select name="sim_for_swap[]">
<?php
    foreach ($swap["sims"] as $swap)  
    		{
?>
<option value="<?php echo $swap['voice'];?>"><?php echo $swap['voice'];?></option>
<?php
}
?>