Mysql attributes to textfield multiline object

simwiz

hi! What im basically asking is, how may I add multiple attribute data to a textfield. I can output mysql data back into a text box but i cannot output multiple data.

$sql = "SELECT userName, msgContent, msgTime, msgDate FROM message";
$result = mysql_query($sql)
or die("Couldn't execute query.".mysql_error());;

then spit this back into ONE multilined text field with possible format.

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo 'username:'.$row['userName'].' ';
echo 'time:'.$row['msgTime'].' ';
echo 'date:'.$row['msgDate'].' ';
echo 'msg:'.$row['msgContent'].' ';
}

above is how id normally display multiple data attributes, but how may I display this in a text field not within a table or as basic html output.

thanks for any replys!

herve

Are looking for the TEXTAREA HTML tag ?

$msgContent = $row['msgContent'];

print "<TEXTAREA NAME=\"msg\">$msgContent</TEXTAREA>";

This should be enclosed in a form ("<FORM> ...</FORM>") to work.

simwiz

its not what i meant :queasy: I can do that quite easily! im asking multiple attributes! so say msgName, msgContent, msgTime and msgDate all to be writen into 1 multi line text field.

say this is the text field --->

Name: msgName
time:msgTime date:msgDate

msg: msgContent

then reloop this for each record within the table. Print this into a text field !

cheers for the help so far :p

mobe

What text field?

do you mean a form text field?

echo "<input name='textfieldname' type='text' value='$row['userName']'>";
echo "<input name='textfieldname' type='text' value='$row['msgTime']'>";
echo "<input name='textfieldname' type='text' value='$row['msgDate']'>";
echo "<input name='textfieldname' type='text' value='$row['msgContent']'>";

or a multi select form field?

echo "<select name='textfieldname' multiple size='4' ><option value='$row['userName']'>$row['userName']</option><option value='$row['msgTime']'>$row['msgTime']</option><option value='$row['msgDate']'>$row['msgDate']</option><option value='$row['msgContent']'>$row['msgContent']</option></select>";

simwiz

just 1 TEXT FIELD

Roger_Ramjet

Concatenate the sevarl fields into one string var and then set the value of the textarea equal to it


$text = $row['userName'] . $row['msgTime'] . $row['msgDate'] . $row['msgContent'];

echo '<input type= "textarea" name ="whatever" value="' . $text . '" />';

herve

Roger Ramjet wrote:
Concatenate the sevarl fields into one string var and then set the value of the textarea equal to it
$text = $row['userName'] . $row['msgTime'] . $row['msgDate'] . $row['msgContent'];

echo '<input type= "textarea" name ="whatever" value="' . $text . '" />';

Exactly 🙂

You can even add some CR/LF :


$text  = "Name : ".$row['userName'] ."\n";
$text .= "Date : ".$row['msgDate'] . "\n"
$text .= "Time : ".$row['msgTime'] . "\n";
$text .= "Msg : ". $row['msgContent']."\n";

echo '<input type= "textarea" name ="whatever" value="' . $text . '" />';