add_search.php
changeset 9 e506cab7f83a
parent 8 6df283b800af
child 19 a1ed9d6856d6
--- a/add_search.php	Thu May 21 12:58:40 2009 +0100
+++ b/add_search.php	Thu May 21 17:11:18 2009 +0100
@@ -63,11 +63,11 @@
 		mysql_select_db('members');
 
 		$seed = crc32($search_term);
-                $req_ID = genID($seed + time(), 30);
+                $req_ID = genID($seed + time(), 32);
 
 		$query = mysql_query("INSERT INTO requests_tbl (req_ID, uid, req_val, req_response, req_created) VALUES ('$req_ID', '$currID', '$search_term', 0, CURDATE())");
 #		$query2 =  mysql_query("SELECT MAX(req_ID) as id FROM requests_tbl");
-		$query2 =  mysql_query("SELECT req_ID as id FROM requests_tbl");
+		$query2 =  mysql_query("SELECT req_ID as id FROM requests_tbl WHERE req_ID ='$req_ID'");
 		mysql_close();
 		
 		while ($db_field2 = mysql_fetch_assoc($query2)) 
@@ -77,7 +77,8 @@
 		
 		// construct message string
 #		$message = "#" . $currID . "#" . $reqID . "#" . $search_term;
-		$message = "#" . $reqID . "#" . $search_term;
+#		$message = "#" . $reqID . "#" . $search_term;
+		$message =  $reqID . $search_term;
 
 		
 		$host="localhost";