Multiple Licence Upgrade Purchase of Lion OS

There are lots of questions as to how to buy multiple license or family pack for the new LION OS upgrade.
You only need to purchase one license!

Download the Upgrade application to your desktop and copy it on to your USB flash disk.

From there you run the application on other computers!

z-index under IE

I had to figure out how to show dropdown menu over some content. I used z-index on css, however, IE did not seem to like it. In order for it to work on IE as compared to Firefox where it was perfectly fine, I added - or + signs as well as added either relative or absolute positioning.

For Example
#sddm div
{ position: relative;
visibility: hidden;
margin: 0;
padding: 0;
background: #EAEBD8;
border: 1px dotted #330000;#5970B2;
z-index:+3;
}

Remove duplicate entries / rows a mySQL database table

ALTER IGNORE TABLE yourtablewithdups ADD UNIQUE INDEX dupidx (field_1 [, field_2x]);
ALTER TABLE yourtablewithdups DROP INDEX dupidx

Pure CSS Image Hover

I wanted the image to be enlarged as you hover over the image thumbnail. Most javascripts enlarge's the picture within the same space, and since my images were all in a row and column setting I wanted a "popup" type.

there is the code
.myButtonLink {

display: block;
width: 60px;
text-indent: -99999px;
}
.myButtonLink:hover
{
display: block;
position: absolute;
width: 250px;
background-color:
#aaa; right:500px; color: #FFFFFF; padding: 5px;

}
and the HTML


for this style to work on both Firefox and IE, the html should look
open anchor tag and inside it reference the class to myButtonLink class=myButtonLink href can be hashed like href=#
Open img tag and reference the class again as class=myButtonLink border=0
with src referencing your image file location. Plus add onmouseover=style.width=250 and onmouseout=style.width=60
close img tag and anchor tag

I am unable to write the code on this blogger, it doesnt allow open close tags.

You can look at the code on http://www.spiralstore.com site if you viewcode by right clicking the page.

Increase the phpMyAdmin Session Timeout

You can override the setting for phpMyAdmin Session Timeout.
1.Open up config.inc.php in the root phpMyAdmin directory
2. Add this code anywhere on the document:

$cfg['LoginCookieValidity'] = ;

Where is some number larger than 1800. For example, 28800 works out to be 8 hours.

Disclaimer! It should go without saying that increasing the timeout is a (comparatively minor) security risk (but a risk nonetheless). Obviously, do not do this on your production server. And as always, proceed with caution.

php javascript confirm alert box

There are many times when you are working with php, drawing content from mysql and you need a function to draw on the Javascript confirm (alert with Yes and No option buttons) script. Learn how to pass in a parameter to Javascript and open another php file to complete the confirm action.

First write the Javascript function that passes a parameter

function go_there(name)
{
var p=name;
 var where_to= confirm("This action sends the data for this profile to the analysis center nd you will not be able to change the data later.\r\nAre you sure you want to make your data Finalized READ ONLY? ");
 if (where_to== true)
 {
   window.location="index.php?page=finalize&profile="+p;
 }

}

Then on you php call the function: I have removed all quotes, therefore fix the code before use.

echo go_there(. $data[profile].); href=#>finalize;



enjoy!