Implode problem

rolwong

I have written something likes this:
$sql = "SELECT student_name from myTable";
$rs_query = mysql_query(($sql),$conn);

$no_of_student = mysql_num_rows($rs_query);
for ($i=0;$i<$no_of_student;$i++) {
$arr[$i] = mysql_fetch_array($rs_query);
}
$myString = implode(",", $arr[]['student_name']);

But It is an error.

my db contains four names: Carmen, Jacky, Martin, Louis

I would like to combine all student name into a string
eg. $myString = "Carmen, Jacky, Martin, Louis"

How can I achieve this? Thanks.

rolwong

On top of this, I would like to ask one more question. I would like to show the string in a text field.
Eg. print "<input type='text' value=\"$myString\">

If the string can display properly in a text field, suppose that the user can select/highlight the text of the text field. I would like to know if there is any possible way to avoid the user delete the text in the text field even though he presses the delete button.
Thanks for advance.

Thora_Fan


$SQL = "SELECT student_name FROM myTable";
$myResult = mysql_query($SQL, $Conn);
while(list($studentName) = mysql_fetch_array($myResult))
{
    $myString .= "$studentName, ";
}

// chop off the last comma
$myString = substr(trim($myString), 0, strlen($myString) - 1);
echo "<input type=\"text\" size=\"25\" name=\"whatever\" value=\"$myString\">"

That's the way I would do it. Hope this helps out. As for the second question, I'm not quite sure on that one.

rolwong

Thanks for the nest code. I need to improve more.

I am still searching if the 2nd question is possible or not. Anyway, thanks for helping me out