[SOLVED] numrows

[timmah1]

Can somebody tell me why this isn't working?

 

No matter if the data matches or not, it always shoes "You can pick today"

 

<?php
session_start();

require("header.php");
require("config.php");

$user = $_SESSION['SESS_USERNAME'];
$today = date('Y-m-d');
echo "$user<br>";
echo "$today<br>";
		$csql = "SELECT user,picked FROM daily_picks WHERE user = '$user' AND picked = '$today'";
		$cres = mysql_query($csql);
		$numrows = mysql_num_rows($cres);			

			if($numrows == 1){	
				echo "You have already submitted picks for today";
			}
				else {
					echo "You can pick today";
				}
require("footer.php");
?>

 

With the way the database is now, user matches user and picked matches today.

 

Can somebody tell me what's wrong.....

 

Thank you in advance.

[F1Fan]

What do you get if you echo the $numrows var? Also, what if you tried > 0 rather than ==1?

[timmah1]

echoing out numrows gives me 6, so to me, it's obvious that there's a match, just not sure why it don't tell me

 

I tried changing it to 0, and I get the same answer "You can pick today"

 

 

[severndigital]

echoing out numrows gives me 6, so to me, it's obvious that there's a match

 

you code is looking for an EXACT match to the number 1

 

...

if($numrows == 1){	

...

 

try making it look for any number larger than 0

 

...

if($numrows > 0){	

...

 

that should do it

 

 

[F1Fan]

Now that you've changed the code, re-post it.

[timmah1]

perfect.

That worked.

 

With using    

if($numrows ==1){

has worked numerous times before on different sites I've done, why wouldn't that work now?

 

 

 

Thank you so much

[timmah1]

Works now.

 

Thanks for all your help

<?php
session_start();

require("header.php");
require("config.php");

$user = $_SESSION['SESS_USERNAME'];
$today = date('Y-m-d');
echo "$user<br>";
echo "$today<br>";
		$csql = "SELECT user,picked FROM daily_picks WHERE user = '$user' AND picked = '$today'";
		$cres = mysql_query($csql);
		$numrows = mysql_num_rows($cres);			

			if($numrows > 0){		
				echo "You have already submitted picks for today";
			}
				else {
					echo "You can pick today";
				}
require("footer.php");
?>

[F1Fan]

Like severndigital said, using ==1 looks for exactly 1. You're returning 6, which is not 1. It probably worked before because your queries were returning only 1, and exactly 1 row. >0 works because 1 and 6 are greater than 0.