SYNTAX help

[Rmazin]

I'm not sure how to word this query.

i need it to say something like

select column1 from tablename where colum2= MIN(column2)

in other words i need it to select column info from column 1 where it is = to the lowest value in column 2.

the value of column 2 will change everyday but i already have that part working.

thank you.


Also can i tell it to grab 2 rows of info?

[guelphdad]

   select column1 
 from tablename 
 where colum2 = 
 (select MIN(column2) from tablename)

[Rmazin]

thank you

[Rmazin]

can i tell it to grab 2 rows of info?

[guelphdad]

How do you mean? If there is more than one row in the table with the same min value for column two then all rows are returned containing that value. If you want to limit which ones are returned how do you choose? If it doesn't matter other than you want to show two rows for col1 that have same min value for col2 then just add a LIMIT 2 at the end of the query.

[Rmazin]

basically I just want to pull the information for the two rows that have the lowest value. they dont necessarily have to have the same value.

[r937]

select column1,column2 from tablename
order by column2 limit 2

[Rmazin]

select column1,column2 from tablename
order by column2 limit 2

This query works when i put it in Dreamweaver or MYSQL CC but when i put the page to the browser it gives me this message:

You have an error in your SQL syntax near 'LIMIT 0, 2' at line 1

[r937]

"put the page to the browser" ????

any chance you could show the actual query?

[Rmazin]

"put the page to the browser" ????

any chance you could show the actual query?

I meant put the page on the server and then opened it in the browser.

sure here it is:

$query_gettest = "SELECT `test` FROM `test_track` WHERE `cat`= '$cat' AND `speed`= '$speed' AND `date`='$date' ORDER BY `id` LIMIT 2";

when i run the query in mysql it works fine and even in the query builder window of Dreamweaver MX. However, when i pull the page up in the browser it gives me the error.

[r937]

that query looks okay

the problem is likely your php code