Data display problem

[Danni]

Having a problem getting this data to display, help please 🙁

 <?php 

if (!eregi("modules.php", $_SERVER['PHP_SELF'])) { 
    die ("You can't access this file directly..."); 
} //end if

require_once("mainfile.php"); 
$module_name = basename(dirname(__FILE__)); 
get_lang($module_name); 

include("modules/$module_name/functions.php");

function main()
    {     

	echo"<br>";
		 OpenTable();
         userCheck();
		 CloseTable();

           echo"<br>";
	 OpenTable();
     confirmNewUser();
	 CloseTable();

echo"<br>";
	 OpenTable();
     finishNewUser();
	 CloseTable();

            echo"<br>";
	 OpenTable();
     activate();
	 CloseTable();

             echo"<br>";
	 OpenTable();
     new_user();
	 CloseTable();

 } 
   include("header.php");
   OpenTable();
   echo"<BR>";
$sql = "SELECT number, email, username FROM 5050";
$result = $db->sql_query($sql);
$number = $row["number"];
$username = $row["username"];
$email = $row["email"];
         print "$number, $emal, $username\n";
         print "</dt></p>";
   CloseTable();
   include("footer.php");   

?>

🙁

[sivasankari_kv]

Your code

$result = $db->sql_query($sql);
$number = $row["number"];

You havent fetched the result set into the row variable

The code be like this

$result = $db->sql_query ( $sql );

if ( mysql_num_rows ( $result ) == 0 )
{
print "No Details Found";
exit ();
}
while ( $row = mysql_fetch_array ( $result ) )
{
$number = $row["number"];
print $number;

}

[Danni]

Ok I tried that and now everything is working great .... except there is only one data row in the design table and when a new entry is added rather then it adding a new row to the design table it replaces it with the most recent entry🙁 🙁

<?
		$sql  = " SELECT number, email, username FROM draw";


	$result = mysql_query($sql, $cid);

    if ( mysql_num_rows ( $result ) == 0 ) 
    { 
    print "No Details Found"; 
    exit (); 
    } 
    while ( $row = mysql_fetch_array ( $result ) ) 
    { 
    $number = $row["number"];
	$email = $row["email"];
	$username = $row["username"];
	}

    print "<p><b>Entries to date:</b></p>\n";

print "<table border=\"1\">";
print "<tr>";
print "<td>NUMBER</td>";
print "<td>EMAIL</td>";
print "<td>USERNAME</td>";
print "</tr>";
print "<tr>";
print "<td>$number</td>";
print "<td>$email</td>";
print "<td>$username</td>";
print "</tr>";
print "</table>";
?>

🙁 🙁

[sivasankari_kv]

Can you give me the table structure and the insert query you are using to insert the data row

[Danni]

Table name is "draw"

draw>number
draw>email
draw>username

Ok this is my form...

<?

if ($_SERVER['REQUEST_METHOD'] == "POST") 
{

    $number = addslashes($_POST["number"]);
	$email = addslashes($_POST["email"]);
	$username = addslashes($_POST["username"]);


	$sql  = " INSERT INTO draw ";
	$sql .= " (number, email, username) VALUES ";
	$sql .= " ('$number', '$email','$username') ";


	$result = mysql_query($sql, $cid);


	if (mysql_error()) { print "Database ERROR: " . mysql_error(); }

	print "<p><b>new entry added</b></p>\n";

}

?>

<form name="fa" action="insert.php" method="POST">     
<table>                                                                                                        
<tr><td><b>Number: </b> </td><td><input type="text" name="number" size=40></td></tr> 
<tr><td><b>Email:</b> </td><td><input type="text" name="email" size=40></td></tr> 
<tr><td><b>User Name: </b> </td><td><input type="text" name="username" size=40></td></tr> 
<tr><th colspan=2><p><input type="submit" value="Submit"></p></th></tr> 
</table>
</form>                                      

[sivasankari_kv]

Your Query seems fine , do u have any update functionality implemeneted in your form .

Try to give some debus statements inbetween specially before u insert and after you insert .