search problem

[ice_berg16]

i'm confuse by this for a long time
there are 2 questions
one is about sql string
another is the divide page

this is an exmple
1.php have a form of search condition which include 3 vars

<form action='2.php' method='post'>
<input type=text name=title>
<input type=text name=poster>
<input type=text name=reply_num>

the user must select 1 condition at least
and can leave others with blank
2.php

$title = $POST['title'];
$poster = $POST['poster'];
$reply_num = $_POST['reply_num];

then there will be a sql string
$sql = 'select * from table where............limit 0,10'
/////////how to write the sql string exactly////

$mysql_query($sql);
//display the result
//there will be only display 10 result in one page
and when i want to get the next 10 rows in the same page
the $_POST var will be unset
and the sql string will be incorrect
so how shall i do ???

[drag0n]

First of all for the sql string, you will need something like:
mysql_query("SELECT*FROMwhatevertableWHEREwhatevercolumnLIKE'%$search%'");

Once you get that, we will move onto the "next Page, etc" function

[ice_berg16]

but you dont know which condition the user have selected
for example

i do it like this

$sql = "select * from table where ";
if (!empty($title))
$sql .= "title like '%$title%' ";
if (!empty($author))
$sql .= "AND author like '%$author%' ";
if (!empty($reply_num))
$sql .= "AND reply_num = $reply_num";

mysql_query($sql);
........................
but if the $title is empty and the other two isnot empty
the $sql string will be like this
$sql = "select * from table where AND author like '%$author%' AND reply_num = $reply_num";

it's incorrect ........
how should i resolve this?

[seby]

well, i hope this gives you a better idea.. not many people here will go out of their way .. 🙂

<form action="search.php" method="post"> 
<input type="text" name="title" /> 
<input type="text" name="poster" /> 
<input type="text" name="reply_num" /> 
<input type="submit" name="submit" value="search" />
</form>

<?php

if ($_POST['submit'])
{
	if (trim($_POST['title']) == '')
	{
		echo 'Please enter some text';
		exit;
	} 
	else
	{
		if (trim($_POST['poster']) != '')
		{
			$condition = " AND author LIKE '%" . addslashes($_POST['poster']) . "%'";
		} 

	if (trim($_POST['reply_num']) != '')
	{
		$condition .= " AND reply_num = '" . addslashes($_POST['reply_num']) . "'";
	} 

	$results = mysql_query("
	           SELECT * FROM table 
			   WHERE your_search_column LIKE '%" . addslashes($_POST['title']) . "%'
			   $condition 
			   ORDER BY your_column DESC LIMIT 0,10
			   "); 
	// rest of your while loop etc...
} 
} 

?>