php / mysql error Again

[Chrisio]

Ok this time the code below should query the db and flag if there are 2 records already in the db matching the time and date, yet it doesnt - however as before with my other problems it works fine on my test server so any clues any one

$alarm_check = "SELECT atime, datetoplay FROM maintable WHERE atime = '" . $_POST['alarmtime'] . "' And datetoplay = '" . $_POST['datebox'] . "'"; // check if username exists in database.

        if (!($alarm_check)) print mysql_error();
        $result1 = mysql_query($alarm_check);
        $num_row = mysql_num_rows($result1);
    
        if ($num_row == 2)
            
        {
            die('<p align="center"><strong><font face="Century Gothic">Im sorry but this time slot is full.</font></strong></p><p align="center"><font face="Century Gothic"><a href="newentry.php">Please go back and pick another time</a></font></p><p align="center"><a href="index.html"><img src="images/smallhouse.gif" alt="Home" width="53" height="67" border="0"></a></p>');
            //die ($num_row);
        } 

many thanks chrisio

[visualAd]

So what error are you getting?

[Chrisio]

Thats just it im not getting any it just posts it to the db and shows the page as though there were less than 2 entrys

[visualAd]

Your server configurations may be different. I suspect that an error is occuring in your query. It would help to chekc the query result rather than the query text after you have called mysql_query(). Change your code to this to see if you get an error dispalyed.

error_reporting(E_ALL);

$alarm_check = "SELECT atime, datetoplay FROM maintable WHERE atime = '" . $_POST['alarmtime'] . "' And datetoplay = '" . $_POST['datebox'] . "'"; // check if username exists in database.

        
if (! ($result1 = mysql_query($alarm_check))) {
    die(mysql_error());
}

$num_row = mysql_num_rows($result1);
    
if ($num_row == 2) {
            die('<p align="center">
<strong><font face="Century Gothic">Im sorry but this time slot is full.</font></strong>
</p><p align="center"><font face="Century Gothic"><a href="newentry.php">Please go back and pick another time</a></font></p>
<p align="center"><a href="index.html"><img src="images/smallhouse.gif" alt="Home" width="53" height="67" border="0"></a>
</p>');

} 

[Chrisio]

thanks very much all it required was some one with a bit off knowledge and I found it in a missspelled variable

it was relating to the sql query

thanks again
chrisio

[visualAd]

Its always a good idea to set error reporting to E_ALL while developing. The display of notices when you misspell variables is a god send and without it you can get some very strange and confusing errors.