Hi, I'm having trouble with preg_replace and a mysql query. Here's my code :
$query = $db->query("SELECT style FROM ".$table_styles." WHERE id = '1'"); $r = $db->fetch_array($query); $style_1 = $r[style]; $query = $db->query("SELECT id, name, description FROM ".$table_categories.""); while($r = $db->fetch_row($query)) { $category_id = $r[0]; $category_name = $r[1]; $category_description = $r[2]; $style_1 = preg_replace('/\[url\]/', "index.php?catID=$category_id", $style_1); $style_1 = preg_replace('/\[title\]/', "$category_name", $style_1); echo "$style_1\n"; echo "<BR>\n"; } This is the schema for $table_styles +----+-------------+-------------------------------------------------+------ -----------------------+ | id | name | description | style | +----+-------------+-------------------------------------------------+------ -----------------------+ | 1 | Title Links | The style for the title links on the main page. | <a href="[url]">[title]</a> | +----+-------------+-------------------------------------------------+------ -----------------------+ This is the schema for $table_categories +----+------+------------------------------------------+-----------+-------- --+ | id | name | description | picture | comments | +----+------+------------------------------------------+-----------+-------- --+ | 1 | PHP | PHP is a powerful open source language. | icon3.gif | 0 | | 2 | ASP | ASP is microsoft's dynamic web language.| icon2.gif | 0 | +----+------+------------------------------------------+-----------+-------- --+ The script should loop and replace [url] and [title] with the relative id and name from $table_categories, however when it is run, it gives out : <a href="index.php?catID=1">PHP</a> <BR> <a href="index.php?catID=1">PHP</a> <BR> I'm really not sure what's going on, can anyone help me ? Alex -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php