PHP - How To Make Options In A Select Box Be Values From A Table.

I'm trying to figure out why the options aren't appearing inside the select dropdown. Any ideas why?

Code: [Select]
echo "<label for=" . $row2['fullName'] . ">" . $row2['fullName'] . "</label>";
                       echo "<select name=" . $row2['fullName'] . " id=" . $row2['fullName'] . " class=dropdown title=" . $row2['fullName'] . " />";
                       if ($styleID == 1 || $styleID == 2 || $styleID == 6) {
                         $charactersQuery = "
                                SELECT
                                    characters.ID,
                                    characters.characterName
                                FROM
                                    characters
                                WHERE
                                    characters.styleID = 3
                                ORDER BY
                                    characters.characterName";
                         $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
                         while ( $row3 = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) {
                            print "<option value=" . $row3['ID'] . ">" . $row3['characterName'] . "</option>\r";
                         }   
                       } else {
                         $charactersQuery = "
                                SELECT
                                    characters.ID,
                                    characters.characterName
                                FROM
                                    characters
                                WHERE
                                    characters.styleID IN (1,2,6)
                                ORDER BY
                                    characters.characterName";
                         $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
                         while ( $row3 = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) {
                            print "<option value=" . $row3['ID'] . ">" . $row3['characterName'] . "</option>\r";
                         }
                       }
                       echo "</select>";
                   }

Hi, Im not sure whether this is a PHP or MySQL question, but im trying to get a select menu to only display the number of options that are defined in the mysql database.   For example   The code I have that retrieves the $quantity from the database.   Lets say that   $quantity = 3   Now I would like the option menu to only display three options, like this:

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
</select>

but for example, if the $quantity was equal to 10 then I would like the menu to be displayed as such

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>

How is it possible to do this? I am completely at a loss here.   Many Thanks   aquaman

Hey Guys,

Here is my issue. I have a MySQL database with a table of products. I use this table to generate a mutliselect form element that is used int a larger form. The larger form contains other information relevant to an issue that we are having with that product (such as an outage). Anyway, the form works fine and the form validation works fine and I write it to the database fine. The issue I'm having is how to save the mutliselect options most efficiently.

This is my current process:

1. User creates a new entry from the form and clicks save
2. The form is validated
3. All entries are written to the database in a table called "incidents" (content inclues, timestamps, description of the problem, the impact, who to contact, etc)
4. Because the products list can vary from 1 product to all (~30) products I broke it out into a separate table called "impacted_products". I then loop through each of the selected products and write one row for each product using the id from the row in the "incidents" table to define the tables relationship.

Example of DB results:

"incidents"

+-----------------+------+----------+---------------------+---------+---------+
| notification_id | what | impact   | time_start          | summary | contact |
+-----------------+------+----------+---------------------+---------+---------+
| 235235          | Test | None.... | 2011-02-08 13:41:00 | Test    |       3 |
+-----------------+------+----------+---------------------+---------+---------+

"impacted_products"

+-----+-----------------+------------+---------------------+---------+
| id  | notification_id | product_id | timestamp           | deleted |
+-----+-----------------+------------+---------------------+---------+
| 202 | 235235          |          7 | 2011-02-10 14:30:42 |       0 |
| 203 | 235235          |         37 | 2011-02-10 14:30:42 |       0 |
| 204 | 235235          |         23 | 2011-02-10 14:30:42 |       0 |
+-----+-----------------+------------+---------------------+---------+

5. Now the users wants to go back and make some updates.
6. They click the edit button from the menu on screen and the form is brought back up and all options/fields are filled out from that which is stored in the database.
7. They make their edits and save again.
8. Now this time it simple updates the "incidents" table but for the products table I do a:

"UPDATE impacted_products SET deleted=1 WHERE notification_id='$ID'"

and "delete" all the old impacted_products for this particular incident and then loop through all the products that the user still had selected and write them to the database again.
9. And repeat

So as you can see this could end up with a lot of "useless" entries in the database since my scripts only pay attention to those "impacted_products" whose deleted value is set to 0.

Example:

