[RESOLVED] Buying items from store

Sacreed

Ok, so am trying to make it where that if you have over 5 coins on you that you can buy a wooden sword but I keep getting a white page and am tired and tired of looking for the error. I know my code may be wrong but hey, am fixing it up as I go,yes it may be sloppy to but like I said earlier, am fixing it up as I go. Here is my code:


<?php include("session.php"); ?>
<?php
$username="";
$password="";
$database="";

$username=$_POST['user'];
$password=$_POST['pass'];
$weapon= 'Wooden Sword';
$coins=5;
$con = mysql_connect("","","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("", $con);

$result = mysql_query("SELECT * FROM userslogin WHERE `coins`= '" . $coins . "'");
if ($row != mysql_fetch_array($result))
  {
  echo "You need at least 5 coins to buy this item.";
  }
	if($row <= mysql_fetch_array($sql))
	{
	$row=("DELETE FROM `userslogin` WHERE `coins`= '" . $coins . "')";
	$row=("INSERT INTO `userslogin` (weapons) VALUES ('$_POST[weapon]')";

  if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "You have just bought a Wooden Sword!";
  }
mysql_close($con);
?>
<html>
<head>
<title>Buy</title>
</head>
<?php include("morelinks.php"); ?>
</body>
</html>

Thanks in advance!

dagon

you don't run your queries, you assign (overwrite) them to a variable(which is already in use for the loop iterator).

Sacreed

Can you show me what am doing wrong? Sorry am not all in it atm lol. Btw, thanks in advance bud 😃

dagon

after 41 posts i have faith that you can work it out for yourself based on the information i provided.

Krik

I think dagon was saying YIKES! And to avoid having his head spin off his shoulders he made a quick post and ran outside to scream. :p Ok he probably didn't do that, but I am almost positive I heard a large number of heads simultaneously hitting keyboards right about the time you posted. 😃

if ($row != mysql_fetch_array($result))
  {
  echo "You need at least 5 coins to buy this item.";
  }
	if($row <= mysql_fetch_array($sql))
	{
	$row=("DELETE FROM `userslogin` WHERE `coins`= '" . $coins . "')";
	$row=("INSERT INTO `userslogin` (weapons) VALUES ('$_POST[weapon]')";

  if (!mysql_query($sql,$con))

Explain what each of those lines is doing. Not what you want them to do but what they are doing???

I assure you it is a far cry from what you want. Basically what dagon said is what is happening.

There are several fundamental mistakes, and you just need to read up on working with queries, you can start at [man]mysql_query[/man] in the php manual.

Even now I can't believe what I am looking at. Having seen bits an piece of the project you are working on and based on the complexity level of such a project I can not believe you have made it this far and not understand the fundamentals that makes the above code so egregiously messed up.

I think its time to end my post and go outside and scream, just joking.

Sacreed

Haha funny 😃 but I fixed it(well, working on something else atm but I know how to fix it). Tell me, what am I currently working on =D? I was tired when I coded that..and I actually seen how bad it was myself. Also, I was using INSERT instead of UPDATE(no one caught that haha!). But ya..am pretty good when am not tired lol =D