Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jun 2nd, 2012  |  syntax: None  |  size: 0.50 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How to use multiple mysql stored procedures on same page to populate drop down menus in php
  2. include 'connect.php';
  3. $ppty_id = mysqli_real_escape_string($link, $_GET['property_id']);
  4.  
  5. $sql = "call getPropertySubTypeByID('$ppty_id')";
  6. $result = mysqli_query($link,$sql) or die ("Error in processing query.".mysqli_error($link));
  7. echo "<option value='#'> Select Property Subtypen";
  8.  while ($row=mysqli_fetch_assoc($result))
  9.  {$id = $row['PptySubTypeID'];
  10.  $name = $row['Name'];
  11.  echo "<option value=$id>$namen";
  12.  }