Page 1 of 1

if statements

Posted: Tue Oct 30, 2007 10:19 am
by hgmmy
Hopefully this is a quick question with a quick answer. Here's an example to go with my question which will be after the example.

Code: Select all

<?php 
include('wp-config.php'); //this were the database connection info is as well as were it connects from.

  $o_theuser = $_POST['theuser'];
  $o_profile = $_POST['profile'];

$update_profile = mysql_query("UPDATE user_allow SET share_info='$o_profile' WHERE ID='{$cur_user_i}' AND reviewers_id='$o_theuser' ");

  if ($o_profile == 'y' || $o_profile == 'n')
 {
  if ($update_profile)
  {
   echo "successful query";
  }
 } else {
 echo "unsuccessful query";
};
?>
Ok so if for an "if condition" you use a variable with a mysql_query in it, will the the condition return true if the query returns successful and false if it returns unsuccessful, and if not what does it take to make a condition that works that way?

Posted: Tue Oct 30, 2007 10:37 am
by Kieran Huggins
if the query is syntacticly valid, the function will return a resource; otherwise it will return false.

That doesn't speak to whether or not the query did anything however.. try mysql_affected_rows instead.