php help
 

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 ?

Re: php help
 

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!

Re: php help
 

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

Re: php help
 

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