PHP Help Needed!

NateJ Active Member

Messages:: 240

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 53

#1

The Problem I'm Having Is When I Want To Echo An Amount, It Just Echoe's "0" When The Number It's Fetching Is Not "0", Anyone Know How To Fix This?

The Piece Of Coding:

<?
$jailthem = $_POST['steal'];

if ($jailthem){
$victim = $_POST['victim'];

$biatch=mysql_query("SELECT * FROM users WHERE username='$victim'");
$bitch = mysql_num_rows($biatch);
if ($bitch != "0"){
$crimes = mysql_query("SELECT bank FROM users WHERE username='$victim'");
$vbank = mysql_fetch_object($crimes);
mysql_query("UPDATE snitch SET clear=clear-1 WHERE snitch='$username'");
mysql_query("UPDATE users SET money=money+$vbank->bank WHERE username='$username'");
echo "You Got $$vbank->bank From $victim's Bank!";
mysql_query("UPDATE users SET bank='0' WHERE username='$victim'");
}else{ echo "This User Doesn't Exist!"; }
$rand=rand(1,20);
if ($rand > 15){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` , `witness` , `witness_per` )
VALUES (
'', '$victim', '$victim', 'Your Bank Was Cleared Out By $username!', '$date', '0', '0', '0', '1', '0'
)");
}else{
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` , `witness` , `witness_per` )
VALUES (
'', '$victim', '$victim', 'Your Bank Was Cleared Out!', '$date', '0', '0', '0', '1', '0'
)");
}}
?>
Click to expand...

NateJ, Feb 5, 2009 IP

Acecool Peon

Messages:: 267

Likes Received:: 6

Best Answers:: 0

Trophy Points:: 0

#2

For starters, I hope you do not use this code in a real site...

If you do, at least use mysql_escape_string() around the variables you use to fetch data.. never trust the user input..

Also, can you tab the stuff out to make it easier to read

Acecool, Feb 5, 2009 IP

NateJ Active Member

Messages:: 240

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 53

#3

<?
$jailthem = $_POST['steal'];

if ($jailthem){
$victim = $_POST['victim'];

$biatch=mysql_query("SELECT * FROM users WHERE username='$victim'");
$bitch = mysql_num_rows($biatch);

if ($bitch != "0"){
$crimes = mysql_query("SELECT bank FROM users WHERE username='$victim'");
$vbank = mysql_fetch_object($crimes);
mysql_query("UPDATE snitch SET clear=clear-1 WHERE snitch='$username'");
mysql_query("UPDATE users SET money=money+$vbank->bank WHERE username='$username'");
echo "You Got $$vbank->bank From $victim's Bank!";
mysql_query("UPDATE users SET bank='0' WHERE username='$victim'");

}else{ echo "This User Doesn't Exist!"; }

$rand=rand(1,20);
if ($rand > 15){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` , `witness` , `witness_per` )
VALUES (
'', '$victim', '$victim', 'Your Bank Was Cleared Out By $username!', '$date', '0', '0', '0', '1', '0'
)");

}else{

mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` , `witness` , `witness_per` )
VALUES (
'', '$victim', '$victim', 'Your Bank Was Cleared Out!', '$date', '0', '0', '0', '1', '0'
)");
}}
?>
Click to expand...

If That's What You Mean By Tabbing It Out, Then There You Go

NateJ, Feb 5, 2009 IP

Log in or Sign up

PHP Help Needed!

NateJ Active Member

Acecool Peon

NateJ Active Member

Useful Searches