fenway

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.

Yeah, that's not how a database works. How do you decide which one of the N rows is correct?

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

1) I'm not spelling anything wrong -- see here. 2) That was a full sentence; "leading" makes it sound optional; the sql-99 date format is YYYY-MM-DD, so there's no choice here, really.

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?

How about: SELECT t1.* FROM yourTable AS t1 INNER JOIN ( SELECT experiment, probe FROM yourTable WHERE pvalue<0.05 GROUP BY experiment, probe ) t2 USING (experiment, probe ) order by t1.probe ASC, t1.pvalue ASC;

Well, you can link the rows... how would linking "data" work?

I don't consider those "leadings zeroes" vs. zerofill.

Depends what the source format is like.

That's up to you and your script... MySQL doesn't really care either way; though MySQL 5 does have some built-in XML support.

Not sure exactly what you're asking for...

No function -- just query the users table with JUST the user name, then in php check the hashed password against the value you've stored in your DB.

Read this thread.

Just iterate through the results.

There are no "leading zeroes" in a date field...

We don't debug php scripts on this board -- show us some sql statement output.

Yes, but that doesn't require a constraint per se.

One answer = one row. Multiple answers = multiple rows.

Huh?