foreach giver fejle
Hej :)Jeg har fået lavet et script som henter data fra mysql. har rettet i et eksisterene script.
Men jeg får følende fejl:
Warning: mysql_fetch_assoc(): 3 is not a valid MySQL result resource in /home/www/30stm.dk/v2/test.php on line 68
Mit script er:
<?php require_once('../Connections/loginserver.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$colname_users = $_GET['testid'];
mysql_select_db($database_loginserver, $loginserver);
$query_users = sprintf("SELECT * FROM `30stm_info` WHERE username LIKE %s ORDER BY username ASC", GetSQLValueString($colname_users . "%", "text"));
$users = mysql_query($query_users, $loginserver) or die(mysql_error());
$row_users = mysql_fetch_assoc($users);
$totalRows_users = mysql_num_rows($users);
?>
<?php
mysql_free_result($users);
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header ("Pragma: no-cache"); // HTTP/1.0
if (isset($_REQUEST['json']))
{
header("Content-Type: application/json");
echo "{\"results\": [";
for ($i=0;$i<count($aResults);$i++)
{
echo "{\"id\": \"".$aResults[$i]['id']."\", \"value\": \"".$row_users['username']."}";
}
echo "]}";
}
else
{
header("Content-Type: text/xml");
echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?><results>";
$i = 1;
do {
echo "<rs id=\"".$i++."\" value=\"".$row_users['username']."\">".$row_users['username']."</rs>";
} while ($row_users = mysql_fetch_assoc($users));
echo "</results>";
}
?>
håber i kan hjælpe mig.
