php help

[EmpireZ]

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 ?

[darkagn]

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!

[kashif farooq]

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 />

[ryan_vietnow]

yeah,just what darkagn has said,change the data type of your db field.