almostbob 866 Retired: passive income ROCKS

perhaps not a direct answer but to determine if the local pc

  • has an application that can read the particular version .doc file you intend to print
  • has a printer
  • has security settings that allows scripts to take over their hardware (MALWARE ALERT)

it would be better to output the .doc as html then printing is easy

almostbob 866 Retired: passive income ROCKS

http://devphp.sourceforge.net/
using the portable version on a thumbdrive in customer offices
the full version on my pc

leviathan185 commented: Just what i needed, Thanks +1
almostbob 866 Retired: passive income ROCKS

havent used the video, have used some of the other howtos on the site http://www.csstutorial.net/

almostbob 866 Retired: passive income ROCKS

Not sure about the exact format, dont have the database structure,
but sql query to create the arrays used to create the table is just 3(maybe 4) lines of code

<?php $dbh = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
// query here creates arrays
mysql_close($dbh); 
echo "<table>";
for($val = 0; $val <= $param1; $val++) // this would be edited to be a parameter of the count returned by the sql above so the table iterates correctly
{ 
echo " <tr>";
 for($ar = 1; $ar <= $param2; $ar++) // this would be edited to be a parameter of the count returned by the sql above so the table iterates correctly
{ 
echo "<td>".${"game".$ar}[$val]."</td>"; 
}
echo "</tr>";
}
echo " </table>";
?>

sql query creates automatically the correct number of arrays for the output html table, from the number of records in the database table

almostbob 866 Retired: passive income ROCKS

make certain you do not change any code you do not understand
the 'new programmers' are using php,
your original answer is obvious, when you understand what the code says, but difficult when you are used to plain html
if you make changes to code that the php depends upon, everything will fail

almostbob 866 Retired: passive income ROCKS

expanding on wilch's prior post, his(her?) answer is correct
the html <label> tag is terribly underused

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Create your news page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<fieldset>
<legend>Checked components will show in the page</legend>
<form method="POST" action="http://*********.php">
<label for='header' class='Header'>Header</label>
<input type="checkbox" name="header" id="header" value="1">
<br>
<label for='footer' class="label">Footer</label>
<input type="checkbox" id='footer' name="footer" value="1">

<hr>
<label for='local' class="label">Local news</label>
<input type="checkbox" id='local' name="local" value="1">

<input type="submit">
</form>
</fieldset>
</body>
</html>

<label>s make checkbox text clickable

almostbob 866 Retired: passive income ROCKS

as noelthefish wrote, the elseif is redundant and takes (miniscule) resources to run, the ! means not,
If (not$variable) {do something;}
else {do something else}

almostbob 866 Retired: passive income ROCKS

Thank you for posting the examples. I looked at the manual and did not understand it. I like forums where people post their own examples and not just refer to "manuals" because it helps me learn more. Thanks for your help.

Glad it all helped, examples stick in my mind better too

nav33n commented: Totally agree :) +11
almostbob 866 Retired: passive income ROCKS
AND Ships.Dest_State IN ('LA') ORDER BY 'PU_Date ASC'

Try removing the ASC from the quotes !

good catch, stared at it and didnt see

jay.barnes commented: Thanks for the help with my MySQL query issue! +1
almostbob 866 Retired: passive income ROCKS

depends on the complexity of the data, and whether you expect to be able to manipulate it online
If the importand information is a static table of information its a piece of cake
have the script that creates the report output it to a .csv file, with the correct name (same name every day)
a php script to display the datafile as a table

<!-- other html -->
<table border="0" cellpadding="0" cellspacing="1">
<?php $row = 1;
$handle = fopen("dailyreport.csv", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
 $num = count($data);
 $row++;
if ($row == 2) {
 echo "<thead>\n<tr>\n";
  for ($c=0; $c < $num; $c++) 	{  echo "<th >" . $data[$c] . "</th>\n";  }
echo "</tr>\n</thead>\n<tbody>"; 
}
else {
echo "<tr>\n";
for ($c=0; $c < $num; $c++) {
echo "<td>" . $data[$c] . "</td>\n";
}
echo "</tr>\n";
}
}
fclose($handle); ?>
</tbody>
</table>
<!--other html -->

crappy code, but it runs
file upload scripts abound, the script above requires the upload script uploads "dailyreport.csv" to the same folder
security is not considered, but should be in any production version

almostbob 866 Retired: passive income ROCKS

