Jeromie,
Your method actually works, thank you, I only had to
add:
foreach($row AS $key => $val) and it worked fine.It
looks like this now: (please note that return $row
didn't work for some reason (see below).. I changed it
to return $result and its fine)
/***** script file ******************/
// snip
$row=$datbs->show();
foreach($row AS $key => $val )
{
echo ($val[0]. " " . $val[1]. " " .
$val[2]. "<br>");
}
/***** class "datbs" ******************/
function show()
{
// snip
while ($row = mysql_fetch_array($this->result))
{$result[] = $row;}
return $result; // return $row didn't worrk ?
// snip
}
/***** ******************/
Thank you for your help.
David
--- David Halliday <[EMAIL PROTECTED]> wrote:
---------------------------------
Hi Jeromie,
Thank you for suggesting the PEAR DB class, I will
study that option. As for this script, I have done the
following but it is not printing anything.
/***** script file ******************/
// snip
$row=$datbs->show();
ECHO $row['id'];
ECHO $row['Date'];
ECHO $row['Name'];
ECHO " <br>";
/***** class "datbs" ******************/
function show()
{
// snip
while ($row = mysql_fetch_array($this->result))
{ $result[] = $row; }
return $row;
// snip
}
/***** ******************/
--- Jeromie Clark <[EMAIL PROTECTED]> wrote:
---------------------------------
Hi -
There are a couple problems here:
1.) Return exits and returns the value immediately, so
you're never
going to get to the 2nd row.
2.) You can only pass one thing back from the
function, so you probably
want to assemble an array of values.
>/***** class "datbs" ******************/
>
>function show()
>{
>// snip
>while ($this->row = mysql_fetch_array($this->result))
> {
> return ($this->row);
> }
>
>// snip
>}
>
Try this:
function show()
{
// $this-> is for accessing/placing a variable in
the class scope.
// You probably don't need to place $row in the
class scope for the
purposes of assembling a result set to pass back.
while ($row = mysql_fetch_array($this->result))
{
$result[] = $row; // this creates an ordered
array, appending
each new value to the end of the array.
}
return $row; // Pass the array you've assembled
back
}
On another note, the PEAR DB class is a really nice
database abtraction
class.
If you're looking for a nice OO way to interact with
the database,
they've done a good job with it.
http://pear.php.net/manual/en/
___________________________________________________________
Yahoo! Exclusive Xmas Game, help Santa with his celebrity party -
http://santas-christmas-party.yahoo.net/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/CefplB/TM
--------------------------------------------------------------------~->
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
