November 4th, 2012, 02:33 PM
|
|
Registered User
|
|
Join Date: Nov 2012
Posts: 5
Time spent in forums: 1 h 6 m 20 sec
Reputation Power: 0
|
|
|
Trouble with php/mysql script
This is the script:
PHP Code:
$mysqli = new mysqli("hidden", "hidden", "hidden", "hidden");
/* check connection */
if (mysqli_connect_errno()) {
echo"Connect failed: %s\n", mysqli_connect_error();
exit();
}
$User = $_REQUEST['UserName'];
$query = "SELECT type, desc FROM uwl_items WHERE holder = $User";
echo $query;
$result = $mysqli->query($query);
echo $result;
while($row = mysqli_fetch_array($result, MYSQLI_NUM))
{
echo "<a></a>";
}
The "hidden" values are correct, there are 2 rows in the table.
It seems as if the query is returning an empty set... can anyone spot the problem?
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
