[RESOLVED] mysql_num_rows not working =\

[ElectricRain]

Im deeply confused, because Ive done this a million times before. Im sure the mistake is obvious but Im just missing it somehow. please help

<?
require ('config.php');

//make the connection to the database
$connection = mysql_connect($server, $dbusername, $dbpassword) or die(mysql_error());
$db = mysql_select_db($db_name,$connection)or die(mysql_error());
?>

<h1>TEST PAGE</h1>
<form name="test" method="post" action="">
<input type="text" name="email" size="20" maxlength="255">
<input type="submit" name="getit" value="submit">

<?
if (isset($getit)) {
	echo "<br><br>submit button has been pressed (test 1 ok)";

$thequery = mysql_query("SELECT * from authorize WHERE email = '".$POST[email]."'") or die("<br><br>couldnt do query because".mysql_error());
$thenumber = mysql_num_rows($thequery) or die("<br><br>couldnt get number because".mysql_error());

echo "<br><br> $thenumber if you see this number test 2 is ok.";
}
?>

</form>

Error:

"submit button has been pressed (test 1 ok)

couldnt get number because"

😕

additionally, I noticed that if I replace

$thenumber = mysql_num_rows($thequery) or die("<br><br>couldnt get number because".mysql_error());

with $thenumber = mysql_num_rows($thequery) ;

It will print out "0 if you see this number test 2 is ok." if no email or a fake email address is typed but nothing atall if a existing email address is typed. This doesnt seem to be related to my database either, for instance, the address [e-mail] does not exist in my database, but if i type this address in itll print nothing.

Prob page currently hosted at

http://www.printedexistence.com/dating_site/testing.php

[laserlight]

0 is a false value. There's no need to check if mysql_num_rows() is working, only to check if mysql_query() is working.

[ElectricRain]

Ok... under normal circumstances I wouldnt be trying to do that, but mysql_query is not throwing an error, n yet I still have this problem- When I type a valid email address into the field, it should bring back a number of rows, should it not? But the typing of a valid email brings back nothing, not zero.. just a blank.

[laserlight]

Let's try again:

<?php
require 'config.php';

//make the connection to the database
$connection = mysql_connect($server, $dbusername, $dbpassword)
	OR die(mysql_error());
$db = mysql_select_db($db_name, $connection)
	OR die(mysql_error());

if (isset($_POST['getit']) && !empty($_POST['email'])) {
	echo 'Thanks for submitting the form<br />';
	$query = "SELECT * FROM authorize WHERE email='" . $_POST['email'] . "'";
	$result = mysql_query($query)
		OR die(mysql_error());
	$number = mysql_num_rows($result);
	echo 'Number of rows returned: ' . $number . '<br />'
		. 'Email address used: ' . $_POST['email'] . '<br />';
}

?>

<h1>TEST PAGE</h1>
<form name="test" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="text" name="email" size="20" maxlength="255">
<input type="submit" name="getit" value="submit">
</form>

[ElectricRain]

I copied and pasted the code exactly and well... look

http://www.printedexistence.com/dating_site/testing.php

precisely the same problem

I was fairly sure there wasnt much up with my code to start with... this is familiar stuff, but I dont know what this means is wrong? Does it mean theres a problem with my database? if so why does the query work?

[ElectricRain]

Ok now this is really interesting. Just messing around I have discovered that, if you hit enter as I have been doing, no value is returned. If you actually click the submit button, or hit tab n then enter, it works. What is goin on??? 😕

[laserlight]

Oh, you've hit upon a browser quirk. This can be solved by including another field in the form. I believe a hidden input will also suffice.

[ElectricRain]

Corrected by altering the code to

<h1>TEST PAGE</h1>
<form name="test" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="text" name="email" size="20" maxlength="255">
<input type="hidden" name="_submit_check" value="1"> 

<input type="submit" name="getit" value="submit">

<?
if (isset($getit) || array_key_exists('_submit_check', $_POST)) { do stuff }

Thanks 🙂