Hi
THis is my link http://www.arcsolutions-india.com/gdocs/test.php
this is displaying data in a left - right format like the general
spreadsheet format..
but i would like to display the data like top to bottom
like i want data to be displayed in customised table format, where in in
one page
i get one student data...is there any kind of way i can code html tr and td
tags in between
to get the suitable format...
following is my code
<p>
<?php
$std= "I";
$div= "A";
//$std= $_REQUEST['std'];
//$div= $_REQUEST['div'];
if ($search > ''){ $search = $search;} else { $search = '';}
?>
<script type="text/javascript" src="http://www.google.com/jsapi";></script>
<script type="text/javascript">
google.load('visualization', '1', {packages: ['table']});
</script>
<script type="text/javascript">
var visualization;
function drawVisualization() {
var query = new google.visualization.Query(
'http://spreadsheets.google.com/tq?key=0Aks_7BF0ulsrdE5IMWxpU0p5VXd5cl9JS0dVWUxaTXc#gid=0');
query.setQuery('SELECT * where F = "<?php echo $std; ?>" and G = "<?php
echo $div; ?>" order by D asc label D "First Name", E "Last Name"');
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
visualization = new
google.visualization.Table(document.getElementById('table'));
visualization.draw(data, {legend: 'bottom'});
}
google.setOnLoadCallback(drawVisualization);
</script>
<div id="table"></div>
</div>
--------------------------------------------
pls advise
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
