All pastes #363182 Raw Edit

Stuff

public php v1 · immutable
·published 2007-02-19 07:26 UTC
rendered paste body
<?PHP	include("includes/config.php");	include("includes/header.php");		mysql_connect($database['host'], $database['userid'], $database['pass']) or	   die("Could not connect: " . mysql_error());	mysql_select_db($database['db']);		$search_query 			= $_POST[searchResults];		$search_query 			= "'$search_query'";		$query 					= "SELECT * FROM releases WHERE rlsText LIKE $search_query ORDER BY rlsID";	//$query   				= mysql_query("SELECT * FROM releases WHERE rlsText LIKE $search_query ORDER BY rlsID");	$results 				= mysql_query( $query ) or die(mysql_error());		$num=mysql_numrows($results);		$i=0;		while ($i < $num) {		$rlsID =mysql_result($results,$i,"rlsID");	echo "$rlsID<br>";		$rlsText =mysql_result($results,$i,"rlsText");	echo "$rlsText<br>";		$urlText =mysql_result($results,$i,"urlText");	echo "$urlText<br>";		$i++;	}?>		<?PHPecho $search_query;//print_r($_POST);		?>		<p> 		today is: <?=date("l dS"). " of " .date("F Y h:i:s A") ?>	</p>					<div id="links">			<?PHP	include("includes/footer.php");?>