<?php
$SearchType = $_POST["SearchPlace"];
$host= 'localhost';
$user= 'user';
$passwd= 'password';
$database= 'dbase';
$table1= 'BUS';
$table2= 'STUDENT';

$connect= mysql_connect($host, $user, $passwd);
mysql_select_db($database);
$pquery = "select busNo from $table1 where place like '".$SearchType."'";

$squery = "select * from $table2 where busNo like '".$pquery."'"; 

$run = mysql_query($squery);
$num_results = mysql_num_rows($run);




if (!$SearchType )
{
echo "<b>You have not selected search details. Please go back and try again.</b>";
}
else
{

if (!$connect)
{
echo"</b>Error: Could not connect to database. Please try again later.</b>";
}

else
{
for ($i=0; $i<$num_results; $i++)
{ 
$row = mysql_fetch_array($run);

$IDNo= stripslashes($row["IDNo"]);
$sName= stripslashes($row["sName"]);
$startDate= stripslashes($row["startDate"]);
$endDate = stripslashes($row["endDate"]);
$sPhone= stripslashes($row["sPhone"]);
$OBox= stripslashes($row["OBox"]);
$busNo= stripslashes($row["busNo"]);

echo "<tr>\n";
echo "<td align=left>\n";
echo "<p> Student ID: ".$IDNo."";
echo "<br>Student Name: ".$sName."";
echo "<br>Starting Date: ".$startDate."";
echo "<br>Ending Date: ".$endDate."";
echo "<br>Student Phone: ".$sPhone."";
echo "<br>P.O.Box: ".$OBox."";
echo "<br>Bus number: ".$busNo."";
echo "</p>";
echo "</td></tr>\n";

echo "\n";
echo "\n";
echo "</table>\n";
}

}
}
?>

Hi I am getting this warning and I don't know why?!! :sad: :!:

please can you help me to find the error

Your query is probably failing. Try

$run = mysql_query($squery) or die(mysql_error());

And see if you get an error.

Or echo out your SQL statment and trying running it against the database.

I tried

$run = mysql_query($squery) or die(mysql_error());

I got this message "Query was empty"

Wat does this mean?

$pquery = "select busNo from $table1 where place like '".$SearchType."'";
 
$squery = "select * from $table2 where busNo like '".$pquery."'";

If $_POST was given as "Foobar" (for want of a better example), $squery would be set to:

select * from STUDENT where busNo like 'select busNo from BUS where place like 'Foobar''

Try running that by itself :-|

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.