----- Original Message -----
From: "raquibul islam"
>I use PHP designer-2007 professional .Its color editor. When i copy the code
>and past in mail the the space generated automatically.Just i'va problem to
>view image.Please help me.
Run this program locally in your XAMPP and see what it displays:
<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='123456';
$dbname='image';
$tbl_name='images';
mysql_connect($dbhost, $dbuser, $dbpass) or die("Error: Cannot find $dbname
database");
mysql_select_db($dbname) or die("Error: Cannot select $dbname database");
echo "Found '$dbname' database<br />";
echo "Attempting to create new '$tbl_name' table<br /><br />";
$sql = "SELECT * FROM $tbl_name LIMIT 1";
if (!mysql_query($sql))
{
$sql = "
create table $tbl_name (
image_id int(10) unsigned NOT NULL auto_increment,
image blob,
image_type varchar(10) NOT NULL default '',
key image_id (image_id)
)";
if (!mysql_query($sql))
{
echo "Error: Failed to create new '$tbl_name' table";
}
else
{
echo "New '$tbl_name' table successfully created";
}
}
else
{
$items = mysql_query("SELECT COUNT(*) FROM $tbl_name");
$total = mysql_result($items, 0);
echo "Table '$tbl_name' already exists (with $total items)";
}
mysql_close();
?>
Regards, Bob.
