Help need with the php.ini

[blmg911]

Hi i have recently bought a sever, but don't know much they is to know about severs, now that i have bought this sever the website i have put on it has part that aren't working here is some code

$user=mysql_fetch_object(mysql_query("SELECT * FROM user_info WHERE username='$username'"));

$newaddm=round($user->money + $price);
mysql_query("UPDATE user_info SET money='$newaddm' WHERE username='$username''");

the problem is that $user->money + $price do not addtogether, no errors are given but this used to work on my hosting account it stop when i got a sever what needs changing or turing on or installing for this to work? many thanks

[bpat1434]

Well, that could be anything really.... but my guess is you need the mySQL extension installed/enabled in your php.ini.

You should do a quick info script to spit out the vital information about what's loaded and where it's loaded from:

<?php phpinfo(); ?>

If you search the page for "mysql" you should get a section header (bold and large text). If you don't, then you need to install/enable the mySQL extension with php.

If you get that header, then I'd wonder about the database and connection and query. Typically it's "bad form" to put both a query call and the fecthing in one call. This raises the chances of unseen errors not being caught. You should really add in some error handling:

$result = mysql_query("SELECT * FROM `user_info` WHERE `username`='$username'") or die(MySQLError());
if($result)
    $user = mysql_fetch_object($result) or die(MySQLError());

if(is_object($user))
    $newaddm = round($user->money + $price);
else
    trigger_error('User is not an object', E_USER_ERROR);

$result = mysql_query("UPDATE `user_info` SET `money`='$newaddm' WHERE `username`='$username'");
if(mysql_affected_rows() < 1)
    die(MySQLError());
else
    echo 'Updated successfully!';

function MySQLError()
{
    echo '
    <!--
    MySQL Error Number: ' . mysql_errno() . '
    MySQL Error Info  : ' . mysql_error() . '
    -->';
}

I prefer to hide mySQL stuff in HTML comments, but you could just as easily print it on the screen in front of you.