Problem showing data

alfpalafox

I have a script that show data from a table that contains all the payments done by each student. And I want to show them one by one.

If the student with ID_NUMBER has 30 payments, I need to show them one by one.

Thanks in advance!!

tomhath

Your question isn't clear enough, any answer would be a guess of what you want.

Do you want an HTML table with 30 rows? Or thirty screens of data, displayed one screen at a time?

How is the data being selected from the database and displayed now?

Anon

HI,

Do you mean something like this?

$sql="SELECT payment FROM payment, student WHERE payment.ID_NUMBER=student.ID_NUMBER";
$r=mysql_query($sql);
if ($m=mysql_fetch_array($r)) {
do {
echo $m[payment]."<br>";
} while ($m=mysql_fetch_array($r);
} else {
//no payments for this student
}

This little piece of php code will show all the payments from one specific student one by one.

Joris

alfpalafox

Yes, it show me all the payments done, but how can I show them with a Next -- Previous link, this way I can see only one record one by one not all in one page.

Thanks for the code.

alfpalafox

I display them like this:

include ("conexion_bd.php");
$consulta = "select * from sistema.tab_pagos where num_cta = '$num_cta'";
$conectar = conexion();
// Abre
if(!$resultado = mysql_query($consulta, $conectar))
{
echo "<h2><font size=5 color=#00008b>Error</font>";
echo "<hr noshade>";
echo "<font size=3>";
echo "No fue posible realizar la consulta";
echo "</font>";
exit;
}
else
{
// Si existe algun resultado de la consulta de autentificacion
$regs = mysql_num_rows($resultado);
if($regs>0)
{
echo "";
echo "<title>Formulario de Ingreso de Datos</title>";
echo"<body background=ICUM.jpg bgproperties=fixed>";
echo"<h2><font size=5 color=#00008b>Modificacion de Datos Generales del Alumno</font></h2>";
echo"<p>";
echo"<hr>";
echo"</p>";
echo"<h2>Modifique los datos que sean necesarios</h2>";
// Procesa los resultados encontrados
while($fila = mysql_fetch_array($resultado, MYSQL_ASSOC))
{
echo"<form method=post action=modificar_pago.php>";
echo"<table>";
echo"<tr>";
echo"<td><b>Numero de cuenta</b></td>";
echo"<td><b>$fila[num_cta]</b></td>";
echo"</tr>";
echo"<tr>";
echo"<td><b>Tipo</b></td>";
echo"<td><input type=text size=20 name=tipo value=$fila[tipo]></td>";
echo"</tr>";
echo"<tr>";
echo"<td><b>Monto</b></td>";
echo"<td><input type=text size=20 name=monto value=$fila[monto]></td>";
echo"</tr>";
echo"<tr>";
echo"<td><b>Interes</b></td>";
echo"<td><input type=text size=20 name=interes value=$fila[interes]></td>";
echo"</tr>";
echo"<tr>";
echo"<td><b>Fecha</b></td>";
echo"<td><input type=text size=20 name=fecha value=$fila[fecha]></td>";
echo"</tr>";
echo"</table>";
echo"<br>";
echo"<input type=submit name=cambiar value=cambiar>";
echo"</form>";
echo"</body>";
echo"";
} // End while procesar resultados
} // End if autentificacion
else
{
// Si no existe resultado de la consulta de autentificacion
echo "<h2><font size=5 color=#00008b>Error en el sistema</font>";
echo "<hr noshade>";
echo "<font size=3>";
echo "No existe el alumno en la base de datos";
echo "</font>";
exit;
}
} // End else

And it shows me all records for one student, what I need to do is to display all the results for that student but one by one (Maybe with a NEXT - PREVIOUS option.

Thanks for everything.