UPDATE subscribers SET email_format = replace(email_format,”TEXT”,”HTML”)
UPDATE subscribers SET email_format = replace(email_format,”TEXT”,”HTML”)
Just go to your Wamp Directory insder “c:/wamp/alias/phpmyadmin.conf” — This path.
Here you can check this <Directory “c:/wamp/apps/phpmyadmin3.4.5/”> the phpmyadmin version is same in your c:/wamp/apps/
Then you see this file
1. AllowOverride All
2. “Deny from all” to “Allow from all”
3. “Order Deny,Allow” to “Order Allow,Deny”
that is all. Now its working. If this is not working then you go to check your ISS part.
<?php
/****************
* File: displaytables.php
* Date: 1.13.2009
* Author: design1online.com
* Purpose: display all table structure for a specific database
****************/
//connection variables
$host = “localhost”;
$database = “your_db_name”;
$user = “your_username”;
$pass = “your_pass”;
//connection to the database
mysql_connect($host, $user, $pass)
or die (‘cannot connect to the database: ‘ . mysql_error());
//select the database
mysql_select_db($database)
or die (‘cannot select database: ‘ . mysql_error());
//loop to show all the tables and fields
$loop = mysql_query(“SHOW tables FROM $database”)
or die (‘cannot select tables’);
while($row = mysql_fetch_array($loop))
{
echo “
<table cellpadding=2 cellspacing=2 border=0 width=75%>
<tr bgcolor=#666666>
<td colspan=5><center><b><font color=#FFFFFF>” . $row[0] . “</font></center></td>
</tr>
<tr>
<td>Field</td><td>Type</td><td>Key</td><td>Default</td><td>Extra</td>
</tr>”;
$i = 0;
$loop2 = mysql_query(“SHOW columns FROM ” . $row[0])
or die (‘cannot select table fields’);
while ($row2 = mysql_fetch_array($loop2))
{
echo “<tr “;
if ($i % 2 == 0)
echo “bgcolor=#CCCCCC”;
echo “><td>” . $row2[0] . “</td><td>” . $row2[1] . “</td><td>” . $row2[2] . “</td><td>” . $row2[3] . “</td><td>” . $row2[4] . “</td></tr>”;
$i++;
}
echo “</table><br/><br/>”;
}
?>
Reference : http://jadendreamer.wordpress.com/2009/01/13/print-all-mysql-database-tables-fields-using-php/
thanks above content for the above url.