hey everyone...
having a problem with my SQL search script. Hopfully you all can help me out.
my php query code.
$query=("select quest_name, quest_information, submitted_by, quest_location,
quest_group_required, quest_leval, MATCH(quest_name)
AGAINST('$string') from quests order by quest_name");
my php output code
while($row = mysql_fetch_array($result)){
echo '<table width="100%" border=1 align="center" cellpadding="0" cellspacing="0" cellborder="1">
<!--DWLayoutTable-->
<tr>
<td height="19" colspan="2" valign="top">Quest Name </td>
<td width="319" valign="top">'.$row['quest_name'].'</td>
<td colspan="2" valign="top">Submitted by : '.$row['submitted_by'].'</td>
</tr>
<tr>
<td width="50" height="19" valign="top">Leval:</td>
<td width="52" valign="top">'.$row['quest_leval'].'</td>
<td> </td>
<td width="102"> </td>
<td width="136" valign="top"><div align="center">View Comments </div></td>
</tr>
<tr>
<td height="19" valign="top">Group:</td>
<td valign="top">'.$row['quest_group_required'].'</td>
<td colspan="3" rowspan="7" valign="top">'.$row['quest_information'].'</td>
</tr>
<tr>
<td height="22" colspan="2" valign="top"><div align="center">Location</div></td>
</tr>
<tr>
<td height="23" colspan="2" valign="top"><div align="center">'.$row['quest_location'].'</td>
</tr>
<tr>
<td height="22"> </td>
<td></td>
</tr>
<tr>
<td height="22" colspan="2" valign="top"><div align="center">Comments</div></td>
</tr>
<tr>
<td height="20" colspan="2" valign="top"><div align="center">%comment_count</div></td>
</tr>
<tr>
<td height="19" valign="top">Add</td>
<td valign="top">View all </td>
</tr>
</table>
<br>
<br>';}
What it's not doing is....
When i type in a string, lets say 1, it does not only return everything relavent to 1. It still returns everything in the databse. Any clue how i can narrow this down?
