Some free software ER diagramming tools

RISE Editor

http://www.risetobloome.com/

UML tool for draw UML diagrams fast (a free software)

Free UML Tool for Fast UML Diagrams

UMLet is an open-source UML tool with a simple user interface: draw UML diagrams fast, export diagrams to eps, pdf, jpg, svg, and clipboard, share diagrams using Eclipse, and create new, custom UML elements.

download : http://www.umlet.com/changes.htm

ArgoUML

http://argouml-downloads.tigris.org/

flash tutorials

http://www.webdesigntutorials.net/flash_tutorials.php

To get the the first N records in a SQL query differs acording to database platforms.

Here's some samples:

Microsoft SQL Server

SELECT TOP 10 column FROM table

PostgreSQL and MySQL

SELECT column FROM table
LIMIT 10

Oracle

SELECT column FROM table
WHERE ROWNUM <= 10

Sybase

SET rowcount 10
SELECT column FROM table

Firebird

SELECT FIRST 10 column 
FROM table

How to send HTTP request using PHP?

There is a predefined php class called HttpRequest. By using this class we can create object for handle HTTP requests. There are list of function to handle it. Refer PHP manual and get some idea about this class.

In WAMP before use this objects you need to make some changes in php.ini file. Add following line into the php.ini file (somewhere near in the extension).

"extension=php_http.dll"

Example

======

user HttpRequest object to handle get method http request

$r= new HttpRequest('www.example.com?valueone=1&valuetwo=2', HttpRequest::METH_GET);

$r->send();

echo $r->getResponseBody();