Reply to thread

Message

<blockquote data-quote="Tharindu DR" data-source="post: 2715796" data-attributes="member: 17360">Im creating a search page.I need to search few data bases within one page so I used a como box to change tables, I dont know about PHP sooo this might be wrong.If some one know a better way pls help me thanx.Here is The Form :&lt;form id=&quot;form1&quot; name=&quot;form1&quot; method=&quot;post&quot; action=&quot;&quot;&gt;&nbsp; &lt;label&gt;Search :&nbsp; &lt;input type=&quot;text&quot; name=&quot;q&quot; id=&quot;q&quot; /&gt;&nbsp; &lt;/label&gt;&nbsp; &lt;label&gt;&nbsp; &lt;input type=&quot;submit&quot; name=&quot;btn&quot; id=&quot;btn&quot; value=&quot;Search&quot; /&gt;&nbsp; &lt;/label&gt;&nbsp; &lt;label&gt;&nbsp; &lt;select name=&quot;lst&quot; id=&quot;lst&quot;&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'book_new_item';?&gt;&quot;&gt;Books&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'comp_new_item'; ?&gt;&quot;&gt;Computers&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'mob_new_item' ;?&gt;&quot;&gt;CellPhones&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'clothe_new_item'; ?&gt;&quot;&gt;Clothing&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'camera_new_item'; ?&gt;&quot;&gt;Cameras&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'dvd_new_item' ;?&gt;&quot;&gt;DVDs&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'sport_new_item'; ?&gt;&quot;&gt;Sporting&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'toy_new_item' ;?&gt;&quot;&gt;Toys&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'music_new_item' ;?&gt;&quot;&gt;Musical&lt;/option&gt;&nbsp; &nbsp; &lt;option value=&quot;&lt;?php $table = 'other_new_item' ;?&gt;&quot;&gt;Others&lt;/option&gt;&nbsp; &nbsp; &lt;/select&gt;&nbsp; &lt;/label&gt;&lt;/form&gt;Here is the SQL : ( Both in the same page)mysql_select_db($database_localhost, $localhost);$query_search = sprintf(&quot;SELECT topic, detail, name, `datetime`, reply FROM $table WHERE topic LIKE %s&quot;, GetSQLValueString(&quot;%&quot; . $colname_search . &quot;%&quot;, &quot;text&quot;));$query_limit_search = sprintf(&quot;%s LIMIT %d, %d&quot;, $query_search, $startRow_search, $maxRows_search);$search = mysql_query($query_limit_search, $localhost) or die(mysql_error());$row_search = mysql_fetch_assoc($search);</blockquote>

[QUOTE="Tharindu DR, post: 2715796, member: 17360"] Im creating a search page. I need to search few data bases within one page so I used a como box to change tables, I dont know about PHP sooo this might be wrong. If some one know a better way pls help me thanx. Here is The Form : [B]<form id="form1" name="form1" method="post" action=""> <label>Search : <input type="text" name="q" id="q" /> </label> <label> <input type="submit" name="btn" id="btn" value="Search" /> </label> <label> <select name="lst" id="lst"> <option value="<?php $table = 'book_new_item';?>">Books</option> <option value="<?php $table = 'comp_new_item'; ?>">Computers</option> <option value="<?php $table = 'mob_new_item' ;?>">CellPhones</option> <option value="<?php $table = 'clothe_new_item'; ?>">Clothing</option> <option value="<?php $table = 'camera_new_item'; ?>">Cameras</option> <option value="<?php $table = 'dvd_new_item' ;?>">DVDs</option> <option value="<?php $table = 'sport_new_item'; ?>">Sporting</option> <option value="<?php $table = 'toy_new_item' ;?>">Toys</option> <option value="<?php $table = 'music_new_item' ;?>">Musical</option> <option value="<?php $table = 'other_new_item' ;?>">Others</option> </select> </label> </form>[/B] Here is the SQL : ( Both in the same page) [B]mysql_select_db($database_localhost, $localhost); $query_search = sprintf("SELECT topic, detail, name, `datetime`, reply FROM $table WHERE topic LIKE %s", GetSQLValueString("%" . $colname_search . "%", "text")); $query_limit_search = sprintf("%s LIMIT %d, %d", $query_search, $startRow_search, $maxRows_search); $search = mysql_query($query_limit_search, $localhost) or die(mysql_error()); $row_search = mysql_fetch_assoc($search);[/B] [/QUOTE]

Verification

Hathara warak wissa keeyada? (Hathara wadi karanna 20)

Latest ads

Reply to thread