By value do you mean variable character or numeric?

a numeric value ie an id # from another sql table that is in a column in the table that i want to show select data.

Just to clarify, so do you need the value or the data from the line with the specified value in another column?

I just want to show rows that have a specific variable numeric value in a certian column instead of all of the rows.

Here's a graphic example:


edit: epic! muh 666th post :D

I apologize, I thought a simple inner join would work, but I'm not sure now. I will see if I can dig something up.

figured it out, just had to use the mysql_fetch_assoc() function :D and WHERE in my query. lol whenever I do the most simplest code, it always takes me a while to fix up, but this took me 5 minutes to figure out :D