Trouble with php/mysql script - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Trouble with php/mysql script

SleepingTrollSleepingTroll Posts: 9Member
This is the script:

<?php
$mysqli = new mysqli("hidden", "hidden", "hidden", "hidden");

/* check connection */
if (mysqli_connect_errno()) {
echo"Connect failed: %s
", 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 "";
}
?>

The "hidden" values are correct, there are 2 rows in the table. you can see the results @

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

Comments

  • TiancrisTiancris Posts: 4Member
    $query = "SELECT type, desc FROM uwl_items WHERE holder = $User";

    If holder is an string field, then you need to write quotes around $User.
  • TiancrisTiancris Posts: 4Member
    $query = "SELECT type, desc FROM uwl_items WHERE holder = $User";

    If holder is an string field, then you need to write quotes around $User.
  • paulinetaylor8paulinetaylor8 Posts: 8Member
    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.
  • paulinetaylor8paulinetaylor8 Posts: 8Member
    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.
  • paulinetaylor8paulinetaylor8 Posts: 8Member
    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.
Sign In or Register to comment.