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.





©Copyright 2000 . All Rights Reserved.
The entire contents of this site is copyrighted and may not be reproduced for any purpose without prior written permission.
Table Of Contents:

Back To Index
|
Chapter 1
FTP Instructions

|
Chapter 2
SSH / Telnet

|
Chapter 3
Email Software Setup

|
Chapter 4
CGI Bin

|
Chapter 5
Secure Server

|
Chapter 6
Formmail

|
Chapter 7
Microsoft Front Page

|
Chapter 8
CGI Scripts

|
Chapter 9
COMING SOON

|
Chapter 10
COMING SOON

|
Chapter 11
Streaming Audio/Real Video

|
Chapter 12
File Manager

|
Chapter 13
Mail Manager

|
Chapter 14
Changing Passwords

|
Chapter 15
Site Statistics

|
Chapter 16
Network Tools

|
Chapter 17
FTP & Anon FTP

|
Chapter 18
SSH / Telnet

|
Chapter 19
Password Protect Directories

|
Chapter 20
Custom Error Pages

|
Chapter 21
MySQL

|
Chapter 22
Mime Types

|
Chapter 23
Crontab

|
Chapter 24
Entropy Chat

|
Chapter 25
Shopping Cart

|
Chapter 26
Search Engine Submission

|
Chapter 27
PGP

|
Chapter 28
Subdomains

|
Chapter 29
Archive Manager

|