PHP - Need Help - Mysql / Php Insert Rows Problem

Hey guys for some reason this code is not working i can't see a problem myself could someone please have a look and point the issue out to me. what i mean by it not working is it won't insert into the database or show a mysql_error.

thanks in advance

Code: [Select]
$guestip = $_SERVER['REMOTE_ADDR'];
$time = date('G:i');
$date = date("y-m-d");

$query = mysql_query("SELECT * FROM IP_Address") or die(mysql_error());
while($row = mysql_fetch_assoc($query)){
   
    if($guestip != $row['ip']){
        //insert into db.
        mysql_query("INSERT INTO IP_Address(id, ip, date, time) VALUES(NULL,'$questip','$date','$time')") or die(mysql_error());
        echo "inserted in to database"; echo mysql_error();
    }else{
        // add hit count and update time and date.
        echo "already in db";
    }
}

I have problem with this code. It does absolutely nothing. When INSERT is over it should redirect to index.php but it does nothing. There is no error, when the submit is clicked the page just refresh itself and because of echo function it write all the values. What seems to be the problem (I going slightly mad )

Code: [Select]
<?php require_once("public/includes/session.php"); ?>
<?php require_once("public/includes/connection.php"); ?>
<?php require_once("public/includes/functions.php"); ?>
<?php include_once("public/includes/form_functions.php");
   include_once("public/includes/header.php");


if (isset($_POST['submit'])) { // Form has been submitted.
$errors = array();


$required_fields = array('nik', 'lozinka', 'ime', 'prezime', 'adresa', 'grad', 'postanskiBroj', 'fiskni', 'moblini', 'email');
$errors = array_merge($errors, check_required_fields($required_fields, $_POST));
$username = trim(mysql_prep($_POST['nik']));
$password = trim(mysql_prep($_POST['lozinka']));
$hashed_password = sha1($password);
$ime = trim(mysql_prep($_POST['ime']));
$prezime = trim(mysql_prep($_POST['prezime']));
$adresa = trim(mysql_prep($_POST['adresa']));
$grad = trim(mysql_prep($_POST['grad']));
$postanskiBroj = trim(mysql_prep($_POST['postanskiBroj']));
$fiskni = trim(mysql_prep($_POST['fiksni']));
$moblini = trim(mysql_prep($_POST['mobilni']));
$email = trim(mysql_prep($_POST['email']));

echo $username . $hashed_password . $ime . $prezime . $adresa . $grad . $postanskiBroj . $fiskni . $moblini . $email;

if ( empty($errors) ) {
$query = " INSERT INTO `gume`.`korisnik` (`id`, `korisnicko_ime`, `lozinka`, `ime`, `prezime`, `adresa`, `grad`, `postanskiBroj`, `fiksni_telefon`, `mobilni_telefon`, `email`)
  VALUES
  (NULL, '$username', '$hashed_password', '$ime', '$prezime', '$adresa', '$grad', '$postanskiBroj', '$fiskni, $moblini', '$email' )";
$result = mysql_query($query, $connection) or die(mysql_error);
if ($result) {
redirect_to("index.php");
} else {
$message = "The user could not be created.";
$message .= "<br />" . mysql_error();
}
} else {
if (count($errors) == 1) {
$message = "There was 1 error in the form.";
} else {
$message = "There were " . count($errors) . " errors in the form.";
}
}
} else { // Form has not been submitted.
$username = "";
$password = "";
}
?>

