Hello!
I been trying to figure how first read a Google docs CSV (live) to be shown as a custom HTML.
The CSV have 50 lines and each line have 15 cells.
With a bit searching i figure out to this :
<?PHP
$file_handle = fopen("https://docs.google.com/spreadsheet/pub?key=0Aus5xZRHSuhydGpmcXBRN0Z2WXM5Sks3TlgydF92R1E&single=true&gid=3&output=csv", "r");
while (!feof($file_handle) ) {
$line_of_text = fgetcsv($file_handle, 1024);
print "<custom code>" . $line_of_text[0] . $line_of_text[1]. $line_of_text[2] . $line_of_text[3] . $line_of_text[4] . $line_of_text[5] . $line_of_text[6] . $line_of_text[7] . $line_of_text[8] . $line_of_text[9] .$line_of_text[10] . $line_of_text[11] . $line_of_text[12] . $line_of_text[13] . $line_of_text[14] . $line_of_text[15] . "<br>";
}
fclose($file_handle);
?>
But what i would need is to view only the row that have the value "(T01S)" in the first cell "A2" or first "$line_of_text[0]" and the header (first line).
I was thinking about just to show a "desired_line" would not help me as if i add a line in the middle many pages would show the wrong line.
Also is it any easy way to show one full line except the first cell? So i can have a custom code on that field? And also so i do not need every pages code if i add more fields?
After many hours of searching i would be very happy for any kind of help!