WITH temp_table AS
(
	SELECT *, (ROW_NUMBER() OVER (ORDER BY field_name)) AS row FROM table_name 
)
 
SELECT * FROM temp_table

 
SELECT * FROM temp_table WHERE row BETWEEN 10 AND 15

< ?_php
$arr = file(“resource.txt”);
foreach ($arr as $key => $value) {
	$arr = split(“\t“,$value); // tab delimeted. You can use any.
	$$arr[0] = $arr[1];
}
	
//Example - "name" is a word in text tile with ‘tab’ delimeted sample text. 
echo $name;
?>

 
txt_title	hello world
txt_message	this is a message
name	Contact