<div id="telo">
   <div id="kreiranjeNaloga">
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<script src="SpryAssets/SpryValidationPassword.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationConfirm.js" type="text/javascript"></script>
<link href="SpryAssets/SpryValidationPassword.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationConfirm.css" rel="stylesheet" type="text/css" />
<p>Polja sa * su obavezna</p>
<form action="new_user.php" method="post">
  <span id="sprytextfield1">
  <label>Korisnicko ime: </label>
  <input type="text" name="nik" id="nik"  size="40" value=""/>
  *<span class="textfieldMinCharsMsg">Korisnicko ime ne moze imati manje od 5 karaktera</span><span class="textfieldMaxCharsMsg">Korisnicko ime moze imati najvise 30 karaktera.</span></span><br />
  <span id="sprypassword1">
  <label>Lozinka:</label>
    <input type="password" name="lozinka" id="lozinka"  size="40" value=""/>
  *<span class="passwordMinCharsMsg">Sifra mora sadrzati najmanje 5 karaktera.</span><span class="passwordMaxCharsMsg">Sifra moze imati najvise 30 karaktera.</span></span>

  <br />
  <span id="spryconfirm1">
  <label>Potvrdite lozinku:</label>
    <input type="password" name="password1" id="password1" size="40" value=""/>
 
  <span class="confirmRequiredMsg">*</span>Obe lozinke moraju da budu iste.</span>
  <br />
  <span id="sprytextfield2">
  <label>Ime:</label>
    <input type="text" name="ime" id="ime" size="40" value=""/>
 
  *
  </span>
  <br />
  <span id="sprytextfield3">
  <label>Prezima</label>
    <input type="text" name="prezime" id="prezime"size="40" value="" />
  *</span>
  <br />
  <span id="sprytextfield4">
  <label>Adresa:</label>
    <input type="text" name="adresa" id="adresa" size="40" value=""/>
    *
 
  </span>
  <br />
  <span id="sprytextfield7">
  <label>Grad:</label>
    <input type="text" name="grad" id="grad" size="40" value="" />
    *
 
  </span> <br />
 
  </span><span id="sprytextfield9">
  <label>Postanski Broj: </label>
    <input type="text" name="postanskiBroj" id="postanskiBroj" size="10" value=""/>
    *
 
  <span class="textfieldInvalidFormatMsg">Postanski broj nije pravilno upisan.</span></span><br />
  <span id="sprytextfield5">
  <label>Broj fiksnog telefona: </label>
  <input type="text" name="fiksni" id="Broj fiksnog telefona" size="40" value="" />
  *<span class="textfieldInvalidFormatMsg">Broj telefona nije pravilno upisan</span></span>
  <br />
  <span id="sprytextfield6">
  <label>Broj mobilnog telefona: </label>
  <input type="text" name="mobilni" id="mobilni" size="40" value=""  />
 *<span class="textfieldInvalidFormatMsg">Broj telefona nije pravilno upisan</span></span><br />
  <span id="sprytextfield10">
  <label>Email:</label>
  <input type="text" name="email" id="email" size="40" value="" />
  *<span class="textfieldInvalidFormatMsg">Email adresa nija pravilno upisana.</span></span><br />
  <input name="submit" type="submit" id="submit" value="Kreiraj korisnika" />
</form>

  </div>
</div>
<?php include("public/includes/footer.php"); ?>

I have an old site written for PHP 5.4 and under and trying (very trying) to get it to work with PHP 7x without much luck. Due to all the changes in 7 my code is one big error message, but one thing at a time. I cannot get the follow code to work at all, even though it worked in PHP 5.

Error:

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'viewuser.php?u=666' id='member'>THE PREDATOR [666] was added to the hit' at line 1
The Query was INSERT INTO gangevents VALUES('','20', UNIX_TIMESTAMP(),'THE  PREDATOR [666] was added to the hit list.')

I have tried at least 20+ different ways of doing this but just can't get the right syntax to get it inserted into MySQL, the code below is just the latest version.  If I echo the a href line out, it works perfect. 

I am sure it is something ridiculously simple, but I have been 4 hours and counting on this now.

Thanks

gangevent_add_2($gangdata['gangID'], "<a href='viewuser.php?u=".$r['userid']."' ".$csscode[$r['userlevel']-1].">".$r['username']."</a> [".$r['userid']."] was added to your hitlist");

function gangevent_add_2($gang, $text) { 
	global $db; $csscode; 
	$db->query("UPDATE users SET gangevent = gangevent + 1 WHERE gang={$gang}");
	$db->query("INSERT INTO gangevents VALUES('','$gang', UNIX_TIMESTAMP(),'$text')");
}

 

Code: [Select]
$date = date('m-d-y');
$ip = $_SERVER['REMOTE_ADDR'];

mysql_query("INSERT INTO users VALUES ($username, $password, 0, $ip, $date)") or die(mysql_error());

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.60.116, 03-06-11)' at line 1


