BR
asked on
PHP - sql script
I use this blow code which works fine..
but I need to refersh the page or click the link again, which I send for email verification, for it to run the update statement.
mysql_query("UPDATE Mytable SET Approve='1' WHERE Email='$email'") it doesn't uptade the Approve column when I open the page. I need to refersh the page.. but it works
what do you suggest I should do?
but I need to refersh the page or click the link again, which I send for email verification, for it to run the update statement.
mysql_query("UPDATE Mytable SET Approve='1' WHERE Email='$email'") it doesn't uptade the Approve column when I open the page. I need to refersh the page.. but it works
what do you suggest I should do?
$result = mysql_query("SELECT * FROM Mytable where Email='$email' and Confirmation='$ConfirmationCode'")
or die(mysql_error());
if (mysql_num_rows($result) == 0)
{
echo "Error: No match found ";
}
else
{
mysql_query("UPDATE Mytable SET Approve='1' WHERE Email='$email'")
or die(mysql_error());
}
echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Age</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['id'];
echo "</td><td>";
echo $row['Name'];
echo "</td><td>";
echo $row['Surname'];
echo "</td><td>";
echo $row['Email'];
echo "</td><td>";
echo $row['Confirmation'];
echo "</td><td>";
echo $row['IP'];
echo "</td><td>";
echo $row['Date'];
echo "</td><td>";
echo $row['Market'];
echo "</td><td>";
echo $row['Approve'];
echo "</td></tr>"; }
echo "</table>";
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear angelll,
I wonder what you have changed? it works now.. but I couldn't see the diffrence..
thank you
I wonder what you have changed? it works now.. but I couldn't see the diffrence..
thank you
I changed:
echo $row['Approve'];
into:
echo "1";
echo $row['Approve'];
into:
echo "1";
ASKER