yay! Thanks very much for your help mate - much appreciated!!!

You can apply any HTML styles to it just as you would anything else by echo-ing out the HTML

Bold - Put echo "<b>"; before the text and echo "</b>"; after

oops might need the <br /> in speech marks.

havent done PHP for ages.

[Edited on 24-01-2007 by James]

echo <br />;

I love you James :D

One last thing though...(for now!).

The 2 rows which are being echoed, I want a line space between them.

Putting a <br /> inbetween them doesn't work as it is obviously disrupting the PHP code.

Also, I would like the row in bold!!

Any ideas?

[Edited on 24-01-2007 by liamC]

I would set a flag, say call the field "AdvertId" or something. Give it 1, 2, 3, 4 etc and then put "Where AdvertId = 3" etc on the end of the select.

OK...another one.

I have made a table wit 2 fields (Title field and description field) so it is echoing 2 rows;

code:
echo $myrow["title"];

echo $myrow["desc"];

Nevermind, sorted it! :D

For future reference, in this line of code taken from my above post;

code:
$result = mysql_query("SELECT databasetable FROM databasename",$db); 

code:
$result = mysql_query("SELECT * FROM tablename",$db); 

OK, getting there eventually.

code:
<?php 

$db = mysql_connect("mysqlname.domain.com", "username", "password"); 

mysql_select_db("databasename",$db); 

$result = mysql_query("SELECT databasetable FROM databasename",$db); 

while($myrow = mysql_fetch_array($result)) 

{

echo $myrow["rowname"]; 

}

?>

code:
php:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.saggy/user/domain.com/folder/index.php on line 61

?>

Cheers.

Anyone able to help me out with the code for this?

I am a php n00b. :(

just SELECT the text out of the database (into a $var) and then echo it out again - simple...

[Edited on 24-01-2007 by aPk]

Is this hard to do mate?

I can write text to the database no problem, and can set that up easy, but it would be displaying the text that I would have a problem with, as I've never done this before? Any pointers/tips? Does it take much programming?

Store the text of each one in a database.

Read it out on the homepage and create an admin screen that chages it in the DB

Right...just a thought/idea if anyone has any how to do this, or if it is possible.

Got a homepage (PHP) with 4 boxes on it. Each box has special offer text in it.

It would be ideal if via an admin page of some sort, that staff were able to type into a box what text they wanted in each special offer box and it then updates the homepage with the text they've just typed in.

Is this possible. Anyone have anymore info on this feature/function?

Cheers