I'm not sure why I get this error. :/

The code below kind of works, I don't get any errors. It has 2 problems; it only inserts the second row of data I get nothing for the first row. It also does not insert the 4id correctly I just get 1 instead of the actually user id number.

I'd appreciate some help, been trying to hack this out for a couple hours.


Code: [Select]
<?php
// Begin the script for this page
$id = $_SESSION['id'];
if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form

} else {
//Assign each array to a variable
$id = $_SESSION['id'];
$store = $_POST['store'];
$item = $_POST['item'];
$itemprice = $_POST['itemprice'];
$itemnumber = $_POST['itemnumber'];
$couponvalue = $_POST['couponvalue'];

$limit = count($id);

for($i=0;$i<$limit;$i++){
$id[$i] = $id[$i];
$store[$i] = check_input($store[$i]);
$item[$i] = check_input($item[$i]);
$itemprice[$i] = check_input($itemprice[$i]);
$itemnumber[$i] = check_input($itemnumber[$i]);
$couponvalue[$i] = check_input($couponvalue[$i]);
}

$query = "INSERT INTO `item` (user_id, store, item, itemprice, itemnumber, couponvalue) VALUES ('".$id[$i]."','".$store[$i]."', '".$item[$i]."', '".$itemprice[$i]."', '".$itemnumber[$i]."', '".$couponvalue[$i]."')";

if (!mysql_query($query,$link)){
die('Error: ' . mysql_error());
} else {
echo "$row record added";
}
}

?>
<div class="pageContent">
    <div id="main">
<div class="container">
<form action="" method="post">
<table>
<tr>
<input type="text" name="id[]" id="id[]" value="<?php echo $_SESSION['id'];?>" />
<td><DIV CLASS="p2"><center><b>Store</b></center></div>
<input type="text" name="store[]" id="store[]" size="15" maxlength="255"/></td>
<td><DIV CLASS="p2"><center><b>Item</b></center></div>
<input type="text" name="item[]" id="item[]" size="15" maxlength="255"/></td>
<td><DIV CLASS="p2"><center><b>Item Price</b></center></div>
<input type="text" name="itemprice[]" id="itemprice[]" size="15" maxlength="255"/></td>
<td><DIV CLASS="p2"><center><b>Item Number</b></center></div>
<input type="text" name="itemnumber[]" id="itemnumber[]" size="15" maxlength="255"/></td>
<td><DIV CLASS="p2"><center><b>Coupon Value</b></center></div>
<input type="text" name="couponvalue[]" id="couponvalue[]" size="15" maxlength="255"/></td>
</tr>
<tr>
<input type="text" name="id[]" id="id[]" value="<?php echo $_SESSION['id'];?>" />
<td><input type="text" name="store[]" id="store[]" size="15" maxlength="255"/></td>
<td><input type="text" name="item[]" id="item[]" size="15" maxlength="255"/></td>
<td><input type="text" name="itemprice[]" id="itemprice[]" size="15" maxlength="255"/></td>
<td><input type="text" name="itemnumber[]" id="itemnumber[]" size="15" maxlength="255"/></td>
<td><input type="text" name="couponvalue[]" id="couponvalue[]" size="15" maxlength="255"/></td>
</tr>
</table>
<input type="submit" name="submit" value="Submit Item">
</form>
</div>
</div>
</div>

Hi all,

I am managing a social network and am creating a script to allow the admin to private message all users on the site. Even setting the max execution time to unlimited within the file does not allow us to insert all 40,000 rows into the 'message' table, it stops after several thousand rows. Our hosts tell us setting this globally is a bad idea/unstable.

Does anyone have some advice on the best to do this? No email notifications need to be sent so it is purely allowing the script to run it's full course without stopping. I did consider a cron job but without emails doing in 'batches' seems a bit unecessary so I'm clearly missing something. ANy and all advice would be most welcome!

Richard

The information is drawn in from a table into a form that the user will click submit and all the rows will be inputted into the table with their username association.

With this form, its only inputting the last row and not all of them. 

You're help is much appreciated!

Here is the form in the PHP area:

