Re: Building Dynamic Value list using ohp

Also look for missing semicolons and unclosed braces in the lines above 22. -Steve On Wednesday, September 26, 2001, at 09:19 AM, Derek Mailer wrote:

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" <fmdev@yahoo.co.uk> To: <gottfried.hufnagel@gmx.at> Cc: <php-general@lists.php.net> 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: <gottfried.hufnagel@gmx.at> To: "George Pitcher" <fmdev@yahoo.co.uk> 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail:

php-list-admin@lists.php.net

-- 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list- admin@lists.php.net

************************************************************************* ********* 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net