[RESOLVED] Database Class Functions

yanaho

Hi, this is my first post. I hope somone can help.
I am trying to create a dynamic table, I could let dreamweaver write it for me but that is beside the point. What I want is to call the function from a Database class file. My question is, the function below, does is return a multidimensional array or is this just returning one row. My guess is it returns one row. If this is the case I would love to see it written to return multiple rows.

function getUsers(){
      $q = "SELECT * FROM ".TBL_USERS;//TBL_USERS is a constant
      $result = mysql_query($q, $this->connection);
      /* Error occurred */
      if(!$result || (mysql_numrows($result) < 1)){
         return NULL;
      }
      /* Return result array */
      $dbarray = mysql_fetch_array($result);
      return $dbarray;
   }

As well I am fighting the code to display the rows dynamically, I'm not sure whether this is do to the function I am calling only returning 1 row

 <? 
$req_shows = $database->getUsers();	
$i=0;
do 
{
  echo "<tr><td>".$req_shows[$i]['type']."</td><td>".$req_shows[$i]['time']."</td><td>".$req_shows[$i]['artistid']."</td><td>".$req_shows[$i]['genre']."</td><td>".$req_shows[$i]['location']."</td></tr>";

$i += 1;
}
while ($i<=sizeof($req_shows));
?>

Any help in this area would be great, thanks in advance

[Edit] Added

tags for sanity and making the site not expand most browsers to scroll horizontally.[/color]

bpat1434

does is return a multidimensional array or is this just returning one row.

The answer is in the code....

/* Return result array */
$dbarray = mysql_fetch_array($result);
return $dbarray;

There is an easier way to display what you want. Use a foreach loop to display your info:

$req_shows = $database->getUsers();
foreach($req_shows AS $id=>$info)
{
  echo '<tr><td>'.$info['type'].'</td>
    <td>'.$info['time'].'</td>
    <td>'.$info['artistid'].'</td>
    <td>'.$info['genre'].'</td>
    <td>'.$info['location'].'</td></tr>';
}

Now, here's a really stupid question but: Do you have more than one user in the database?

yanaho

bpat1434 wrote:
Now, here's a really stupid question but: Do you have more than one user in the database?

Yes the Table is populated, and thanks for the quick reply, the loop you provided is working but not displaying the data I'm looking for I don't know why it only populates the table with a single character value, don't know if you can help or not
as this is the same thing I was getting before

yanaho

The information coming back seems to be only the first character of each column in the first row and populating the table with 20 rows of the same information (1 char)

The table currently has 3 rows of data

I guess when u said

The answer is in the code....

PHP Code:
/ Return result array /
$dbarray = mysql_fetch_array($result);
return $dbarray;

I still don't know the answer, i know its an array, but is this a multidimensional array returning multiple rows

This is all the important code maybe it will help

<table width="495" border="1" >
<tr>
<td>Type</td>
<td>Time</td>
<td>Artist</td>
<td>Genre</td>
<td>Location</td>
</tr>
<?
$req_shows = $database->getShows(date);
foreach($req_shows as $id=>$data)
{
echo '<tr><td>'.$data['type'].'</td>
<td>'.$data['time'].'</td>
<td>'.$data['artistid'].'</td>
<td>'.$data['genre'].'</td>
<td>'.$data['location'].'</td></tr>';
}
?>
</table>

// getShows Function
function getShows($date){
$q = "SELECT FROM ".TBL_MUSIC_SHOWS." WHERE date = '$date'";
$result = mysql_query($q, $this->connection);
/ Error occurred/
if(!$result || (mysql_numrows($result) < 1)){
return NULL;
}
/ Return result array */
$dbassoc = mysql_fetch_assoc($result);
return $dbassoc;
}

I know its something something small or stupid, my lack of experience in PHP and not having coded for awhile, but I can't seem to progress past this point. Thanks in advance

bpat1434

It's an array of the results from the query. Not much more I can say other than that and if you need more help, look at www.php.net/mysql_fetch_array