fork download
  1. <form class="form-horizontal" role="form" method="post">
  2. <div class="form-group">
  3. <label for="inputLocation" class="col-sm-2 control-label">Location</label>
  4. <div class="col-sm-4">
  5. <?php
  6.  
  7. $queryData = mysql_query("SELECT DISTINCT cat_name as cat_name FROM 'categories' ORDER BY `cat_name`");
  8. $result = mysql_fetch_array($queryData); //$result now has database tables
  9. ?>
  10. <select name='cat_name'>
  11. <?php
  12. foreach($result as $row)
  13. {
  14. ?>
  15. <option values=<?php echo($row['cat_name']); ?><?php echo($row['cat_name']); ?></option>
  16. <?php
  17. }
  18. ?> </select>
  19.  
  20. </div>
  21. </div>
  22. </form>
Runtime error #stdin #stdout #stderr 0.03s 52480KB
stdin
Standard input is empty
stdout
<form class="form-horizontal" role="form" method="post">
    <div class="form-group">
        <label for="inputLocation" class="col-sm-2 control-label">Location</label>
        <div class="col-sm-4">
stderr
PHP Fatal error:  Call to undefined function mysql_query() in /home/ZDQXNe/prog.php on line 7