Just a little note to myself..

MYSQL statment to select from one table based on occurances in two tables.

• SELECT * FROM webcal_entry LEFT JOIN webcal_entry_user ON webcal_entry.cal_id = webcal_entry_user.cal_id WHERE webcal_entry.cal_due_date = curdate() AND webcal_entry_user.cal_status != 'd'"

Artisteer is a web design app that lets you build templates for your favourite CMS. Once youve created your master piece you can then export them as the templates of your choice.

http://www.artisteer.com/

the download from Cnet is the latest shareware version. Your free to build but there will be a watermark let on the template you finally save.

cnet.com/Artisteer

another untested possible download link is

http://rapidshare.com/files/256079575/Artisteer.2.2.0.16836_-_Updated__Working.rar

Send mail form in php and html.
note the actually email address used should be locked in the php file for security reasons.



Below is the markup code to enter into your html
index.html :

<script language="JavaScript"> // Expanding images script copyright Matthew LaCerais MLacerais@osc.state.ny.us // Distributed by hypergurl http://www.hypergurl.com // Permission to use script granted if above credits are left intact <!-- function resizeImage(e) { if (document.layers) { //Netscape var xMousePos = e.pageX; var xMousePosMax = window.innerWidth+window.pageXOffset; } else if (document.all) { // IE var xMousePos = window.event.x+document.body.scrollLeft; } else if (document.getElementById) {//Netscape var xMousePos = e.pageX; var xMousePosMax = window.innerWidth+window.pageXOffset; } var i = (-1 * (((xMousePos/340) - (250/340)) * ((xMousePos/340) - (250/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture1.width=(170 * i); picture1.height=(125 * i); i = (-1 * (((xMousePos/340) - (420/340)) * ((xMousePos/340) - (420/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture2.width=(170 * i); picture2.height=(125 * i); i = (-1 * (((xMousePos/340) - (525/340)) * ((xMousePos/340) - (525/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture3.width=(170 * i); picture3.height=(125 * i); i = (-1 * (((xMousePos/340) - (600/340)) * ((xMousePos/340) - (600/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture4.width=(170 * i); picture4.height=(125 * i); i = (-1 * (((xMousePos/340) - (680/340)) * ((xMousePos/340) - (680/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture5.width=(170 * i); picture5.height=(125 * i); } function output(message) { obj = eval("text"); obj.innerHTML = "<span style="font-size:\;">"+message+"</span>"; } function handleMouse() { if (document.layers) { // Netscape document.captureEvents(Event.MOUSEMOVE); document.onmousemove = resizeImage; } else if (document.all) { // Internet Explorer document.onmousemove = resizeImage; } else if (document.getElementById) { // Netcsape 6 document.onmousemove = resizeImage; } } function doNothing(e) { var i = 0.4; picture1.width=(170 * i); picture1.height=(125 * i); picture2.width=(170 * i); picture2.height=(125 * i); picture3.width=(170 * i); picture3.height=(125 * i); picture4.width=(170 * i); picture4.height=(125 * i); picture5.width=(170 * i); picture5.height=(125 * i); } function ignoreMouse() { if (document.layers) { // Netscape document.captureEvents(Event.MOUSEMOVE); document.onmousemove = doNothing; } else if (document.all) { // Internet Explorer document.onmousemove = doNothing; } else if (document.getElementById) { // Netcsape 6 document.onmousemove = doNothing; } } //--> </script>

and this is the code to enter into a php file.
Sendmail.php :

<table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="4" onmouseover="ignoreMouse()"></td> </tr> <tr> <td width="8" height="140" valign="bottom" onmouseover="ignoreMouse()"> </td> <td width="142" valign="bottom" onmouseover="handleMouse()"></td> <td width="889" valign="bottom" onmouseover="handleMouse()"><nobr> <a href="http://www.hypergurl.com" target="_blank"><img name="picture1" src="image1.gif" width="68" height="50" onmouseover="output('Palm Tree')" onmouseout="'output(" border="0" /></a> <a href="http://www.hypergurl.com/hosting.html" target="_blank"><img name="picture2" src="image2.gif" width="68" height="50" onmouseover="output('Family')" onmouseout="'output(" border="0" /></a> <a href="http://www.hypergurl.com" target="_blank"><img name="picture3" src="image3.gif" width="68" height="50" onmouseover="output('Family 1')" onmouseout="'output(" border="0" /></a> <a href="http://www.hypergurl.com" target="_blank"><img name="picture4" src="image4.gif" width="68" height="50" onmouseover="output('Menu Option 4')" onmouseout="'output(" border="0" /></a> <a href="http://www.hypergurl.com" target="_blank"><img name="picture5" src="image5.gif" width="68" height="50" onmouseover="output('Menu Option 5')" onmouseout="'output(" border="0" /></a> </nobr></td> <td width="3" valign="bottom" onmouseover="ignoreMouse()"> </td> </tr> <tr> <td height="10" colspan="4" onmouseover="ignoreMouse()"></td> </tr> </table>

