Hi
Thank you for your comment I have managed with most of the Quires by deleting the table stock and adding labour filed to the jobcard table.
But i am still struggling with one query which is (...

Hi all
It’s required from me to create a database for a company which have three branches; the company does repair and sale second hand cars. I have created the database with my tutor but I think...

Hi kronass

Yes I do agree with your ERD it does make sense this way. Now we need to move on to the next step the normalisation.

Kind Regards
HB25

Hi kronass
Thank you for your help, please find attached with this my ERD and Normalisation.

Kind regards
HB25

Hi kronass
Thank for replying to my thread, I have managed to get my ERD done but I may need some advice on Normalization can you help with that?
If you can then I will post my normalization and...

Hi Josh
This is only a college work and for the time been this is fine. But do you know what will be the if statement to check user input date is exist in the datable or return a message to the...

Hi Josh
Just to let you know that i have managed to solve my problem below is the code i have used and thank you very much for all your kind help.

$date =...

Hi Josh
I have run query into phpMyAdmin and it did return the right number of rows, please see attached image.
When I click on create php code and copy and paste that query to my php page it does...

Hi
Sorry for not replying in the past days I was out in town.
I have tried all the above but no successes yet, I am using the below code but I am getting this Resource id #2.
Any Idea what is...

Hi
Thank you for helping me out with this problem, please find below answers to your questions:

Ok can you use a client like phpMyAdmin to view the tables themselves?
Yes
If so do the dates...

Hi Josh Connerty
Thank you for your help, it looks like the query working but PHP does not echo out the results.
For your information the date is stored in the database in this format ( Y M D)....

Hi
I will explain what I am trying to do:
I have used MYPHP admin to create a database where user booking details will be stored in a table called bookings.
Now I need to retrieve all the...

Hi
I do have a form called booking, when user should be able to type a booking number in text box and by clicking on the Find button then all the details for this booking should be displayed.
My...

Dear Friends,

I am designing a database for a local garage where they repair and sale cars. I have come up with the attached normalisation.
I would be very grateful if someone could have a look...

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...

Hi nav33n
Thank you very much for your advice, you have solved my thread once again.

Kind Regards
HB25

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...

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...

Hi buddylee17
Thank you very much for your help, your code did work.
Regards
HB25

Hi
I explain what I have: user will visit the site to change booking detail using their client and booking ID, once thy typed their ID they will be directed to another page where they will be...

This did not work for me. could please put it in my code a bove and post the code here again.

thanks for helping.

Regards

Hi
I do have one more question if you could help me with I promises this will be my last question :
When user use (changebooking) page and click on submit to change their booking details, what...

As i live in the UK and the format for date is like this.
I think i will go with your advice i shoud leve it as its.

BTW MaxMumford has solved my problem this time how i could mark him as a...

Hi
So how can we apply this to my query if you think it’s going to work?
Regards
HB25

Hi
I have opened this thread in another form and this is what I have been giving as a code but it will return an error saying (Error: Column 'startdate' cannot be null) any advice?
...

Hi
This is what I get:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near...

Hi
I have gathered from searching the net that I could use the code below to format the date as (DD-MM-YYYY)

insert into table ( field ) values ( str_to_date($date,'%d-%m-%Y') );

The code...

Hi MaxMumford
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...

This is my code


<?php

// open database connection code and then my code as follows

$sql="UPDATE bookings SET startdate...

same thing hapning :icon_sad:

BTW this is the query which I am using just in case if it does make deference.


$result = mysql_query("SELECT * FROM bookings WHERE bookingID='$_POST[bookingID]'");

No there is only one record in my table with Booking ID 33 and the bookingID column in my table is already an auto increment primary key.

Any more suggestions?

Thanks

Hi
Thanks for sorting out my thread we almost there, but there is a very small problem which is after retrieving the information it will repeat the table more than 9 times, I was wondering how this...

Hi

You almost solved my thread, what I meant by (It does bring back everything from the table ) is it will bring back the information from the first tow row as well in my table which I don’t want...

Hi
This code work but not solve the program completely as i want to display the information in table, this is what I get:
booking has been changedbookingID | 33
roomID | 0
clientID | 33...

Hi
Thank you for replying to my thread bu t i don’t understand what do you mean buy using this code:


foreach($result_array as $key => $value)


For your information, i do have two queryes...

Hi
I am using the fallowing code to give some information back to the user after running some queries. The information will be displayed in row only.

$result1 = mysql_query("SELECT * FROM...

Hi nav33n

I have been trying to sort the table to display the information in columns and rows but I am not getting there any help will be highly appreciated.

I would like to displayed the...

Thanks for your help, I will start work on it to make it better but if i have a problem i will get back to you.
Good night
HB 25

Dear nav33n
Thank you very much your code is much much better than the one I have used, did work and thanks for solving this problem for me but I do have one more problem and hopefully I want...