Hey, am trying to make a query that shows me all the mails registered into my database.
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
<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 />';
}
}
php and mysql
Moderators: macek, egami, gesf
Re: php and mysql
Code: Select all
echo $ingreso['correo'], '<br />';should read
Code: Select all
echo $user['correo']. '<br />';Return to “mySQL & php coding”
Who is online
Users browsing this forum: No registered users and 3 guests