+-----+-----------------+------------+---------------------+---------+
| id  | notification_id | product_id | timestamp           | deleted |
+-----+-----------------+------------+---------------------+---------+
| 176 | 235235          |         37 | 2011-02-08 15:26:25 |       1 |
| 177 | 235235          |         43 | 2011-02-08 15:26:25 |       1 |
| 178 | 235235          |         37 | 2011-02-08 15:37:58 |       1 |
| 179 | 235235          |         43 | 2011-02-08 15:37:58 |       1 |
| 180 | 235235          |          1 | 2011-02-08 15:39:49 |       1 |
| 181 | 235235          |          7 | 2011-02-08 15:39:49 |       1 |
| 182 | 235235          |         37 | 2011-02-08 15:39:49 |       1 |
| 183 | 235235          |         43 | 2011-02-08 15:39:49 |       1 |
| 184 | 235235          |          1 | 2011-02-08 15:40:53 |       1 |
| 185 | 235235          |          7 | 2011-02-08 15:40:53 |       1 |
| 186 | 235235          |         37 | 2011-02-08 15:40:53 |       1 |
| 187 | 235235          |         43 | 2011-02-08 15:40:53 |       1 |
| 188 | 235235          |         37 | 2011-02-10 10:00:47 |       1 |
| 189 | 235235          |          1 | 2011-02-10 12:17:05 |       1 |
| 190 | 235235          |          7 | 2011-02-10 12:17:05 |       1 |
| 191 | 235235          |         13 | 2011-02-10 12:17:05 |       1 |
| 192 | 235235          |         37 | 2011-02-10 12:17:05 |       1 |
| 193 | 235235          |         23 | 2011-02-10 12:17:05 |       1 |
| 194 | 235235          |          1 | 2011-02-10 12:21:52 |       1 |
| 195 | 235235          |          7 | 2011-02-10 12:21:52 |       1 |
| 196 | 235235          |         13 | 2011-02-10 12:21:52 |       1 |
| 197 | 235235          |         37 | 2011-02-10 12:21:52 |       1 |
| 198 | 235235          |         23 | 2011-02-10 12:21:52 |       1 |
| 199 | 235235          |          7 | 2011-02-10 12:22:26 |       1 |
| 200 | 235235          |         37 | 2011-02-10 12:22:26 |       1 |
| 201 | 235235          |         23 | 2011-02-10 12:22:26 |       1 |
| 202 | 235235          |          7 | 2011-02-10 14:30:42 |       0 |
| 203 | 235235          |         37 | 2011-02-10 14:30:42 |       0 |
| 204 | 235235          |         23 | 2011-02-10 14:30:42 |       0 |
+-----+-----------------+------------+---------------------+---------+

I did it this way beacuase it seems the easiest and fastest way. Otherwise I would have to lookup all the impacted_products from the table that match that notification_id and check

1) Was there a new product selected? If so, add it.
2) Was a product that was selected no longer selected? If so, delete it.
3) Was a product that was selected before still selected now? If so, leave it alone.

This seemed like a lot of extra looping and a lot of extra DB queries to essentially end up at the same place.

However, I feel that there has still got to be a more efficient way of doing this where I won't have all the extra entries in the impacted_products table. 

Any ideas?

Thanks in advance!

Hi im new to php and I need help making webpage that queries a mysql database based on a 3 check boxes and displays results on the same page or on another page. The table being queried has 4 columns, name, gps, wifi, bluetooth. So for example a row in the table would be like, samsung galaxy s2, yes, yes, yes. The idea is for it to be a website that will display phones according to their features.

So the idea is depending on if the boxes were ticked the samsung galaxy would be displayed as a result. So i need some help understanding how to make this.

Some1 gave me the code below in attempt to help me (im not sure it works or not) but im not sure how fully use it, ie what pages i need to make and how i create the connection to the mysql database, and how to use the query that they wrote to display the results

thanks

