Is it possible to retrieve one cell of data from a MySQL database? I need to put the ID from one row of a table into a php variable so that I can recall the correct row later on for editing purposes. If you know how to do this please help me! I will post my code if you ask me to.
Jump to Post
Yes. Just select that one column name and use a WHERE clause to limit it to the one row you want:
SELECT column_name FROM table_name WHERE spme_column = 'some value'
All 7 Replies
We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.