Въпрос относно проверка на стойности от базата данни

K

Knoppix_

Registered
Здравейте,
имам следният проблем имам един инпут който проверявам и който искам ако е изпълнено едно условие да ми излизат две съобщения. Стигнах до някъде т.е уж работи но не мога да визуализирам двете съобщеният там където искам.
Ето кодовете
това е jquery

Код: 
$(document).ready(function(){
$("#vlekach_number").keyup(function() {
var name = $('#vlekach_number').val();
if(name=="")
{
$("#disp").html("");
}
else
{
$.ajax({
type: "POST",
url: "pages/user_check.php",
data: "vlekach_number="+ name ,
success: function(html){
$("#disp").html(html);
}
});
return false;
}
});
});

Това е сайта с формата с която въвеждам информацията
Код: 
`<style type="text/css">
		#fm{
			margin:0;
			padding:10px 30px;
		}
		.ftitle{
			font-size:14px;
			font-weight:bold;
			color:#666;
			padding:5px 0;
			margin-bottom:10px;
			border-bottom:1px solid #ccc;
		}
		.fitem{
			margin-bottom:5px;
		}
		.fitem label{
			display:inline-block;
			width:80px;
		}
	</style>
<div style="float:right; margin-right:25px; margin-top:-32px;">
<a href="?page=kasova-kniga-main"><img src="images/close.png" border="0" /></a>
</div>
	<table id="tt" class="easyui-datagrid" style="width:860;height:400px"
			url="pages/get_advance.php"
			title="Получени служебни аванси във фирма Петко Ангелов БГ ЕООД" iconCls="icon-search" toolbar="#tb"
			rownumbers="true" pagination="true" singleSelect="true">
		<thead>
			<tr>
				<th field="vlekach_number" width="80" align="center">Влекач</th>
				<th field="trailer_number" width="80" align="center">Ремарке</th>
                <th field="driver_name" width="90">Шофьор</th>
                <th field="slujeben_avans" width="90">Служебен аванс</th>
                <th field="start_date" width="90">Дата</th>
                <th field="end_date" width="90">Дата на отчитане</th>
                <th field="destination" width="90">Дестинация</th>
                <th field="zabelejka" width="90">Забележка</th>
			</tr>
		</thead>
	</table>
	<div id="tb" style="padding:3px">
    <a href="#" class="easyui-linkbutton" iconCls="icon-add" plain="true" onClick="newAdvance()">Нов запис</a>
		<a href="#" class="easyui-linkbutton" iconCls="icon-edit" plain="true" onClick="editAdvance()">Редакция</a>
		<a href="#" class="easyui-linkbutton" iconCls="icon-remove" plain="true" onClick="removeAdvance()">Изтриване</a>
		<span>Влекач номер:</span>
		<input id="itemid" style="line-height:26px;border:1px solid #ccc;">
		<span>Дата:</span>
		<input id="productid" style="line-height:26px;border:1px solid #ccc">
        <a href="#" class="easyui-linkbutton" plain="true" onClick="doSearch()" iconCls="icon-search">Филтър</a>
	</div>
 <div id="dlg" class="easyui-dialog" style="width:400px;padding:10px 20px"
			closed="true" buttons="#dlg-buttons">
		<form id="fm" method="post" novalidate>
        <div class="fitem"> <label>Влекач:</label>
        <select name="vlekach_number" class="easyui-combobox" required="true" style="width:140px;" />
                    <?php
                        $user_name = "root";
                        $password = "";
                        $database = "programa";
                        $server = "localhost";
                        //connect to host
						$db_handle = mysql_connect($server,$user_name,$password);
                        if (!$db_handle){
                            die('Не мога да се свържа: ' . mysql_error());
                        }
                        //connect to database
                        mysql_select_db($database, $db_handle);
                        //collect user names
						mysql_query("SET CHARACTER SET utf8");
                        $query = mysql_query("SELECT * FROM vlekachi")
                            or die(mysql_error());
                        $row_count = mysql_num_rows($query);
                        for ($i=0; $i<$row_count; $i++) {
                            $user = mysql_fetch_array($query);
                            echo("<option value=\"".$user['vlekach']."\">".$user['vlekach']."</option>");
                        }
                        mysql_close($db_handle);
                    ?>
</select></div>
        <div class="fitem"><label>Ремарке:</label>
        <select name="trailer_number" class="easyui-combobox" required="true" style="width:140px;"  >
                    <?php
                        $user_name = "root";
                        $password = "";
                        $database = "programa";
                        $server = "localhost";
                        //connect to host
						$db_handle = mysql_connect($server,$user_name,$password);
                        if (!$db_handle){
                            die('Не мога да се свържа: ' . mysql_error());
                        }
                        //connect to database
                        mysql_select_db($database, $db_handle);
                        //collect user names
						mysql_query("SET CHARACTER SET utf8");
                        $query = mysql_query("SELECT * FROM remarketa")
                            or die(mysql_error());
                        $row_count = mysql_num_rows($query);
                        for ($i=0; $i<$row_count; $i++) {
                            $user = mysql_fetch_array($query);
                            echo("<option value=\"".$user['remarke']."\">".$user['remarke']."</option>");
                        }
                        mysql_close($db_handle);
                    ?>
</select></div>
		<div class="fitem"><label>Шофьор:</label>
         <select name="driver_name" class="easyui-combobox" required="true" style="width:140px;"  >
                    <?php
                        $user_name = "root";
                        $password = "";
                        $database = "programa";
                        $server = "localhost";
                        //connect to host
						$db_handle = mysql_connect($server,$user_name,$password);
                        if (!$db_handle){
                            die('Не мога да се свържа: ' . mysql_error());
                        }
                        //connect to database
                        mysql_select_db($database, $db_handle);
                        //collect user names
						mysql_query("SET CHARACTER SET utf8");
                        $query = mysql_query("SELECT * FROM shofiori")
                            or die(mysql_error());
                        $row_count = mysql_num_rows($query);
                        for ($i=0; $i<$row_count; $i++) {
                            $user = mysql_fetch_array($query);
                            echo("<option value=\"".$user['ime']."\">".$user['ime']."</option>");
                        }
                        mysql_close($db_handle);
                    ?>
</select>
        </div>
		<div class="fitem"><label>Служебен аванс:</label><input name="slujeben_avans" class="easyui-validatebox" required="true"></div>
		<div class="fitem"><label>Дата на получаване:</label><input name="start_date" class="easyui-datetimebox"  required="true"></div>
        <div class="fitem"><label>Дата на отчитане:</label><input name="end_date" class="easyui-datetimebox"></div>
        <div class="fitem"><label>Дестинация:</label><input name="destination" class="easyui-validatebox"></div>
        <div class="fitem"><label>Забележка:</label><input name="zabelejka" class="easyui-validatebox"></div>
        <div id="disp" style="border:1px solid #000;"></div>
		</form>
	</div>
	<div id="dlg-buttons">
		<a href="#" class="easyui-linkbutton" iconCls="icon-ok" onClick="saveAdvance()">Запис</a>
		<a href="#" class="easyui-linkbutton" iconCls="icon-cancel" onClick="javascript:$('#dlg').dialog('close')">Отказ</a>
	</div>
А това е php файла за проверка
Код: 
<?php
include('conn.php');
if(isset($_POST['vlekach_number']))
{
$name=$_POST['vlekach_number'];
$query=mysql_query("select * from kasova_kniga where vlekach_number='$name' AND start_date !='' ");
$row=mysql_num_rows($query);
if($row==0)
{
echo "<span style='color:green;'>Niama neotcheteni avansi</span>";
}
else
{
echo "<span style='color:red;'>Внимание! За този влекач има неотчетени аванси!</span>";
}
}
?>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Горе