while($row=mysql_fetch_array($get_items_sql)){
   
              $name  =$row['item'];
              $date = ($row['expiration_date']);
              $exp_date = date('M d Y', strtotime($row['expiration_date']));
                    $content .= "";
               $content .="<table width=\"450\" border=\"0\"><tr><td width=\"200\"><span class=\"anotherfont\"><input name=\"item[]\" type=\"hidden\" value=\"$name\" id=\"item[]\">$name</span></td><td width=\"200\"><span class=\"greenfont\"><input name=\"expiration_date[]\" type=\"hidden\" value=\"$date\" id=\"expiration_date[]\">$exp_date</span><input name=\"username[]\" type=\"hidden\" value=\"$username\" id=\"username[]\"/>
</td></tr><br /></table>";
    $content .= "\n";
            }
            $content .= "</ul>\n";


Then below is part of the HTML Form with $content referenced:

<form action="add_select.php?source_id=<?php echo $coupon_source ?>" method="post" enctype="multipart/form-data" name="add_new" id="add_new">
<?php echo $content ?>


<input name="SUBMIT" type="submit" value="submit" /></form><br />


Then here is the section from the "add_select.php" file from the form:

include('connect.php');

foreach($_POST['item'] as $row=>$item)
{
$Item_name=$item;
$expiration_date=$_POST['expiration_date'][$row];
$username=$_POST['username'][$row];
}

foreach($_POST['item'] as $row=>$item)
{
$Item_name=mysql_real_escape_string($item);
$expiration_date=mysql_real_escape_string($_POST['expiration_date'][$row]);
$username=mysql_real_escape_string($_POST['username'][$row]);
}


 
$sql2="INSERT INTO place (item, expiration_date, username) VALUES ('$Item_name', '$expiration_date', '$username')"; 



if (!mysql_query($sql2))

  {

  die('Error: ' . mysql_error());

  }else {
     
     
    header("location:insert_complete.php");
}
                 

Hi coders,     i have a js to add multiple input and its depend to a user how many input should he want to add. and my problem is, it work insert data in a first line of rows but the rest of rows are not save.   any idea, what should i add to make it work.    js

<script>
$(document).ready(function(){
  $('#add').click(function(){
   var inp = $('#box');
   var i = $('input').size() + 1;
      $('<div id="box' + i +'"><input type="text" id="name" class="name" name="code[]' + i +'" placeholder="Input '+i+'"/><img src="remove.png" width="32" height="32" border="0" align="top" class="add" id="remove" /> </div>').appendTo(inp);
				
i++;
});
$('body').on('click','#remove',function(){
$(this).parent('div').remove();
});
});
</script>

html

<div id="box">
<input name = "code[]" type="text" id="name" class="name" placeholder="Input 1">
<img src="add.png" width="32" height="32" border="0" align="top" class="add" id="add" />
</div>

php

$rf = $_POST['regform'];
$b = $_POST['branch'];
$d = $_POST['date'];
$c = $_POST['code'];
$u = $_POST['user'];
				
for($i = 0; $i<count($c); $i++)
  {
    $a_query = mysql_query("INSERT INTO code_number(ts_number,branch_id,yy,code,username) VALUES('$rf','$b','$d','$c[$i]','$u')");
  }		
  return $a_query;

So when I execute this it'll go for about 130k rows then give a 500 error. Any ideas how to avoid this and get it to complete?

Code: [Select]
$i=10000000;
while($i<=99999999)
  {
  $public = $i;
  $value = rand(10000000, 99999999); 
  mysql_query("INSERT INTO yummy_table (public, value) VALUES('$public', '$value' ) ") or die(mysql_error()); 
  $i++;
  }
echo "done";

Hi, I have an app that access a MySQL database via a php script.
I noticed that INSERT was returning error but the data was being recorded successfully.
I finally traced the problem to be related with the line 
echo $conn->affected_rows;   

For some reason when it is an SQL INSERT it returns -11 but as I said the INSERTS executes successfully.

The app requesting the service sends in sequence:

