quote:

---

Originally posted by James
To a software developer that would be trivial.

You might not get a package as complete as an off-the-shelf package, but you could certainly get something that would meet your needs.

---

quote:

---

Originally posted by Dan
My knowledge is very limited about this, so I'd like to have a go and learn a bit. Reckon I could do it?

Doesn't need to look pretty, a website would do ok. Any places I can look for info, other than google

---

quote:

---

Originally posted by Dan
We have servers etc already, although i know absolutley nothing about these, as im there to fix trucks, and have nothing to do with the computer systems.

Im thinking the best thing i could make first as a learning curve, would be to make a page which allows you to input a vehicles details, along with all the info we would need to know about it.

That way i can build the database with all the info in, which i can then build bits around it to access this data and give me the info?

Or am i barking up the wrong tree lol

---

quote:

---

Originally posted by Dan
a database of vehicles with fields such as last service date, last service date mileage, mot test, etc.

---

quote:

---

Originally posted by Dan
I could then use something in the vehicle initial input data to say how many weeks between services.

---

quote:

---

Originally posted by Dan
Could a database then produce its own date for the next one due, based on the last service date and the weeks between services?

---

code:


<form method="post" action="initialdata.php">



Customer:  <input type="text" size="12" maxlength="30" name="customer"><br />

<br />



Reg No:  <input type="text" size="12" maxlength="30" name="reg"><br />





<br />

<br />

<input type="submit" value="Submit">





</form>

code:








<?php

mysql_connect("localhost", "admin", "password") or die(mysql_error());

echo "Connected to MySQL<br />";

mysql_select_db("planner") or die(mysql_error());



 

$customer = $_POST["customer"];

$reg = $_POST["reg"];

 



mysql_query("INSERT INTO vehicle 

(customer, reg) VALUES('$customer', '$reg' ) ") 

or die(mysql_error());  





$result = mysql_query($query);



?>