Muddy_Funster

to see if the value is as you think it is, put this line just before your mail send script echo $email ; exit();

Generaly, you would make a login script for the admin side of it. This would let whoever has the admin login do what needs to be done, without having to bother with directory level security.

DOH! Good Catch PFM

sorry - I meant $email. Can you echo $email at the point you would send the mail and see what it has in it?

at a glance, I would change: $query="INSERT INTO tblgerecht(gerecht) VALUES('$_POST[nieuwgerecht]')"; to $query="INSERT INTO tblgerecht (gerecht) VALUES ('".$_POST['nieuwgerecht']."')"; and see how that goes.

tried changing LEFT( product, INSTR( product, ' ')) to RIGHT( product, INSTR( product, ' ')) ? if that's not relevent, could you post your table structure and some sample data?

The code you posted desn't actualy deal with the formating of the information on the page for display. what you are looking for is your html table code(it will start with <table>) remove the </tr><tr> from the table code leaving a single <tr> at the start, and single </tr> at the end, this will present everything on a single line. if you want, post your full code and we'll point out where to apply the changes.

assign "[email protected]" to your $mail variable and you should be good to go.

Well the drop down and the page layout is done with HTML and CSS. The actual querie is done through PHP and SQL. So you're looking fore a little of everything. I can't recomend any books for the PHP / SQL as I have used online manuals for both for years now. I will look out what books I have on CSS and HTML and let you know what they are, they are pretty good - just can't remember what they are called :-\ I'll get back to you.

seems to have gone out of fashion

wooo, aint you cheeky :- not the best way to go about getting help. I'll try again, on the off chance you fell off that high horse. 1: the php tags I reffer to are the forums php tags these format the code in a way that makes life easier for all concerned. 2: there is no way 118 lines in that code you posted - so clearly something is missing. 3: the ... also contains the file name that has the error - helpful if you have used an include anywhere in the code you didn't post. 4: the STRUCTURE is not in your code as this reffers to table name, field name, field type, any fileds that are keys, any indexed fields and any fields that are auto incramented. 5: It's impossable to answer without the relevant information!

1: put your code in the php tags 2: post the full page of code 3: post the full error message 4: post your table structure 5: Read the Forum Guidelines! (honestly - they are there for a reason, had you read them alredy I could be posting back something much more helpfull to your cause)

I think they want to know about blobs but looking at the field types being used already I would recomend brushing up on basics before going any further.

why do you think that cramming more code onto a single page and having the server run through all the code each time using PHP_SELF is more efficient? to do what you are looking to do, simply add a hidden field to the form, call it what you like and assign it a value of one (1). have the code at the top of the page check if(!isset($_POST['variableName'])) { //your password comment and submit form here }else{ //confirmation that the password has been sent }

It's got to be said : don't hide them - FIX them never release code to end users untill you have it working bug/error/warning free (believe me, even when you get to this point they will still find problems that you didn't think possible). It's not going to do you any favours if your users are left looking at a blank page wondering where your site has gone because you've hidden the error message and the script failed.

your if is malformed: <php if($DateOfBirth != '0000-00-00'){echo $DateOfBirth;} ?> is how it should look. When writing an if I find it helps to think of the { as being "then begin" and the } as "end" so when you run through the logic you remember where to put them. e.g. IF variable called DateOfBirth does not equal the value 0000-00-00 then begin show message on screen displaying the contents of the DateOfBirth variable end

Bumping is against the rules.... What are you looking to learn? PHP or SQL? Books are a good resource (even if you do have to spend all of about £30 for a good one) but often, if you have the time and determination you will be able to colate information from the inter net that you can then print off and create your own refference volume.

<a href='edit_data.php?=$row[0]' you haven't put in a variable name to assign $row[0] to. you would need something like <a href='edit_data.php?table=$row[0]' then use $tableName = $_GET['table'] In your edit_data.php page. That help at all?

mark solved?

What type of database are you using, because this isn't really a PHP question.

...mysql_real_escape_string.....?

not really sure what's going on here, or what your getting at about posting multiple entries, your code is only set to post a sigle update and there is nothing about an array that I can identify. What exactly are you looking to achieve? and what EXACTLY is the problem that you are having (e.g error code, blank page, runs through but result differs from that which is desired by....)

Three things- 1st: wrap you code inside the forums PHP tags or we're likely not even going to look at it (it's in the terms of use for the forum - I'm not just being nasty.....or am I ). 2nd: you think we need it kept simple? this is actualy counter productive, as the issue could lie further on in your code and we are just going to end up asking you to post it all anyway. 3rd: we need information on all aspects of the script, in most casses that meens table struct from databases accessed, posting up of included files contents etc. Where's fenways signature when you need it?...

change this echo ("<td><a href=\"edit_form.php?id=$row[id_number]\">Edit</a></td></tr>"); to echo '<td><a href="edit_form.php?id='.$row['id_number'].'">Edit</a></td></tr>'; and see how you get on

without posting two forms into each result line the easiest way that I can think of is to change the following line to look something like this : echo $result['sSlug'].' '.$result['sBudget'].' '.$result['sArt'].' <a href="dbEdit.php?record='.$result['id'].'"> EDIT</a> | <a href="dbDelete.php?record='.$result['id'].'">DELETE</a> <br>'; then make up a new new page for each function: called dbEdit.php and dbDelete.php. At the start of each of these use the line $id = $_GET['record']; you can then code each page to do what you want it to do (either edit a record or delete it) by using the $id refference to the primary key field for the record. Did that make sense?