select * from nmr where id >= offset limit 5

edit: oh and you prob want a "order by id asc" just to make sure.

$tableid = $_GET['id'];
$query  = "SELECT * FROM nmr WHERE id >= $tableid LIMIT 5";
 

 
$getid = $_GET['id'];
$tableid = mysql_escape_string($getid);
$query  = "SELECT * FROM nmr WHERE id >= $tableid LIMIT 5";
 

$tableid = mysql_escape_string($_GET['id']);

if (isset($_GET['id']) && is_numeric($_GET['id'])) {
 
    // No need to escape via mysql_escape_string as we
    // know it's numeric from the is_numeric test in the
    // if statement.
    $table_id = $_GET['id'];
 
    // sprintf can also be used to sanitise input from a user,
    // but it can make code harder to read. In this example %d
    // requires the variable to be an integer. The other types
    // are listed on the manual page.
    $query  = sprintf("SELECT * FROM nmr WHERE id >= %d LIMIT 5", $table_id);
 
    // Rest of your code goes here
 
}else {
 
    // ID is not set in the URL query or it is not a number, show an error here?
 
}

Problem number something:

I have a load of the data I want in my database in the form of an Excel spreadsheet. I've now saved it as a CSV and removed all the lines already present. I thought I could import this using PHPMyAdmin but it turns out I can't. I've read that it's possible (from the PHPMA wiki of all places) but for me it only gives me the option to import SQL based files.

I've upgraded PHPMA versions from 2.11.6 to 3.1.0 with no luck.

How and where does one enable CSV imports/uploads?

Thank you!

All imported now. All the help from all round has been appreciated. No doubt I'll be back for more.

Actually, why am I only able to access PHPMyAdmin on the server itself and not on any locally networked PC?

http://www.heidisql.com/download.php

So infinitely much better than PHPMyAdmin. By fuck I hate PHPMyAdmin.

(have to allow remote connections from wherever you intend to use the app, obviously)

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";