selecting from tables

[peuge]

Hi,

I am selecting everything from a table and now I want to display it all. The only problem is that each thing comes as an element of the array $row. If I echo $row[1], $row[2] then I get what I want but is there an easier way? Am I using the wrong fetch command?

Thanks.

 

$result = mysql_query("SELECT * FROM $tables[0]");

 

 

while($row = mysql_fetch_array($result))

{

 

  echo "<tr>";

  echo "<td>" . $row[0] . "</td>";

  echo "</tr>";

}

 

[paul2463]

if you change it to

mysql_fetch_assoc($result);

 

then you will be able to use the column names such as

$first = $row['firstname'];
$last = $row['lastname'];

[peuge]

Sorry I was not quite clear in my first post. I am creating something along the lines of the user selects a database of his/her choice and then it displays the data for that database. Therefore using 'firstname' might apply to a table in one database but not the other. So is there another way?

Thanks

[paul2463]

the examples i put are just that, examples, change the words inside the brackets to what column names you have in your database

 

this makes it easier for me because i know what column names I am pulling from the database so the I can use the column names and not the array key makes my life more interesting

[trq]

while($row = mysql_fetch_array($result))
{
 foreach ($row as $r) {
   echo "<tr>";
   echo "<td>" . $r . "</td>";
   echo "</tr>";
 }
}

[peuge]

Paul2463: Thanks. But the code still does not help because I have different tables in different databases with different heading names as well as the tables have a different number of fields.

 

Thorpe: It seems to be giving me duplicates as well as not putting them next to each other in the table? Sorry im quite new to this.

 

Thanks

[peuge]

This is my output:

11 is the ID

pp is the username

and c483f6ce851c9ecd9fb835ff7551737c is the md5 password.

 

 

id username password

11

11

pp

pp

c483f6ce851c9ecd9fb835ff7551737c

c483f6ce851c9ecd9fb835ff7551737c

 

 

[trq]

Yeah, sorry.

 

while($row = mysql_fetch_array($result,MYSQL_NUM))
{
  echo "<tr>";
  foreach ($row as $r) {
    echo "<td>" . $r . "</td>";
  }
  echo "</tr>";
}

[peuge]

cool, thanks man, works perfectly!