why do you suggest using " height='100' height='100' " when <p><img src="picture.gif" style="float:right">then add my text,... , will be more generic and will work for all sizes of a given image?

Tip: It is a good practice to specify both the height and width attributes for an image. If these attributes are set, the space required for the image is reserved when the page is loaded. However, without these attributes, the browser does not know the size of the image, and cannot reserve the appropriate space to it. The effect will be that the page layout will change during loading (while the images load).http://www.w3schools.com/tags/att_img_width.asp

'work' is such a subjective description,
html & xhtml get more strict with each iteration,
'work correctly' is better,
'work correctly tomorrow' is better still
a "generic" page would likely load the image from a database in which the src alt width and height are stored in table columns <img <?php echo $sqlqueryresultcontaining_src_alt_width_height ?> />

almostbob 866 Retired: passive income ROCKS
almostbob 866 Retired: passive income ROCKS

without debugging the code, don't have the db structure, don't know what table refers to what, you have to end up with something like

mysql_select_db($database_rsGunn, $rsGunn);
$query_rsInventory1 = "SELECT ap_form_1.element_1_1, ap_form_1.element_1_2, ap_form_1.element_1_3, ap_form_1.element_1_4, ap_form_1.element_1_5, ap_form_1.element_1_6, ap_form_1.element_2, ap_form_1.element_3, ap_form_1.element_16, ap_form_1.element_4, ap_form_1.element_5, ap_form_1.element_57, ap_form_1.element_6, ap_form_1.element_7, ap_form_1.element_8, ap_form_1.element_9, ap_form_1.id FROM ap_form_1 where id=".$id;
$rsInventory1 = mysql_query($query_rsInventory1, $rsGunn) or die(mysql_error());

horrible data structure ap_form.element_57, not at all intuitive

almostbob 866 Retired: passive income ROCKS

your link to inventory.php has a parameter ?id=$id
assuming $id is the id link of the record in the database
that id is available in inventory.php as $id
somewhere in the inventory.php file there should be (could be, usually is) an sql query that selects the row defined by that id
something like

"select * from database where id=$id"

I could not find such query in the file
I could find many queries, but none that selected on the basis of $id
it may be as simple as finding the variable used in inventory.php to select and
change that named variable to $id /* or */
change the parameter name passed by the link to that used in inventory.php /* or */
add a sql select with the right format
the sql in the files is convoluted, almost as if written to hide its intent

almostbob 866 Retired: passive income ROCKS

inventory.php
there is no 'select * from database where id='.$id
there is no reference to '$id' in the file
the href calling the inventory script
inventory.php?id=$id
if you don't use it, you lose it, and id is getting lost

almostbob 866 Retired: passive income ROCKS
<div class="content">
<table width="600">
<?php $counter = 0; // initialize counter outside loop 
do { echo '<tr';
if ($counter++ % 2) {echo 'class="hilite"';} 
echo '><td width="162"><img src="'.$row_rsAllListings['element_16'].'"></td>';
echo '<td width="426"><h2><a href="\inventory.php?id="'.$id.'">'.$row_rsAllListings['element_1_1'];
echo '</a> |  '.$row_rsAllListings['element_2'].'<br />';
echo $row_rsAllListings['element_3'].'</h2><br />';
echo $row_rsAllListings['element_4'].'<br />';
echo $row_rsAllListings['element_5'].'Beds / '.$row_rsAllListings['element_6']; 
echo $row_rsAllListings['element_7'].'Baths / '.$row_rsAllListings['element_8'].'sf per '.$row_rsAllListings['element_9'].'<br /></td></tr>'; } while ($row_rsAllListings = mysql_fetch_assoc($rsAllListings)); ?>
</table>
</div>

this code is from clicking 'suggestions' devPHP
original code

<div class="content">
  <table width="600">
  <?php $counter = 0; // initialize counter outside loop ?>
<?php do { ?>
<tr <?php if ($counter++ % 2) {echo 'class="hilite"';} ?>>
      <td width="162"><img src="<?php echo $row_rsAllListings['element_16']; ?>></td>
      <td width="426">
<h2><a href="\inventory.php?id=" . $id . "\"><?php echo $row_rsAllListings['element_1_1']; ?></a> | <?php echo $row_rsAllListings['element_2']; ?><br />
        <?php echo $row_rsAllListings['element_3']; ?></h2>
        <br />
        <?php echo $row_rsAllListings['element_4']; ?><br />
        <?php echo $row_rsAllListings['element_5']; ?> Beds / <?php echo $row_rsAllListings['element_6']; ?>-<?php echo $row_rsAllListings['element_7']; ?> Baths / <?php echo $row_rsAllListings['element_8']; ?>sf per <?php echo $row_rsAllListings['element_9']; ?><br />
      </td>
    </tr>
    <?php } while ($row_rsAllListings = mysql_fetch_assoc($rsAllListings)); ?>
  </table>
