want help in querying with a variable

shahim

hye ppl,
i am in a sort of a fix here.. i have a table.. where i want to check the value that i am getting from this query and then display whether that values are present in the other table, if they present then ... it should show "online" otherwise... should tell u "offline" now... how do i make it up.. am currently using javascipt. can someone help me out with this.. pls...

<?php
// get results
$select_query1 = "select tel_no,async_port from linetemp" ;
$result1 = mysql_query($select_query1, $mysql_link) or die("Error occured");

$select_query2 = "select nasport from RADONLINE where nasidentifier='62.100.194.250'" ;
$result2 = mysql_query($select_query2, $mysql_link) or die("Error occured");
$data2=mysql_fetch_array($result2);

// now you can display the results returned
if (mysql_num_rows($result1) <= 0) {
print "<br>No Data was found<br>&nbsp";
}
else {
print "<table align=\"center\" bordercolorlight=\"#009999\" bordercolordark=\"#CCFF33\" cellpadding=\"3\" cellspacing=\"0\" border
=\"1\" width=\"95%\"><tr>";

print "<td align=\"center\" style=\"v-align: center\" class=forminputtext width=\"40%\" bgcolor=\"#D9F2FF\">";
print "Telephone No.";
print "</td>";

print "<td align=\"center\" style=\"v-align: center\" class=forminputtext width=\"30%\" bgcolor=\"#D9F2FF\">";
print "NAS Port";
print "</td>";

print "<td align=\"center\" style=\"v-align: center\" class=forminputtext width=\"30%\" bgcolor=\"#D9F2FF\">";
print "Online/Offline";
print "</td>";

print "</tr>";

while ($data1=mysql_fetch_array($result1))
{
print "<tr>";

print "<td align=\"center\" style=\"v-align: center\" class=forminputtext width=\"15%\" >";
print "<b>$data1[0]</a></b>";
print "</td>";

print "<td align=\"center\" style=\"v-align: center\" class=forminputtext width=\"35%\" >";
print "<b>$data1[1]</a></b>";
print "</td>";

print "<td align=\"center\" style=\"v-align: center\" class=formlabeltext width=\"10%\">";
if ($data1[1] == $data2[0]) { print "<b>Online</b>"; }
    else { print "Offline";  }
print "</td>";

print "</tr>";

}
print "</table>";
print "<br>";
}

?>
[/I]

TodManPlaa

what does your code return at the moment - at a glance it looks ok to me...

shahim

no man..
u know wat.. actually here
//
print "<td align=\"center\" style=\"v-align: center\" class=formlabeltext width=\"10%\">";
if ($data1[1] == $data2[0]) { print "<b>Online</b>"; }
else { print "Offline"; }
//

i want to .... actually .. search the values i get in my this column... in another table .. to check whether they are present there .. or no.. .. thats key.. just gimme some javascript help.. how to do it...

TodManPlaa

Javascript! I'm not fluent in that one.

Can't help you there sorry - I missunderstood your initial query.

Mega

what is peoples thing with using a print statement for EVERY line of HTML o_0

I wish i knew what you were asking for also

<?

// get results 
$select_query1 = "select tel_no,async_port from linetemp" ; 
$result1 = mysql_query($select_query1) or die("Error occured"); 

$select_query2 = "select nasport from RADONLINE where nasidentifier='62.100.194.250'" ; 
$result2 = mysql_query($select_query2) or die("Error occured"); 
$data2=mysql_fetch_array($result2); 

// now you can display the results returned 
if (mysql_num_rows($result1) == 0) { 
	echo '<br>No Data was found<br>'; 
} 
else {
	echo <<<EOF
<table align="center" bordercolorlight="#009999" bordercolordark="#CCFF33" cellpadding="3" cellspacing="0" border 
="1" width="95%"><tr> 

<td align="center" style="v-align: center" class=forminputtext width="40%" bgcolor="#D9F2FF"> 
Telephone No. 
</td> 

<td align="center" style="v-align: center" class=forminputtext width="30%" bgcolor="#D9F2FF"> 
NAS Port 
</td> 

<td align="center" style="v-align: center" class=forminputtext width="30%" bgcolor="#D9F2FF"> 
Online/Offline 
</td> 

</tr>
EOF;


while( $data1 = mysql_fetch_array($result1) ){ 
	echo <<<EOF
<tr> 

<td align="center" style="v-align: center" class=forminputtext width="15%" > 
<b>{$data1['tel_no']}</a></b> 
</td> 

<td align="center" style="v-align: center" class=forminputtext width="35%" > 
<b>{$data1['async']}</a></b> 
</td> 

<td align="center" style="v-align: center" class=formlabeltext width="10%"> 
EOF;

if ($data1['tel_no'] == $data2['nasport']){
	echo '<b>Online</b>'
} 
else { 
	echo 'Offline';
} 

echo '</td> 

</tr>';
}

echo '
</table> 
<br>';

}

i want to .... actually .. search the values i get in my this column... in another table .. to check whether they are present there .. or no.. .. thats key.. just gimme some javascript help.. how to do it...

means absolutely nothing to me

🙂