code:
Code: [Select]
<form action="?do=filter" method="post">
<table cellspacing="0" cellpadding="3" border="1">
<tr>
<td>GPS<input type="checkbox" name="gps" value="checked"></td>
<td>Wifi<input type="checkbox" name="wifi" value="checked"></td>
<td>Bluetooth<input type="checkbox" name="bluetooth" value="checked"></td>
</tr>
<tr><td><input type='submit' name='filter' value='Filter'></td></tr>
</table>
</form>
</html>
<?php
function filterMe($filter){
if(isset($_POST[$filter])){
return "Yes";
}else{
return "No";
}
}

if(isset($_POST['filter'])){
echo "Gps - " . filterMe('gps');
echo "
Wifi - " . filterMe('wifi');
echo "
Bluetooth - " . filterMe('bluetooth');
}
?>


All you need to do is use a query something like
SELECT name,gps,wifi,bluetooth FROM `product` WHERE `gps`='".filterMe('gps')."' AND `wifi`='".filterMe('wifi')."' AND `bluetooth`='".filterMe('bluetooth')."'

I accidently posted this in the PHP applications board and didn't mean to because its a blizzard here and my comp is getting slow and lagging and I thought I had clicked in the right board but I was wrong so if a mod, admin can delete that other entry I'd be thankful.

I'm trying to queries together because I have this query but I want to only put in those characters that have not been taken so I have another table that lists all the characters that are used. TABLE handler_characters which has fields called id, handler_id, character_id. What I want to somehow do is have it get all the character_ids out of that table and then subtract those ids from this query so it won't list them as options. Any thoughts on how to accomplish this?


<?php
                $query = 'SELECT id, charactername FROM characters ORDER BY `charactername`';
                $result = mysqli_query ( $dbc, $query ); // Run The Query
                while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) { 
                    print "<option value=\"".$row['id']."\">".$row['charactername']."</option>\r";
                }
                ?>

I am trying to create a dynamic table that gets generated based upon users selection of last name (via a select menu) as well as the ability to filter all the table contents between two ages.  Additionally, I would like the ability to select all last names between two ages as well.  Each item I would hope to have a onchange command.

Thanks in advance for any help on the above items.


Here is the main php code

<?php

$con = mysql_connect('localhost', 'root', '');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("test", $con);

$lastname_result = mysql_query("SELECT lastname FROM user GROUP BY lastname");

$result = mysql_query("SELECT * FROM user");

?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../themes/style.css" rel="stylesheet" type="text/css" media="print, projection, screen" /></link>
<link href="../common.css" rel="stylesheet" type="text/css"></link>
</head>

<body>

<table width="100%" border="0" cellspacing="0" cellpadding="5" class="main">
<tr>
   <td width="160" valign="top"></td>
     <td width="732" valign="top">
    
     <table width="90%" border="0" align="center">
     <form action="test3.php" method="post">
       <select name="area" onchange="submit">
       <option value="">Select an lastname</option>
       <option value=""></option>
       <?php while(list($lastname)=mysql_fetch_array($lastname_result))
       {
       echo "<option value='$lastname'>$lastname</option>";
       }?>
        </select>
      
<label for="startage">From</label>
   <input type="text" id="from" name="from"/>
   <label for="endage">to</label>
   <input type="text" id="to" name="to"/>
   <input type="submit" name="Submit" value="Refresh" />
       </form>
       </table>
<table id="tablesorter" class="tablesorter" border="0" cellpadding="0" cellspacing="1">
<thead>
<tr>
<th>First Name</th>
<th>Last Name</th>
<th>Age</th>
<th>Hometown</th>
<th>Job</th>
</tr>
</thead>
<tbody>
<?php
while($row=mysql_fetch_assoc($result)){
?>
<tr>
<td><?php echo $row['firstname']; ?></td>
<td><?php echo $row['lastname']; ?></td>
<td><?php echo $row['age']; ?></td>
<td><?php echo $row['hometown']; ?></td>
<td><?php echo $row['job']; ?></td>
</tr>
<?php } // End while loop. ?>
</tbody>
</table>  
      <p>&nbsp;</p>
      <p>&nbsp;</p>
  <p align="right">&nbsp; </p></td>
    <td width="196" valign="top">&nbsp;</td>
  </tr>
