In php list view how to display repeated coloumn items into a dropdown list?

Question

0.00/5 (No votes)

See more:

XML

<select>
    
        <option value="<?php echo $row['coloumn1']; ?>">
        <?php echo $row['coloumn1']; ?>
        </option>
     
</select>

this is what i have now.... and i need inside this while loop check every row value with previous all(rows) and compare. If its match means put tat group value in drop down list... Remaining value must displayed as text view....

PHP

 <form method="get" action="inc.php">
<table id="resultTable" data-responsive="table">
	<thead>
		<tr>
			<th> Product Code </th>
			<th> Product Name </th>
			<th> Qty </th>
			<th> Price </th>
		</tr>
	</thead>
	<tbody>
   
		
             while($row = mysqli_fetch_array($sres))
			 
			 //while($row!=0)
                        {			
			 
			<tr class="record">
			<input type="text" name="productcode[]" id="productcode" value="<?php echo $row['product_code']; ??>" readonly>
			<td><input type="text" name="productname[]" id="productname" value="<?php echo $row['product_name']; ??>" readonly>
                        </td>
			<td><label for="qty"></label>
			  <input type="text" name="qty[]" id="qty" value="1"></td>
			<td>
						$ppp=$row['price'];
			
			 
	            	<input type="text" name="price[]" id="price" value="<?php echo $ppp;??>" readonly>
			</td>	
							 }
			            
			<tr>
				<td colspan="4">Total:</td>
				</tr></tr></tbody></table> <br>
                <input type="submit" id="calculate" name="calculate" value="Calculate">
				
 } 
<br>
</form>

Posted 17-Apr-14 21:26pm

Arun2012

Updated 19-Apr-14 1:55am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2014-04-17T21:36:00

use a while loop to loop thru the recordsets returned from sql query and echo each row into the option of a select tag, refer: populate-drop-down-list-from-database-using-mysqli-prepared-statements[^]
+++++++++++++++++++++++++[round 2]
How do you construct dropdownlist in html? see example:

<select>
  <option value="1">pencil</option>
  <option value="2">eraser</option>
  <option value="3">paper</option>
</select>

So in your php script, you have to loop to populate the options from the recordset retrieved from the database, so use while loop, example:

XML

<?php
     while($row = mysqli_fetch_array($sres)){
?>
    <option value="<?php echo $row['product_code'] ?>">
          <?php echo $row['product_name'] ?>
     </option>
<?php
    }
?>

You php script will interwind with html to create the html output of the select dropdownlist. You got to have a good knowledge of html first so that you know how to construct them using php.