oops...I was going to add...
2) -
$result = mysql_query($query, $mysql_link);
doesn't require the $mysql_link argument, try
$result = mysql_query($query);
Another general comment is that you have copied a bit of your code that
seems to include the root password to mysql. Not a good idea - you should
check and edit your code if necessary before posting.
Hope this helps - good luck
Derek
----- 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]
