[SOLVED] mysql change field

[PICS]

I'm trying to change a field after the security code is valid but i don't think my code is right to change the field. Help me out please :]

 

<?PHP

$sc2=$_GET['sc'];

$username="teteted";
$password="dfsfsdf";
$database="picstools_com_-_u";


mysql_connect('localhost',$username,$password);
$query1=" UPDATE sms SET verify='yes' WHERE sc='$sc2'";
mysql_query($query1);
echo "Record Updated";

@mysql_select_db($database) or die( "Unable to select database");
$query=" SELECT * FROM sms WHERE sc='$sc2'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$cell=mysql_result($result,$i,"cell");
$pw=mysql_result($result,$i,"pw");
$sc3=mysql_result($result,$i,"sc");
$vi="yes";


echo '<h1>Congratulations!</h1><br><br>Your Phone Number '.$cell.' Has Been Registered.';

++$i;
}
?>

[per1os]

Closing the mysql connection is unnecessary and you are doing it before you call mysql_result.

 

Chances are that is what is screwing you up. Also be wary of SQL Injection.

[PICS]

thanks frost, that works but im getting an error...

 

Warning: mysql_close(): no MySQL-Link resource supplied in /var/www/html/sms/verify2.php on line 35

[per1os]

Don't use mysql_close.

 

www.php.net/mysql_close

 

The connection automatically closes when the script is done running.

[PICS]

thanks frost, works great now