形式问题！请帮忙 ！ [英] Form Problem ! Please Help !

问题描述

我的表格和结果在一页上。

如果我使用：


if（$ Company）{

$ query ="选择公司，联系

来自tblworking

其中ID = $ Company

按公司ASC排序" ;;

}


if（$ Name）{

$ query =" SELECT *

FROM TBLWorking

WHERE联系人喜欢''％$姓名％''

订购联系人" ;;

}

$ result = mysql_query（$ query）;

$ number = mysql_numrows（$ result）;

for（$ i = 0; $ i< $ number; $ i ++）{<


$ CompanyName = mysql_result（$ result，$ i，" Company"）;

$ ContactName = mysql_result（$ result，$ i，" Contact" ）;


打印"公司：$ CompanyName";

打印"< P>名称：$ ContactName";

}


一旦我进入页面，它就会使用$ Name搜索，即使我没有输入任何信息。
< b r />
这导致我在屏幕上打印出一个完整的列表，而不是我需要搜索
。


我如何获得这只是表格，然后表格和结果？


谢谢

解决方案

< blockquote>公司）{

query ="选择公司，联系

来自tblworking

其中ID =

公司

按公司ASC排序" ;;

}


if（

My form and results are on one page.
If I use :

if ($Company) {
$query = "Select Company, Contact
From tblworking
Where ID = $Company
Order By Company ASC";
}

if ($Name ) {
$query = "SELECT *
FROM TBLWorking
WHERE Contact Like ''%$Name%''
ORDER BY Contact";
}
$result = mysql_query($query);
$number = mysql_numrows($result);
for ($i=0; $i<$number; $i++) {

$CompanyName = mysql_result($result,$i,"Company");
$ContactName = mysql_result($result,$i,"Contact");

Print "Company: $CompanyName";
Print "<P>Name: $ContactName";
}

As soon as I enter the page it searchs using $Name, even though I have not
entered any information.

This results in me getting a complete list printed on screen, with out me
having to search.

How do I get this to show just the form, then the form and the results ?

Thanks

解决方案

Company) {

query = "Select Company, Contact
From tblworking
Where ID =

Company
Order By Company ASC";
}

if (

这篇关于形式问题！请帮忙 ！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！