Archive for October, 2008
Resolving Query Problems Using Subquery
Sometimes when working with databases and records, we have find difficulties in displaying data from many tables using SQL especially using join syntax. For example you want to include some aggregate columns from three tables below :
the structure of the products table :
1
2
3
4
5
ProductID text(15),
VendorID text(15),
Descriptions text(50),
UnitsInStock integer,
Price integer
Data in [...]
Difference DHCP with BOOTP and RARP
DHCP based on the BOOTP and still compatible with previous technology. The Main differences is BOOTP designed for manual pre-configuration from the host’s information in a database server, while the DHCP is used to address the allocation of network dynamically configuration and also important for new other hosts to join the network.
As In addition, DHCP [...]
What’s DHCP
For the network computer user would often hear the term DHCP. DHCP is an abbreviation of the Dynamic Host Configuration Protocol. DHCP is a big benefit in a computer network. DHCP is used to make computers that are on a network computer that can retrieve configuration (IP address, DNS address and others) from a DHCP [...]
How to Connect the VB 2005 to MySQL
Here is how to connect Visual Basic.Net to the MySQL database:
1. In the project - add reference - on the tab. Net - find MySql.Data - click OK
2. In the namespace - imports mysql.data.mysqlclient
3. In the form load or in the module or whatever form
type this code to connect with mysql
1
2
3
4
5
6
Dim myString [...]
How do I install WordPress in Windows XP?
You can make it count in the 10 ~ 20 minutes just to be able to install WordPress on Windows XP using MySql. So what steps? Previous need to know what is installed with XAMPP, features what it founds:
Apache HTTPD 2.2.8 + Openssl 0.9.8g
MySQL 5.0.51a
PHP 5.2.5
PHP 4.4.8
phpMyAdmin 2.11.4
FileZilla FTP Server 0.9.25
Mercury Mail Transport System 4.52
And [...]