A tech Developers website with news and tips and tricks and bits and peices to keep you going and amused at the same time.

http://www.sitepoint.com

If youve got website or even a few different websites, or possibley you would like to have your own personal search engine for a favourite site that doesnt have a search feature, then this little script is for you.

the following link is a walk through and explaination to create a simple search engine in php and html.

http://www.onlamp.com/pub/a/php/2002/10/24/simplesearchengine.html

Here's a great bit of coding to display your images in thumbnails and enlarge them on the page on mouseover.

Simply make your images around 170 pixels by 125 pixels and the script will do the rest. In the example above we have used 5 images, yet with a little manipulation of the script you could add more or less if desired.

You will need to position the description layer to suit your page, more details below.

Installation:

Step 1

Copy and paste the code below into the head of your html document. Nothing to configure in this part.

<script language="JavaScript"> // Expanding images script copyright Matthew LaCerais MLacerais@osc.state.ny.us // Distributed by hypergurl http://www.hypergurl.com // Permission to use script granted if above credits are left intact <!-- function resizeImage(e) { if (document.layers) { //Netscape var xMousePos = e.pageX; var xMousePosMax = window.innerWidth+window.pageXOffset; } else if (document.all) { // IE var xMousePos = window.event.x+document.body.scrollLeft; } else if (document.getElementById) {//Netscape var xMousePos = e.pageX; var xMousePosMax = window.innerWidth+window.pageXOffset; } var i = (-1 * (((xMousePos/340) - (250/340)) * ((xMousePos/340) - (250/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture1.width=(170 * i); picture1.height=(125 * i); i = (-1 * (((xMousePos/340) - (420/340)) * ((xMousePos/340) - (420/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture2.width=(170 * i); picture2.height=(125 * i); i = (-1 * (((xMousePos/340) - (525/340)) * ((xMousePos/340) - (525/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture3.width=(170 * i); picture3.height=(125 * i); i = (-1 * (((xMousePos/340) - (600/340)) * ((xMousePos/340) - (600/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture4.width=(170 * i); picture4.height=(125 * i); i = (-1 * (((xMousePos/340) - (680/340)) * ((xMousePos/340) - (680/340)))) + 1; if (i < .4) i = .4; if (i > 2) i = 2; picture5.width=(170 * i); picture5.height=(125 * i); } function output(message) { obj = eval("text"); obj.innerHTML = "<span style="font-size:\;">"+message+"</span>"; } function handleMouse() { if (document.layers) { // Netscape document.captureEvents(Event.MOUSEMOVE); document.onmousemove = resizeImage; } else if (document.all) { // Internet Explorer document.onmousemove = resizeImage; } else if (document.getElementById) { // Netcsape 6 document.onmousemove = resizeImage; } } function doNothing(e) { var i = 0.4; picture1.width=(170 * i); picture1.height=(125 * i); picture2.width=(170 * i); picture2.height=(125 * i); picture3.width=(170 * i); picture3.height=(125 * i); picture4.width=(170 * i); picture4.height=(125 * i); picture5.width=(170 * i); picture5.height=(125 * i); } function ignoreMouse() { if (document.layers) { // Netscape document.captureEvents(Event.MOUSEMOVE); document.onmousemove = doNothing; } else if (document.all) { // Internet Explorer document.onmousemove = doNothing; } else if (document.getElementById) { // Netcsape 6 document.onmousemove = doNothing; } } //--> </script>

Step 2

Copy and paste the code below into your html where you want the images to appear on your page. Change the links within to your own and the image src to reflect the images that you use.

<table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="4" onmouseover="ignoreMouse()"></td> </tr> <tr> <td width="8" height="140" valign="bottom" onmouseover="ignoreMouse()"> </td> <td width="142" valign="bottom" onmouseover="handleMouse()"></td> <td width="889" valign="bottom" onmouseover="handleMouse()"><nobr> <a href="http://www.hypergurl.com" target="_blank"><img name="picture1" src="image1.gif" width="68" height="50" onmouseover="output('Palm Tree')" onmouseout="'output(" border="0" /></a> <a href="http://www.hypergurl.com/hosting.html" target="_blank"><img name="picture2" src="image2.gif" width="68" height="50" onmouseover="output('Family')" onmouseout="'output(" border="0" /></a> <a href="http://www.hypergurl.com" target="_blank"><img name="picture3" src="image3.gif" width="68" height="50" onmouseover="output('Family 1')" onmouseout="'output(" border="0" /></a> <a href="http://www.hypergurl.com" target="_blank"><img name="picture4" src="image4.gif" width="68" height="50" onmouseover="output('Menu Option 4')" onmouseout="'output(" border="0" /></a> <a href="http://www.hypergurl.com" target="_blank"><img name="picture5" src="image5.gif" width="68" height="50" onmouseover="output('Menu Option 5')" onmouseout="'output(" border="0" /></a> </nobr></td> <td width="3" valign="bottom" onmouseover="ignoreMouse()"> </td> </tr> <tr> <td height="10" colspan="4" onmouseover="ignoreMouse()"></td> </tr> </table>

