name-database archive

5) { if(strlen($where) > 0) $where = $where . " AND RecDate >= '" . $_POST['txtDateFrom'] . "'"; else $where = "RecDate >= '" . $_POST['txtDateFrom'] . "'"; } } if(isset($_POST['txtDateTill'])) { if(strlen($_POST['txtDateTill']) > 5) { if(strlen($where) > 0) $where = $where . " AND RecDate <= '" . $_POST['txtDateTill'] . "'"; else $where = "RecDate >= '" . $_POST['txtDateTill'] . "'"; } } if(isset($_POST['txtMessageID'])) { if(strlen($_POST['txtMessageID']) > 0) { if(strlen($where) > 0) $where = $where . " AND YahooMessageID = '" . $_POST['txtMessageID'] . "'"; else $where = "YahooMessageID = '" . $_POST['txtMessageID'] . "'"; } } if(isset($_POST['txtUser'])) { if(strlen($_POST['txtUser']) > 0) { if(strlen($where) > 0) $where = $where . " AND FromUser like '%" . $_POST['txtUser'] . "%'"; else $where = "FromUser like '%" . $_POST['txtUser'] . "%'"; } } if(isset($_POST['txtMessage'])) { if(strlen($_POST['txtMessage']) > 2) { if(strlen($where) > 0) $where = $where . " AND (Subject like '%" . $_POST['txtMessage'] . "%' OR Message like '%" . $_POST['txtMessage'] . "%')"; else $where = "(Subject like '%" . $_POST['txtMessage'] . "%' OR Message like '%" . $_POST['txtMessage'] . "%')"; } } $link = mysql_connect("localhost", "USERNAME", "PASSWORD") or die(mysql_error()); mysql_select_db("name-database") or die (mysql_error()); $query = "SELECT YahooMessageID, Subject, FromUser, RecDate FROM archive WHERE " . $where . " ORDER BY YahooMessageID desc"; $result = mysql_query($query, $link) or die(mysql_error()); while($row = mysql_fetch_row($result)) { $resulthtml.=<< Yahoo | $row[0] $row[1] $row[2] $row[3] EOD; } $rowcount = mysql_num_rows($result); mysql_close($link); } } ?> name-database archive

Enter search criteria

Subject/Message
User
Message ID [Number]
Date	from till (format yyyy-mm-dd)

query results:

Message ID

Subject

From

Date