Warning: mysql_fetch_array(): supplied argument is not a val

racemaster

Registered
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/****.awardspace.info/market.php on line 52
Нямаш достатъчно кредита!

Код:
 <?
include 'header.php';
?>
<html>
<head>
<title></title>
<style type="text/css">
a
{
   color: #FFFFFF;
}
a:visited
{
   color: #FFFFFF;
}
a:active
{
   color: #FFFFFF;
}
a:hover
{
   color: #FFFF00;
}
</style>
</head>
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF">
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left">
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div>
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center">
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div>
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left">

<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br>
<?php
if($_SESSION['id']) {
$name = $_SESSION['id'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$points = '50'; $credits = '5';}
if($id == 2){$points = '100'; $credits = '10';}
if($id == 3){$points = '150'; $credits = '15';}
if($id == 4){$points = '200'; $credits = '20';}
if($id == 5){$points = '250'; $credits = '25';}
if($id == 6){$points = '300'; $creditst = '30';}



$sql = "SELECT * FROM street-users WHERE username = '$username'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['credits'] < $credits) { echo ' <center> Нямаш достатъчно кредита! <br>   <center> '; } else {



$credits = ($my['credits'] - $credits);
$points = ($my['points'] + $points);
if($nrgy > $my['maxnrg']) { $nrgy = $my['maxnrg']; }



$sql = "UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'";
if(mysql_query($sql)) { echo " <center> Успешно зареди $enrg точки!   <center> "; }}} else { ?>
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>   
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>  
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>  
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>  
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>  
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>  
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div>
</body>
</html>

52 ред
$my = mysql_fetch_array($do);
 
Код:
 <? 
include 'header.php'; 
?> 
<html> 
<head> 
<title></title> 
<style type="text/css"> 
a 
{ 
   color: #FFFFFF; 
} 
a:visited 
{ 
   color: #FFFFFF; 
} 
a:active 
{ 
   color: #FFFFFF; 
} 
a:hover 
{ 
   color: #FFFF00; 
} 
</style> 
</head> 
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF"> 
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left"> 
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div> 
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center"> 
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div> 
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left"> 
 
<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS"> 
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;"> 
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br> 
<?php 
if($_SESSION['id']) { 
$name = $_SESSION['id']; 
if(isset($_GET['id'])) { 
$id = htmlspecialchars($_GET['id']); 
if($id == 1){$points = '50'; $credits = '5';} 
if($id == 2){$points = '100'; $credits = '10';} 
if($id == 3){$points = '150'; $credits = '15';} 
if($id == 4){$points = '200'; $credits = '20';} 
if($id == 5){$points = '250'; $credits = '25';} 
if($id == 6){$points = '300'; $creditst = '30';} 



$sql=mysql_query("SELECT * FROM street-users WHERE username = '$username'");
$my=mysql_fetch_array($sql); 
if($my['credits'] < $credits) { echo ' <center> Нямаш достатъчно кредита! <br>   <center> '; } else { 



$credits = ($my['credits'] - $credits); 
$points = ($my['points'] + $points); 
if($nrgy > $my['maxnrg']) { $nrgy = $my['maxnrg']; } 



$sql = "UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'"; 
if(mysql_query($sql)) { echo " <center> Успешно зареди $enrg точки!   <center> "; }}} else { ?> 
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>    
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>   
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>   
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>   
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>   
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>   
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div> 
</body> 
</html>
 
justspy каза:
Код:
 <? 
include 'header.php'; 
?> 
<html> 
<head> 
<title></title> 
<style type="text/css"> 
a 
{ 
   color: #FFFFFF; 
} 
a:visited 
{ 
   color: #FFFFFF; 
} 
a:active 
{ 
   color: #FFFFFF; 
} 
a:hover 
{ 
   color: #FFFF00; 
} 
</style> 
</head> 
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF"> 
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left"> 
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div> 
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center"> 
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div> 
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left"> 
 
<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS"> 
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;"> 
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br> 
<?php 
if($_SESSION['id']) { 
$name = $_SESSION['id']; 
if(isset($_GET['id'])) { 
$id = htmlspecialchars($_GET['id']); 
if($id == 1){$points = '50'; $credits = '5';} 
if($id == 2){$points = '100'; $credits = '10';} 
if($id == 3){$points = '150'; $credits = '15';} 
if($id == 4){$points = '200'; $credits = '20';} 
if($id == 5){$points = '250'; $credits = '25';} 
if($id == 6){$points = '300'; $creditst = '30';} 



$sql=mysql_query("SELECT * FROM street-users WHERE username = '$username'");
$my=mysql_fetch_array($sql); 
if($my['credits'] < $credits) { echo ' <center> Нямаш достатъчно кредита! <br>   <center> '; } else { 



$credits = ($my['credits'] - $credits); 
$points = ($my['points'] + $points); 
if($nrgy > $my['maxnrg']) { $nrgy = $my['maxnrg']; } 



$sql = "UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'"; 
if(mysql_query($sql)) { echo " <center> Успешно зареди $enrg точки!   <center> "; }}} else { ?> 
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>    
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>   
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>   
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>   
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>   
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>   
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div> 
</body> 
</html>
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/street-racing.awardspace.info/market.php on line 51
Нямаш достатъчно кредита!
 
Нещо не се вижда къде си дефинирал $username.
За сметка на това пък, имаш дефиниран $name. Пробвай с тази променлива.
 
Код:
 <? 
include 'header.php'; 
?> 
<html> 
<head> 
<title></title> 
<style type="text/css"> 
a 
{ 
   color: #FFFFFF; 
} 
a:visited 
{ 
   color: #FFFFFF; 
} 
a:active 
{ 
   color: #FFFFFF; 
} 
a:hover 
{ 
   color: #FFFF00; 
} 
</style> 
</head> 
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF"> 
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left"> 
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div> 
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center"> 
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div> 
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left"> 
 
<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS"> 
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;"> 
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br> 
<?php 
if($_SESSION['id']) { 
$name = $_SESSION['id']; 
if(isset($_GET['id'])) { 
$id = htmlspecialchars($_GET['id']); 
if($id == 1){$points = '50'; $credits = '5';} 
if($id == 2){$points = '100'; $credits = '10';} 
if($id == 3){$points = '150'; $credits = '15';} 
if($id == 4){$points = '200'; $credits = '20';} 
if($id == 5){$points = '250'; $credits = '25';} 
if($id == 6){$points = '300'; $creditst = '30';} 



$sql=mysql_query("SELECT * FROM street-users WHERE username = '$name'") or die(mysql_error());;
$my=mysql_fetch_array($sql); 
if($my['credits'] < $credits) { echo ' <center> Нямаш достатъчно кредита! <br>   <center> '; } else { 



$credits = ($my['credits'] - $credits); 
$points = ($my['points'] + $points); 
if($nrgy > $my['maxnrg']) { $nrgy = $my['maxnrg']; } 



$sql2=mysql_query("UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'") or die(mysql_error()); 
if ($sql2) { echo " <center> Успешно зареди $enrg точки!   <center> "; }}} else { ?> 
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>    
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>   
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>   
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>   
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>   
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>   
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div> 
</body> 
</html>
 
<?
include 'header.php';
?>
<html>
<head>
<title></title>
<style type="text/css">
a
{
color: #FFFFFF;
}
a:visited
{
color: #FFFFFF;
}
a:active
{
color: #FFFFFF;
}
a:hover
{
color: #FFFF00;
}
</style>
</head>
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF">
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left">
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div>
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center">
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div>
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left">

<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br>
<?php
if($_SESSION['id']) {
$name = $_SESSION['id'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$points = '50'; $credits = '5';}
if($id == 2){$points = '100'; $credits = '10';}
if($id == 3){$points = '150'; $credits = '15';}
if($id == 4){$points = '200'; $credits = '20';}
if($id == 5){$points = '250'; $credits = '25';}
if($id == 6){$points = '300'; $creditst = '30';}


echo('$username = "'.$username.'";');exit;
$sql = "SELECT * FROM street-users WHERE username = '$username'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['credits'] < $credits) { echo ' <center> Нямаш достатъчно кредита! <br>   <center> '; } else {



$credits = ($my['credits'] - $credits);
$points = ($my['points'] + $points);
if($nrgy > $my['maxnrg']) { $nrgy = $my['maxnrg']; }



$sql = "UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'";
if(mysql_query($sql)) { echo " <center> Успешно зареди $enrg точки!   <center> "; }}} else { ?>
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>  
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>  
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>  
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>  
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>  
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>  
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div>
</body>
</html>

Я кажи какво ти изкарва :)
 
xlebabarov каза:
<?
include 'header.php';
?>
<html>
<head>
<title></title>
<style type="text/css">
a
{
color: #FFFFFF;
}
a:visited
{
color: #FFFFFF;
}
a:active
{
color: #FFFFFF;
}
a:hover
{
color: #FFFF00;
}
</style>
</head>
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF">
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left">
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div>
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center">
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div>
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left">

<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br>
<?php
if($_SESSION['id']) {
$name = $_SESSION['id'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$points = '50'; $credits = '5';}
if($id == 2){$points = '100'; $credits = '10';}
if($id == 3){$points = '150'; $credits = '15';}
if($id == 4){$points = '200'; $credits = '20';}
if($id == 5){$points = '250'; $credits = '25';}
if($id == 6){$points = '300'; $creditst = '30';}


echo('$username = "'.$username.'";');exit;
$sql = "SELECT * FROM street-users WHERE username = '$username'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['credits'] < $credits) { echo ' <center> Нямаш достатъчно кредита! <br>   <center> '; } else {



$credits = ($my['credits'] - $credits);
$points = ($my['points'] + $points);
if($nrgy > $my['maxnrg']) { $nrgy = $my['maxnrg']; }



$sql = "UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'";
if(mysql_query($sql)) { echo " <center> Успешно зареди $enrg точки!   <center> "; }}} else { ?>
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>  
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>  
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>  
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>  
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>  
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>  
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div>
</body>
</html>

Я кажи какво ти изкарва :)

Сега излиза това $username = "";
 
Именно това си мислех. $username не е зададен никъде, за това не може да ти се изпълни заявката.

Опитай се да зададеш $username = потребителско име Сесии ли използваш? Ако да, то да речем, че потребителското име се запаметява в $_SESSION['username'];

Тогава замени в кода, който ти дадох този ред:


<?
include 'header.php';
?>
<html>
<head>
<title></title>
<style type="text/css">
a
{
color: #FFFFFF;
}
a:visited
{
color: #FFFFFF;
}
a:active
{
color: #FFFFFF;
}
a:hover
{
color: #FFFF00;
}
</style>
</head>
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF">
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left">
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div>
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center">
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div>
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left">

<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br>
<?php
if($_SESSION['id'] && $_SESSION['username']) {
$name = $_SESSION['id'];
$username = $_SESSION['username'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$points = '50'; $credits = '5';}
if($id == 2){$points = '100'; $credits = '10';}
if($id == 3){$points = '150'; $credits = '15';}
if($id == 4){$points = '200'; $credits = '20';}
if($id == 5){$points = '250'; $credits = '25';}
if($id == 6){$points = '300'; $creditst = '30';}



$sql = "SELECT * FROM street-users WHERE username = '$username'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['credits'] < $credits) { echo ' <center> Нямаш достатъчно кредита! <br>   <center> '; } else {



$credits = ($my['credits'] - $credits);
$points = ($my['points'] + $points);
if($nrgy > $my['maxnrg']) { $nrgy = $my['maxnrg']; }



$sql = "UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'";
if(mysql_query($sql)) { echo " <center> Успешно зареди $enrg точки!   <center> "; }}} else { ?>
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>  
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>  
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>  
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>  
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>  
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>  
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div>
</body>
</html>

Естествено, ако го оставиш по този начин, скрипта ще ти е бая незащитен... Защитата я оставям на теб :lol:
 
xlebabarov
Код:
 <center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br>

<?php
if($_SESSION['id'] && $_SESSION['id']) {
$name = $_SESSION['id'];
$username = $_SESSION['id'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$points = '50'; $credits = '5';}
if($id == 2){$points = '100'; $credits = '10';}
if($id == 3){$points = '150'; $credits = '15';}
if($id == 4){$points = '200'; $credits = '20';}
if($id == 5){$points = '250'; $credits = '25';}
if($id == 6){$points = '300'; $creditst = '30';}



$sql = "SELECT * FROM street-users WHERE username = '$username'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['credits'] < $credits) { echo ' <center> Нямаш достатъчно кредита! <br>   <center> '; } else {



$credits = ($my['credits'] - $credits);
$points = ($my['points'] + $points);
if($nrgy > $my['maxnrg']) { $nrgy = $my['maxnrg']; }



$sql = "UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'";
if(mysql_query($sql)) { echo " <center> Успешно зареди $enrg точки!   <center> "; }}} else { ?>
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>  
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>  
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>  
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>  
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>  
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>  
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?>
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/street-racing.awardspace.info/market.php on line 54
Нямаш достатъчно кредита!
 
racemaster каза:
xlebabarov
Код:
 <center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br>

<?php
if($_SESSION['id'] && $_SESSION['id']) {
$name = $_SESSION['id'];
$username = $_SESSION['id'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$points = '50'; $credits = '5';}
if($id == 2){$points = '100'; $credits = '10';}
if($id == 3){$points = '150'; $credits = '15';}
if($id == 4){$points = '200'; $credits = '20';}
if($id == 5){$points = '250'; $credits = '25';}
if($id == 6){$points = '300'; $creditst = '30';}



$sql = "SELECT * FROM street-users WHERE username = '$username'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['credits'] < $credits) { echo ' <center> Нямаш достатъчно кредита! <br>   <center> '; } else {



$credits = ($my['credits'] - $credits);
$points = ($my['points'] + $points);
if($nrgy > $my['maxnrg']) { $nrgy = $my['maxnrg']; }



$sql = "UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'";
if(mysql_query($sql)) { echo " <center> Успешно зареди $enrg точки!   <center> "; }}} else { ?>
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>  
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>  
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>  
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>  
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>  
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>  
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?>
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/street-racing.awardspace.info/market.php on line 54
Нямаш достатъчно кредита!

Е пич въобще това ли е market.php? та това дето си дал е 42 реда каде 54 ред е грешката, малко се замисли
 
Код:
	 <?
include 'header.php';
?>
<html>
<head>
<title></title>
<style type="text/css">
a
{
   color: #FFFFFF;
}
a:visited
{
   color: #FFFFFF;
}
a:active
{
   color: #FFFFFF;
}
a:hover
{
   color: #FFFF00;
}
</style>
</head>
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF">
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left">
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div>
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center">
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div>
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left">

<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br>
<?php
if($_SESSION['id']) {
$name = $_SESSION['id'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$points = '50'; $credits = '5';}
if($id == 2){$points = '100'; $credits = '10';}
if($id == 3){$points = '150'; $credits = '15';}
if($id == 4){$points = '200'; $credits = '20';}
if($id == 5){$points = '250'; $credits = '25';}
if($id == 6){$points = '300'; $creditst = '30';}



$sql=mysql_query("SELECT * FROM `street-users` WHERE `username` = '$name'") or die(mysql_error());
$my=mysql_fetch_array($sql);





if($my['credits'] < $credits)
{ 
echo ' <center> Нямаш достатъчно кредита! <br>   <center>'; 
} 
else 
{

$credits = ($my['credits'] - $credits);
$points = ($my['points'] + $points);
if($nrgy > $my['maxnrg']) 
{
$nrgy = $my['maxnrg']; 
}


$sql2=mysql_query("UPDATE street-users SET credits = '$credits', points = '$points' WHERE username = '$username'") or die(mysql_error());
if ($sql2) 
{ 
echo " <center> Успешно зареди $enrg точки!   <center> "; 
}
}
} else { ?>
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>   
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>  
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>  
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>  
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>  
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>  
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div>
</body>
</html>
 
като натисна да си купа 50 точки ми излиза ей тва
Код:
Нямаш достатъчно кредита!
а ги имам а на останалите
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-users SET credits = '-10', points = '100' WHERE username = ''' at line 1
 
Код:
    <?
include 'header.php';
?>
<html>
<head>
<title></title>
<style type="text/css">
a
{
   color: #FFFFFF;
}
a:visited
{
   color: #FFFFFF;
}
a:active
{
   color: #FFFFFF;
}
a:hover
{
   color: #FFFF00;
}
</style>
</head>
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF">
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left">
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div>
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center">
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div>
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left">

<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br>
<?php
if($_SESSION['id']) {
$name = $_SESSION['id'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$points = '50'; $credits = '5';}
if($id == 2){$points = '100'; $credits = '10';}
if($id == 3){$points = '150'; $credits = '15';}
if($id == 4){$points = '200'; $credits = '20';}
if($id == 5){$points = '250'; $credits = '25';}
if($id == 6){$points = '300'; $creditst = '30';}



$sql=mysql_query("SELECT * FROM `street-users` WHERE `username` = '$name'") or die(mysql_error());
$my=mysql_fetch_array($sql);





if($my['credits'] < $credits)
{
echo ' <center> Нямаш достатъчно кредита! <br>   <center>';
}
else
{

$credits = $my['credits'] - $credits;
$points = $my['points'] + $points;
if($nrgy > $my['maxnrg'])
{
$nrgy = $my['maxnrg'];
}


$sql2=mysql_query("UPDATE `street-users` SET `credits` = '$credits', `points` = '$points' WHERE `username` = '$username'") or die(mysql_error());
if ($sql2)
{
echo " <center> Успешно зареди $enrg точки!   <center> ";
}
}
} else { ?>
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>   
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>  
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>  
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>  
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>  
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>  
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div>
</body>
</html>
 
на всички нямаш достатачно кредита а на последното заредихте успешно но не ъпдейтва таблицата в points и не взима от таблицата credits
 
Код:
    <?
include 'header.php';
?>
<html>
<head>
<title></title>
<style type="text/css">
a
{
   color: #FFFFFF;
}
a:visited
{
   color: #FFFFFF;
}
a:active
{
   color: #FFFFFF;
}
a:hover
{
   color: #FFFF00;
}
</style>
</head>
<body background="images/img4.png" bgcolor="#FFFFFF" text="#FFFFFF">
<div id="wb_Image1" style="overflow:hidden;position:absolute;left:205px;top:172px;z-index:0" align="left">
<img src="images/img2.png" id="Image1" alt="" align="top" border="0" style="width:616px;height:22px;"></div>
<div id="wb_Text3" style="position:absolute;left:208px;top:171px;width:611px;height:23px;z-index:1;" align="center">
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">Магазин</font></div>
<div id="wb_Html2" style="position:absolute;left:205px;top:194px;width:616px;height:229px;z-index:2;" align="left">

<center> <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="wb_Table2" style="position:absolute;width:616px;background-image:url(images/img3.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="Table2"> <br>
<?php
if($_SESSION['id']) {
$name = $_SESSION['id'];
if(isset($_GET['id'])) {
$id = htmlspecialchars($_GET['id']);
if($id == 1){$points = '50'; $credits = '5';}
if($id == 2){$points = '100'; $credits = '10';}
if($id == 3){$points = '150'; $credits = '15';}
if($id == 4){$points = '200'; $credits = '20';}
if($id == 5){$points = '250'; $credits = '25';}
if($id == 6){$points = '300'; $creditst = '30';}



$sql=mysql_query("SELECT * FROM `street-users` WHERE `username` = '$name'") or die(mysql_error());
$my=mysql_fetch_array($sql);





if($my['credits'] < $credits)
{
echo ' <center> Нямаш достатъчно кредита! <br>   <center>';
}
else
{

$credits1 = $my['credits'] - $credits;
$points1 = $my['points'] + $points;

$nrgy = $my['maxnrg'];
if($nrgy > $my['maxnrg'])
{
$nrgy = $my['maxnrg'];
}


$sql2=mysql_query("UPDATE `street-users` SET `credits` = '$credits1', `points` = '$points1' WHERE `username` = '$username'") or die(mysql_error());
if ($sql2)
{
echo " <center> Успешно зареди $enrg точки!   <center> ";
}
}
} else { ?>
<a href="?a=market&id=1"> <center> Купи 50 точки за 5 кредита <center> </a>   
<a href="?a=market&id=2"> <center> Купи 100 точки за 10 кредита <center> </a>  
<a href="?a=market&id=3"> <center> Купи 150 точки за 15 кредита <center> </a>  
<a href="?a=market&id=4"> <center> Купи 200 точки за 20 кредита <center> </a>  
<a href="?a=market&id=5"> <center> Купи 250 точки за 25 кредита <center> </a>  
<a href="?a=market&id=6"> <center> Купи 300 точки за 30 кредита <center> </a>  
<? }} else { echo ' <meta http-equiv="refresh" content="0;url=index.php"> '; } ?></div>
</body>
</html>
Всички идва от доста неподреден код .. и сега незнам дали ще стане ... надявам се
 
Добре пич .. невиждам дефинирана променлива $username а пак се ползва при ъпдейтването ... как става тая работа .. тази променлива $name какво взима .. и ако няма променлива $username дай да я дефинираме само кажи с какво, ако е слогнатия потребител, кажи как е сесията или там каквото ползваш ..
 
Пич плати си на професионалист да ти спретне тая гора дето имаш или каквото е там, не се занимавай с готовите системи те имат хулл грешки
(моля модератор да не ми прави забележка но е казано къде и какъв е сайта)
 
Дай информация. В базата данни какво се записва в полето $username - потребителско име или потребителско ID??? И каква е сесийната променлива, съдържаща потребителското име и ID??

Разберете хора, не сме екстрасенси, за да гадаем какво е написано! Помогнете ни, за да ви помогнем :?:
 

Горе