</table>
</body>
</html>



and here is the sql code to generate a test database.
Code: [Select]
CREATE DATABASE /*!32312 IF NOT EXISTS*/`test` /*!40100 DEFAULT CHARACTER SET latin1 */;

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(20) NOT NULL,
  `lastname` varchar(20) NOT NULL,
  `age` int(3) NOT NULL,
  `hometown` varchar(25) NOT NULL,
  `job` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `user` */

insert  into `user`(`id`,`firstname`,`lastname`,`age`,`hometown`,`job`) values
(1,'Peter','Griffin',41,'Quahog','Brewery'),
(2,'Lois','Griffin',40,'Newport','Piano Teacher'),
(3,'Joseph','Swanson',39,'Quahog','Police Officer'),
(4,'Glenn','Quagmire',41,'Quahog','Pilot'),
(5,'Megan','Griffin',16,'Quahog','Student'),
(6,'Stewie','Griffin',2,'Quahog','Dictator');

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites.  When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell.  It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in.  Both cases mess up the table and formatting.  I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<table id="datatables-column-search-select-inputs" class="table table-striped" style="width:100%">

                                        <thead>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                                <th>Actions</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php

                                            //QUERY TO SELECT ALL USERS FROM DATABASE

                                            $query = "SELECT * FROM users";

                                            $select_users = mysqli_query($connection,$query);

                                            

                                            // SET VARIABLE TO ARRAY FROM QUERY

                                            while($row = mysqli_fetch_assoc($select_users)) {

                                                $user_id = $row['user_id'];

                                                $user_firstname = $row['user_firstname'];

                                                $user_lastname = $row['user_lastname'];

                                                $username = $row['username'];

                                                $user_phone = $row['user_phone'];

                                                $user_image = $row['user_image'];

                                                $user_title_id = $row['user_title_id'];

                                                $user_role_id = $row['user_role_id'];

                                            

                                                // POPULATES DATA INTO THE TABLE

                                                echo "<tr>";

                                                echo "<td>{$user_id}</td>";

                                                echo "<td>{$user_firstname}</td>";

                                                echo "<td>{$user_lastname}</td>";

                                                echo "<td>{$username}</td>";

                                                echo "<td>{$user_phone}</td>";

                                            

                                                //PULL SITE STATUS BASED ON SITE STATUS ID

                                                $query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

                                                $select_site = mysqli_query($connection, $query);

                                                while($row = mysqli_fetch_assoc($select_site)) {

                                                    $site_name = $row['site_name'];

                                                    echo "<td>{$site_name}</td>";

                                                }

                                                echo "<td>{$user_title_id}</td>";

                                                echo "<td>{$user_role_id}</td>";

                                                echo "<td class='table-action'>

                                                    <a href='#'><i class='align-middle' data-feather='edit-2'></i></a>

                                                    <a href='#'><i class='align-middle' data-feather='trash'></i></a>

                                                    </td>";

                                                //echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

                                                echo "</tr>";

                                            }   

                                            ?>

 

                                            <tr>

                                                <td>ID</td>

                                                <td>FirstName</td>

                                                <td>LastName</td>

                                                <td>Username</td>

                                                <td>Phone #</td>

                                                <td>Location</td>

                                                <td>Title</td>

                                                <td>Role</td>

                                                <td class="table-action">

                                                <a href="#"><i class="align-middle" data-feather="edit-2"></i></a>

                                                <a href="#"><i class="align-middle" data-feather="trash"></i></a>

                                                </td>

                                            </tr>

                                        </tbody>

                                        <tfoot>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                            </tr>

                                        </tfoot>

                                    </table>

I am trying to create a dynamic table that gets generated based upon users birthday, then selection of last name (via a select menu), then first name (via a select menu), Each selection would subsequently filter out items not chosen.  i.e. if the last name of Griffin were selected, only those with the last name Griffin would be present when selecting the first name.

I have been able to generate the birthday and then last name selection, but I am unclear of how to add the first name into the mix (and any other subsequent filters thereafter)

Here is what I as so far.  Any help would be appreciated.

