Derek,
That worked a treat - not to try and get the flatness out of my head - that
wall was hard!
What still has me stumped is that as far as the query-building goes, both
methods are pretty much the same yet yours doesn't generate the error yet
mine does????
Prepare yourselves as this is the login page to a system which at present
runs to 45 pages of Lasso?Filemaker coding which I'm hoping to convert to
PHP/MySQL (or MS-SQL as we have that and DB2 too).
Thanks again
George
----- Original Message -----
From: "Derek Mailer" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 4:14 PM
Subject: Re: [PHP] Building Dynamic Value list using ohp
> what's the error you're getting now?
>
> if you aren't getting any error, but it just isn't working try something
> like...(note that I haven't tested this code).
>
> $drop_down_list = "<select name=\"select\">";
>
> $link = mysql_connect ('localhost', '****', '****')
> or die ("Could not select db");
> mysql_select_db ('Heronsql')
> or die ("Could not connect");
> $query="select distinct HEI from heronuser";
> $result = mysql_query ($query);
> $num = mysql_num_rows($result);
> for ($i = 0; $i < $num; $i++) {
> $HEI = mysql_result($result, $i, "HEI");
> $drop_down_list .= "<option value=\"$HEI\">$HEI</option>";
> }
> mysql_close($link);
>
> $drop_down_list .= "</select>";
>
> echo "$drop_down_list";
>
>
> Cheers the noo,
>
> Derek
>
> ----- Original Message -----
> From: "George Pitcher" <[EMAIL PROTECTED]>
> To: "Maxim Maletsky (PHPBeginner.com)" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Wednesday, September 26, 2001 3:42 PM
> Subject: Re: [PHP] Building Dynamic Value list using ohp
>
>
> > Thanks for everyone's help but this is still failing to work.
> >
> > Revised code is:
> >
> > <?php
> > $link = mysql_connect ('localhost', '****', '****')
> > or die ("Could not select db");
> > mysql_select_db ('Heronsql')
> > or die ("Could not connect");
> > $query="select distinct HEI from heronuser";
> > $result = mysql_query ($query); // I've also tried with ($query,
$link)
> > if(mysql_num_rows($result)) {
> > // show all HEIs as options in select form
> > while($row = mysql_fetch_row($result))
> > {
> > print("<option value=\"{$row[0]}\">{$row[0]}</option>");
> > }
> > }
> > mysql_close($link);
> > ?>
> >
> > Any more suggestions (please)?
> >
> > George
> > ----- Original Message -----
> > From: "Maxim Maletsky (PHPBeginner.com)" <[EMAIL PROTECTED]>
> > To: "'George Pitcher'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 26, 2001 3:17 PM
> > Subject: RE: [PHP] Building Dynamic Value list using ohp
> >
> >
> >
> > 1. this:
> > print("<option value=\"$row[0]\">$row[0]</option>");
> > should be this:
> > print("<option value=\"{$row[0]}\">{$row[0]}</option>");
> > or like this:
> > echo '<option value="'.$row[0].'">'.$row[0].'</option>');
> >
> > The reason for it is that within double quote you can parse for 'simple'
> > variables only (es: $var, not $var[]). Otherwise it gives you a parse
> > error.
> >
> > 2. this:
> > mysql_connect ('localhost', 'root', 'monty');
> > better be this:
> > mysql_connect ('localhost', '****', '****'); // for security
> > reasons obviously, you don't wanna give the password our to the group,
> > even so it is your local server (you might not be original with the
> > password on production machines, no?)
> >
> >
> > Hope it helps,
> > Maxim Maletsky
> >
> > PHPBeginner.com
> >
> >
> >
> >
> > -----Original Message-----
> > From: George Pitcher [mailto:[EMAIL PROTECTED]]
> > Sent: mercoledì 26 settembre 2001 15.31
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] Building Dynamic Value list using ohp
> >
> >
> > Hi all,
> >
> > I'm having a problem with dynamically building a value list.
> >
> > My code:
> >
> > <?php
> > mysql_connect ('localhost', 'root', 'monty');
> > mysql_select_db ('Heronsql');
> > $query = ("select HEI from heronuser"); // LINE 22 on original script
> > $result = mysql_query($query, $mysql_link);
> > if(mysql_num_rows($result)) {
> > // show all HEIs as options in select form
> > while($row = mysql_fetch_row($result))
> > {
> > print("<option value=\"$row[0]\">$row[0]</option>");
> > }
> > }
> > ?>
> >
> > But this generates:
> >
> > "Parse error: parse error in c:\program files\apache
> > group\apache\htdocs\bizflyers\login.php on line 22"
> >
> > Any suggestions?
> >
> > Regards
> >
> > George
> >
> >
> >
> > _________________________________________________________
> >
> > Do You Yahoo!?
> >
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED] To
> > contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>
>
****************************************************************************
******
> This e-mail (and any attachment) is intended only for the attention
> of the addressee(s). Its unauthorised use, disclosure, storage
> or copying is not permitted. If you are not the intended recipient,
> please destroy all copies and inform the sender by return e-mail.
> This e-mail (whether you are the sender or the recipient) may be
> monitored, recorded and retained by Business Information
> Publications Limited (BiP). E-mail monitoring/ blocking software
> may be used, and e-mail content may be read at any time.You
> have a responsibility to ensure laws are not broken when composing
> or forwarding e-mails and their contents.
>
****************************************************************************
******
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
