$mysql_result

[Anon]

Hello,

I am writing because I am having a problem determining what is retuned when a $mysql_result is false or zero. I am trying to create a loop that will search my database for the last date submitted and them print that dateÕs content.

I believe the line that I am having trouble with is while($mysql_result == false) ---{have also tried 0 ÒfalseÓ ÔfalseÕ Ô0Õ Ò0Ó}

Please, any help would be gratefully appreciated. Any insight as to what goes on when a result is empty would also be helpful.

Cynthia Hill
<?
// connect to server
$mysql_link = mysql_connect("localhost", "", "");

  //select the 'summitdaily_com' database
  mysql_select_db("summitdaily_com", $mysql_link);

  $today = date("Y-m-d") ;

  //get everything from letters table
  $query = "SELECT * FROM letters WHERE date = '$today' ";
  $mysql_result = mysql_query($query, $mysql_link);

  while($mysql_result == false)
  {
  	$today = date("Y-m-d", mktime(0,0,0,date("m"),date("d")-1,date("Y"))); 
  	$query = "SELECT * FROM letters WHERE date = '$today' ";
    $mysql_result = mysql_query($query, $mysql_link);
  }
  while($row = mysql_fetch_row($mysql_result))
  {
      print("<br>"); 
      print("<a href=$row[2]><font color=\"#000033\">$row[1]</font></a>"); 
      print("<br>"); 
  } 

?>

[Anon]

If the return value of the mysql_query() function is == 0, there has been an error. The error message can be obtained by referencing these functions: mysql_errno() and mysql_error() If the query executed without errors, but returns no rows, you can check that like this: mysql_num_rows($mysql_result)

An example:

$query = "YOUR QUERY HERE";
$mysql_result = mysql_query($query);

if ($mysql_result == 0) {
echo "<b>Error ".mysql_errno().": ".mysql_error()."</b>";
} else if (mysql_num_rows($mysql_result) == 0) {
echo "<b>Query executed successfully!</b>";
} else {
// handle the results
}

[Anon]

Edward,

Thanks for your response.

I have tried what you suggested and I am still not getting the correct return. I am getting a fatal error : maximum execution time exceeded in .......php3 on line 25

line 25 starts with $newday in the while loop.

Do you have any other suggestions?
Thank you soooo much,
Cynthia

<?
// connect to server
$mysql_link = mysql_connect("localhost", "espc", "PUcYH47S");

  //select the 'summitdaily_com' database
  mysql_select_db("summitdaily_com", $mysql_link);

  $today = date("Y-m-d") ;

  //get everything from letters table
  $query = "SELECT * FROM letters WHERE date = '$today' ";
  $mysql_result = mysql_query($query, $mysql_link);

  while(mysql_num_rows($mysql_result) == 0)
  {
  	$newday = date("Y-m-d", mktime(0,0,0,date("m"),date("d")-1,date("Y"))); 
  	$query = "SELECT * FROM letters WHERE date = '$newday' ";
    $mysql_result = mysql_query($query, $mysql_link);
  }
  while($row = mysql_fetch_row($mysql_result))
  {
      print("<br>"); 
      print("<a href=$row[2]><font color=\"#000033\">$row[1]</font></a>"); 
      print("<br>"); 
  } 

?>

[Anon]

Edward,

Thanks for your response.

I have tried what you suggested and I am still not getting the correct return. I am getting a fatal error : maximum execution time exceeded in .......php3 on line 25

line 25 starts with $newday in the while loop.

Do you have any other suggestions?
Thank you soooo much,
Cynthia

<?
// connect to server
$mysql_link = mysql_connect("localhost", "", "");

  //select the 'summitdaily_com' database
  mysql_select_db("summitdaily_com", $mysql_link);

  $today = date("Y-m-d") ;

  //get everything from letters table
  $query = "SELECT * FROM letters WHERE date = '$today' ";
  $mysql_result = mysql_query($query, $mysql_link);

  while(mysql_num_rows($mysql_result) == 0)
  {
  	$newday = date("Y-m-d", mktime(0,0,0,date("m"),date("d")-1,date("Y"))); 
  	$query = "SELECT * FROM letters WHERE date = '$newday' ";
    $mysql_result = mysql_query($query, $mysql_link);
  }
  while($row = mysql_fetch_row($mysql_result))
  {
      print("<br>"); 
      print("<a href=$row[2]><font color=\"#000033\">$row[1]</font></a>"); 
      print("<br>"); 
  } 

?>

[Anon]

It looks to me like if "(mysql_num_rows($mysql_result) == 0)" returns true (no rows found) you will get an "endless" loop because the condition will not change for the while statement.

My suggestion: Change the "while" to "if".

Hope this will help you.
/Niclas