echo MySql column names and values

Question

What I need is to have a list name => value to be able to make MySql queries. My problem is, I can access MySql records, but I also need to access table's column names, what should I change in my code?

Thanks

$query = "SELECT * FROM test_table";
$result = mysql_query($query) or die("Erro!: " . mysql_error());
if (mysql_num_rows($result) > 0) {
    $row = mysql_fetch_array($result);
    if(is_array($row)) {
        foreach ($row as $col => $val) {
            echo $col." = ".$val."<br>";
        }
    }
}

ok, so now why can't I join the values to then make my sql queries?

while($row = mysql_fetch_assoc($result)) {
        foreach ($row as $col => $val) {
            $colunas .= join(",",$col);
            $valores .= join(",",$val);
        }
        echo "colunas = ".$col."<br>";
        echo "valores = ".$val."<br>";
    }

I just get empty colunas and valores

Thanks, sorry if it seems to easy, but I'm lost

I think some books or manuals can be useful in beginning of studying. Maybe dev.mysql.com/doc — user680786
– user680786, Commented May 24, 2011 at 10:10

Shakti Singh · Accepted Answer · 2011-05-24 10:09:11Z

12

You needs while loop and a call to mysql_fetch_assoc

  while($row = mysql_fetch_assoc($result)) {   
        foreach ($row as $col => $val) {
            echo $col." = ".$val."<br>";
        }
    }

answered May 24, 2011 at 10:09

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Haim Evgi · Accepted Answer · 2011-05-24 10:09:57Z

2

use mysql_fetch_assoc,

see : http://www.php.net/manual/en/function.mysql-fetch-assoc.php

answered May 24, 2011 at 10:09

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

Comments

bigblind · Accepted Answer · 2011-05-24 11:02:44Z

2

I think you mixed up some variable names, and, you don't need the join function, since you're adding one column name at a time. does this work?

$colunas=$valores="";

while($row = mysql_fetch_assoc($result)) {
        foreach ($row as $col => $val) {
            $colunas .= $col.',';
            $valores .= $val.',';
        }
        echo "colunas = ".$colunas."<br>";
        echo "valores = ".$valores."<br>";

answered May 24, 2011 at 11:02

bigblind

12.9k14 gold badges72 silver badges132 bronze badges

Collectives™ on Stack Overflow

echo MySql column names and values

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related