teammatt3 — Thu, 05 Jul 2007 00:31:19 +0000

I meant to do that

pr0gr4mm3r — Wed, 04 Jul 2007 15:59:39 +0000

Here is what teammatt3's code looks like -> http://scripts.pr0gr4mm3r.net/query_ex.php
Somebody didn't run it before posting . Change...

<?php
$username = $username . $x;
$sql = \"INSERT INTO tblName (username, password, city) VALUES('$username', '$password', '$city');\";
?>

...to...

<?php
$new_username = $username . $x;
$sql = \"INSERT INTO tblName (username, password, city) VALUES('$new_username', '$password', '$city');\";
?>

That will leave you with this.

If you want some more random data, you can try something like this.

You can copy any of these query outputs directly into phpMyAdmin's SQL window.

I also have a table of ~4000 records of sample user information if you want it.

teammatt3 — Wed, 04 Jul 2007 01:05:28 +0000

Do you have to use phpmyadmin to do it? You could write a simple PHP script that could do it for you.

<?php
mysql_connect('localhost', 'user_name', 'db_password');

mysql_select_db('db_name');

$password = 'aaaaaa';
$city     = 'NewYork';
$username = 'marble';

while($x < 1000)
{
    $username = $username . $x;
    $sql = \"INSERT INTO tblName (username, password, city) VALUES('$username', '$password', '$city');\";
    mysql_query($sql);
    $x++;
}
     
?>

I think that would do it. Just make sure your host allows you to do a bunch of queries . The username would be marble1, marble2 etc.