
Untitled
By: a guest on
Jun 2nd, 2012 | syntax:
None | size: 0.50 KB | hits: 12 | expires: Never
How to use multiple mysql stored procedures on same page to populate drop down menus in php
include 'connect.php';
$ppty_id = mysqli_real_escape_string($link, $_GET['property_id']);
$sql = "call getPropertySubTypeByID('$ppty_id')";
$result = mysqli_query($link,$sql) or die ("Error in processing query.".mysqli_error($link));
echo "<option value='#'> Select Property Subtypen";
while ($row=mysqli_fetch_assoc($result))
{$id = $row['PptySubTypeID'];
$name = $row['Name'];
echo "<option value=$id>$namen";
}