My database name is registros
My table name is ingreso
The var for mail is called correo in my program
I tried that but is not working for me, if you guys can help me to find the mistake I would appreciate it
Code: Select all
<html>
<body bgcolor="black">
<b>
<head><title>Administrador</title></head>
<h1 align="center" class="Estilo1"><font face="bell mt cursiva" color="darkred" size="12">
<font face="bell mt cursiva" color="darkred" size="12"> <marquee bgcolor="black">Usuarios registrados en la base de datos</marquee></font>
<center><img src="iupsm.jpg" style="border:15px solid#333300" width="397" height="268"></center>
<?php
$conexion=mysql_pconnect("localhost","root","");
if(!$conexion){
echo "No Se Pudo Conectar";
exit;
}
mysql_select_db("registros");
echo '<h2>Usuarios registrados:</h2>';
$sql = "SELECT correo FROM ingreso";
// run the query. Will return a resource or false
$result = mysql_query($sql);
// if it ran OK
if ($result) {
// while I have more results, loop through them
// returning each result as an array
while ($user = mysql_fetch_array($result)) {
// use the array keys (column names) to output the data
echo $ingreso['correo'], '<br />';
}
}