DBs, arrays and loops, O My!

Zagu

Hello, I'm really new (ok, three days) but I'm under a bit of a strain to get this project done. Really really close but cannot get the last piece. I cannot find the exact answer I need via google, etc.
Here's the story.

I've got a database that I'm pulling records from. That works.
I need to loop through each selected record, put it into an array and then output that array to a function.

I can loop.

I can array.

I can output a manually contructed array.

I just cannot get the array to loop through the db records.

Total newbie stuff.

All the help files I found so far say, "Dude! you need to loop through your record set." I know that but cannot seem to pull if off.

Any help at all would be terrific. I have a real need for this to be finished in the somewhat near future.

Here's what I have so far. Everything that is listed below works. (Finer points have been left out)

I just cannot figure out where to put the loop.

//php PDF class is from http://www.ros.co.nz/pdf/
//I'm creating PDF mailing labels from a mysql database

include ('class.label.php');
$labeltype="Av5160";

$label= new Clabel($labeltype);
$user_name = "works";
$password = "works";
$database = "works";
$server = "works";

$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);
$SQL = "SELECT * FROM mailinglist";
$result = mysql_query($SQL) or die(mysql_error());

$row = mysql_fetch_array($result);

$count=1; //to be used for while loop, needed for $key

$info = array(

$count=>array("line1"=>"{$row['FIRST NAME']} {$row['LAST NAME']}",

"line2"=>"{$row['2ND NAME']}",
"line3"=>$row['ADDRESS'],
"line4"=>$row['CITY']),

);

$label->makeLabel($info);

Everything here works so far. I just cannot get how to loop through that array and not get errors when the array gets submitted.

Additional information:

$info is sent to makeLable() function that looks like this
while (list($key, $add_arr)=each($labelInfo)) {
//do various things
}
No matter how I create the loop, this while loop thinks that the $add_arr is the entire looping through the record set. If I echo $key and $add_arr, I get back

1 (then 3 pages of text)

I need

1 array('line1', 'line2', 'line3', 'line4', etc.)

Any help at all would be appreciated.

Thanks

linda_thomas

Im new also 😉 Do you mean you are trying to out put all the data from your table? If so

<?php
include_once 'connect.inc';
@mysql_connect($host,$user,$password) or die ("Unable to connect to server!");
@mysql_select_db($database) or die( "Unable to connect to database, please try later!");

$query="SELECT * FROM yourtable";
$result=mysql_query($query);


$num=mysql_numrows($result);


mysql_close();
?>


<?php
$i=0;
while ($i < $num) {

$one=mysql_result($result,$i,"colum_name");
$two=mysql_result($result,$i,"colum_name");
$three=mysql_result($result,$i,"colum_name");
$four=mysql_result($result,$i,"colum_name");
?>

<div><? echo $one; ?></div>
<div><? echo $two; ?></div>
<div><? echo $three; ?></div>
<div><? echo $four; ?></div>

<?php
$i++;
}
?>

Is this what you wanted?

Linda

Zagu

Hi Linda,
Thanks for the reply.

The difficulty seems to be that I am not tryting to echo the results. I know I am successful connecting because I can echo everything fine. And all the examples I find online are putting the data from the DB into echo. The difficulty seems to be that I am trying to gather it up all the data into a single array without an echo and send it as a variable into a function.

Any ideas?
Thanks,
Z

linda_thomas

You still need to define them. you could then just :

$one=mysql_result($result,$i,"colum_name");
$two=mysql_result($result,$i,"colum_name");
$three=mysql_result($result,$i,"colum_name");
$four=mysql_result($result,$i,"colum_name");

$label="$one,$two,$two"
?>

Zagu

Hello,
Below is my current php according to your suggestions. I only get one row returned but then again it didn't break the makeLable function. If I just echo the results, I get all of the rows. but once I try to send it to the function, I only get one row.

????

current code:

<?php

include ('class.label.php');
$labeltype="Av5160";

$label= new Clabel($labeltype);
//db connection stuff

$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);
$SQL = "SELECT * FROM mailinglist";
$result = mysql_query($SQL) or die(mysql_error());

$row = mysql_fetch_array($result);

$i=0;
while ($row = mysql_fetch_array($result)){
$first=$row['FIRST NAME'];
$last=$row['LAST NAME'];
$address=$row['ADDRESS'];
$city = $row['CITY'];

$i++;

$info = array($i => array("line1" => $first, "line2" => $last, "line3" => $address, "line4" => $city,));
$label->makeLabel($info);
}