fenway

I think LOAD DATA INFILE has the equivalent on "ON DUPLICATE KEY UPDATE".

Well, if you get a proper db dump, it should be simple enough.

The keys were disabled? I've never heard of that happening "on its own"...

More about this here.

Um... no database queries?

Don't you mean mysql_insert_id?

DISTINCT is not a function. Use group by.

You'll have to use backticks around any identifiers that have spaces in them -- `like this`.

Yikes... use a single statement.

Um, no.... you'll need LIKE '%TEA%'

No, you don't.... format/pad the number on output.

So? give it an alias.

You can check the output of COUNT() in a HAVING clause.

This something that doesn't need to be done by the DB.

you need to sort by both -- LEFT( yourColumn, 1 ) and the the substring to skip the letter.

Update how?

Echo the actual query... it's probably getting run twice.

You'd have to split your search query on, say, spaces, and then test each keyword separately.

The problem is your use of group by & mixing comma and JOIN, amongst other things.

I don't understand... you mean to query this table? What output are you expecting?

Next time, use code blocks, and don't post your access credentials! As for the upload, there are countless tutorials on php image uploads....

you need ppk%, not ppk_ -- the latter matches only one character. And an anchor, too....

You can't use SUM in a WHERE clause.

Right... that makes sense. The trick is to "order" by the lowest probe value, and then carry that forwards. Like this: select t1.* from exp as t1 inner join ( SELECT r1.*, @rank:=@rank+1 as rank FROM ( SELECT probe, MIN(pvalue) AS pvalue FROM exp WHERE pvalue<0.05 GROUP BY probe ORDER BY pvalue ASC ) as r1 cross join ( select @rank := 0 ) as r2 ) as t2 using ( probe ) order by t2.rank ASC, t1.pvalue ASC No SP required!

I find that hard to believe... does each individual select return the expected results?