Search results for query: *

Hi I am designing a database for a local garage which sales and repair cars, I have come up with attached ERD diagram could anyone give me any advice on it and let me know if there is something wrong with it. Thanks for your help. Kind Regards HB 25

Hi Sorry my mistake, i have put your code in the wrong place, I have placed it after the query and it works . Thank you very much for your help HB 25

Hi I have put the if statement before the MySQL query in my code but it did not work. Any more advice? I am new to PHP and MySQL Thanks.

Hi Thank you, I have managed to sort this problem but I do have another page where user could delete their booking with us, my questions is what will be the if statement before the MySQL delete statement to check the bookingID which user provided is exist in the table bookings if not exist then...

Hi I am using the code below to validate user when they login to my website, the first part check if user have typed their username and the second part search the table to check user exist. These two parts work fine but the last part the while condition don’t work it keep give me the error...

...if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("xxxxxxxx", $con); $result = mysql_query("SELECT * FROM clients WHERE clientID=$_POST[clientID]"); // if statment should start here // if statment should finish here while($row =...

hi this what i have used : $startdate=mysql_real_escape_string(preg_replace('/(\d{2})-(\d{2})-(\d{4})/','$3-$2-$1',$_POST[startdate])); $enddate=mysql_real_escape_string(preg_replace('/(\d{2})-(\d{2})-(\d{4})/','$3-$2-$1',$_POST[enddate])); $adults=mysql_real_escape_string($_POST[adults])...

Hi This is the outcome, and still prints date in this format 0000-00-00. Arrival 2009-04-21 Departure 2009-05-22 ________________________________________ Array ( [firstname] => Alan [surname] => smith [address1] => hhhhhhhhhhhh [address2] => hhhh [town] => hh...

Hi feherke Blow is what was between the horizontal line, but the dates in the table printed is (0000-00-00. Array ( [firstname] => Alan [surname] => smith [address1] => 75 Paltan Road [address2] => didsbury [town] => Manchester [postcode] => M20 1JK [telephone] =>...

Hi feherke I have typed the mentioned code and below is the outcome, I think you write it does have a problem with $_POST data. Any idea how we could fix this? Regards HB25 Array ( [firstname] => Alan [surname] => smith [address1] => 75 Paltan Road [address2] => didsbury [town] => Manchester...

Hi Sorry y feherke I am new to PHP and Mysql, could you please apply it to my code and post the code here again. Thanks ever so much for your kind help.

...{ die('Error: ' . mysql_error()); } $last_insert_booking_id = mysql_insert_id(); $result = mysql_query("SELECT * FROM clients WHERE clientID='$last_insert_client_id'"); $result1 = mysql_query("SELECT * FROM bookings WHERE bookingID='$last_insert_booking_id'"); print...

Hi 1. how is your $_POST data look like ? 02/04/2009 my mistake i have used (/) insted of (-), after change the date to 02-04-2009 it will jsut show the date as 2009-04-02 2. An extra closing bracket ( ] ) : Again after deleting the extra bracket, i do get the same error message: Error: Column...

Hi The first code is just show (0000-00-00) in the start and end date field, and the second code it say Error: Column 'startdate' cannot be null Any more advice? Thanks HB25

Hi The code below is the query which I am using, could you please let me know how I could embed the code you are mention above to this query? $sql="INSERT INTO bookings (clientID, roomID, startdate, enddate, adults, children, roomtype, requirements) VALUES...

Hi feherke This did work; I just wanted to say a big thank you for solving my thread. My last problem is at the moment user will have to type date in this format (YYYY-MM-DD) as my phpMyadmin will only store date in this format any idea how I could make it to store date in this format...

...{ die('Error: ' . mysql_error()); } print "Your booking ID ".$bookingID; echo " has been changed"; $result = mysql_query("SELECT * FROM bookings WHERE bookingID='".$_POST['bookingID']."'"); $result_array = mysql_fetch_array($result); echo '<table border=1>'...

Sorry this what i get ----------------------------------------- First name | nothing here (I mean this is empty) ------------------------------------ last Nmae | nothing here (I mean this is empty) ------------------------------------ Arrival date|nothing here (I mean this is empty)...

I have tryed your code it only display rows and no columns.

I have tryed your code it only display one rows and no columns.