";
echo "";
$sql = "SELECT * from gui_mb_user JOIN gui ON gui.gui_id = gui_mb_user.fkey_gui_id WHERE ";
$sql .= "gui.gui_public = 1 AND gui_mb_user.fkey_mb_user_id = $1 AND gui_mb_user.mb_user_type = 'owner' Order BY fkey_gui_id ";
$v = array($mb_user_id,);
$t = array('i',);
$res = db_prep_query($sql,$v,$t);
$count=0;
while($row = db_fetch_array($res)){
$gui_id[$count]=$row["gui_id"];
$gui_name[$count]=$row["gui_name"];
$gui_description[$count]=$row["gui_description"];
$count++;
}
echo"";
echo " | ";
echo "";
$sql = "SELECT * from gui_wms JOIN gui ON gui_wms.fkey_gui_id = gui.gui_id JOIN wms ON ";
$sql .= "gui_wms.fkey_wms_id = wms.wms_id AND gui_wms.fkey_gui_id=gui.gui_id WHERE gui.gui_id = $1 ORDER BY gui_wms_position";
$v = array($selected_gui_id);
$t = array('s');
$res = db_prep_query($sql,$v,$t);
$count_wms = 0;
echo "";
echo " | ";
echo "";
echo "
";
echo "";
echo "
";
echo "";
echo "";
echo " | ";
echo "
";
echo "