selectbox+database connection retrive problem
Posted on
16th Feb 2014 07:03 pm by
admin
Code: [Select]
<tr>
<th align="left" scope="col"><span class="style2 style8">Features </span></th>
<th colspan="2" align="left" scope="col"><span class="style8">
<textarea name="features" cols="30%" rows="6"></textarea>
</span></th>
<th scope="col"><span class="style8">
<select name="select">
<?php
$query="select ID, CODE from features order by ID asc";
$result=mysql_query($query);
while(list($id, $name)=mysql_fetch_row($result)) {
echo "<option value="".$id."">".$name."</option>";
}
?>
</select>
</span></th>
</tr>
hi frds...
am using same select box in 20 different place in same php page.for these i creating database connection,executing query and value display in select box.my question is ,i want write same set of code for 20 selectbox in my php page ?if it so means,my php form load very slowly because php is creating 20 different database conection on loading page.how to solve these problem??i need to creat one connection,using that one connection i should diaplay same values,20 select box in my php page any suggestion pls..
or
query="select ID, CODE from features order by ID asc";
$result=mysql_query($query);
can i store $result in any array variable.. then i can dispaly value in select box..?? suggest pls..thanks
No comments posted yet
Your Answer:
Login to answer
310
18
Other forums
check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard meth
Comma seperated implode & modifying returned string.
I have a PHP post form that posts up to 4 variables. I need whatever variables are passed to be comb
Confusing Functions
So, I've been reading up on Functions and I like them! However, I need some help using variables in
Syntax error
hi im having a little trobble with this script
-------------------------------------------------
Is there a way to override built in php functions without APD?
I am trying to use the
rename_function()
override_function()
options that are built into
Not loading image
When this function gets loaded it doesn't load the image just trying to figure out why.
Code:
POST into Array problem
Hi Chaps,
I have a repeat region, displaying rows of data: jobid, fromtable, translatorcharge
Change log of Cost centre change in Plant maintenance order
Hi,
How to view Change log of Cost centre in Plant maintenance order. Not visible thru 'Docume
Show message after entering data
Hello Colleagues
I would like to display messages after entering the data example: "
dat
extract a file from zip file
hi,
i know how to unzip a zip file in php, but is there a way to just extract a certain file only