Mod_Rewrite(username)

[whitewingz]

hi guyz how can i work on this in url?
example

http://whitewingz.com/user.php?id=1

into mod rewrite

uhttp://whitewingzsite.com/whitewingz
anyone know how to work on this?

thanks to who want to help me :D

Edited:
Sorry hehe

[subzero]

you can tell it to be that

[whitewingz]

it's ok now<-(what i mean here is the question above is ok becuase you dont understand before because of that link that i use example.com so i change it so you can see the real question).. sorry hehe :D

[subzero]

you still need help ??

Use any rewrite here then get the script to know it first

[whitewingz]

yes i still need help..
i try this but it seems not work it say not found

RewriteRule ^([^/.]+)$ /user.php?who=$1

i try to search my name whitewingz.com/whitewingz

user does not exist..

but when i try whitewingz.com/1

it works..

but i want to be mod rewrite is name?

it's lavalair script..

[subzero]

order by id

you will need to use abc like getting username from id

[i0nutzxp]

user.php?who=whitewingz means that in ur query's u must put :

$x = mysql_fetch_assoc(mysql_query("SELECT `bla`, `bla` FROM `users` WHERE name='".mysql_real_escape_string($_POST['who'])."'"));
not
$x = mysql_fetch_assoc(mysql_query("SELECT `bla`, `bla` FROM `users` WHERE id='".((int)$_POST['who'])."'"));

[whitewingz]

user.php?who=whitewingz means that in ur query's u must put :

$x = mysql_fetch_assoc(mysql_query("SELECT `bla`, `bla` FROM `users` WHERE name='".mysql_real_escape_string($_POST['who'])."'"));
not
$x = mysql_fetch_assoc(mysql_query("SELECT `bla`, `bla` FROM `users` WHERE id='".mysql_real_escape_string($_POST['who'])."'"));

i try it.. thanks..

[pichiriche]

$name = $_POST['name'];

$ok = mysql_fetch_assoc(mysql_query("SELECT id FROM blabla_users WHERE name='".mysql_real_escape_string($name).'""));

$who = $ok[0];

simple...