Updating mysql data with php Free xxx skype

I have session_start(); at the top of my page and I have echo'd out the session data as below, so I know the data is correct.

$sql = "INSERT INTO viewed id='', uid='$urlid', usecurecode='".$_SESSION['SESS_SECURE_CODE']."', ulogin='".$_SESSION['SESS_LOGIN']."', uimg='".$_SESSION['SESS_IMG1']."', ucountry='".$_SESSION['SESS_COUNTRY']."', ucity='".$_SESSION['SESS_CITY']."', uage='".$_SESSION['SESS_AGE']."', vdate='now()'"; $result = mysql_query($sql) or die(mysql_error()); echo "Thank you!

Information updated.";mysql_query("INSERT INTO viewed (uid,usecurecode,ulogin,uimg,ucountry,ucity,uage,vdate) VALUES ('$urlid','$_SESSION[$securecode]', '$_SESSION[$login]', '$_SESSION[$img1]', '$_SESSION[$country]', '$_SESSION[$city]', '$_SESSION[$age], 'now()')") or die("couldn't add new user");$sql = "UPDATE viewed SET uid='$urlid', usecurecode='".$_SESSION['SESS_SECURE_CODE']."', ulogin='".$_SESSION['SESS_LOGIN']."', uimg='".$_SESSION['SESS_IMG1']."', ucountry='".$_SESSION['SESS_COUNTRY']."', ucity='".$_SESSION['SESS_CITY']."', uage='".$_SESSION['SESS_AGE']."', vdate='now()'"; $result = mysql_query($sql) or die(mysql_error()); echo "Thank you!

You need to provide an employee ID to update an employee salary.It is also possible to update multiple columns with a single UPDATE statement.This requires the use of multiple column = value expressions in UPDATE statement.The WHERE keyword is probably the most important part of the statement to remember.Without a WHERE condition, the update will be applied to every row in the table.

Leave a Reply