Bonsoir Bob,
i can't make a link to the code because the site is on my computer but i have put the différents scénario and the code of my chronoconnectivity
I would want that the zone 3 is clikckable so that the Internet users visualize(display) the route(course)
1) if the third column of my table mysql(openrunner) content
<a href="http://www.openrunner.com/index.php?id=798577" /a>
Result (the "|" character séparate columns in result of chrnoconnectivity)
KMS | PARCOURS | OPENRUNNER
45 | La Brède Saint Selve Castres Portets Arbanats Virelade Podensac (par route du bas) Illats Saint Michel de Rieuffret Grenade Saint Morillon La Brède |
50 | La Brède Saint Selve Castres Portets Langoiran Cadillac Cérons Illats Saint Michel de Rieuffret Grenade Saint Morillon Le Reys La Brède |
2) if the third column content
http://www.openrunner.com/index.php?id=798577
Result
KMS | PARCOURS | OPENRUNNER
45 | La Brède Saint Selve Castres Portets Arbanats Virelade Podensac (par route du bas) Illats Saint Michel de Rieuffret Grenade Saint Morillon La Brède | http://www.openrunner.com/index.php?id=798577
this is the code for my chronoconnectivity (a copier/coller of your code with my variables)
WHERE SQL
<?php
$kilom = JRequest::getString('kilom', '', 'post');
if ( $kilom ) {
echo " WHERE `kms` = $kilom ";
}
?>
HEADER
<?php
// get the number of records returned
$db =& JFactory::getDBO();
global $count;
$count = $db->loadResult();
// add style & script snippets
$style = $script = "";
$style .= "
table.cf_listing {
margin-bottom: 12px;
}
";
$script .= "
$('clear').addEvent('click', function() {
$('kilom').value = '';
});
";
$doc =& JFactory::getDocument();
if ( $script ) {
$script = "window.addEvent('domready', function() { $script });";
$doc->addScriptDeclaration($script);
}
if ( $style) {
$doc->addStyleDeclaration($style);
}
// get the previous filter string
$kilom = JRequest::getString('kilom', '', 'post');
?>
<!-- display the filter box and buttons -->
<input type='text' name='kilom' id='kilom' value='<?php echo $kilom; ?>' /> <input type='submit' name='filter' id='filter' value='Quelle distance ?' /> <input type='button' name='clear' id='clear' value='Effacer le champs de selection' />
<!-- start the listing table -->
<table class='cf_listing'>
<?php
// check if there are any records returned
if ( !$count ) {
// no records - show the message
echo "<div>Désolé retour $count Cette distance est inconnue dans la base.</div>";
} else {
echo "<div>Nombre de résultats trouvés : $count</div>";
// some records, show the header & footer rows
?>
<thead>
<tr>
<th style='width:20px;'>KMS</th>
<th style='width:5px;'>|</th>
<th style='width:650px;'>PARCOURS</th>
<th style='width:5px;'>|</th>
<th style='width:300px;'>OPENRUNNER</th>
</tr>
</thead
<tfoot>
<tr>
<td colspan='5' style='background:green; height:5px;'></td>
</tr>
</tfoot>
<?php
}
?>
<tbody>
BODY
<tr><td>{kms}</td><td>|</td><td>{par}</td><td>|</td><td>{ope}</td></tr>
I have try this
<tr><td>{kms}</td><td>|</td><td>{par}</td><td>|</td><td><a href="{ope}" /a></td></tr>
the result is like 1)
FOOTER
</tbody>
</table>
<?php
// visualiser ou non la pagination selon le resultat
global $count;
if ( $count ) {
?>
{pagination}
<?php
}
?>
and i read the forum for the pagination problem
Very thank's to you
JL