Echoing with Database

[adeang]

this should do it.

Code:

<?php

/**
 * @author Adeang
 * @copyright 2008
 */

$con = mysql_connect("localhost","dbusername","dbpassword");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM inventory
WHERE ItemQuantity >='1'");

while($row = mysql_fetch_array($result))
  {
  echo $row['ItemName'] . " " . $row['ItemQuantity'];
  echo "<br />";
  }

?>

[adeang]

The quantity is stored as the default. 

<?php


$result = mysql_query("SELECT * FROM Armor
WHERE quantity > 1");

while($row = mysql_fetch_array($result))
  {
  
  }

?>

Is what I have, and I get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource which would be the While part.

did you forget to connect to db?

[votter]

Nothing new came up with it.  I make a table with userid as a field, itemid and itemname, right?  Then add rows so I can put all itemnames and id's in?

[adeang]

and you tried this code?

Code:

<?php

/**
 * @author Adeang
 * @copyright 2008
 */

$con = mysql_connect("localhost","dbusername","dbpassword");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM inventory
WHERE ItemQuantity >='1'");

while($row = mysql_fetch_array($result))
  {
  echo $row['ItemName'] . " " . $row['ItemQuantity'];
  echo "<br />";
  }

?>

[votter]

If I do that, then everybody will get the same echo, and it only seems to echo out the wrong thing I think.  Let me try it again.

[votter]

<?php include('stylesheet.php'); ?>
<?php include('variables.php'); ?>

<?php

$items = mysql_query("SELECT * FROM Items
WHERE ItemQuantity >= '1'");

while($items = mysql_fetch_array($items))
  {
  echo $Items['itemname'] . " " . $Items['ItemQuantity'];
  echo "<br />";
  }
mysql_error();
?>

Is what I have, and I get:

Bronze Plate 0

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in inventory.php on line 9

On the page.

[adeang]

okay so what you want to do is get the users game name and put and use it to grab their amount of items?

Code:

<?php

include_once ('stylesheet.php');
include_once ('variables.php');

//----------------CONNECTS TO DATABASE------------------------//
$con = mysql_connect("localhost","dbusername","dbpassword");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);
//------------------------------------------------------------//

$result = mysql_query("SELECT * FROM inventory WHERE username ='$username' AND WHERE ItemQuantity >='1'");

while($row = mysql_fetch_array($result))
  {
   echo $row['ItemName'] . " " . $row['ItemQuantity'];
   echo "<br />";
  }

?>

and also maybe share some more of the scripts you have made, because we have no idea what is in any of your files that you have included, because maybe in one of the included files you have included another file aka inventory.php 

[votter]

<?php

$result = mysql_query("SELECT * FROM Items WHERE ItemQuantity > 0 AND userid = '$user[id]'");
while($row = mysql_fetch_array($result))
  {
  echo $row['ItemQuantity'] . ": " . $row['ItemName'];
  echo "<br />";
  }

?>

Works now, but I was just wondering how I should create the database or databases for this to work and not have the database/s so giant.

[adeang]

well no matter what you going to have to have a db full of the items, etc, and have a place to store how much of that item a user has.

p.s. still working on it.

[votter]

Ya, I know that, just didn't know if I should use 2 or 1 database or what.  I'm adding all the items to the table today.

Or I might wait and see what others suggest.

[votter]

added itemid and  itemname to one table, and filled that out. 

[adeang]

im not an expert but I think you should use 1 db

[votter]

Ok, Just not sure then How when they register, it would add all those rows with there userid.

mysql_query("INSERT INTO `Inventory` (`userid`, `itemid`, `itemamount`) VALUES ('$user[id]', '1', '1'), ('2', '1')")
or die(mysql_error());

I just don't know how you would do this part, so would the userid be VALUES be NULL, and would the database one not be auto increment?  lol.

[votter]

I got it, thanks all for the help. .

[adeang]

awesome!!! can we see an example???

if dont know hot to setup server on comp so others can see it ask me!