|
|
Posted by Georgi Naumov on 06/17/07 09:24
Shutey написа:
> On 17 Jun, 09:31, Georgi Naumov <gonau...@gmail.com> wrote:
> > Shutey :
> >
> >
> >
> > > I have a strange issue with dropdowns. Using php4, mySQL5, Apache 2 on
> > > a fast XP pro PC, I have a form which requires 5 dropdowns populated
> > > with indentical values. I extract the values using SQL and populate 2
> > > variables and use a for-next loop to create the dropdown. The dropdown
> > > contains some 310 items! It works beautifully if I have 1 or 2
> > > dropdowns but as soon as I add more it partially creates the 3rd and
> > > just stops until it times out!
> > > All 5 work because I have altered their positions but it always stops
> > > part way through creating the 3rd dropdown.
> >
> > > I tried an alternative method by doing away with the variables and
> > > constructing the dropdowns with a 'while' statement reading through
> > > the results of my SQL and got exactly the same problem only 2 and a
> > > bit dropdowns.
> >
> > > Stopping it running after a few seconds or several minutes makes no
> > > difference, it seems to reach a certain point and just stop - no error
> > > messages or anything!
> >
> > > I have tried increasing the resourses in my php.ini file but this also
> > > made no difference.
> >
> > > Can anyone suggest an alternative or a fix?
> >
> > > Thanks
> >
> > ..........................................................................................
> > Can you paste same code ?- Hide quoted text -
> >
> > - Show quoted text -
>
> Here's the code I am currently using, there are 4 more identical
> 'name=option2, 3, 4 and 5' but otherwise the same.
>
> $qry = 'SELECT field1, field2 ';
> $qry .= 'FROM database ';
> $qry .= 'ORDER BY field1, field2;';
>
> echo '<table border="0" cellpadding="2" cellspacing="0"><tr>';
> echo "<td>Label 1:</td>";
> echo "<td><select name='option1' size='1'>";
> echo "<option value=''></option>";
> $x = -1;
> $res = mysql_query($qry) or die("Query failed);
> while($row = mysql_fetch_array($res))
> {
> extract($row);
> $x+=1;
> $sel = '';
> if ($field1 == $ref_variable1) $sel = 'SELECTED';
> echo "<option value='" . $field1 . "' $sel>" . $field2 . "</
> option>";
> }
> echo "</select></td>";
> echo "</tr></table>";
>
> Thanks for your interest
..............................................................................
Code looks good. Do you tring to add
this in begining on your script ?
error_reporting(E_ALL);
ini_set("display_errors",1);
Tell me if it show messages.
P.P:
Sorry for my bad english.
Navigation:
[Reply to this message]
|