This is the script:

<?php
$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. you can see the results @

http://underworldlords.com/Inv.php?UserN…

It seems as if the query is returning an empty set... can anyone spot the problem?

P.S. for the admins and moderators... I can't see your site for all the ads!

$query = "SELECT type, desc FROM uwl_items WHERE holder = $User";

If holder is an string field, then you need to write quotes around $User.

$query = "SELECT type, desc FROM uwl_items WHERE holder = $User";

If holder is an string field, then you need to write quotes around $User.

I think the best tutorial you will get for PHP, MySql and javascript is from w3schools. It is a very good source for learning programming languages and it also provides the ethical ways of structured programming.

I think the best tutorial you will get for PHP, MySql and javascript is from w3schools. It is a very good source for learning programming languages and it also provides the ethical ways of structured programming.

I think the best tutorial you will get for PHP, MySql and javascript is from w3schools. It is a very good source for learning programming languages and it also provides the ethical ways of structured programming.