For Every Row In mySQL Database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Quazel
Forum Commoner
Posts: 25
Joined: Thu Mar 18, 2010 7:12 pm
Location: Edina, Minnesota

For Every Row In mySQL Database

Post by Quazel »

How do I make php run a script for every row in a sql database and stop when there is no more rows.
JakeJ
Forum Regular
Posts: 675
Joined: Thu Dec 10, 2009 6:27 pm

Re: For Every Row In mySQL Database

Post by JakeJ »

$qry = mysql_query("SELECT something FROM table");

While($row = mysql_fetch_array($qry) {
echo $row['something'];
}
kurbot
Forum Newbie
Posts: 18
Joined: Tue Jul 20, 2010 2:20 pm

Re: For Every Row In mySQL Database

Post by kurbot »

too elaborate alittle more:

Code: Select all

function MyFunction($parm1 = '', $parm2 = '', $etc = ''){
// Do Something

}

$qry = mysql_query("SELECT something FROM table");

While($row = mysql_fetch_array($qry) {
  echo $row['fieldname']; // would echo data from the data field
  MyFunction($parm1, $parm2, $etc); // Would Call a Script/Function | Parms are OPTIONLA
}
Post Reply