database sql code:
Code: [Select]
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(20) NOT NULL,
  `lastname` enum('Griffin','Griffin6','Quagmire','Swanson') NOT NULL,
  `age` int(11) NOT NULL,
  `hometown` varchar(25) NOT NULL,
  `job` varchar(25) NOT NULL,
  `birthdate` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `user` */

insert  into `user`(`id`,`firstname`,`lastname`,`age`,`hometown`,`job`,`birthdate`) values
(1,'Peter','Griffin',41,'Quahog','Brewery','1960-01-01'),
(2,'Lois','Griffin',40,'Newport','Piano Teacher','1961-08-11'),
(3,'Joseph','Swanson',39,'Quahog','Police Officer','1962-07-23'),
(4,'Glenn','Quagmire',41,'Quahog','Pilot','1960-02-28'),
(5,'Megan','Griffin',16,'Quahog','Student','1984-04-24'),
(6,'Stewie','Griffin',2,'Quahog','Dictator','2008-03-03');
index.php:
<?php
include('config.php');  //Include the database connections in it's own file, for easy integration in multiple pages.

$lastname_result = mysql_query("SELECT lastname FROM user GROUP BY lastname");

$result = mysql_query("SELECT * FROM user");

?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="start/jquery-ui-1.8.4.custom.css" rel="stylesheet" type="text/css"/></link>
<link href="../themes/style.css" rel="stylesheet" type="text/css" media="print, projection, screen" /></link>
<link href="../common.css" rel="stylesheet" type="text/css"></link>
<script type="text/javascript" src="jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="jquery.tablesorter.js"></script>
<script type="text/javascript" src="jquery-ui-1.8.4.custom.min.js"></script>
<script type="text/javascript">
$(document).ready(function() 
    { 
        $("#myTable").tablesorter({widgets: ['zebra']});
$("#options").tablesorter({sortList: [[0,0]], headers: { 3:{sorter: false}, 4:{sorter: false}}});
    } 
); 

function reSort(par) {
$("#tableBody").empty();
var vfrom = document.getElementById('from').value;
var vto = document.getElementById('to').value;
$.get('table.list.php?from='+vfrom+'&to='+vto+'&lastname='+par,function(html) { 
             // append the "ajax'd" data to the table body 
             $("#tableBody").append(html); 
            // let the plugin know that we made a update 
            $("#myTable").trigger("update"); 
// set sorting column and direction, this will sort on the first and third column 
            var sorting = [[0,0]]; 
            // sort on the first column 
            $("#myTable").trigger("sorton",[sorting]); 
        }); 
}

</script>
</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="5" class="main">
<tr>
<td width="160" valign="top"></td>
<td width="732" valign="top">
<table width="90%" border="0" align="center">
<form method="post">
<label for="from">From</label>
<input type="text" id="from" name="from"/>
<label for="to">to</label>
<input type="text" id="to" name="to"/>
  <?php //added javascript function call to function located in "ajax.js" ?>
<select id="selectbox" name="area" onchange="reSort(this.value);"> <?php //added javascript function call to function located in "ajax.js", and changed the id for content change via javascript. ?>
<option value="">Select an lastname</option>
<option value=""></option>
<?php while(list($lastname)=mysql_fetch_array($lastname_result)) {
     echo "<option value='$lastname'>$lastname</option>";
}
?>
</select>
</form>
</table>
<table id="myTable" class="tablesorter" border="0" cellpadding="5" cellspacing="1">
<thead>
<tr>
<th>First Name</th>
<th>Last Name</th>
<th>Age</th>
<th>Birthday</th>
<th>Hometown</th>
<th>Job</th>
</tr>
</thead>
<tbody id="tableBody"> <?php //added id to the tbody so we could change the content via javascript ?>

</tbody>
</table>  
<p>&nbsp;</p>
<p>&nbsp;</p>
<p align="right">&nbsp; </p>
</td>
<td width="196" valign="top">&nbsp;</td>
</tr>



</table>
</body>
</html>


table.list.php:
<?php
include('config.php');  //database connection.
if(!isset($_GET['lastname'])) { //if the proper get parameter is not there, redirect to google.
header('Location: http://google.com');
exit();
}

