Re: populate pulldownbox from query [message #174083 is a reply to message #174078] |
Sat, 21 May 2011 07:29 |
Co
Messages: 75 Registered: May 2011
Karma:
|
Member |
|
|
On 21 mei, 04:44, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> On 5/20/2011 6:49 PM, Co wrote:
>
>
>
>
>
>
>
>
>
>> On 21 mei, 00:29, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>>> On 5/20/2011 6:16 PM, Jeff North wrote:
>
>>>> On 20 May 2011 20:06:38 GMT, in comp.lang.php Denis McMahon
>>>> <denis.m.f.mcma...@gmail.com>
>>>> <4dd6c9cd$0$30688$bed64...@gradwell.net> wrote:
>
>>>> > | On Fri, 20 May 2011 11:30:02 -0700, Co wrote:
>>>> > |
>>>> > |> Can anyone help me here?
>>>> > |
>>>> > | General observation, html attributes, such as the select name, option
>>>> > | values etc should be enclosed in quotes at the html level, such as one of
>>>> > | the following:
>>>> > |
>>>> > | echo "<option value='$some_var_name'>some text</value>";
>>>> > | echo "<option value=\"$some_var_name\">some text</value>";
>>>> > | echo '<option value="$some_var_name">some text</value>';
>>>> > |
>>>> > | Rgds
>>>> > |
>>>> > | Denis McMahon
>>>> Not to quibble about such a matter but you don't necessarily need
>>>> quotes around attributes (I prefer quotes as any syntax highlighting
>>>> editor will show the values up).
>
>>>> http://www.w3.org/TR/html4/intro/sgmltut.html#h-3.2.2
>>>> In certain cases, authors may specify the value of an attribute
>>>> without any quotation marks. The attribute value may only contain
>>>> letters (a-z and A-Z), digits (0-9), hyphens (ASCII decimal 45),
>>>> periods (ASCII decimal 46), underscores (ASCII decimal 95), and colons
>>>> (ASCII decimal 58). We recommend using quotation marks even when it is
>>>> possible to eliminate them.
>
>>> I believe that's why he said SHOULD, and not MUST.
>
>> sorry Jerry you lost me.
>> The form I am using this on is an profile edit page.
>> The user should get all his profile data and be able to change it and
>> save it.
>> That is why I need the value from the database along with the names
>> loaded in the listbox.
>
>> Marco
>
> Marco, that comment wasn't directed at you.
>
> Your first problem is - are you getting the correct data from the
> database? If not, you need to do that first - which is a MySQL
> question, not a PHP one (and should be asked in comp.databases.mysql).
>
> If you are getting the correct information back from the database,
> what's wrong with the partner name?
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================
I do get the right data from the database.
The listbox gets filled correctly.
It is just that the name which is currently set as partner doesn't
show in the box.
I tried to fix that with:
echo "<option value='$partner'>{$nt['rank']} {$nt['firstname']}
{$nt['lastname']}</option>";
Problem is that I cannot do it at first I have to wait until the do
while loop for filling the listbox
has run.
Marco
|
|
|