asked on PHP MySQL display all entries in a column
Hello,
I'm trying to pull data out of a MySQL DB and show it on a php page. I would like to show all entries for a particular column, but every example I try either doesn't work, or this one shown below, that only shows 1. I'm thinking maybe I can loop or add another $row, but Im not sure. There could potantialy be a lot of entries, so im guessing it wiould need to loop until the end.
When that's echo'd it only shows 1 entry, when the db is showing several names that fit the criteria.. Is there also a way to show them in a row with comma seperators? name1, name2, name3...
I'm trying to pull data out of a MySQL DB and show it on a php page. I would like to show all entries for a particular column, but every example I try either doesn't work, or this one shown below, that only shows 1. I'm thinking maybe I can loop or add another $row, but Im not sure. There could potantialy be a lot of entries, so im guessing it wiould need to loop until the end.
$result = mysql_query("SELECT name FROM s_users WHERE rank = 1 LIMIT 0 , 30") or die(mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$sl = $row['name'];
When that's echo'd it only shows 1 entry, when the db is showing several names that fit the criteria.. Is there also a way to show them in a row with comma seperators? name1, name2, name3...
PHPMySQL Server
Last Comment
Ray Paseur
ASKER
Is there a way to attach that to a variable for formatting reasons? Right now I have
Is there also a way to show them in a row with comma seperators? name1, name2, name3...
$html2 .= '<tr><td colspan="8"><b>'.$sl.'</b></td></tr>';
Is there also a way to show them in a row with comma seperators? name1, name2, name3...
Certainly...
$result = mysql_query("SELECT name FROM s_users WHERE rank = 1 LIMIT 0 , 30") or die(mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$html2 .= '<tr><td colspan="8"><b> ' . $row['name'] . '</b></td></tr>';
}
ASKER
Hello, I tried the suggestion but this way its still only pulling out one name at a time.
The example you provided earlier pulled out multiple names, but stacked them vertically, so I know they are in there, Im just not having any luck dragging them out. Below is the full function.
The example you provided earlier pulled out multiple names, but stacked them vertically, so I know they are in there, Im just not having any luck dragging them out. Below is the full function.
function userrank ()
{
$result = mysql_query("SELECT name FROM s_users WHERE rank = 1 LIMIT 0 , 30") or die(mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$html2 = '';
$html2 .= '<tr><td colspan="8"><b>:: Add Chat Staff</b></td></tr>';
$html2 .= '<tr><td colspan="8"><b>' . $row['name'] . '</b></td></tr>';
$html2 .= '<tr align="center">';
$html2 .= '<td>Staff Name</td>';
$html2 .= '<td>Title</td>';
$html2 .= '</tr>';
$html2 .= '<tr align="center">';
$html2 .= '<td><input type="text" name="userrank" value=""></td>';
$html2 .= '<td>'.showSelectedID2('title','0').'</td>';
$html2 .= '<td><input type="submit" name="addrank" value="Add"></td>';
$html2 .= '<td> </td>';
$html2 .= '</tr>';
return $html2;
}
}
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If you run that script segment and find only one name in the results set, you can be fairly sure that there is only one row in s_users that satisfied the WHERE clause.
ASKER
I ran the coding snip and it gave me this result:
Which is how many rank = 1 there currently are.
string(11) "user1,user2"
Which is how many rank = 1 there currently are.
ASKER
Thank you Ray, this worked perfect for what I was trying to tie it into and its formatted great!!
Thanks for the points and thanks for using EE. All the best, ~Ray
Open in new window