$lastname = preg_replace('~[^A-Za-z]+~','',$_GET['lastname']);  //strip out anything but alpha for the name.
$lastname = trim($lastname); //trim the name from all whitespace.
if($lastname != '') { //check against an empty string.  could have just used "empty()".

$where = ' WHERE lastname = \'' . $lastname . '\''; //write the where clause.
}
else { //if lastname is empty, the where clause will be to, and it will return all names.
$where = NULL;
unset($lastname);
}

$from = (isset($_GET['from'])) ? date('Y-m-d',strtotime($_GET['from'])) : NULL;
$to = (isset($_GET['to'])) ? date('Y-m-d',strtotime($_GET['to'])) : NULL;

if($from != NULL && $to != NULL) {
$where .= (isset($lastname)) ? ' AND ' : ' WHERE ';
$where .= " birthdate BETWEEN '$from' AND '$to'";
}
elseif($from != NULL) {
$where .= (isset($lastname)) ? ' AND ' : ' WHERE ';
$where .= " birthdate >= '$from'";
}
elseif($to != NULL) {
$where .= (isset($lastname)) ? ' AND ' : ' WHERE ';
$where .= " birthdate <= '$to'";
}
$query = "SELECT * FROM user $where";
$result = mysql_query($query); //get the database result.
while($row=mysql_fetch_assoc($result)){  //loop and display data.
?>
<tr>
<td><?php echo $row['firstname']; ?></td>
<td><?php echo $row['lastname']; ?></td>
<td><?php echo $row['age']; ?></td>
<td><?php echo $row['birthdate']; ?></td>
<td><?php echo $row['hometown']; ?></td>
<td><?php echo $row['job']; ?></td>
</tr>

<?php } // End while loop. ?>

This seems to be a bit of a challenge but I am creating a multiple page form and on one of the pages I have a select field. I would like the user to have the ability to select multiple options but I am using some functions to move the data in hidden fields from page to page. I don't think my functions are jiving with my my foreach loop cause I keep getting an invalid argument error.

Thanks in advance for any help.

Here is my function:

    function setSelected($fieldName, $fieldValue) {
        if(isset($_POST[$fieldName]) && $_POST[$fieldName] == $fieldValue) {
            echo 'selected="selected"';
        }
    }

And here is my loop:

    $selections = "";
   
    if(isset($_POST["selections"])) {
        foreach ($_POST["selections"] as $selection) {
            $selections .= $selection . ", ";
        }
    }

I have a Prepared Statement that runs a SELECT statement and returns 2 records, and I would like to store the Field Value for each Record into an Array.

Here is the code I usually use for queries that return just a single value...

// ******************
// Populate Form. *
// ******************

// Build query.
$q2 = "SELECT response
FROM bio_answer
WHERE member_id=?";

// Prepare statement.
$stmt2 = mysqli_prepare($dbc, $q2);

// Bind variable to query.
mysqli_stmt_bind_param($stmt2, 'i', $memberID);

// Execute query.
mysqli_stmt_execute($stmt2);

// Store results.
mysqli_stmt_store_result($stmt2);

// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt2)>0){
// Details Found.

// Bind result-set to variable.
mysqli_stmt_bind_result($stmt2, $response);

// Fetch record.
mysqli_stmt_fetch($stmt2);

// Close prepared statement.
mysqli_stmt_close($stmt2);

}else{
// Details Not Found.
$_SESSION['resultsCode'] = 'DETAILS_NOT_FOUND_2133';

// Close prepared statement.
mysqli_stmt_close($stmt2);

// Set Error Source.
$_SESSION['errorPage'] = $_SERVER['SCRIPT_NAME'];

// Redirect to Display Outcome.
header("Location: " . BASE_URL . "/members/results.php");

// End script.
exit();
}//End of POPULATE FORM



Can someone help me out with the syntax so that I get an end result like this...

$answerArray[0] = 'I want to be my own boss!!'
$answerArray[1] = 'Don't waste your time trying to do your own Taxes!'


