Multiple Fields

longbow

any one have a idea on how to select from multiple fields in one table heres the code im useing for one field is there something i can add to it to select the other field?

mysql_select_db("test",$conn);
$sql = "SELECT * FROM journal ORDER BY id DESC";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result)) {
    $blah = $newArray['comments'];
 print "<tr><td align=\"center\" bgcolor=\"#7F7F7F\"><BR>";
 echo $blah;
 print "</tr></td>";
}

thanks
longbow

rebelo

I am afraid I don't understand what you're asking. Your SQL query is selecting ALL of the fields (SELECT * FROM...), so what is it you mean by "the other" field?

Need a bit more information, sorry.

ozzythaman

if you know the names of the columns of the table:

$r=mysql_query("select * from aaaa");

while ($row=mysql_fetch_array($r)){

echo $row['thisisnameofcol1'];
echo "<br>\n";
echo $row['thisisnameofcol2'];
echo "<br>\n";
echo $row['thisisnameofcol3'];
echo "<br>\n";
}

or if you know how many columns it has:

while ($row=mysql_fetch_row($r)){

echo $row[0];

echo $row[1];

echo $row[2];

echo $row[3];

}

longbow

the fields go:
ID, comments, name
and i want to select both the name and comments and post them in one Cell of a table that i have ti set to print

matt72

mysql_select_db("test",$conn); 
$sql = "SELECT * FROM journal ORDER BY id DESC"; 
$result = mysql_query($sql, $conn) or die(mysql_error()); 
while ($newArray = mysql_fetch_array($result)) { 
    $comments = $newArray['comments']; 
    $name = $newArray['name'];
 print "<tr><td align=\"center\" bgcolor=\"#7F7F7F\"><BR>"; 
 echo "$name $comments"; 
 print "</tr></td>"; 
}

🙂

rebelo

Originally posted by longbow
the fields go:
ID, comments, name
and i want to select both the name and comments and post them in one Cell of a table that i have ti set to print

Then simply modify your original code to something like this:

mysql_select_db("test",$conn);
// select comments and name from all rows
$sql = "SELECT comments,name FROM journal ORDER BY id DESC";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result)) {
    print "<tr><td align=\"center\" bgcolor=\"#7F7F7F\"><BR>";
    // print name and comments
    echo $newArray['name'];
    echo "<br>";
    echo $newArray['comments'];
    print "</tr></td>";
}

Note that the way you were originally reading the array into new variables is redundant. You can print the values straight from the array like I did above which saves you having to do stuff like this:

$blah = $newArray['comments']; // not necessary