Chapter 1
Account Overview


Chapter 2
Getting Started


Chapter 3
Control Panel Overview


Chapter 4
FTP Instructions


Chapter 5
SSH / Telnet


Chapter 6
Email Software Setup


Chapter 7
File Manager


Chapter 8
Change Password


Chapter 9
Mail Manager


Chapter 10
Site Statistics


Chapter 11
Mailing List


Chapter 12
Microsoft FrontPage


Chapter 13
Site Creation Tool


Chapter 14
Counters


Chapter 15
Protect Directories


Chapter 16
Redirect URL


Chapter 17
Search Engine


Chapter 18
Formmail


Chapter 19
PGP & PGP Mail


Chapter 20
Mime Types


Chapter 21
Anonymous FTP


Chapter 22
Archive Manager


Chapter 23
SSL (Secure Server)


Chapter 24
MySQL


Chapter 25
Shopping Cart


Chapter 26
CGI-bin


Chapter 27
Real Audio / Real Video


  


Chapter 24 - MySQL



Perl While Loop Example

If your SQL query will return more than one record, you will need to place the fetchrow() call in a while loop.

my (@telephone);
my $i = 0;
my $count;
while (@aRow = $sth->fetchrow())
{
    $telephone[$i] = @aRow[0];
    $i++;
}
$count = $i;

# @telephone can now be used to build an html table 
# to display all the telephone numbers in the "518"
# area code.