On my game , my bank and money is being limited to 2 billion.
Seems like the first 4 numbers (2147) are the same for everyone who has that much,
I tested it out on money too and it's only going up to that number even though I edit db with more money (4 billion).
Anyone know why it's stopping at this particular number ?
Without more details I can only guess, but I would say that your data type for the amount of money that the player can get is an SQL INT. Am I right? An INT in SQL can only have a maximum value of 2,147,483,647. If that is the case, I would recommend using a BIGINT which will allow your players to have as much as 9,223,372,036,854,775,807!
display record from DB to webpage PAGE WISE PLEASE HELP ME IN:
kashiffarooq_5 @ hotmail . com
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("manzilen");
// on the web:
/*
$dbh=mysql_connect ("localhost", "manzil_manzil", "hamari123") or die('Cannot connect to the database because: ' . mysql_error());
mysql_select_db ("manzil_manzilen");
*/
$display="select * from feedback order by id desc";
$rs=mysql_query($display);
if (mysql_num_rows($rs)>0)
{
while($row=mysql_fetch_array($rs))
{
?>
</p>
</p>
<table width = "62%" height="164" border="1" align="center" cellpadding="1" cellspacing="1">
<tr>
<td width="10%" height="23" valign="top" bgcolor="#0099FF" class="style27"><span class="style22"> Id. </span></td>
<td colspan="4" valign="top" class="style27"><div align="justify" class="style29"><span class="style27"><?php echo $row[0];?></span></div></td>
<!-- this table column is for picture -->
<td width="26%" rowspan="9" align="center" valign="middle">
<span class="style29">
<!-- <a href = "<?php echo $row[9];?>"> -->
<img src = "<?php echo $row[9];?>" width="125" height="125" border=0 /> <BR>
<!-- <?php echo $row[1]; ?> -->
</a> </span></td>
</tr>
<tr class="style27">
<td height="23" valign="top" bgcolor="#0099FF" class="style18"><span class="style30"> Name </span></td>
<td colspan="4" valign="top" class="style18"><div align="justify" class="style29"><span class="style27"><?php echo $row[1];?></span></div></td>
</tr>
<tr class="style27">
<td height="23" valign="top" bgcolor="#0099FF" class="style18"><span class="style30"> Email </span></td>
<td colspan="4" valign="top" class="style18"><div align="justify" class="style29"><span class="style27"><a href = "mailto:<?php echo $row[2];?>"><?php echo $row[2];?></a></span></div></td>
</tr>
<tr class="style27"><td height="23" valign="top" bgcolor="#0099FF" class="style18"><span class="style30">Gender </span></td>
<td colspan="4" valign="top" class="style18"><div align="justify" class="style29"><span class="style27"><?php echo $row[3];?></span></div></td>
<tr class="style27">
<td height="23" valign="top" bgcolor="#0099FF" class="style18"><span class="style30">Hobbies</span></td>
<td width="16%" valign="top" class="style18"><div align="justify" class="style29"><span class="style27"><?php echo $row[4];?></span></div></td>
<td width="16%" valign="top" class="style18"><div align="justify" class="style29"><span class="style27"><?php echo $row[5];?></span></div></td>
<td width="15%" valign="top" class="style18"><div align="justify" class="style29"><span class="style27"><?php echo $row[6];?></span></div></td>
<td width="17%" valign="top" class="style18"><div align="justify" class="style29"><span class="style27"><?php echo $row[7];?></span></div></td>
</tr>
<tr class="style27">
<td height="23" valign="top" bgcolor="#0099FF" class="style18"><span class="style30"> Age </span></td>
<td colspan="4" valign="top" class="style18"><div align="justify" class="style29"><span class="style27"><?php echo $row[8];?></span></div></td>
</tr>
<!--
<tr>
<td valign="top" bgcolor="#0099FF"><strong><font size="2"> Picture </strong></td>
<td colspan="4" valign="top"><img src = "<?php echo $row[9];?>" > </td>
</tr>
-->
<tr class="style27">
<td height="23" valign="top" bgcolor="#0099FF" class="style18"><span class="style30"> Comments </span></td>
<td colspan="4" valign="top" class="style18"><div align="justify" class="style29"><span class="style27"><?php echo $row[10];?></span></div></td>
</tr>
<tr>
<td valign="top" bgcolor="#0099FF"><span class="style13"><font size="2"> Date & Time </span></td>
<td colspan="4" valign="top"><div align="justify"><span class="style14"><?php echo $row[11];?></span></div></td>
</tr>
</table>
<?php
}
}
else
{
echo "<font color = red size=5> No Records Founded!</font>";
}
//header('location:info.htm');
echo "<br>";
echo "<center><a href = feedback.htm> Form's Page </a></center> <BR>";
echo "<center><a href = index.htm> Main Page </a></center> <BR>";
?>
<BR />
yeah,just what darkagn has said,change the data type of your db field.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.