how to fetch id value

[nitesh]

Hi guys if iam getting 1 value of row in MYSQL table then how i can get other values of the same row with 1 value.

[Don E]

You mean get other values from columns in that same row which equals 1? Something like this you mean: SELECT column1, column2, column3 FROM table WHERE id = 1;The 'id' above is a column, along with those other columns(column1, column2, column3) in the table where it has auto incremented values for each row;1, 2, 3 etc. The above would select the columns mentioned where the id column is equal to 1. (If this is what you're asking to do)