char* txtSQL[]={"INSERT INTO activity (mac,jd,date,time,area,type,value) VALUES ('a9c4952de6b4',2458454,'2018-12-01','10:22','Area0002','h',130)",
                            "INSERT INTO activity (mac,jd,date,time,area,type,value) VALUES ('a9c4952de6b4',2458454,'2018-12-01','10:22','Area0002','h',130)",
                            "INSERT INTO activity (mac,jd,date,time,area,type,value) VALUES ('a9c4952de6b4',2458454,'2018-12-01','10:22','Area0002','h',130)",
                            "INSERT INTO activity (mac,jd,date,time,area,type,value) VALUES ('a9c4952de6b4',2458454,'2018-12-01','10:22','Area0002','h',130)",
                            "UPDATE activity set value=333 where value=130",
                            "SELECT sum(value) from activity where mac='a9c4952de6b4'",
                            "DELETE from activity WHERE value=333"};

I set a monitor to check what was being returned and got:

query=INSERT INTO activity (mac,jd,date,time,area,type,value) VALUES ('a9c4952de6b4',2458454,'2018-12-01','10:22','Area0002','h',130)
HttpResponse:  -   httpResponseCode: -11
query=INSERT INTO activity (mac,jd,date,time,area,type,value) VALUES ('a9c4952de6b4',2458454,'2018-12-01','10:22','Area0002','h',130)
HttpResponse:  -   httpResponseCode: -11
query=INSERT INTO activity (mac,jd,date,time,area,type,value) VALUES ('a9c4952de6b4',2458454,'2018-12-01','10:22','Area0002','h',130)
HttpResponse:  -   httpResponseCode: -11
query=INSERT INTO activity (mac,jd,date,time,area,type,value) VALUES ('a9c4952de6b4',2458454,'2018-12-01','10:22','Area0002','h',130)
HttpResponse:  -   httpResponseCode: -11
query=UPDATE activity set value=333 where value=130
HttpResponse: 4 *   httpResponseCode: 201   -------------------------------------->As can be seem the INSERTS above returned error but worked OK
query=SELECT sum(value) from activity where mac='a9c4952de6b4'
HttpResponse: 1379 *   httpResponseCode: 200
query=DELETE from activity WHERE value=333
HttpResponse: 4 *   httpResponseCode: 201

The  PHP script do ing the job i s as be low :

<?php
include('connection.php');

//these are just in case setting headers forcing it to always expire 
header('Cache-Control: no-cache, must-revalidate');

error_log(print_r($_POST,TRUE));

if( isset($_POST['query']) && isset($_POST['key']) ){                                   //checks if the tag post is there and if its been a proper form post
  header('Content-type: application/x-www-form-urlencoded');
  if($_POST['key']==$SQLKEY){                                                           //validates the SQL key
    $query=urldecode($_POST['query']);
    if(get_magic_quotes_gpc()){     //check if the worthless pile of crap magic quotes is enabled and if it is, strip the slashes from the query
      $query=stripslashes($query);
    }
    $conn = new mysqli($DB_ADDRESS,$DB_USER,$DB_PASS,$DB_NAME);    //connect

    if($conn->connect_error){                                                           //checks connection
      header("HTTP/1.0 400 Bad Request");
      echo "ERROR Database Connection Failed: " . $conn->connect_error, E_USER_ERROR;   //reports a DB connection failure
    } else {

      $result=$conn->query($query);                                                     //runs the posted query                        

      if($result === false){
        header("HTTP/1.0 400 Bad Request");                                             //sends back a bad request error
        echo "Wrong SQL: " . $query . " Error: " . $conn->error, E_USER_ERROR;          //errors if the query is bad and spits the error back to the client
      } else {
        if (strlen(stristr($query,"SELECT"))>0) {                                       //tests if it's a SELECT statement
          $csv = '';                                                                                // bug fix Undefined variable: csv
          while ($fieldinfo = $result->fetch_field()) {
            $csv .= $fieldinfo->name.",";
          }
          $csv = rtrim($csv, ",")."\n";
//********************************          echo $csv;                                                                    //prints header row
          $csv = '';

          $result->data_seek(0);
          while($row = $result->fetch_assoc()){
            foreach ($row as $key => $value) {
              $csv .= $value.",";
            }
            $csv = rtrim($csv, ",");                                                 //."\n";
          }
          echo $csv;                                                                    //prints all data rows
        } else {
          header("HTTP/1.0 201 Rows");
          echo $conn->affected_rows;       //if the query is anything but a SELECT, it will return the number of affected rows (INSERT IS  RETURNING -11)
        }
      }
      $conn->close();                                          //closes the DB
    }
  } else {
     header("HTTP/1.0 400 Bad Request");
     echo "-Bad Request";                                       //reports if the secret key was bad
  }
} else {
        header("HTTP/1.0 400 Bad Request");
        echo "*Bad Request";
}
?>

