my limited mysql knowledge always produced inaccurate search results when i write the board search engine. i want to do better this time for the new board so i’m reading this and trying out mysql regular expression and full text search. i’m pretty excited.

oh also, leslie reminded me. this perl style coding will save you from using back slashes and stuff like

<?=$var?>

PHP CODE:

<?php
f(isset($j_sidebar)) { 
	echo <<<EOF 
	<div id="side"> 
	{$j_sidebar} 
	</div>
	<!--/side--> 
	EOF; 
} 
echo <<<EOF 
<div id="main"> 
{$j_main} 
</div><!--/main--> 
</div><!--/outer--> 
</body> 
</html> 
EOF;
?>

vs.

PHP CODE:

if(isset($j_sidebar)) { 
	echo "<div id=\"side\"> $j_sidebar </div><!--side-->"; 
} 
echo "<div id=\"main\"> $j_main </div><!--/main--> </div><!--/outer--> </body> </html>";</code>

i’ve been using the second for too long, it’s hard to change but it certainly doesn’t hurt to try something different 🙂

hehe another tip from leslie, you can insert multiple records into one table using just one query:

INSERT INTO blah (blah, blah) VALUES (blah, blah), (blah, blah), ....