displaying records?

[addie]

hi anyone know:
i have 2 records to db table
I subject and message

subject: hello there
message: im still noob at php

how i display only half of message
example im still noob...

[MastahUK]

Hmm.......I'm no expert myself, but I think you could perhaps use the explode function. As I have nothing better to do at the moment while waiting for someone to answer my thread, I'll just make an example:

// I assume you are already connected to the database for this to work

$result = mysql_query("SELECT * FROM tablename") or die("Invalid query: " . mysql_error());

$words = 3; // Set this to how many words of the message you want to appear.  In your example, it was 3.


// Loop through each row in the table.  Will only happen once if that is how many rows there are.
while ($myrow = mysql_fetch_array($result))
{
	echo $myrow['subject'];    // will output "hello there"
	$message_words = explode(" ", $myrow['message']);   // Puts each word in message into an array
	$i = 0;

while ($i < $words)
{
	if ($i == 0)
	{
		$new message = $message_words[$i];
	} else {
		$new_message .= " " . $message_words[$i];
	}
	$i++;
}
echo $new_message; // Should output "im still noob"
}

I have not tested this, so sorry if it doesn't work.

[OhLordy]

That would work perfectly well, you could also do it like this.

<?php
$result=mysql_query('SELECT * FROM tablename') or die(mysql_error());
while($row=mysql_fetch_array($result)) {
  //echo the first half of message, spliting the string at the next
  //space after the half way point
  echo(substr($row['message'],0,strpos($row['message'],' ',strlen($row['message'])/2)));
}
?>

HTH
Rob