empty query

[proctk]

HI

 

How can I tell if a query is empty

 

I need to test this

 

$get_buddys = mysql_query($query_get_buddys) or die ("Invalid query". mysql_error());

[Hypnos]

If a query string is empty, or there were 0 results?

 

mysql_num_rows, if you want the latter.

[proctk]

yeh I tried that but something weird is happening, it always returning a result but the out but does not match the number of found rows

[mmarif4u]

Can u post ur code.

[proctk]

this code was created with the support on this forum from another post.  It returns a result all the time using the mysql_sql_num_rows regardless if the out put is blank

 

thanks

 

      <?php $query_get_buddys = ("SELECT * FROM buddylink b
								 LEFT JOIN users u ON b.buddy_id = u.user_id AND month(u.DOB) ='$month'
								 WHERE b.owner_id = '$id'"); 

		$get_buddys = mysql_query($query_get_buddys) or die ("Invalid query". mysql_error());
	    
		while($buddyBirthdays = mysql_fetch_assoc($get_buddys)){

		//Get child birth day
		$buddyBirthDay = $buddyBirthdays['DOB'];
		$buddyBirthDay_array = explode("-",$buddyBirthDay);
		$buddy_day_num = $buddyBirthDay_array[2]; ?>
      <?php if(!empty($buddyBirthdays['DOB'])){?>
      <p class="bdayText"> <?php echo $buddy_day_num; ?> - <a class="bdayLink" href="../profile.php?id=<?php echo $buddyBirthdays['user_id'] ?>"><?php echo $buddyBirthdays['first_name'].' '.$buddyBirthdays['last_name']; ?></a>(<?php echo birthday($buddyBirthdays['DOB']) ?>)</p>
      <?php }else{}?>
      <?php }	?>
      <?php $query_get_buddys = ("SELECT * FROM buddylink b
								 LEFT JOIN users u ON b.buddy_id = u.user_id AND month(u.DOB) ='2'
								 WHERE b.owner_id = '$user_id'"); 

		$get_buddys = mysql_query($query_get_buddys) or die ("Invalid query". mysql_error());

		while($buddyBirthdays = mysql_fetch_assoc($get_buddys)){

		//Get child birth day
		$buddyBirthDay = $buddyBirthdays['DOB'];
		$buddyBirthDay_array = explode("-",$buddyBirthDay);
		$buddy_day_num = $buddyBirthDay_array[2]; ?>
      <?php if(!empty($buddyBirthdays['DOB'])){?>
      <p class="bdayText"> <?php echo $buddy_day_num; ?> - <a class="bdayLink" href="../profile.php?id=<?php echo $buddyBirthdays['user_id'] ?>"><?php echo $buddyBirthdays['first_name'].		' '.$buddyBirthdays['last_name']; ?></a>(<?php echo birthday($buddyBirthdays['DOB']) ?>)</p>
      <?php }else{}?>
      <?php }	?>

[mmarif4u]

try to use mysql_num_rows.

i did not see any of that using in ur query.