Step 3

Copy the code below and paste this below step 2 within your html source. Change the left and top pixel figures to suit the position of the text description on your page layout.

<div id="text" name="text" style="position:absolute; left:166px; top:527px; width:665px; height:94px; z-index:1" onmouseover="ignoreMouse()"></div>

The NEW adobe CS4 packages are out. Be the first to put them to trial.
instructions as below. enjoy.

Once you've got the trial version you can then enter your serial number to turn this trial into the full version of the app.




1. Register an account with adobe.com
2. log in.
3. Go to adobe.com/downloads
4. Select photosohp light room
5. Download the trial version
6. after a few seconds into the download cancel it
7. Click on the links below or inject them into your web browsers URL bar and download!

Photoshop CS4
_http://trials.adobe.com/Applications/Photoshop/CS4/Win/ADBEPHSPCS4_LS1.exe
_http://trials.adobe.com/Applications/Photoshop/CS4/Win/ADBEPHSPCS4_LS1.7z

Master Collection
_http://trials.adobe.com/Applications/MastCol/CS4/Win/ADBESTAMCS4_LS1.exe
_http://trials.adobe.com/Applications/MastCol/CS4/Win/ADBESTAMCS4_LS1.7z

Design Premium
_http://trials.adobe.com/Applications/DesignPre/CS4/Win/ADBESTDSCS4_LS1.exe
_http://trials.adobe.com/Applications/DesignPre/CS4/Win/ADBESTDSCS4_LS1.7z

Web Premium
_http://trials.adobe.com/Applications/WebPre/CS4/Win/ADBESTWDCS4_LS1.exe
_http://trials.adobe.com/Applications/WebPre/CS4/Win/ADBESTWDCS4_LS1.7z

Production Premium CS4
_http://trials.adobe.com/Applications/ProdPrem/CS4/Win/ADBESTVDCS4_LS7.exe
_http://trials.adobe.com/Applications/ProdPrem/CS4/Win/ADBESTVDCS4_LS7.7z

Photoshop Content
_http://trials.adobe.com/Applications/Photoshop/CS4/Win/PHSPCS4_Cont_LS1.exe

Illustrator CS4
_http://trials.adobe.com/Applications/Illustrator/CS4/Win/ADBEILSTCS4_LS1.exe
_http://trials.adobe.com/Applications/Illustrator/CS4/Win/ADBEILSTCS4_LS1.7z

InDesign CS4
_http://trials.adobe.com/Applications/InDesign/CS4/Win/ADBEIDSNCS4_LS1.exe
_http://trials.adobe.com/Applications/InDesign/CS4/Win/ADBEIDSNCS4_LS1.7z

InCopy CS4
_http://trials.adobe.com/Applications/InCopy/CS4/Win/ADBEAICYCS4_LS1.7z
_http://trials.adobe.com/Applications/InCopy/CS4/Win/ADBEAICYCS4_LS1.exe

After Effects CS4
_http://trials.adobe.com/Applications/AfterEffects/CS4/Win/ADBEAFETCS4_LS7.7z
_http://trials.adobe.com/Applications/AfterEffects/CS4/Win/ADBEAFETCS4_LS7.exe

After Effects Content
_http://trials.adobe.com/Applications/AfterEffects/CS4/Win/ADBEAFETCS4_Cont_LS7.exe
_http://trials.adobe.com/Applications/AfterEffects/CS4/Win/ADBEAFETCS4_Cont_LS7.7z

PremierePro CS4
_http://trials.adobe.com/Applications/PremierePro/CS4/Win/ADBEPPROCS4_LS7.7z
_http://trials.adobe.com/Applications/PremierePro/CS4/Win/ADBEPPROCS4_LS7.exe

Premiere Pro Content
_http://trials.adobe.com/Applications/PremierePro/CS4/Win/ADBEPPROCS4_Cont_LS7.exe
_http://trials.adobe.com/Applications/PremierePro/CS4/Win/ADBEPPROCS4_Cont_LS7.7z

Dreamweaver CS4
_http://trials.adobe.com/Applications/Dreamweaver/CS4/Win/ADBEDRWVCS4_LS1.exe
_http://trials.adobe.com/Applications/Dreamweaver/CS4/Win/ADBEDRWVCS4_LS1.7z

Fireworks CS4
_http://trials.adobe.com/Applications/Fireworks/CS4/Win/ADBEFWKSCS4_LS1.exe
_http://trials.adobe.com/Applications/Fireworks/CS4/Win/ADBEFWKSCS4_LS1.7z

Flash Pro CS4
_http://trials.adobe.com/Applications/FlashPro/CS4/Win/ADBEFLPRCS4Win_LS1.exe
_http://trials.adobe.com/Applications/FlashPro/CS4/Win/ADBEFLPRCS4Win_LS1.7z
_http://trials.adobe.com/Applications/FlashPro/CS4/Win/ADBEFLPRCS4Win_Cont_LS1.exe