SQLite Forum

Retrieving FIRST occurrence of a string in a column (SQLITE PHP)
Login
Hi I'm new to SQLITE and PHP and I'm trying to build a simple database.

How can I echo all the variables of a table that are under a specific column heading ("ColumnX")?

Next step, I would need to find the index of the PREVIOUS, the NEXT, the FIRST and the LAST occurrence of a specific unique string ("Hello")  in the column.

Cheers!