StephenM

Hi there, I'm not sure if this is the source of the problem but you could check. What happens if you make the following change on line 3: <?php if ($_POST) { $myoptions=$_POST['options'][0];

Does this modification make any difference? SELECT DISTINCT (h.hotel_name) , r.room_name, f.features_name

Hi, Did you try and run the SQL query on its own in phpmyadmin? It might reveal more information.

Hi. Check the tip on page 124. mysql -u yourusername -p sitename If successful login, it will directly open the sitename database.

perhaps the value of $query_row['name'] is empty?

It talks about that a bit more here: http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html

Somebody else who uses the same OS as you with XAMPP installed might know how to go about it?

Hi, does mysql start without problems from the shell (without navigating to the mysql bin directory) ?

I tested this code and it worked for me without changing your code. So I'm not sure why either.

can you post your validation section for the $_POST['datecreated'] value?

I am not sure what is wrong either but here are some suggestions of things to have a second look at: See at the end of your code, an extra bracket looks out of place and I wonder is it messing things up? exit(); }else{//IF THE EMAIL ADDRESS IS ALREADY REGISTERED echo '<p class="error">The email address is not acceptable because it is already registered</p>'; } } Another security issue consider is lack of filtering of the email variable although I don't think this is your current problem (you didn't use real escape string function here) // Check for an email address: i

to be honest, I've had to read some of the code a few times myself when reading the book. sometimes it's difficult to read the code when it's on the two column layout because it's all bundled up together.

If you have a closer look, you will probably notice that this is due to if statements inside if statements rather than any mistake.

Any reason why the path needs to be set?

I can't find anything obvious wrong. In your login.php, what argument is inside the redirect_user() function. At the moment, you are being redirected to index.php. This is the default setting for the redirect_user() function. What you need to have is redirect_user('loggedin.php') Can you confirm what code you have running on the server for redirect_user()?