function javascript help

Question

im new to programming and i need help on my code ? i want my page to prompt me if there will be available rooms left. im using the onload function on the admin page.

so far here is my code

function prompt()
{
< ?php 
include("dbconfig.php");

$sql = "SELECT COUNT(*) FROM rooms WHERE status = 'available'";
$result = @mysql_query($sql) or die("Could not execute query");

?> 
if(< ?php $result <= 14 ?>){
 alert("Rooms left: < ?php echo $result ?>");
 }

else{
 alert("Welcome Admin.");
 } 
}

window.onload=prompt;

can someone help me ? please need this code asap. thank you so much

edit:

the code worked fine now but it displays "Resource id#4"? not the value of the count ? any help with this ? -renz

Answer 1

mysql_query returns resource, not a result. Try to use:

$sql = "SELECT COUNT(*) FROM `rooms` WHERE `status` = 'available'";
$res = @mysql_query($sql) or die('Could not execute query');
$count = mysql_result($res, 0, 0);

Answer 2

There should be no space in php tags:

< ?php 
 ^

Should be:

<?php 

You are also missing a fetching function, here is how you can get row count in a variable:

<?php $count = mysql_num_rows($result);?>

Later you can use the $count variable in the if condition.

Answer 3

use mysql_fetch_row , and after that in the condition , compare to $row[0]

$sql = "SELECT COUNT(*) FROM `rooms` WHERE `status` = 'available'";
$res = @mysql_query($sql) or die('Could not execute query');

$row = mysql_fetch_row($res);

if(< ?php $row[0] <= 14 ?>){

Answer 4

I feel you can't mix php with js codes. php is mainly on server side , while the js is client side from the snippet you provide, maybe you should use purely php as follows:

< ?php 
    include("dbconfig.php");
    $sql = "SELECT COUNT(*) FROM rooms WHERE status = 'available'"; 
    $result = @mysql_query($sql) or die("Could not execute query");
    if ($result <= 14) {
        echo("Rooms left: $result");
    }
    else {
        echo("Welcome Admin.")
    }
 ?>

This should be run at the first when request