[darkcarnival]

hi,

fixed the last problem,in a way but now i got a different one now. when the news is viewed, it will not sure the post like i want it to show. like for example if i wanted to show dates or names like:

3/2/04-me
3/5/04-you
3/23/04-meself

it will show up like this:

3/2/04-me3/5/04-you3/23/04-meself

any ideas on whats doing this?thx.

[Infinite_Hackers]

Originally Posted by darkcarnival

hi,

fixed the last problem,in a way but now i got a different one now. when the news is viewed, it will not sure the post like i want it to show. like for example if i wanted to show dates or names like:

3/2/04-me
3/5/04-you
3/23/04-meself

it will show up like this:

3/2/04-me3/5/04-you3/23/04-meself

any ideas on whats doing this?thx.

please show us your script (never forget that!)

[darkcarnival]

well im not sure what line to show. if you tell me what line, ill show it

[Infinite_Hackers]

show us the line(s) where you get your information and display it

[darkcarnival]

do you mean the line that displays the info or the line that inserts the info in the DB?

[Infinite_Hackers]

the whole code... really.. we just need to see how/what you code is... and how we can help you... :S

[darkcarnival]

ok then

PHP Code:

<?

echo "<FORM METHOD=\"post\" ACTION=\"/News2/Post.php?action=process_post\">";

echo "Logged in as: $metaluser<BR>";

echo "Posting In: <SELECT NAME=\"cat\">";

echo "<OPTION VALUE=\"\">Select Category<BR>";



include "/home/httpd/vhosts/metalstation1.com/httpdocs/News2/config.php";



$db_connection = mysql_connect ($DB_HOST, $DB_USER, $DB_PASS) or die ('Could not connect to MySQL: ' . mysql_error());

mysql_select_db ($DB_NAME) or die ('Could not Select Database: ' . mysql_error());

$query2 = mysql_query("select * from News_Category");



if ($query2)

        {



$numOfRows = mysql_num_rows ($query2);



for ($i = 0; $i < $numOfRows; $i++)

        {

$cat = mysql_result ($query2, $i, "Category");



echo"<OPTION VALUE=\"$cat\">$cat<BR>";

        }

echo "</SELECT><BR>";

        }

else

        {

echo mysql_errno().": ".mysql_error()."<BR>";

        }

echo "Subject: <input type=\"text\" name=\"subject\" SIZE=\"35\" value=\"\" class=\"text\"><BR>";

echo "<TEXTAREA NAME=\"body\" ROWS=\"15\" COLS=\"50\" WRAP=\"hard\" class=\"text\"></TEXTAREA><BR>";

echo "<INPUT TYPE=\"submit\" Value=\"Post\" class=\"submit\">";

echo "</FORM>";

  switch ( $action )

  {

  case 'process_post':

  

  if ($subject == ""){

  echo "You didnt add a subject. Please go back and add it.";

       }

  elseif ($body == ""){

  echo "You didnt add anything. Please go back and do add something.";

  }

  elseif ($cat == ""){

  echo "You didn't add a category. Please enter a category.";

  }

  else{

        include "/home/httpd/vhosts/metalstation1.com/httpdocs/News2/config.php";

        $db_connection = mysql_connect ($DB_HOST, $DB_USER, $DB_PASS) or die ('Could not connect to MySQL: ' . mysql_error());

        mysql_select_db ($DB_NAME) or die ('Could not Select Database: ' . mysql_error());



            $query = mysql_query("insert into News_Posts (Subject, Body, Date, Username, Category) values ('$subject', '$body', CURDATE(), '$metaluser', '$cat')");



            if ($query)

            {

              echo "Success! being redirected to post, click <A HREF=\"/News2/view.php?cat=$cat\">here</A> if your want to go now.";

              echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"2; URL=/News2/view.php?cat=$cat\">";

            }

            else

            {

              echo "post error! below is error message:<BR>";

              echo mysql_errno().": ".mysql_error()."<BR>";

            }

      }

  break;

  }

[Infinite_Hackers]

Where in your code does it display
3/2/04-me3/5/04-you3/23/04-meself

(when viewed)

[darkcarnival]

alright, i think i figured it out

what i was using as a example was the body($row[body])

when my program outputs the body of my news its putting it out in text form. because i made a test post that did this:

hi,

test

bye

and it came out like this:

hi test bye

now is there a code that will add <BR> to blank spots? or is there a small problem that im not getting at?

but im talking about the body variable.

[Keith]

Wherever you want to break to a new line, add <br /> to the end of the echo string, inside the quotations.