Thanks,


Debbie

Hi all i have 2 small questions and maybe someone could help me out.
Say I have a database with a table 'users'.
This table has fields: email, name and year.

What I want to do is show at the front-end all users, by selecting them from the table, and arrange them by year in column 1 and show them as individuals in column 2. But here is the thing; if someone selects for instance year 1970 and also someone from 1970 individually, someone will be selected twice. (edit:As a side note the selecting is aimed and emailing the users, that's why selecting someone twice is not good
First question is: does anyone know how to remove doubles (maybe even triples if there is a select all button, maybe turn this around and say select only 1 instance of a user).

Second question: is this a wise way to let someone select. Right now all users are fetched, and if the table users grows this could be tricky because of the large number of users.

If someone could point me in the right direction of thinking I would be very happy, been thinking about this and scalability for quite a while now 

Hi All, I want to copy into a table values from another table that partially match a given value, case-insensitively. So far I do as follows but I wonder whether there is a quicker way.

$input_table=array('1'=>'toto','2'=>'tota','3'=>'hello','4'=>'TOTO','5'=>'toto');
$input_table_2 = array_map('strtolower', $input_table);
$value_to_look_for='Tot';
$value_to_look_for_2=strtolower($value_to_look_for);
$output_table=array();
foreach ($input_table_2 as $k=>$v)
  {
  if(false !== strpos($v, $value_to_look_for_2))
    {
    $output_table[]=$input_table[$k];
    }
}

One drawback is that $input_table_2 is 'foreached' whereas there might be no occurrences, which would lead to a loss of time/resources for big arrays.   Thanks.

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?



Thanks in advance,
Vero

Hi guys, I am trying to create a script that gets a multiple select form selections and assign them to variables with php via the POST method.

This is my code:

Code: [Select]
<select name="search_commodity[]" multiple="multiple" size="3" style="position:absolute; top:80px; left:414px; " >
<option value="all">All</option>
<option value="none">None</option>
<option value="some">Some</option>
</select>


Then after the form gets submited then it should go to this php page and the first value of the chosen options has to be assigned to the variable called commo. The problem is that is is not assigning anything.
Code: [Select]

<?php $commo = $_POST['search_commodity[0]']; ?>


Can someone help please? I can't figure it out.

hi

people can vote 3 times with 3 select menus
but i want them not to be able to choose 3x the same select option

the options in the select menus come out of the database

this is how i let them vote

Code: [Select]
<?php

include("./includes/egl_inc.php");
$secure = new secure();
$secure->secureGlobals();
session_start();

if (isset ($_GET['match'])) 
{ 

$matchid = (int)$_GET['match'];
$_SESSION['matchid'] = $matchid;
$matchmaps = mysql_fetch_array(mysql_query("SELECT maps,game FROM ffa_matches WHERE id=$matchid"));
$matchmapschecker = $matchmaps[maps];
$matchgamechecker = $matchmaps[game];

$maps=mysql_query("SELECT id,map FROM ffa_maplists where gameid = $matchgamechecker");
while(list($id,$map)=mysql_fetch_row($maps))
{ 
$maplist.="<option value='$id'>$map</option>\n";

}


  $out[body].="<table width='98%' border='0' cellspacing='0' cellpadding='0' style='border:1px solid black'>
   <tr style='color:#cccccc; background-color:black;'>
<td valign='middle' background='$config[bg2]' align='center' colspan='10'>

<br/>Choose Maps<br/>
</td>
   </tr></table><table width='98%' border='0' cellspacing='0' cellpadding='0' style='border:1px solid black'>
<tr style='background-color:black;'>
<td>
<form action='ffainsertmapvote.php' method='post'>
<select name='map1'>$maplist</select>
<select name='map2'>$maplist</select>
<select name='map3'>$maplist</select>
<input type='hidden' name='match' value='$matchid' />
<input type='submit' value='Vote' />
</form> </td>
</tr></table>";


}



include("$config[html]");
?>

do i need jquery to fix this? i dont want the user to be able to go to a next screen without having max 2 the same options selected

thanks in advance !