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

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

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.