what could be wrong

[tito]

Please someone, what could be wrong below? I connect to mysql, the status=1 but the proper echo is not coming up

elseif($ip == "192.168.2.81" && $status == "1")

<?php
require ("config.php");
mysql_connect($host,$user,$pass);
@mysql_select_db($database) or die( "Unable to select database");
$result=mysql_query('SELECT * FROM sessions') or die(mysql_error());
if($HTTP_SERVER_VARS['REMOTE_ADDR'] == "192.168.2.81")
{
echo "yourloc.gif";
}
elseif($ip == "192.168.2.81" && $status == "1")
{
echo "connected.gif";
}
else
{
echo "notavail.gif";
}
?>

[CaptianChaos]

You need a space in elseif: else if

I don't see where $ip is being set. You may need to"
$ip = $HTTP_SERVER_VARS['REMOTE_ADDR'];

Also, where is $status being set, in the config.php? If not, then $status == "1" will always be false.

Another thing is that you do a mysql_query, but then don't do anything with the $result..., which means the mysql stuff in your example has no relevance to the problem.

[tito]

Thanks. $status is in the db. so is $ip
I am tryng to tell a table cell to use a different bg according to the state.

I got a table with many cells. Each one is a PC. I need to indicate that if the PC making the request
$HTTP_SERVER_VARS['REMOTE_ADDR'] == "192.168.2.79" to display an image, if it is not, but that $ip in db has $status on (meaning another pc connected) to display another bg, if not then display the off image

[shadypalm88]

It might help if we could see the config file. Also you don't need to make it "else if", "elseif" is fine.

And, which one is coming up and what's the IP of the machine you're getting the problem with?

[tito]

the config file is simple
<?

$user = "root";
$pass = "mypass";
$host = "localhost";
$database = "pcstat";
?>

I got that far without error. I do not know how to get $ip and $status from the query

<?php
require ("config.php");
$machine = $HTTP_SERVER_VARS['REMOTE_ADDR'];
mysql_connect($host,$user,$pass);
@mysql_select_db($database) or die( "Unable to select database");
$result=mysql_query('SELECT * FROM sessions') or die(mysql_error());
$row = mysql_fetch_array($result);

mysql_free_result($result);
if($machine == "$ip" && $status == "1")
{
echo "yourloc.gif";
}
else if($ip != "$machine" && $status == "1")
{
echo "connected.gif";
}
else
{
echo "notavail.gif";
}
?>

[shadypalm88]

Assuming you have columns in that table called "ip" and "status", it would work like this:

<?php
require ("config.php");
$machine = $_SERVER['REMOTE_ADDR'];
mysql_connect($host,$user,$pass);
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query('SELECT * FROM `sessions`') or die(mysql_error());
$row = mysql_fetch_array($result);


$ip = $row['ip'];
$status = $row['status'];

mysql_free_result($result);
if($machine == $ip && $status == "1")
{
echo "yourloc.gif";
}
else if($ip != "192.168.2.81" && $status == "1")
{
echo "connected.gif";
}
else
{
echo "notavail.gif";
}
?>

[tito]

that is displaying the last image for all states
<?php
require ("config.php");

mysql_connect($host,$user,$pass);
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query('SELECT * FROM sessions') or die(mysql_error());
$row = mysql_fetch_array($result);

$ip = $row['ip'];
$status = $row['status'];

mysql_free_result($result);
if($ip == $HTTP_SERVER_VARS['REMOTE_ADDR'] && $status == "1")
{
echo "yourloc.gif";
}
else if($ip != $HTTP_SERVER_VARS['REMOTE_ADDR'] && $status == "1")
{
echo "connected.gif";
}
else
{
echo "notavail.gif";
}
?>

[tito]

sorry that works. thanks a lot
i had another problem

[shadypalm88]

Well, let's look at what the file is doing and you can see if it's what you are expecting it to do.

It connects to a MySQL server and gets all records in the table named sessions. Then it loads the first record from that table into an array called $row. It gets the ip and session fileds from that array and puts them into variables called $ip and $session.

Then, if your IP is the IP from that record and its status is 1, it shows "yourloc.gif". If your IP isn't the same as the IP from that record, but its status is 1, it shows "connected.gif". Otherwise, if your IP isn't the same as the one from the record, and the status isn't 1, it shows "notavail.gif".

Edit: cleared some stuff up.

[tito]

my problem is that I had 2 status in the db. I record when the user logs on (status=1) and logs off (status=0). The query was confused.
once I deleted the status=0, it worked.
I just need to add another parameter in the table to indicate active or not.