a comma is showing as the result

Anon

Hi all,

when i query the database a , (comma) is shown as all the results.

dunskii

van__

RTFLMAO!
Thanks for the chuckle.

Post some code and maybe someone can help.

Anon

here it is.

<?php

$db = mysql_connect("localhost", "root");

mysql_select_db("fjc",$db);

$result = mysql_query("SELECT b.bar_id as b_bar_id, b.lst_name as b_lst_name, b.fst_name as b_fst_name, b.qc_sc as b_qcsc, b.modified as b_modified FROM barristers b ORDER BY b.lst_name",$db);

<table width="70%" align="center" border=0>
<tr>
<td align="center"><span class="head">Barrister</span></td>
<td align="center"><span class="head">Last Modified</span></td>
<td align="center"><span class="head">Edit/Delete</span></td>
</tr>

while ($myrow = mysql_fetch_row($result))  {

<tr>
	<td><span class=\"text\"><li> <? echo ($myrow["b_lst_name"]); ?>, <? echo ($myrow["b_fst_name"]); ?> <? echo ($myrow["b_qcsc"]); ?></span></td>
	<td align="center"><span class=\"text\"><? echo ($myrow["b_modified"]); ?></span></td>
	<td align="center"><span class=\"text\"><a href="edit_barrister.php?$b_bar_id">EDIT</a>&nbsp;&nbsp;<a href="delete_barrister.php?$b_bar_id">DELETE</a></span>
	</td>
</tr>

<?
}
?>

</table>

Anon

Hello:

Poor coding.

Your code:
$result = mysql_query("SELECT b.bar_id as b_bar_id, b.lst_name as b_lst_name, b.fst_name as b_fst_name, b.qc_sc as b_qcsc, b.modified as b_modified FROM barristers b ORDER BY b.lst_name",$db);

You can code it just like this:

$result = mysql_query("SELECT bar_id, lst_name, fst_name, qc_sc, modified FROM barristers ORDER BY lst_name");

Wouldn't it be simple and nice? What's you reason putting 'b' there?

Alan

Anon

i've taken the b out, but it still doesnt work

any ideas??

Anon

try changing
while ($myrow = mysql_fetch_row($result)) {

while ($myrow = mysql_fetch_array($result)) {