Replace syntax

[Archbob]

This doesn't seem to be working:

$result2="REPLACE INTO cl_categories WHERE CatParent='$CatID' (CatParent) VALUES('0')";
        mysql_query($result2);

Isn't replace supposed to be just like insert?

[stolzyboy]

this is how it is done

update tablename set fieldwithcrap = replace(fieldwithcrap,
'oldstring', 'newstring');

[Archbob]

Okay, one more formatting question.

when you display data, how do you get it to display in tables? like I right display my data in two column format using categories in the left column and text in the right but for the right page. I want to display the categories like yahoo does with only Category names in the 3-column format, I'm not sure how to do that.

[stolzyboy]

not sure what you are getting at can you post some code and some database structure to see how you have it set up currently

[Archbob]

$r=mysql_query("SELECT * FROM cl_categories Where CatParent='NADA'", $db) or die("4");
		while ($res = mysql_fetch_array($r))
			print "<a href='index.php?catID=$res[CatID]'>$res[CatName]</a><br>";

This just lists the top level categories.

I want format along the lines like http://www.freebiedirectory.com . How do you get it two columns to a row, I'm confused.

Wow I jus realized that in this script, I've written about 2/3 of it and the other 1/3 came from people at php builder.

[stolzyboy]

when you do your select you can do something like this this should give you three columns i think you can figure out the rest

<?
$conn = mysql_connect("localhost", "username", "pass") or die ("Could not connect to database!");
$db = mysql_select_db("database") or die ("Could not select database");
$query = "select * from table where field = 'whatever'";
$result = mysql_query($query) or die ("Could not select");
$i = 1;
?>
<table border="0" width="502" cellspacing="0" cellpadding="0" align="center"><tr>
<?
while ($row = mysql_fetch_array($result))
{
$j = $i % 3;
if ($j == 0){
?>
</td></td>
</tr><tr>
<?
}
else{
?>
<td width="250" align="center" valign="top">
</td>
<?
}
$i++;
}
?>
</table>