Well, the database is all going well and I'm finding it extremely useful.

Managed to get the fid thing semi working by mounting the network folder as my N:\ drive and found that I can stick a few lines in the Firefox prefs file to give expections to certain sites for local access.

Since it's only going to be used on 4 computers at uni, and the only 4 with this local access, then it's no hassle to sort Firefox for these 4 computers. It is, I think, 4 clicks to open each fid but that's better than the usual 11 or more, especially when the network is often a bit sluggish.

My supervisor was also suitably impressed and would like to use it for everyone in our groups data since it's a far easier way to keep things collated. Definitely was worth doing it then.

Right, down to the important part. I have a problem(ish). When pulling a row from the database I use the "id" to determine the row. Is it possible to use any other unique field to determine which one I want? For example the "code" (eg: AT025). In MySQL (PHPMA) Do I need to make the field a Primary or Unique or Indexed field or something?

I'd like to pull the record using the address bar like I do with the "id" field.

(http://domain/full.php?id=5)

eg: http://domain/full.php?code=AT025

Coding that is fine, but it doesn't pull the record out. I'm assuming it's because it's not indexed?!

It seems you are reading me right because I'd already tried that but it didn't work. Don't know the error as I'm on the bus but I'll post when I get home.

Also
Matt: Thanks for whatever change you made to the lite mode because this here text entry box is now the right size in Iris!

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\fullc.php on line 29

$tableid = $_GET['id'];

$tablecode = $_GET['code'];

$query  = "SELECT * FROM nmr WHERE id=$tableid";

$query  = "SELECT * FROM nmr WHERE code=$tablecode";

Right. Quoting made it work. Thanks.

I still need to sort out protecting my database.

I may just password protect the site (fail)

Aye. I've been taking a backup every so often. But automated would be far more useful.

I also handwrite each entry in my lab book :D

<form name="openlocation">
<input type="text" name="code" value="AT">
<input type="button" value="Go To" onClick="document.location = "fullc.php?="'document.openlocation.code.value';; ">
</form>

<input type="text" id="code" value="AT"/>
<button type="button" onclick="location.href='./fullc.php?code='+$j('#code').val();">Go To</button>

<input type="text" id="code" value="AT"/>
<button type="button" onclick="location.href='./fullc.php?code='+document.getElementById('code').value;">Go To</button>

Yay, nearly there. Just the 'code' needs to be in single quotes in the final URL.

Though that now seems to have broken somehow :@

Fantastic. Done. Sorted. Working. :D

Also, don't worry, I'll be keeping you occupied with more questions in the coming weeks/months. :Y