hi guys,

trying to write a searching engine with php and mysql. my question is that as the an input keyed in the web site, the php tell mysql to search for it.

here is my code:


$sql = "SELECT * FROM `General` WHERE `Item_Name` LIKE $Name";
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password );
$result=mysql_db_query( $mysql_database, $sql,$conn );
while($row=mysql_fetch_row($result))
{
print_r($row);
}
mysql_free_result($result);

as the users will not type exact name of looking for item, so i would prefer to use LIKE instead of = sign.

somehow i always get error messages:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\Book_Shop\SearchOK.php on line 36

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\Book_Shop\SearchOK.php on line 47

please help. thank you very much.

[b][size我試著血一各技術器和防灌屬程式,但是這兩各程式只有在寫完當天可用.適閣一天候技術器完全停擺,我的防灌水也沒用了!以下是我的程式,請哪位高手好心幫幫忙指點我一下!


$ip_addr = getenv("REMOTE_ADDR");

//建立連線 --- 透過 (伺服器位址、使用者名稱、使用者密碼)
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password );

//準備好您的 SQL 語法
$sql = "SELECT time_to_sec( now( ) ) - time_to_sec( time )FROM `my_index`WHERE `New` ='1' AND `ip_addr` = '$ip_addr' ORDER BY `time_to_sec( now( ) ) - time_to_sec( time )` ASC ";

//進行查詢(選取)
$result=mysql_db_query( $mysql_database, $sql,$conn );

//將查詢後的結果 --> 抓出一筆
$row=mysql_fetch_row($result);

//印出該筆資料的所有欄位[陣列]
print_r($row);

$time = $row[0]; //適閣一天候,$time < 0

//清除查詢結果
mysql_free_result($result);

if ($time > 5)
{

//建立連線 --- 透過 (伺服器位址、使用者名稱、使用者密碼)
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password);

//準備好您的 SQL 語法
$sql = "INSERT INTO `my_index` ( `New` , `Time` , `ip_addr` )VALUES ('1', NOW( ) , '$ip_addr');";

//選取您要處理的資料庫
mysql_select_db($mysql_database,$conn);

//進行查詢(或叫做執行)...
$result = mysql_query($sql);

//抓取自動增加的欄位key值(流水號)...
$id = mysql_insert_id();

//結束並且釋放連線
mysql_close($conn);

}