Mysql Displaying Anything over 0

[mr_mind]

alright now did you check over that to make sure that all of the data being pulled and checked is correct. i have no idea what your table layout is and im working with what code you gave me

[Deanznet]

Checking now but stay with me

 

			$item_exists_query = mysql_query("SELECT * FROM items WHERE item_name='$item'");

 

the last part where it says $item should that be $itemID since $itemID is the name?

 

if i change it to that than it says cannot find item

[mr_mind]

no because the code

 

function item_exists($item) {

 

Defines $item as whatever is passed to it and then uses the variable data passed in the function variable

[Deanznet]

Alright, Now i get You do not have enough money

 

maybe theirs a problem now with the sql?

[mr_mind]

This is where your cash is defined. check to see if these values are correct.

 

$user_info_query = mysql_query("SELECT * FROM phpbb_users WHERE user_id='$user_id'");

$user_info_array = mysql_fetch_array($user_info_query);

$user_cash = $user_info_array['user_points'];

 

then check to see if the price of the item is correct:

 

$price_query = mysql_query("SELECT * FROM items WHERE item_name='$itemID'");

$price_array = mysql_fetch_array($price_query);

$price = $price_array['item_price'];

 

Edit: disregard what was previously in this post. it was incorrect

 

[Deanznet]

Still getting You do not have enough money

 

The money is located in the phpbb_user column in the user_points table.

 

 

[mr_mind]

NOTE: You must set $user_id as your user_d through whichever way you show the user id of the user logged in

[Deanznet]

$user_id should be the id of the user thats loged in should work fine. but it not it still says money

[mr_mind]

$user_id should be the id of the user thats loged in should work fine. but it not it still says money

 

what is the code which sets $user_id?

[Deanznet]

Im using phpbb session so its

 

$user_id = $userdata['user_id'];

 

also when i do  echo "$user_id";

 

it echos my id

 

Items price also displays in green along with stock

[mr_mind]

Sorry i looked at the error checking and the error for You ave no money was swapped with Item out of stock so check this info:

 

the query is:

 

mysql_query("SELECT * FROM items WHERE item_name='$itemID'");

 

 

and the row is:

 

item_quantity.

 

is this correct?

[Deanznet]

Im lost lol

 

here are my tables

 

CREATE TABLE `items` (
  `item_id` int( NOT NULL default '0',
  `item_desc` varchar(255) NOT NULL default '',
  `item_price` int( NOT NULL default '0',
  `item_quantity` int( NOT NULL default '0',
  `item_picture` varchar(255) NOT NULL default '',
  `item_sellback` int( NOT NULL default '0',
  `item_in_shop` tinyint(2) NOT NULL default '0',
  `item_name` varchar(255) NOT NULL default ''


  `item_id` int( NOT NULL default '0',
  `item_name` varchar(255) NOT NULL default '',
  `user_owner_id` int( NOT NULL default '0',
  `item_quantity` int( NOT NULL default '0'

And than phpbb_user with user_points 

[mr_mind]

ahh theres the mistake. the sql query had "WHERE item_name='$itemID'" and item_name should have been item_id

 

replace this line:

 

$price_query = mysql_query("SELECT * FROM items WHERE item_name='$itemID'");

 

with this line:

 

$price_query = mysql_query("SELECT * FROM items WHERE item_id='$itemID'");