es que en la tabla de usuarios hay insert el id de la plataforma
y en la plataforma es que esta el text para mostrar como podrá hacerlo
este eror me tiro
xml-user-manager ver="1.0"><br/><b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>C:\AppServ\www\userxml\userxml.php</b> on line <b>19</b><br/></xml-user-manager>
y tengo esto
Código PHP:
Ver original<?php
$dbhost = "localhost";
$dbname = "sdr";
$dbuser = "csdm";
$dbpass = "seeeemdm";
$charset = "utf-8";
$conn = @mysql_connect($dbhost,$dbuser,$dbpass) or
die ("ERROR! No connection to database!"); $usql = mysql_query("SELECT U.* FROM usuarios U LEFT JOIN plataforma P ON (U.IDUsuario = P.userID) WHERE U.Suspender = '0' AND U.Baneado = '0'
AND U.Baja = '0'
AND P.IDPlataforma
ORDER BY U.IDUsuario ASC");
header("Content-type: text/xml; charset=".$charset); print("<xml-user-manager ver=\"1.0\">\n");
if ($_Suspender == "1") {
$status = "1";
$_EnabledCambios = "false";
} else {
$status = "0";
$_EnabledCambios = "true";
}
if ($_Baneado == "1") {
$status = "1";
$_EnabledCambios = "false";
} else {
$status = "0";
$_EnabledCambios = "true";
}
if ($_Baja == "1") {
$status = "1";
$_EnabledCambios = "false";
} else {
$status = "0";
$_EnabledCambios = "true";
}
if ($line["Clave"] == "") {
$name = "";
} else {
$name = "name=\"".$line["Clave"]."\" ";
}
if ($line["Password"] == "") {
$password = "";
} else {
$password = "password=\"".$line["Password"]."\" ";
}
if ($line["Usuario"] == "") {
$displayname = "";
} else {
$displayname= "display-name=\"".$line["Usuario"]."\" ";
}
if ($line["IDPlataforma"] == "") {
$profiles = "";
} else {
$profiles = "profiles=\"".$line["IDPlataforma"]."\" ";
}
if ($line["maxconnections"] == "") {
$maxconnections = "";
} else {
$maxconnections = "max-connections=\"".$line["maxconnections"]."\" ";
}
if ($line["Suspender"] == "") {
$enabled = "";
} else {
$enabled = "enabled=\"".$_EnabledCambios."\" ";
}
print("<user ".$name.$password.$displayname.$profiles.$maxconnections.$enabled."/>\n");
}
print("</xml-user-manager>");
?>