SOLVED Problem with ABCDEF... links

Haggen · April 12, 2006

Hi, i have this agenda script and i need to add the "ABCDEFG..." on each listing...

I have this code:

[code]<? include ("admin/config.php"); ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 <title><? echo "$page_title"; ?></title>
 <LINK REL="stylesheet" TYPE="text/css" href="css.css">
</head>
<body leftmargin="8" rightmargin="8" bottommargin="8" bgcolor="#FFFFFF" >
<table border="0" width="92%" height="100%" cellpadding="0" cellspacing="0" align="center">
<? include ("includes/main_header.php"); ?></td>
<tr>
 <td width="14%" valign="top" align="center" bgcolor="357A54">
 <? include ("includes/main_nav.php"); ?>

 </td>
 <td valign="top" bgcolor="#FFFFFF"> 
 <table border="0" width="98%" height="100%" cellspacing="1" cellpadding="2" align="center">
 <tr><td height="40" colspan="7" class="titulos">Directorio de Empleados <div style="text-align:right;" class="base">[ <a href="listar_todos_empleados.php">Mostrar Todos</a> ]</div></td></tr>

 <tr align="center" height="1">
 <td width="45%" class="row1">Nombre</td>
 <td width="15%" class="row1">Telefono</td>
 <td width="20%" class="row1">Celular</td>
 <td width="20%" class="row1">Departamento</td>
 </tr>
 <?
