Jump to content

Archived

This topic is now archived and is closed to further replies.

ntspdy

If statement not working

Recommended Posts

First off, I appreciate any help I can get.

Here is my issue, I'm making a call to a DB then depending on the data from one column I'm displaying the data from a second column. The problem I'm getting is that even though I know the data in the column I cannot get my if statement to recognize the "true" part of the statement. Here is the code.

<?php
include('dbconnect.php');

$query="SELECT runtime
FROM missionruntime";
$query1="SELECT start
FROM missionruntime";

$runtime=mysql_query($query);
$start=mysql_query($query1);

if ( $start == 2006-04-19 13:51:59 ) {
echo "SERVER DOWN";
} else {
echo mysql_result($runtime,"runtime");
}
?>

Now I know that $start = 2006-04-19 13:51:59 but it will not display SERVER DOWN. It just displays a blank page. Since the data type is varchar(20) do I have to specify my = statement differently?

Share this post


Link to post
Share on other sites
try...

if ( $start == '2006-04-19 13:51:59') {
echo "SERVER DOWN";
} else {
echo mysql_result($runtime,"runtime");
}

Share this post


Link to post
Share on other sites
You need to fetch the stuff

[code]
<?php
include('dbconnect.php');

$query="SELECT runtime
FROM missionruntime";
$query1="SELECT start
FROM missionruntime";

$runtime=mysql_fetch_array(mysql_query($query));
$start=mysql_fetch_array(mysql_query($query1));



if ( $start['start'] == 2006-04-19 13:51:59 ) {
echo "SERVER DOWN";
} else {
echo {$runtime['runtime']};
}
?>
[/code]

Share this post


Link to post
Share on other sites
You should combine the two queries into one.

[code]<?php
include('dbconnect.php');

$query="SELECT runtime, start FROM missionruntime";
$rs = mysql_query($query1);
$row=mysql_fetch_assoc($rs);



if ( $row['start'] == 2006-04-19 13:51:59 ) echo "SERVER DOWN";
else echo $row['runtime']; // you don't need the curly braces here. (edited original post)
?>[/code]

Ken

Share this post


Link to post
Share on other sites
Thanks guys, and thanks for answering my second question before I asked it kenrbnsn. I was sure there was a way to do that but that was second on my list.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.