A couple of things about the code...
1) -
mysql_connect ('localhost', 'root', 'monty');
should be
$mysql_link = mysql_connect ('localhost', 'root', 'monty');
2) -
You only pass
you can read more about it all and copy and adapt the code snippter from
http://www.php.net/manual/en/ref.mysql.php
----- Original Message -----
From: "George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 2:54 PM
Subject: Re: [PHP] Building Dynamic Value list using ohp
> Thanks Gottfried, but that doesn't change the response I get.
>
> Any more suggestions.
>
> George P in Edinburgh
>
> PS I am hoping to come over to Frankfurt for the conference in November
> (boss might pay)
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: "George Pitcher" <[EMAIL PROTECTED]>
> Sent: Wednesday, September 26, 2001 2:46 PM
> Subject: Re: [PHP] Building Dynamic Value list using ohp
>
>
> > hi!
> >
> > try:
> >
> > $query = "select HEI from heronuser"; // line 22
> >
> > greetinx!
> > gottfried
> >
> > > 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]
> > >
> >
> > --
> > GMX - Die Kommunikationsplattform im Internet.
> > http://www.gmx.net
>
>
> _________________________________________________________
> 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]