echo '
<a href=listar_empleados.php?letra=numerico>0-9</a> | 
<a href=listar_empleados.php?letra=a>A</a> | 
<a href=listar_empleados.php?letra=b>B</a> | 
<a href=listar_empleados.php?letra=c>C</a> | 
<a href=listar_empleados.php?letra=d>D</a> | 
<a href=listar_empleados.php?letra=e>E</a> | 
<a href=listar_empleados.php?letra=f>F</a> | 
<a href=listar_empleados.php?letra=g>G</a> | 
<a href=listar_empleados.php?letra=h>H</a> | 
<a href=listar_empleados.php?letra=i>I</a> | 
<a href=listar_empleados.php?letra=j>J</a> | 
<a href=listar_empleados.php?letra=k>K</a> | 
<a href=listar_empleados.php?letra=l>L</a> | 
<a href=listar_empleados.php?letra=m>M</a> | 
<a href=listar_empleados.php?letra=n>N</a> | 
<a href=listar_empleados.php?letra=o>O</a> | 
<a href=listar_empleados.php?letra=p>P</a> | 
<a href=listar_empleados.php?letra=q>Q</a> | 
<a href=listar_empleados.php?letra=r>R</a> | 
<a href=listar_empleados.php?letra=s>S</a> | 
<a href=listar_empleados.php?letra=t>T</a> | 
<a href=listar_empleados.php?letra=u>U</a> | 
<a href=listar_empleados.php?letra=v>V</a> | 
<a href=listar_empleados.php?letra=w>W</a> | 
<a href=listar_empleados.php?letra=x>X</a> | 
<a href=listar_empleados.php?letra=y>Y</a> | 
<a href=listar_empleados.php?letra=z>Z</a> | 
<a href=listar_empleados.php>Todos</a>
';

 $connection=mysql_connect("$hostname", "$username", "$password")
 or die("Could not establish connection");
 mysql_select_db($database_name, $connection)
 or die ("Could not select database");
 if (isset($_GET['np'])){
 $num_pages=$_GET['np'];
 } else {
 $query="SELECT COUNT(*) FROM empleados";
 $result=mysql_query($query);
 $row=mysql_fetch_array($result, MYSQL_NUM);
 $num_records=$row[0];
 if ($num_records > $display){
 $num_pages=ceil($num_records/$display);
 } else {
 $num_pages=1;
 }
 }
 if (isset($_GET['letra'])) {
 if ($_GET['letra'] == 'numerico')
 $sort = "AND SUBSTRING(nombre, 1, 1) IN ('.','#','0','1','2','3','4','5','6','7','8','9')";
 elseif (strpos('abcdefghijklmnopqrstuvwxyz', strtolower($_GET['letra'])) !== false)
 $sort = "AND nombre LIKE '" . $_GET['letra'] . "%'";
} else
 $sort = '';

 if (isset($_GET['s'])){
 $start=$_GET['s'];
 } else {
 $start=0;
 }


 $query="SELECT * FROM " . empleados . " ORDER BY nombre ASC LIMIT $start, $display";
 $result=mysql_query($query);
 while($row=mysql_fetch_array($result)){
 $bg=($bg=="$altrow_color1" ? "$altrow_color2" : "$altrow_color1");
 $etitle=$row[etitle];
 $alt_title=$row[alt_title];
 if ($alt_title == "N/D" and $etitle != "N/D")
 $alt_title='(<a href="show_anime.php?id=' . $row[id] . '" class="style1">' . $etitle . '*</a>)';
 elseif ($alt_title == "N/D" and $etitle == "N/D")
 $alt_title="";
 else
 $alt_title='(<a href="show_anime.php?id=' . $row[id] . '" class="style1">' . $row[alt_title] . '</a>)';
 echo '<tr height="1" bgcolor="' . $bg . '" onMouseOver="this.style.backgroundColor=\'' . $mouseover_color . '\';" onMouseOut="this.style.backgroundColor=\'' . $bg . '\';">
 <td class="lista">  <a href="mostrar_empleados.php?id=' . $row[id] . '" class="style1">' . $row[nombre] . ' ' . $row[apellido_paterno] . ' ' . $row[apellido_materno] . '</td>
 <td align="center" class="lista">' . $row[telefono] . '</td>
 <td align="center" class="lista">' . $row[celular] . '</td>
 <td align="center" class="lista">' . $row[depto] . '</td>
 </tr>';}



 mysql_close($connection);
 $connection=mysql_connect("$hostname", "$username", "$password")
 or die("Could not establish connection");
 mysql_select_db($database_name, $connection)
 or die ("Could not select database");
 $query = "select count( * ) as Total from empleados";
 $result = mysql_query($query);
 $row = mysql_fetch_assoc($result);
 $Totalempleados = $row['Total'];

echo " <div class=base align=center>Total de Empleados: $Totalempleados</div>\n";
?>
 <tr valign="top">
 <td colspan="7">
<div style="text-align:right;" class="base">[ <a href="listar_todos_empleados.php">Mostrar Todos</a> ]</div>
 <div style="text-align:center;">
 <?
 if ($num_pages > 1) {
 $current_page = ($start/$display) + 1;
 if ($current_page != 1) {
 echo '<a href="list_anime.php?s=' . ($start - $display) . '&np=' . $num_pages . '" class="style3">Anterior</a> ';}
 for ($i = 1; $i <= $num_pages; $i++) {
 if ($i != $current_page) {
 echo '<a href="list_anime.php?s=' . (($display * ($i - 1))) . '&np=' . $num_pages . '" class="style3">' . $i . '</a> ';
 } else {
 echo '';
 echo $i . ' ';}
 }
 if ($current_page != $num_pages) {
 echo '<a href="list_anime.php?s=' . ($start + $display) . '&np=' . $num_pages . '" class="style3">Siguiente</a>';}
 }
 ?>
 </div>
 </td>
 </tr>
 </table>
 </td>
</tr>
<? include ("includes/main_footer.php"); ?>
</table>
</body>
</html>[/code]

Im not sure what im doing wrong... Any help will be great!

jworisek · April 12, 2006

I hate to burst your bubble, but unless you tell us what is going wrong we don't know what is wrong either!

Barand · April 12, 2006

I do not have your database so I cannot run your script, so perhaps you would care to give me a clue about what to look for

a) what is it doing that it it shouldn't do?

b) what is it not doing that it should?

In other words, what is your problem other then "this script doesn't work"?

Haggen · April 13, 2006

Upps, sorry guys.. well, this code is suppost to have ABC links to select a letter and display the entries that start with the selected letter.

This code doesnt do anything at all :(, i clicked the letter and i keep seeing my whole list of entries.

Haggen · April 17, 2006

Any help please?

Barand · April 17, 2006

You need a query like

[code]$letra = $_GET['letra'];

$query = "SELECT * FROM empleados
               WHERE nombre LIKE '$letra%'
               ORDER BY nombre ASC
               LIMIT $start, $display";[/code]

I searched your code and cannot find the word "WHERE" .

Haggen · April 17, 2006

Thanks man... that was the problem... :D

Sign In

SOLVED Problem with ABCDEF... links

Recommended Posts

Haggen

Link to comment

Share on other sites

jworisek

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

Haggen

Link to comment

Share on other sites

Haggen

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

Haggen

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information

Sign In

**SOLVED** Problem with ABCDEF... links

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Archived

Important Information

SOLVED Problem with ABCDEF... links