Wathever you are ging to do with meta tag they still are html tag, so as long as you embend the tag in php code it shuold just work fine. <?php echo "<any_html_tag attribute01=\"$myattribute01\" attribute02=\"$myzttribute02\"> </any_html_tag>"; ?> Any text editor should help you modifying the code by "find & replace" tools. Hope can help ps. FORZA ITALIA AGLI EUROPEI Franciccio "Alessandro Folghera" <info@xxxxxxxxxxx> ha scritto nel messaggio news:40975641001B47A9@xxxxxxxxxxxxxxxxxxxxx > I hope that phpers will be not angry if I'm posting that maybe stupid > question. > I have the following script, an URL Directory Manager (PHP4 from Wrox Press). > I'd like to pass the variable "category" into the TITLE META TAG from > php_category when I select the corrispondent category_id into the URL > Directory > Manager, i.e. to display the right category everytime I call it from the > script. As I'm an absolute beginner, I'd like someone could suggestme the most > rapid way to do it whitout rewriting all the code. Thanks for all, Alessandro > xxxxxxxxxxxx Tables of MySQL sample_db xxxxxxxxxxxxxxxxxxxxxxxxxxxx # Table > structure for table 'php_category' CREATE TABLE php_category ( category > varchar(30) NOT NULL, category_id varchar(15) NOT NULL, num_item int(5) NOT > NULL, PRIMARY KEY (category_id) ); # Table structure for table 'php_directory' > CREATE TABLE php_directory ( url_id int(10) NOT NULL auto_increment, > category_id varchar(15) NOT NULL, title varchar(150) NOT NULL, url > varchar(150) > NOT NULL, description text NOT NULL, registerdate date, hit int(5) NOT NULL, > lastaccesstime timestamp(14), password varchar(20) binary, email varchar(100) > NOT NULL, approved char(1) NOT NULL, PRIMARY KEY (url_id), UNIQUE url (url, > category_id) ); xxxxxxxxxxxxxxx php_directory.inc xxxxxxxxxxxxxxxxxxxxxx > xxxxxxxxxxxxxxxxxx php_directory.php xxxxxxxxxxxxxxxxx "; $MYSQL_ERRNO = ''; > $MYSQL_ERROR = ''; function directory_header() { global $new_window_width, > $new_window_height; ?> alert(\"Error: $msg\");history.go(-1)"; > directory_footer(); exit; } function user_message($msg, $url='') { > directory_header(); if(empty($url)) echo "alert(\"$msg\");history.go(-1)"; > else > echo "alert(\"$msg\");self.location.href='$url'"; directory_footer(); exit; } > function get_category_info($category_id) { global $default_dbname, > $category_tablename, $root_category_id, $category_id_length, $welcome_message, > $PHP_SELF; global $link_id; if(!$link_id) $link_id = > db_connect($default_dbname); if($category_id == $root_category_id) { > $category_info_array["category"] = "Top"; $category_info_array["num_item"] > = 0; > $query = "SELECT max(category_id), count(*) FROM $category_tablename WHERE > length(category_id) = $category_id_length"; $result = mysql_query($query); > if(!$result) echo sql_error(); $query_data = mysql_fetch_row($result); > $sibling_id = $query_data[0]; $num_child = $query_data[1]; > $category_info_array["num_child"] = $num_child; if(!$sibling_id) > $next_category_id = '001'; else { $sibling_length = strlen($sibling_id); > $next_category_id = $sibling_id + 1; for($i = strlen($next_category_id); $i > " . > $query_data[0] .""; $parent_array[$j] = $query_data[0]; $j++; } > $category_info_array["href_fullname"] = implode("->", $parent_href_array); > $category_info_array["fullname"] = implode("->", $parent_array); } return > $category_info_array; } function get_url_info($url_id) { global $link_id, > $default_dbname, $directory_tablename; if(!$link_id) $link_id = > db_connect($default_dbname); $query = "SELECT url_id, category_id, title, url, > description,registerdate, date_format(registerdate, '%M, %e, %Y') as > formatted_registerdate, hit, lastaccesstime, date_format(lastaccesstime, '%M, > %e, %Y %r') as formatted_lastaccesstime, password, email, approved FROM > $directory_tablename WHERE url_id = '$url_id'"; $result = mysql_query($query); > if(!$result) echo sql_error(); return mysql_fetch_array($result); } function > search_form($category_id) { global $root_category_id, $PHP_SELF; > if(!isset($category_id)) $category_id = $root_category_id; ?> > "> Search: ">Current Category ">All Categories OR AND > > $category_href_fullname ($num_child_str, $num_item_str) > > \n"; else echo " > > $category_href_fullname ($num_child_str) > > \n"; search_form($category_id); $query = "SELECT category, category_id FROM > $category_tablename WHERE (length(category_id) = $category_depth * > $category_id_length) AND category_id LIKE '$category_id%' ORDER BY category"; > $result = mysql_query($query); if(!$result) echo sql_error(); > if(mysql_num_rows($result) > 0) { ?> > > \n"; echo "\n"; echo "<\"$PHP_SELF?action=show_list> > category_id=$my_category_id\"> $my_category ($num_child_str, > $num_item_str)\n"; > echo "\n"; if(!($i % 2)) echo "\n"; $i++; } if(!($i % 2)) { echo " \n" ; echo > ""; } ?> > > $found_str - Keyword(s): $keywords > > > \n"; if($total_num > 0) echo " > Displaying page $page_num out of $last_page_num > > \n"; $query = "SELECT url_id, category_id, title, url, description, > date_format(registerdate, '%M, %e, %Y') as formatted_registerdate, hit, > date_format(lastaccesstime, '%M, %e, %Y %r') as formatted_lastaccesstime, hit > FROM $directory_tablename WHERE $category_str AND approved = 1 $keyword_str > ORDER BY registerdate DESC $limit_str"; $result = mysql_query($query); > if(!$result) echo sql_error(); $i = 1; while($query_data = > mysql_fetch_array($result)) { $url_id = $query_data["url_id"]; > $formatted_registerdate = $query_data["formatted_registerdate"]; > $formatted_lastaccesstime = $query_data["formatted_lastaccesstime"]; $url = > "http://" . $query_data["url"]; $title = $query_data["title"]; $description = > $query_data["description"]; $hit = $query_data["hit"]; echo " > <\"$PHP_SELF?action=go_url&url=$url&url_id=$url_id\">". ($i+($cur_page * > $records_per_page)).".$title \n"; echo " > > > > \n"; echo $description; echo " > > \n"; echo "Last Access: $formatted_lastaccesstime > > \n"; echo "Hit(s): " . number_format($hit) . " > > \n"; if($admin) echo "<\"$PHP_SELF?action=delete_url&url_id=$url_id> > > category_id=$category_id&url=$url> title=$title&cur_page=$cur_page\"> > [Delete] > > \n"; echo "<\"javascript:open_window('$PHP_SELF? > > action=modify_url_form&url_id=$url_id> > > category_id=$category_id&cur_page=$cur_page');\"> [Modify] \n"; if(!$admin) > > echo "<\"mailto:$dirmaster_email? subject=PHPDirectory]SiteMissing> > > body=url_id:$url_id($url)\"> [Report Broken Link] \n"; echo " > > \n"; $i++; } if($search_on) $search_str = > "&search_on=1&search_type=$search_type&keywords=$keywords&search_category=$s > earch_category"; echo " > "; if($page_num > 1) { $prev_page = $cur_page - 1; echo > "<\"$PHP_SELF?action=show_list&category_id=$category_id&cur_page=0$search_st > r\">[Top]"; echo > "<\"$PHP_SELF?action=show_list&category_id=$category_id&cur_page=$prev_page$ > search_str\">[Prev] "; } if($page_num [Next] "; echo > "<\"$PHP_SELF?action=show_list&category_id=$category_id&cur_page=$last_page$ > search_str\">[Bottom]"; } echo " > "; echo " > > <\"$PHP_SELF?action=show_list\">[Directory Home] \n"; if($submittable) echo > "<\"javascript:open_window('$PHP_SELF?action=add_url_form&category_id=$categ > ory_id');\">[Submit a URL]\n"; echo " > "; ?> "; list_sites('new', $category_id); ?> > > Submit a PHP Site! > > "> "> > > Category > Title > URL > Email > Password > Retype Password > Description > ( Chars Max.) > > > $max_desc_length) error_message("Description too long! $max_desc_length chars > max!"); $title = addslashes($title); $description = addslashes($description); > $password = crypt($password, '.v'); if(!$link_id) $link_id = > db_connect($default_dbname); $query = "SELECT url FROM $directory_tablename > WHERE url = '$url' AND category_id = '$category_id'"; $result = > mysql_query($query); if(!$result) error_message(sql_error()); > if(mysql_num_rows($result) != 0) error_message("$url already exists in the > directory!"); $approved = 0; if($admin) { $query = "UPDATE $category_tablename > SET num_item = num_item + 1 WHERE category_id = '$category_id'"; $result = > mysql_query($query); if(!$result) error_message(sql_error()); $approved = 1; } > $query = "INSERT INTO $directory_tablename VALUES(NULL, '$category_id', > '$title', '$url', '$description', curdate(), 0, NULL, '$password', '$email', > $approved)"; $result = mysql_query($query); if(!$result) > error_message(sql_error()); if($send_mail){ $mail_subject = "PHP Directory>> > Thank your for your listing."; $mail_body = "Thank you for sharing your > resources with us.\n"; $mail_body = "Your contribution will be listed after > review in a day or two.\n\n"; $mail_body .= "Title: $title\n"; $mail_body .= > "URL: $url\n"; $mail_body .= "Description: $description"; mail($email, > $mail_subject, $mail_body, "From: $dirmaster_email\nReply-to: > $dirmaster_email"); } $num_rows = mysql_affected_rows($link_id); if($num_rows > != 1) error_message(sql_error()); else echo " alert(\"$title($url) has been > successfully submitted!\"); > opener.location.href='$PHP_SELF?action=show_list&category_id=$category_id'; > self.close(); "; } function modify_url_form() { global $PHP_SELF, > $max_desc_length, $url_id, $category_id, $admin_script, $cur_page; > directory_header(); if(basename($PHP_SELF) == $admin_script) $admin = 1; > $url_info_array = get_url_info($url_id); $category_info_array = > get_category_info($url_info_array["category_id"]); ?> > > Update your PHP site! > > * Submitted on: > * Hits: > * Last Access: > "> "> "> > > Category > Email > Password > Title " SIZE="30" MAXLENGTH="150"> > URL " SIZE="30" MAXLENGTH="150"> > Description > ( Chars Max.) > > > $max_desc_length) error_message("Description too long! $max_desc_length chars > max!"); $url_info_array = get_url_info($url_id); if(!$admin >> > (($url_info_array["password"] != crypt($password, '.v')) || > ($url_info_array["email"] != $email))) error_message("You don't have > permission > to modify this URL!"); $title = addslashes($title); $description = > addslashes($description); if(!$link_id) $link_id = > db_connect($default_dbname); > $query = "UPDATE $directory_tablename SET title='$title', url='$url', > description='$description' WHERE url_id='$url_id'"; $result = > mysql_query($query); if(!$result) error_message(sql_error()); $num_rows = > mysql_affected_rows($link_id); if($num_rows != 1) error_message(sql_error()); > else echo "alert(\"$title($url) has been successfully modified!\"); > opener.location.href='$PHP_SELF?action=show_list&category_id=$category_id&cu > r_page=$cur_page'; self.close();"; } function go_url() { global > $default_dbname, > $directory_tablename; global $url_id, $url; if(isset($url_id) >> > isset($url)) { > if(!$link_id) $link_id = db_connect($default_dbname); $result = > mysql_query("UPDATE $directory_tablename SET hit = hit + 1 WHERE > url_id=$url_id"); if(!$result) error_message(sql_error()); header("Location: > $url"); exit; } } function list_sites($mode='top', $category_id='') { global > $directory_tablename, $root_category_id, $PHP_SELF, $num_top_sites, > $num_new_sites; if(!$link_id) $link_id = db_connect($default_dbname); > if($mode=='top') { $order_by_str = 'ORDER BY hit DESC'; $limit_str = "LIMIT > $num_top_sites"; } else { $order_by_str = 'ORDER BY registerdate DESC'; > $limit_str = "LIMIT $num_new_sites"; } if($category_id == $root_category_id) > $category_str = '1'; else $category_str = "category_id LIKE '$category_id%'"; > $query = "SELECT url_id, title, url FROM $directory_tablename WHERE > $category_str AND approved = 1 $order_by_str $limit_str"; $result = > mysql_query($query); if(!$result) echo sql_error(); if(mysql_num_rows($result) > > 0) { if($mode=='top') echo "Top $num_top_sites! > "; else if($mode=='new') echo "New $num_new_sites! > "; } $i = 1; while($query_data = mysql_fetch_array($result)) { $url_id = > $query_data["url_id"]; $url = "http://" . $query_data["url"]; $title = > $query_data["title"]; echo " - > <\"$PHP_SELF?action=go_url&url=$url&url_id=$url_id\">$i. $title > \n"; $i++; } } ?> xxxxxxxx dir_manager.php xxxxxxxxxxxxxxxxxxx Click on the > level on which you want to add a new category. > > "; echo " > > > > \n"; echo > > "<\"javascript:open_window('$PHP_SELF?action=add_category_form&parent=$roo > > t_category_id')\">" . $category_info_array["category"] ." (" . > > $category_info_array["num_child"] . ")"; } else { echo " > > Click on the category you want to edit. > > > > "; echo " > >> > >> \n"; echo > >> "<\"javascript:open_window('$PHP_SELF?action=edit_category_form&category_ > >> id=$root_category_id')\">" . $category_info_array["category"] ." (" . > >> $category_info_array["num_child"] . ")"; } echo " > >> \n"; echo " > >>> > >>> \n"; while($query_data = mysql_fetch_array($result)) { $category_id = > >>> $query_data[0]; $category_info_array = get_category_info($category_id); > >>> for($i=0; $i X \n"; if($mode == 'add_category') echo > >>> "<\"javascript:open_window('$PHP_SELF?action=add_category_form&parent=$c > >>> ategory_id')\">" . $category_info_array["category"] ." (" . > >>> $category_info_array["num_child"] . ")"; else echo > >>> "<\"javascript:open_window('$PHP_SELF?action=edit_category_form&category > >>> _id=$category_id')\">" . $category_info_array["category"] ." (" . > >>> $category_info_array["num_child"] . ")"; echo " > >>> \n"; } echo " > >> > >> \n"; echo " > > > > \n"; directory_footer(); } function add_category_form() { global > > $default_dbname, $directory_tablename, $category_tablename, $PHP_SELF; > global > > $link_id, $parent; $category_info_array = get_category_info($parent); > > $category_id = $category_info_array["next_id"]; $category_fullname = > > $category_info_array["fullname"]; directory_header(); ?> > > > > Adding a New Category: > > > > "> "> > > > > Category ID > > Category Name > > > > > > alert(\"$category was successfully added!\"); > > opener.location.href='$PHP_SELF'; self.close();"; directory_footer(); } > > function edit_category_form() { global $default_dbname, > $directory_tablename, > > $category_tablename, $PHP_SELF; global $link_id, $category_id; > > $category_info_array = get_category_info($category_id); directory_header(); > > ?> > > > > Editing the Category: > > > > "> "> > > > > Category ID > > Category Name " SIZE="20"> > > Resources > > > > > > alert(\"$category was successfully updated!\"); > > opener.location.href='$PHP_SELF?mode=edit_category'; self.close();"; > > directory_footer(); } function delete_category() { global $default_dbname, > > $directory_tablename, $category_tablename, $PHP_SELF; global $link_id, > > $category_id, $mode; if(empty($category_id)) error_message("Empty Category > > ID!"); if(!$link_id) $link_id = db_connect($default_dbname); $query = > "DELETE > > FROM $category_tablename WHERE category_id LIKE '$category_id%'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); $del_subs = > > mysql_affected_rows($link_id) - 1; $query = "DELETE FROM > $directory_tablename > > WHERE category_id LIKE '$category_id%'"; $result = mysql_query($query); > > if(!$result) error_message(sql_error()); $del_items = > > mysql_affected_rows($link_id); echo "alert(\"1 category, $del_subs > > subcategories, and $del_items items were deleted!\"); > > self.location.href='$PHP_SELF?mode=$mode';"; } function update_db() { global > > $default_dbname, $directory_tablename, $category_tablename, $PHP_SELF; > global > > $link_id, $category_id, $mode; directory_header(); if(!$link_id) $link_id = > > db_connect($default_dbname); $query = "SELECT category, category_id, > num_item > > FROM $category_tablename"; $result = mysql_query($query); if(!$result) > > error_message(sql_error()); $num_revs = 0; while($query_data = > > mysql_fetch_row($result)) { $category = $query_data[0]; $category_id = > > $query_data[1]; $num_item = $query_data[2]; $query = "SELECT count(*) FROM > > $directory_tablename WHERE category_id = '$category_id' AND approved = 1"; > > $result2 = mysql_query($query); $query_data2 = mysql_fetch_row($result2); > > $total = $query_data2[0]; if(!$result2) error_message(sql_error()); > > if($num_item != $total) { $query = "UPDATE $category_tablename SET > num_item = > > $total WHERE category_id = '$category_id'"; $result2 = mysql_query($query); > > if(!$result2) die(sql_error()); echo "Number of resources in \"$category\" > > mismatch -> revised: $total resources. > > \n"; $num_revs++; } } if(!$num_revs) echo "No inconsistency found. > > \n"; else if($num_revs) echo "$num_revs inconsistency has been corrected. > > \n"; else echo "$num_revs inconsistencies have been corrected. > > \n"; echo "Done.\n"; directory_footer(); } function view_new() { global > > $default_dbname, $directory_tablename, $category_tablename, > > $records_per_page, $PHP_SELF, $link_id; global $cur_page; if(!$link_id) > > $link_id = db_connect($default_dbname); $query = "SELECT count(*) FROM > > $directory_tablename WHERE approved != 1"; $result = mysql_query($query); > > if(!$result) echo error_message(sql_error()); $query_data = > > mysql_fetch_row($result); $total_num = $query_data[0]; if(!$total_num) echo > > error_message("No new listing!"); $limit_str = "LIMIT " . $cur_page * > > $records_per_page . ", $records_per_page"; $query = "SELECT url_id, url, > > title, description, category_id FROM $directory_tablename WHERE approved = 0 > > ORDER BY registerdate $limit_str"; $result = mysql_query($query); > > if(!$result) echo error_message(sql_error()); $page_num = $cur_page + 1; > > $total_num_page = floor($total_num/$records_per_page); $last_page_num = > > $total_num_page + 1; directory_header(); top_menu(); echo " > > > > Displaying the page $page_num out of $last_page_num. > > > > "; echo " > > \n"; while($query_data = mysql_fetch_array($result)) { $url_id = > > $query_data["url_id"]; $url = "http://" . $query_data["url"]; $title = > > $query_data["title"]; $description = $query_data["description"]; > $category_id > > = $query_data["category_id"]; $category_info_array = > > get_category_info($category_id); $category_fullname = > > $category_info_array["fullname"]; echo " > > * \n"; echo > > "<\"javascript:open_window('$PHP_SELF?action=edit_new_form&url_id=$url_ > > id&category_id=$category_id');\">[Edit] \n"; echo "<\"$url\">$title > > ($category_fullname) - $description\n"; echo ""; } echo " > > \n"; echo " > > \n"; echo " > > "; if($cur_page > 0) echo "<\"$PHP_SELF?action=view_new&cur_page=0\">[Top]"; > > if($cur_page != 0) { $prev_page = $cur_page - 1; echo > > "<\"$PHP_SELF?action=view_new&cur_page=$prev_page\">[Prev] "; } if($cur_page > > [Next] "; } if($cur_page != $total_num_page) echo > > "<\"$PHP_SELF?action=view_new&cur_page=$total_num_page\">[Bottom]"; echo " > > "; directory_footer(); } function edit_new_form() { global $PHP_SELF, > > $max_desc_length, $url_id, $category_id; directory_header(); $url_info_array > > = get_url_info($url_id); $category_info_array = > > get_category_info($url_info_array["category_id"]); ?> > > > > Editing a new listing. > > > > * Submitted on: > > "> "> "> > > > > Category > > Email "> > > Title " SIZE="30" MAXLENGTH="150"> > > URL " SIZE="30" MAXLENGTH="150"> > > Description > > ( Chars Max.) > > Action Approve Delete > > > > > > alert(\"$title($url) has been successfully deleted!\"); > > opener.location.href='$PHP_SELF?action=view_new'; self.close();"; } else { > > if(strlen($description) > $max_desc_length) error_message("Description too > > long! $max_desc_length chars max!"); $title = addslashes($title); > > $description = addslashes($description); $query = "UPDATE > $category_tablename > > SET num_item = num_item + 1 WHERE category_id = '$category_id'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); $query = > > "UPDATE $directory_tablename SET title='$title', url='$url', > > description='$description', approved = 1 WHERE url_id='$url_id'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); > if($send_mail){ > > $mail_subject = "PHP Directory>> Your contribution has been listed."; > > $mail_body = "Thank you for sharing your resources with us.\n"; $mail_body = > > "Your contribution has been listed. Thank you.\n\n"; $mail_body .= "Title: > > $title\n"; $mail_body .= "URL: $url\n"; $mail_body .= "Description: > > $description"; mail($email, $mail_subject, $mail_body, "From: > > $dirmaster_email\nReply-to: $dirmaster_email"); } $num_rows = > > mysql_affected_rows($link_id); if($num_rows != 1) > error_message(sql_error()); > > else echo "alert(\"$title($url) has been successfully approved!\"); > > self.close();"; } } function delete_url() { global $default_dbname, > > $directory_tablename, $category_tablename, $category_id, $url_id, $url, > > $title; global $PHP_SELF, $link_id; if(!$link_id) $link_id = > > db_connect($default_dbname); $query = "UPDATE $category_tablename SET > > num_item = num_item - 1 WHERE category_id = '$category_id'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); $query = > > "DELETE FROM $directory_tablename WHERE url_id = '$url_id'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); $num_rows = > > mysql_affected_rows($link_id); if($num_rows != 1) > error_message(sql_error()); > > else echo "alert(\"$title($url) has been successfully deleted!\"); > > > self.location.href='$PHP_SELF?action=show_list&category_id=$category_id';"; } > > function top_menu() { global $PHP_SELF; echo "<\"$PHP_SELF\">Admin "; > echo "| > > <\"javascript:open_window('$PHP_SELF?action=update_db');\">Update DB "; echo > > "| <\"$PHP_SELF?mode=edit_category\">Edit Category Mode "; echo "| > > <\"$PHP_SELF?mode=add_category\">Add Category Mode\n"; echo "| > > <\"$PHP_SELF?action=view_new\">New Listings\n"; echo "| > > <\"$PHP_SELF?action=show_list\">View Listings in Admin Mode\n"; echo " > > > > \n"; } switch($action) { case "add_category_form": add_category_form(); > > break; case "add_category": add_category(); break; case > "edit_category_form": > > edit_category_form(); break; case "edit_category": edit_category(); break; > > case "delete_category": delete_category(); break; case "view_new": > > view_new(); break; case "edit_new_form": edit_new_form(); break; case > > "edit_new": edit_new(); break; case "add_url_form": add_url_form(); break; > > case "add_url": add_url(); break; case "modify_url_form": modify_url_form(); > > break; break; case "modify_url": modify_url(); break; case "go_url": > > go_url(); break; case "delete_url": delete_url(); break; case "update_db": > > update_db(); break; case "show_list": directory_header(); top_menu(); > > show_list(); directory_footer(); break; default: list_categories(); break; } > > ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php