Re: 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)" <php-general@phpbeginner.com> To: "'George Pitcher'" <fmdev@yahoo.co.uk>; <php-general@lists.php.net> 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:fmdev@yahoo.co.uk] Sent: mercoledì 26 settembre 2001 15.31 To: php-general@lists.php.net 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: 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 -- 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 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com