Maq

Can you show us your current code because the solution Garethp provided should work...

So nothing happens...? Looks like it's not even getting to the if statement. Can you output the url in the if statement?

Example. Has code and sample for you.

^--- What?

Change: echo "</pre> <form name='\"form1\"' method='\"post\"' action="%5C%22%24_SERVER%5B'PHP_SELF'%5D%5C%22">< and before your query, add: echo "".$title." ".$eventTime." ".$eventDate." ".$venue." ".$description." This is what you JUST ADDED..."; echo " Here is your query: $sql "; Tell me what it says...

You select your database when you first connect. The others for you query are as follows: $sql="INSERT INTO kirkbydiarydates (eventTime, eventDate, venue, title, description) VALUES ('$eventTime', '$eventDate', '$venue', '$title', '$description')"; kirkbydiarydates - table name eventTime, eventDate, venue, title, description - field names Is this error generated from the insert query I mentioned javascript:void(0);above?

1) Are all the images in that format, DSCXXXX? 2) Can we your code?

Hmm... You may want to double check that because mysql_error() doesn't lie. Well, sometimes it does. table - citycm_co_uk field - kirkbydiarydates They both exist?

Maybe that's why he's asking for a critique cause he knows it needs it. Why don't you give him some pointers and suggestions instead of 2 word replies that are useless. -The color scheme is a poor choice. Use one of those color generator sites to find something that fits your site. -The head needs some work. You have a blue/gray background in the header with a red block that has the title of your site. Doesn't look too good. -I like how you utilize the full page but you need to add more content. What kind of feedback are you looking for? Design? Layout? Everything?

Please use: mysql_query($sql) or die(mysql_error()); and tell me what the error message says.

a statement sure to make its way into economics and political science textbooks. lol

Bug? This is a serious problem if it's been down for hours. Why don't you call your hosting provider and ask them what's going on. Downtime usually does not last this long...

$sql="INSERT INTO kirkbydiarydates (eventTime, eventDate, venue, title, description) VALUES ('$eventTime', '$eventDate', '$venue', '$title', '$description')";

Lol, that's the whole point of ORDER BY DESC and LIMIT. You should have said that from the beginning, at least you realized how to solve this problem.

Check out this tutorial.

What?

I don't... I just had an epiphany... I was so focussed on the individual result of the query, that wasn't thinking about how I could use a bigger range of results. Thanks (for helping me think through it more clearly) I'm confused ???

Put it in a function and use the for loop like blade suggested: $connection = //whatever your connect string is...; for($x=0; $x{ doQ($x, $connection); } function doQ($limit, $connection) { $result = mysql_query("SELECT * FROM sv_newsbrief ORDER BY briefID DESC $limit,1", $connection); if (!result) { die("Database query failed: " . mysql_error()); } while ($row = mysql_fetch_array($result)) { $briefID = $row["ID"]; $open = $row["open"]; $in_issue = $row["in_issue"]; $item1 = $row["item1"]; $item2 = $row["item2"]; $item3 = $row["item3"]; $close = $row["close"]; $brief = $item1 . $item2 . $item3; echo $brief; } ?>

Sorry, but when someone starts a thread on how to create a file and doesn't even know how to create a submission button, it makes me think he just wants a CnP solution... And in-case you couldn't figure out the delete part: if (isset($_POST['create'])) { $create = "File.html"; $create = fopen($create, 'w') or die("can't open file"); fclose($ourFileHandle); } if (isset($_POST['delete'])) { $delete = "File.html"; unlink($delete); } ?> </pre> <form action="<?php%20echo%20%24_SERVER%5B'PHP_SELF'%5D;%20?>" method="post"> <

This doesn't even relate to your question. The link you provided is just a black background with some text... I think what you need to do is set the width and height to 100%.

This kid is not going to learn anything if you just give him the code.

Yes! Make a link to a .php page and use the information in the links I gave you.

create delete

Found this thread on WebProWorld. Seems to be a similar to your problem but for some reason the blame is on Microsoft... Weird! Hope it helps.

Let me know how it works out.