willpower

Simply return the data from the DB as normal. Then echo this out in the head (so your php has to gpo before this) of your doc. $title = my DB's return then in the HTML <title><? echo $title;?></title> etc etc

are you updating or inserting? Thorpe is right...you need not and indeed cant insert a value like that into an auto_increment column if inserting and updating...well then you should only require to update the NEW variables

REmove this line mail($email_address, $subject, $event, $dateevent, $comments "From: $name <$email>\nX-Mailer: Simple PHP Contact Form 1.0 (www.korske.com)"); and replace with mail("Lisa Cleveryley <".$email_address. ">",$subject_prefix,$message,"From: ".$name." <".$email.">");

In your WHERE statement you have no ' ' around the $address_no As a result it is failing to find a matching row, but not hitting an error. so it shoudl read WHERE address_no='$address_no'

please supply your updated code

lets get it working first!

your nearly there!!!. mail($email_address, $subject, $message, "From: $name <$email>\nX-Mailer: Simple PHP Contact Form 1.0 (www.korske.com)"); Think about his line. It mails all the other bits and pieces. You need to send a $message ...right? well you work the rest out So we can create a $message by saying $message="This is my message...name=".$name." and email=".$email." and event=".$event." and ....you work the rest out! lol am i am bad teacher???

are you working on this or just waiting for some poor sucker to code this for you....lol

Yeah..sorry just read the post again and actually looked at your page this time. you have HTML... <select name="event" size="1"> You need to have a $_POST statement for each name. Here the name is "event" So the PHP to get this information becomes $event=$_POST['event']; for the <option value=" other">Other</option> it would be $option=$_POST['other']; etc. FINALLY use the $message in your code to stake these all together $mesage=$event.$option.etc.etc Now this is not going to be pretty!!!! but one step at a time

OK Really we could do with seeing your html form. But in its absense let me make the following clear. The html form has an action attached (or should have) to the <form> tag. Make sure this points to the php file. The <input> tags all should have a name value ie <input type="text" name="Your Name" /> Where each element has a name you need to make sure that there is a $something= $_POST['something']; that corresponds with it. ie $name=$_POST['Your Name']; This lets PHP identify the field in the form to the the posted information from. Sort all that out and come back to us. Will

I must be failing to understand this. You say that you want all items that are not set to 'N' if that is correct then ask for that in your SQL WHERE completed <>'N'

First thing you need to do is checkout the GDlib http://uk2.php.net/gd Then as you get stuck as spceific questions about each trauma that you having. Good Luck

I cant see any evidence of it being changed or rendered as PHP...how have you come to this conclusion

he types faster than me!!!

you have double open quotes that are unescaped. Look at the colors. You will see the blue in the echo statement. this needs tro be fixed.

You wont include a file with the header comand. The header command will reedirect rather than include if you are looking to redirect then the command is correct. the main ideas here would be o capture the url (if i understand your question) and for this id use $url =$_SERVER['REQUEST_URI']; the use the $url var in the redirect where appropriate. The explode can be used...perhaps by exploding at each "/". But from yor post I'd struggle to offer more info. Will

Databas with 3 fields id, name ,active rows are 1----option1----1 2----option2----1 3----option3----1 How can i extract all options into a single array so as $results=array('option1','option2','option3');

$query="SELECT.............my statement.........."; $result=mysql_result($query); $row_result=mysql_fetch_assoc($result); $total_rows=mysql_num_rows($result); do { ?> <tr> <td><? echo $row_result['Song Title'];?></td> <td><a href "<? echo $row_result['Link'];?>"> Link Title </a> </tr> <? } while ($row_result = mysql_fetch_assoc ($result)) Now this is only part of the code...but it should give you an idea

sorry you are right the code you have (i blieve) is problematic as it spits all the row from the DB as 1 string. You will need to rework this before you can have a link where you want it. you will need to seperate out all fields so that your downlaod field can be treated differently

so you currently echo the results from ['description']? just add a conditional. if ($_Session['lang']=="en") { echo //english description;} if ($_Session['lang']=="fr") { echo //french description;} if ($_Session['lang']=="gr") { echo //german description;} PS last post just came up. Yes if you did that ID's would be a problem....but y would you delete 1 descrition and not all. Anyway youur table is fine.

you have it <a href " <? echo link from db;?> "><? echo link name from DB ; ?></a> You clearly will have to store the link location in the database OR have a logical process so that all links are 'worked out' ie $link="http://this_path_always/".<? echo $this_name; ?>.$this_file_extension;

bumpety bump.

now...with the greatest of respect....we cant help with that sort of response. You have given no indication of a) how your tables are set up...and b) how you come to your next problems about deletion. Lets start again. Try and be more precise in the environment that you are working and the specific issue(s) that you have. Everything will go wrong is a little but vague...lol

Id use sessions lets say that you have identical data in 3 tables...1 table for each language. tables english, french, german I'd set the Session['lang'] to default to "english" $lang=$_SESSION['lang'] then i'd "SELECT products from '$lang' WHERE...." then if someone clicks a button (flag) reset the $Session to the relevant language. That could be one solution. it kinda depends on what table format you have.

'<?php echo number_format($oRS["GrandTotal"],2) ?>'> change the "" to ' and the opoosite too so that you have "<?php echo number_format($oRS['GrandTotal'],2) ?>"> Try That