On Sat, Feb 23, 2008 at 11:16 AM, Emiliano Boragina
<emiliano.boragina@xxxxxxxxx> wrote:
> Hi everyone
>
> I am beginner
>
> I have the following code:
>
>
>
> <?
>
> $buscar = $_REQUEST['buscar'];
>
> $base = "inscripcion";
>
> $conexion = mysql_connect ( 'localhost' , 'root' , 'root' );
>
> mysql_select_db ( $base , $conexion );
>
> echo "<table border='1'>";
>
> $resultado = mysql_query ("select * from alumnos where Curso like
> '$buscar'" , $conexion);
>
> while ( $registro = mysql_fetch_row ($resultado)) {
>
> echo "<tr>";
>
> foreach ( $registro as $clave ) {
>
> echo "<td>" . $clave . "</td>";
>
> }
>
> }
>
> echo "</tr></table>";
>
> ?>
>
> <form action="buscar.php" method="post">
>
> <input type="text" name="buscar"><br>
>
> <input type="submit" value="BUSCAR">
>
> </form>
>
>
>
> I want to add a message when find results on the DB: "Find n results", when
> don't find results: "0 results".
>
> How and where I must write the IF, and how I do for the n (number of
> results) appear.
>
>
>
> Thanks a lot!
>
> Nice weekend!
>
Just get the number from mysql_num_rows($resultado). It will return
the number of rows returned by the query and you can use it anywhere
as long as $resultado is a valid resource.
http://www.php.net/mysql_num_rows
Andrew
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
