altered query string to produce correct trans_ID
authorAlex McMahon <alex.mcmahon@cs.tcd.ie>
Thu, 21 May 2009 17:11:18 +0100
changeset 9 e506cab7f83a
parent 8 6df283b800af
child 10 1c27769b8435
altered query string to produce correct trans_ID
add_search.php
--- 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";