</div>
almostbob 866 Retired: passive income ROCKS

48 hours

google instructions from google,
or google instructions from some nicknames . . . .
such difficult choices

do the same at yahoo and bing
SEO instructions from the SE that you are trying to O, what a concept, it'll never catch on

almostbob 866 Retired: passive income ROCKS
<img height='100' height='100' alt='alt text' style='float:right'>

works as expected with the sizes specified

Note: with the <img> inside the <p> element, only the text of that <p> will wrap around the image. (examples assuming elements are not styled elsewhere )

<div><p><img height='100' height='100' alt='alt text' style='float:right'>this text will wrap around the image</p>
<p>this text will not</p>
</div>

<div><img height='100' height='100' alt='alt text' style='float:right'><p>this text will wrap around the image</p>
<p>this text will wrap around the image</p>
<p>this text will wrap around the image</p>
almostbob 866 Retired: passive income ROCKS
<FORM encType='text/plain' action='mailto:recipient@mydomain.co.uk'>

quotes, validate the html

<FORM method='post' action='full-url-to-form-handler-script-including-SELF-if-mail-handler-is-declared-within-the-same-file'>

generic mailer use

<?php ob_start("ob_gzhandler"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<htm>
<head>
<title>Tell A friend -</title>
<P>Tell a friend about our site!</p>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method='post'>
<input type='hidden' value="add this message to everything the user sends" name='essage1'>
<div style='width:100%; float:left;'>
<div style='width:39%; text-align: right; float:left;'>To (Friend's name) : </div>
<div style='width:59%; text-align: left; float:right;'><input class='infor' type='text' size='40' value='<?php echo $to_name; ?>' name='to_name'>
</div>
<div style='width:100%; float:left;'>
<div style='width:39%; text-align: right; float:left;'>To (Friend's email) :  </div>
 <div style='width:59%; text-align: left; float:right;'><input  type='text' size='40' value='<?php echo $to_email; ?>' name='to_email'>
 </div>
</div>
<div style='width:100%; float:left;'>
<div class='required' style='width:39%; text-align: right; float:left;'>From (Your name) :
 </div>
 <div class='required' style='width:59%; text-align: left; float:right;'><input class='infor' type='text' size='40' value='<?php echo $from_name; ?>' name='from_name'>
</div>
</div>
<div style='width:100%; float:left;'>
<div style='width:39%; text-align: right; float:left;'>From (Your email) :   </div>
 <div style='width:59%; text-align: left; float:right;'><input class='infor' type='text' size='40' value='<?php echo $from_email; ?>' name='from_email'>
  </div>
 </div>
<div style='width:100%; float:left;'>
 <div style='width:39%; text-align: right; float:left;'>Message :
 </div>
<div class='required' style='width:59%; text-align: left; float:right;'><textarea name='message' cols='45' rows='6'></textarea>
  </div>
 </div>
</div>
<div class="dontprint" style='width:100%; float:left;'>
 <center>
  <button type="submit" name="subm" value="submit" onclick="return(confirm('Are all fields complete?'));" >Submit</button>
<button name="reset" type="reset" VALUE="Reset" >Reset</button>
</div>
</form>
<?php If ($to_email && $message1 && $subject) {
$to = "\"$to_name\" <$to_email>";
$from = "\"$from_name\" <$from_email>";
$to = str_replace("\\'", "'", $to);
$from = str_replace("\\'", "'", $from);
$subject = str_replace("\\'", "'", $subject);
$message = str_replace("\\'", "'", $message);
mail($to, $subject, "Hi $to_name $message1 …
almostbob 866 Retired: passive income ROCKS

most server language have a mail function
php
asp
perl
without coding your own you could google
cgi mail script,,php mail script,,asp mail script,,
Big nose bird http://bignosebird.com/cgi.shtml has a cgi script, auto reply, address verification, required fields, redirect on success, etc etc all bells and whistles very configurable from within the html forms, easy to setup while you learn to code your own

almostbob 866 Retired: passive income ROCKS

the mobile version, of my site is at the subdomain m.mysite.com
this codescrap first in www mysite.com/index.php redirects

<?php $mobile = "http://m.mysite.com/";
if(preg_match('/Windows CE/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/Blackberry/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/Palm/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/SymbianOS/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/Opera Mini/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/Nokia/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/Samsung/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/vodaphone/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/Jphone/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/AvantGo/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/DoCoMo/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");}
elseif(preg_match('/DDIPOCKET/i',$_SERVER['HTTP_USER_AGENT'])) { header("location: $mobile");} 
/* redirect to pda page else continue */ ? >

the code can be better, but it works now

m.mysite.com mirrors www mysite.com but has shortened text descriptions(click for full text), iconized images, to keep each page very small ($/KB), and make the page faster in handhelds.
it is vital to use relative sizes ems,% in a mobile page, the browser rendering differences between palm/blackberry make firefox/IE a piece of cake

www.opera.com/mini/ has an emulator you can test your mobile site on

almostbob 866 Retired: passive income ROCKS
almostbob 866 Retired: passive income ROCKS
if ($checkbox) {
$file = 'downloads/Tutorial1.wmv.zip';
// Set headers
header("Cache-Control: public ;");
header("Content-Description: File Transfer");
header("Content-Disposition: attachment; filename=Tutorial1.wmv.zip");
header("Content-Type: application/zip");
header("Content-Transfer-Encoding: binary");
header("Content-Length: " . filesize($file) ."; ");

maybe, going to think

almostbob 866 Retired: passive income ROCKS

considering the thread is almost a year old.......

unsolved, of vague interest to me, an alternate approach if the op is interested enough to return.

almostbob 866 Retired: passive income ROCKS
almostbob 866 Retired: passive income ROCKS

if the file is stored in a blob in the database, print the database field
if the filename only is stored in the database, without the directory structure

readfile('./pathtofolder/'.$file); //or
readfile("./pathtofolder/$file");

always forget which one is the right form

almostbob 866 Retired: passive income ROCKS

the <table> is redundant only <ul> is required

almostbob 866 Retired: passive income ROCKS

I cant do it via email, incoming mail servers are not easy to access
in php its a trivial matter
this code embeds in the html at the point the news is to appear

<?php $content=filegetcontents('path to uploadfile');
/* code to check & sanitize $content per your requirments */
if !$content { echo '<div class=\'filler\'>watch this space for news updates</div>';
exit; }
echo "<div class='news'>$content</div>"; ?>

to get the news text
and an upload link or ftp to send the data

its not the approach you asked for, but it may work for you, or a perl guru can produce similar code

almostbob 866 Retired: passive income ROCKS

in html I dunno
in php I use a link to a force download script <a href=download.php?file=filename&type=filetype> it does not check for filetypes etc, because i code the link

<?php if(!$file) return false;
header("content-disposition: attachment; filename=$file");
header("content-type: $type;");
readfile("$file"); ?>

there might be need to sanitize the code to prevent someone getting other files off your site http://www.yoursite.com/download.php%3Ffile%3Ddownload.php%26type%3Dtext%2Fphp works

almostbob 866 Retired: passive income ROCKS
#navigation:hover { background:url(NavBGHover.png); height:36px; }

Every unstyled link has a hover attribute, the default is underline
user browsers have the option to
underline links -always -never -onmouseover
the part where it becomes very annoying is where the designer removes the default actions when styling the page. changing the background image only won't cause an issue with screen readers, (well not with mine, I wont see the image anyway) please don't change other behaviours, or link colors. doing so makes the site ureadable to the visully impaired

almostbob 866 Retired: passive income ROCKS

type it in notepad
or for basic instruction in what the <tags> do http://www.w3schools.com/htmL/

almostbob 866 Retired: passive income ROCKS

Do you know any other way?

None than than already shown in the prior posts,
replace references the unique identifier/index, the only part of the row that remains the same after the replace

almostbob 866 Retired: passive income ROCKS
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- @(#) $Id$ -->
<head>
<title>bal bla</title>
<style type='text/css'>
.left { width: 39%; float:left; test-align:left; display:inline; }
.right { width: 39%; float:right; text-align:left; display:inline; }
.container { width: 80%; margin:auto;}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
</head>
<body>
<div class='container'>
<div class='left'>this is left</div>
<div class='right'>this is not left</div>
</div>
</body>
</html>

The outer container div serves to keep the two inner divs aligned if one has 1000 lines of text, and one does not,
fixed pixel widths fail/ get scroll bars on less than fullscreen windows, W3C reccommends em % as element sizes,

display: inline; seems to fix IE bugs

almostbob 866 Retired: passive income ROCKS

.REPLACE works exactly like INSERT,..except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index

http://dev.mysql.com/doc/refman/5.1/en/replace.html

the primary key ID is not referenced by the replace statement, the replace wont work as you intend, it becomes an insert statemen

almostbob 866 Retired: passive income ROCKS
<?php if(isset($_GET['withButton'])){ echo '<input type="text">'; } ?>

shorter

almostbob 866 Retired: passive income ROCKS

You cant
anything that is displayed is downloaded to the client computer before it is displayed,
the user has absolute control

almostbob 866 Retired: passive income ROCKS

I feel inclined towards ASP.NET because I have been using it a lot recently, and I am out of touch from PHP.

answering just this part,
PHP has a short learning curve.
scripts can be read (canibalized) for proceedures
php.net user manuals have source code samples for each function
freeware PHP IDE, that debugs my code errors and opens the manual to the correct page to ensure that I know what I am doing.

For me too ASP.net is slower than the same site written in php.
perl cgi is fastest by far, but too hard to write.

almostbob 866 Retired: passive income ROCKS

dont use category names in the posted urls http://bla.com/?1=something&2=somethingelse

$category = $_GET['cat'];
$subcategory = $_GET['subcat'];
if iset($1) { $category=$1; }
if($category=="") { header("Location: index.php"); } 
elseif ( iset($2)) {  $subcategory=$2; )
if($subcategory=="")
$result=mysql_query("SELECT * FROM ".$category." ORDER BY RAND() LIMIT 1");
else $result=mysql_query("SELECT * FROM ".$category." WHERE Category LIKE '".$subcategory."' ORDER BY RAND() LIMIT 1");
$row = mysql_fetch_assoc($result);
$data=$row['column'];
header("Location: ".$data);
echo $data;
if (!mysql_num_rows($result));
  echo "No records found";
}

ignore syntax errors, just a thought process
Bob

almostbob 866 Retired: passive income ROCKS

asp.net works on MS hosts,
limiting the

  • %age of hosts it can run on
  • and therefore- portability of developed software,
  • potential marketplace should your product be that good

php is faster than asp for certain applications, asp is faster than php for certain applications here are 2 million google results half of which say each is faster http://www.google.com/search?hl=en&q=which+is+faster+asp+or+php&meta=
php has a larger user base,
php scripts are available prewritten to do most of what anyone requires, and customization is easy

MS products are notoriously released incomplete
asp is proprietary (Vax VMS, EbDic, mainframe client-server architecture. (all gone the way of the dodo)) apple mac ( 20 years and still less presence than linux ( am certain it still going out of sheer bloody mindedness))
pc hardware, in the face of better designs, dominates because everybody could make anything work with it,
php works on just about everything

almostbob 866 Retired: passive income ROCKS

Ooops

Sorry
only Chrome has yet implemented font embedding, I tried it a few times, curious, but do not know whether that part of css2 is widely implemented yet
there are some discussions and tutorials on embedding fonts in web pages using the .eot standard. but for practical purposes, visitors wont be able to acess the font in 'common' browsers, it wont work

http://bloggingdiary.com/css-embedded-fonts-and-the-font-face-rule/

almostbob 866 Retired: passive income ROCKS

code for connect_db

<?php
$db_link = mysql_connect ('localhost','root','');
if(!$db_link) { die('<br>'.$mysql_error().'<br>')};
$db = mysql_select_db('users');
if(!$db) { die('<br>'.$mysql_error().'<br>')};
?>

to give a hint should things go wrong
for the code sample previously given I get the images in the attachments, the window border is at the top of the image, margin:0;

can not find a visible whitespace, thinking takes time, back soon

almostbob 866 Retired: passive income ROCKS
<?php session_start();
require("connect_db.php"); ?>
<html>
<head>
<style type="text/css">
body { margin:0; text-align: center; } /*top & bottom are redundant*/
.body2{ width: 666px; background-color: #e43546; }
form { margin:0; } 
</style>
</head>
<body>
<div class="body2">
<?php echo 'Text, text<br>';
echo '<form method="post">
Name: <input type="text" name="name">  Pass: <input type="password" name="password">  <input type="submit" id="login" value="login"></form>
<a href="reg.php">New user</a><br>';
echo 'Text, text<br>'; ?>
</div>
</body>
</html>

is there white space in connect_db

almostbob 866 Retired: passive income ROCKS

place the font on your server

@font-face {font-family: THISFONT; src: url(resolved-path-to-THISFONT.ttf);}

then you can reference the font

almostbob 866 Retired: passive income ROCKS

behaviours pallet,
a dreamweaver question then ?
try the dreamweaver formums at http://forums.adobe.com/community/dreamweaver

almostbob 866 Retired: passive income ROCKS

Government department, nuff said, in government mediocre is up

almostbob 866 Retired: passive income ROCKS

What Makes 100%? What does it mean to give MORE than 100%? Ever wonder about those people who say they are giving more than 100%? We have all been to those meetings where someone wants you to give over 100%. How about achieving 103%? What makes up 100% in life?

Here is something someone sent me that is indisputable logic.
a little mathematical formula that might help you answer these questions:

If:
A:1 B:2 C:3 D:4 E:5 F:6 G:7 . . . . . . Z:26

Then:

H-A-R-D-W-O-R-K
8+1+18+4+23+15+18+11 = 98%

and

K-N-O-W-L-E-D-G-E
11+14+15+23+12+5+4+7+5= 96%

But,

A-T-T-I-T-U-D-E
1+20+20+9+20+21+4+5 = 100%


And,

B-U-L-L-S-H-I-T
2+21+12+12+19+8+9+20 = 103%

A-S-S-K-I-S-S-I-N-G
1+19+19+11+9+19+19+9+14+7 = 118%

So, one can conclude with mathematical certainty, that Hardwork and Knowledge will get you close, and Attitude will get you there,

its the Bull**expletive deleted** and A**expletive deleted** kissing that will put you over the top.

almostbob 866 Retired: passive income ROCKS

get a google webmaster tools account,
Follow all the directions
I get my sitemaps made from the sitemap tool at http://www.auditmypc.com/
Google have a good set of howtos to tell google how to index your site called webmaster 101

this code in your .htaccess file redirects external sites accessing images

<Files .htaccess>
order allow,deny
deny from all
</Files>

RewriteEngine On
RewriteCond %{HTTP_REFERER} !^http://(.+\.)?MYSITE\.com/ [NC]
RewriteCond %{HTTP_REFERER} !^$
RewriteRule .*\.(jpe?g|gif|bmp|png)$ /images/nohotlink.jpg [L]

The <file></file> block prevents anyone reading your .htaccess file
the second block protects images being accessed from offsite

almostbob 866 Retired: passive income ROCKS

i got this thing to work on php4 before but some functions deprecated and it doesn't works now...duh

before i try your suggestion, can i clear some of my doubts?

sorry my noobiness, but does your method means i need to upload the image file in png format?

or does it convert the existing jpg image to output as png?

it outputs the image as png at the moment,
its a demo/ thought provoker not a solution yet
you could use the original content-type as a switch
--ignoring syntax-- I'm sleepy its midnight --

switch($image_type}
case 'image/gif':
 imagegif ();//etc
 break;
case 'image/jpeg' :
 imagejpeg ();//etc
 break;
case 'image/bmp': 
 imagewbmp ();//etc
 break;
almostbob 866 Retired: passive income ROCKS
<? $dbserver = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "em";
$dbconn = @mysql_connect($dbserver,$dbuser,$dbpass) or exit("SERVER Unavailable"); 
@mysql_select_db($dbname,$dbconn) or exit("DB Unavailable"); 
$sql = "SELECT image FROM em.testblob WHERE id =".$_GET["id"]; 
$result = @mysql_query($sql,$dbconn) or exit("QUERY FAILED!"); 
$image = @mysql_result($result,0,"imgdata"); 
$output = imagecreatefromstring($image);
header("Content-type: image/png"); 
header("Content-disposition: inline"); 
imagepng($output);
imagedestroy($ouput);
mysql_close($dbconn); ?>

not sure, untested, I only store file system
see aslo imagejpeg, imagegif, imagewbmp functions
if required test original content-type and output using the appropriate function

papermusic commented: pls save me... +1
almostbob 866 Retired: passive income ROCKS
header("Content-type: $contenttype"); 
header("Content-disposition: inline");