Any help will be much appreciated.
Thanks

Paulo Borges

Can anyone tell me why this is not INSERTing? My array data is coming out just fine.. I've tried everything I can think of and cannot get anything to insert.. Ahhhh!

<?php
  $query = "SELECT RegionID, City FROM geo_cities WHERE RegionID='135'";
  $results = mysqli_query($cxn, $query);
  $row_cnt = mysqli_num_rows($results);
  echo $row_cnt . " Total Records in Query.<br /><br />";
  if (mysqli_num_rows($results)) {
      while ($row = mysqli_fetch_array($results)) {
          $insert_city_query = "INSERT INTO all_illinois SET state_id=$row[RegionID], city_name=$row[City] WHERE id = null" or mysqli_error();
          $insert = mysqli_query($cxn, $insert_city_query);
          if (!$insert) {
              echo "INSERT is NOT working!";
              exit();
          }
          
          echo $row['City'] . "<br />";
          
          echo "<pre>";
          echo print_r($row);
          echo "</pre>";
      }
      //while ($rows = mysqli_fetch_array($results))
      
      } //if (mysqli_num_rows($results))
      
      else {
          echo "No results to get!";
      }
?>

Here is my all_illinois INSERT table structu

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is my source table geo_cities structu

CREATE TABLE IF NOT EXISTS `1` (
  `CityId` varchar(255) NOT NULL,
  `CountryID` varchar(255) NOT NULL,
  `RegionID` varchar(255) NOT NULL,
  `City` varchar(255) NOT NULL,
  `Latitude` varchar(255) NOT NULL,
  `Longitude` varchar(255) NOT NULL,
  `TimeZone` varchar(255) NOT NULL,
  `DmaId` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

im wondering how to get php to read the latest row (instead of show them all) and when another one comes it replaces it once the page refreshes

Hello, I'm having a bit of a problem here, all help to this issues would be much appreciated

I am trying to use text boxes to insert numbers into the database based on what is inputed.
If I have a string, like this for example:
$variable = 09385493;

And I want to insert it into the database like this:
mysql_query("INSERT INTO integers(number)
VALUES ('$variable')");

When checking the integers table in my database, looking at the number field, the $variable that was inserted is outputted as
9385493

Notice the number zero was taken out of the front of the number. If the number is double 0's (009385493), both of those zero's would disappear, too.

Thanks

I'm trying to pull user referral data from my database. This is what I have so far.


<table cellpadding="0" cellspacing="0" style="border:1px #000000 solid;" width="68%">
<tr>
<td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
User
</b></font></td>
<td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
Email
</b></font></td>
<td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
Date
</b></font></td>
<td bgcolor="#eeeeee" style="padding:2px;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b>
Visits
</b></font></td>
</tr>


<?

$lole=$_COOKIE["usNick"];

$tabla = mysql_query("SELECT * FROM tb_users where username='$lole' ORDER BY id ASC"); 

while ($row = mysql_fetch_array($tabla)) { 




echo "<tr><td><font size=\"2\" face=\"verdana\">";

echo $row["username"];

echo "</font></td><td><font size=\"2\" face=\"verdana\">";

echo $row["email"];

echo "</font></td><td><font size=\"2\" face=\"verdana\">";

echo $row["joindate"];

echo "</font></td><td><font size=\"2\" face=\"verdana\">";

echo $row["visits"];

echo "</font></td></tr>";

}

echo "</table>";

?>




<script type="text/javascript">
initSortTable('myTable',Array('S','N','S','N','S'));
</script>



I just found out my user ID is missing from database..