Letting me know it works.

[riseofthevalk]

if ($userdata['user_LastManagement'] == $now){
echo "You've already managed your turns today!";
}else{
$result = dbquery("UPDATE ".$db_prefix."users SET user_LastManagement= '$now', user_AvailableTurns = '$total' WHERE user_id='".$userdata['user_id']."'") or die(mysql_error());
};

This is my code. I'm curious as to how to echo an statement ONLY in the event that the query worked. I've tried adding it at the bottom but it says it no matter what.:devious:

[kingmundi]

if ($userdata['user_LastManagement'] == $now){
echo "You've already managed your turns today!";
}else{
$result = dbquery("UPDATE ".$db_prefix."users SET user_LastManagement= '$now', user_AvailableTurns = '$total' WHERE user_id='".$userdata['user_id']."'") or die(mysql_error());
};

I have never been a big fan of
or die()
nor have I liked building a SQL statement right in the middle of a function. All data going into a SQL string should be sanitized. Parameterized query is even better.

However, to answer your question.

//assumming $db_prefix, $now, $total and $userdata is safe
$query = "UPDATE ".$db_prefix."users SET user_LastManagement= '$now', user_AvailableTurns = '$total' WHERE user_id='".$userdata['user_id']."'";

//assumming dbquery returns same return types as mysql_query
$result = dbquery($query);
if($result)
{
echo $query;
} 

[riseofthevalk]

Hrm, but this doesn't take into account my other ifelse stuff. :\

[riseofthevalk]

???

[kingmundi]

I can't believe I actually have to type this out...

if ($userdata['user_LastManagement'] == $now)
{
echo "You've already managed your turns today!";
}
else
{

//assumming $db_prefix, $now, $total and $userdata is safe
$query = "UPDATE ".$db_prefix."users SET user_LastManagement= '$now', user_AvailableTurns = '$total' WHERE user_id='".$userdata['user_id']."'";

//assumming dbquery returns same return types as mysql_query
$result = dbquery($query);
if($result)
{
echo $query;
}

} 

[riseofthevalk]

Thank you!

[ljm]

I recommend that you change the last instance of $query to echo something else, otherwise it'll plaster info on your database structure all over the page every time the query works.

[riseofthevalk]

No worries. I never planned on echoing the actual query.