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">
Did you know?Explore Trending and Topic pages for more stories like this.
<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
array & querys help/advice.
Ok so here goes , I have a mysql database and basically here's what I need to do.
// foreach
Why will this program not run if the variables are not global?
Hey guys I have a kind of perplexing situation that is probably simple, but I can't seem to understa
Values disappear from my array :( HELP!
hey all, I have a lil mysql/php/apache script that queries a database
and pulls put 5 integers.
SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum
Redirecting Admin
In my members table, I have a field called "perm" and it's set to zero for all members. Ho
Javascript form submit and radio buttons?
When this form is submitted, it is automatically resubmitted using JS.
All my fields are carr
Why Are These Functions Causing MASSIVE Memory Problems? Please Help!
Hi,
I have a script with some options.
I use regex to replace patterns in strings, but
While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess
php title problem
Hi,
I am having a problem managing my page title with PHP.
Currently I have my <
Select question
Hi,
First I would like to say that php is pretty new for me..
so please don't shoot me if