Shell Programming and Scripting

I'd watch while ($story = mysql_fetch_array($result)) - it looks like you might be assigning a new value to $story. Is there a comparison operator, like == ?

i wrote this one, and get no errors, but it wont display anything . It will coneect to the db, cause if i change stuff in the dbconnect.php, it displays unable to connect to db, which is the custom error i put in. I have changed db's to make sure i didnt make a mistake in creating the db, but still nottin. Whats wrong with the script?


<?php

include('dbconnect.php');
include('header.php');

$result = mysql_query("select * from message")
or die (mysql_error());

while ($row = mysql_fetch_array($result));
{

print $row['text'];

}
mysql_free_result($result);



?>

Okay, see if this helps:

http://hotwired.lycos.com/webmonkey/...x2a_page6.html

that worked thanks, now

PHP doesnt really support html stuff, so have alook at this

www.compulearn.ie and see the text, with the picture, how do i get php to display exactly like that, but php gets it from mysql.

what kinda code would i have to put into mysql for php to display like that,

ive made the menu bar on the left part of the header.php, but php puts the text from mysql underneat that, how do i get php to put the text where it is on the website, do i have to put like <<maintext>> thing in so it will place the text there ?

Thanks

okay, heres the problem.

i have drawin a diagram below to show what happens when my sql print the text. I have a header and left bar, named header.php ( includes the left bar) and it puts the text under all that as shown.

+--------------------------------------------------------+
| |
| HEADER |
+---------+----------------------------------------------+
| Home |
| News |
| Links |
| Contact|
| Join Us|
| Login |
| Register|
+----------+
TEXT ENDS UP DOWN HERE

But i want it like this

+--------------------------------------------------------+
| |
| HEADER |
+---------+----------------------------------------------+
| Home | I WANT THE TEXT TO GO HERE LIKE
| News | THIS BUT IT WONT DO IT FOR ME !!!!
| Links |
| Contact|
| Join Us|
| Login |
| Register|
+----------+




Can someone tell me y mysql puts the text down under everything??
I also want to have a admin interface to edit that e.g.

A text box and a edit button and it will change the text.

Please someone help me

I think it'd help if you pasted the contents of header.php, if it's not too big...

its too big.

is it possible to get mysql to print to a varaible?eg...


+--------------------------------------------------------+
| |
| HEADER |
+---------+----------------------------------------------+
| Home |
| News |
| Links |
| Contact| $printhere
| Join Us|
| Login |
| Register|
+----------+