*kenv

aight got it, so to resolve the problem of case insensitive on login i should make a query with LOWER() to get the unique user insteed of a "Fake use"?

i tryed and get no result when the lower was outside the substring so i think you meant this way "SELECT * FROM id_users WHERE substring(LOWER(`username`), 1, 1) = '$list' ORDER BY LOWER(username) ASC LIMIT $startIndex, $perPage" it works perfectly but is that a good way to do it whit case-sensitive? i mean, even if user have received an email containing their info

Yup ok so here's my query to get all members and i have done it to have a limit per page "SELECT * FROM id_users ORDER BY LOWER(username) ASC LIMIT $startIndex, $perPage" This method worked fine to get the full list(binary), but when it comes to show only users who have their name starting with A for exemple: heres the code "SELECT * FROM id_users WHERE substring(`username`, 1, 1) = '$list' ORDER BY LOWER(username) ASC LIMIT $startIndex, $perPage" It only shows those who have a capital "A" as the $_GET['list'] result is "A" and get only lower case if result is "a" ----------- Now when its not set to binary It let me login with ex: "Kenji_-" even if my real username is "kenji_-" so when i get to my profile it should show me the menu to edit my profile and such as im the auth user, but it shows me the menu for a visitor(add bud, send message, etc). Hope you can help me out on this one cause i dont know which one to use and how to fix the error of it. -----------

so why binary's there if latin1_swedish_ci is case sensitive? does it have its own purpose else then being case sensitive? also, when its not set to binary i can log with the username i got even if i change some letters to uppercase or lowercase :s

thanks, ive been workin on something with your method and worked perfectly. Now i got a simple question but dont know why it does that and i dont know how can it be resolved. On the page where i can see the members who are registered to the site, they are in order from A to Z but the thing is, that they select and post user who have a capital letter at the beggining of their name and print after all others who doesnt. like the exemple below: AVERY Dan Ninjit SteadyCactus // then lowercase db_ g-enius kiwi thanks again for the tips.

isnt it possible to do that with cookies? and if yes... how can i do that?

its even worst... im still lost and its dark oh thats my glasses !!! Seriously im not into it, im just trying to learn this huge language... so i guess this is new for me any ressource would be a good help

Alright, so ive been trying for few hours now to bring something to my custom build forum. I really dont know how its called but it shows user when theres new post in a topic etc. So i've made a table for each user who are "authenticate" and not only registered to the site. My connection with the create table for each user <?php $host = "localhost"; $user = "username"; $pass = "password"; $data = "database"; $conn = mysql_connect($host, $user, $pass) or die(mysql_error()); mysql_select_db($data, $conn) or die(mysql_error()); $sql9 = "SELECT * FROM id_users WHERE `user_activation` = '1'"; $rs9 = mysql_query($sql9, $conn) or die(mysql_error()); $numofrows9 = mysql_num_rows($rs9); while($row9 = mysql_fetch_array($rs9)){ mysql_query("CREATE TABLE IF NOT EXISTS `id_userforum_".$row9['username']."` ( `userforum_id` int(11) NOT NULL auto_increment, `userforum_viewed` varchar(255) NOT NULL default '0', `userforum_parentid` varchar(255) NOT NULL default '', PRIMARY KEY (`userforum_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5"); The above part work fine as i can see all table for each user in the database This part is where nothin happen. seems like theres nothing there. No rows insert, or updated $userforum = "SELECT * FROM `id_userforum_".$row9['username']."` WHERE `userforum_parentid` = '".$id."'"; $userresult = mysql_query($userforum) OR die(mysql_error()); if (mysql_num_rows($userresult) >= 1) { list($mytotal) = mysql_fetch_array($userresult); if ($mytotal != 0) { mysql_query("UPDATE `id_userforum_".$row9['username']."` SET `userforum_viewed`='0' WHERE `userforum_parentid`='$id' LIMIT 1") or die('Cannot update row!'); } else { mysql_query("INSERT INTO id_userforum_".$row9['username']."(userforum_viewed,userforum_parentid) values('0', '$id')") or die('Cannot insert row!'); } } } ?> Does anyone see what i might did wrong or have any other way to do it

edited my post and also i tryed to login as admin but says there was a field blank. So im wondering, what should have been a secure login and how could i make it work so eacxh time you press login, it login and not just return you to the home page till you finaly get logged in after multiple times tryin.

Alright, so i got a login script done since quite a while now and i have trouble with it, seems like sometimes the user/pass isnt sent and just get you back to the main page like it should do but without being logged in. So heres the code, if someone can help me out on this... <?php if (isset($_GET['sec'])) { if ($_GET['sec'] == 'logout') { setcookie("username",'',time()-(60*60*24*365), "/" ); } } //if session ID matches IP address if ( $_SESSION['ip'] != $_SERVER['REMOTE_ADDR']) { session_regenerate_id(); $_SESSION = array(); } //if not logged in if ( !isset($_SESSION['username']) ) { //not logged in and is attempting to if ($_POST['Register']) { header("Location: index.php?register=1"); } if ($_POST['Login']) { $user = ($_POST['username']); $pass = ($_POST['password']); $ip = ($_POST['ip']); if (!$user | !$pass) { echo ''; } else { $pass = md5($pass); $query = "SELECT * FROM `id_users` WHERE username = '$user' AND password = '$pass' AND user_activation = '1' LIMIT 1"; $query = mysql_query($query); if (mysql_num_rows($query) == 1) { $_SESSION['username'] = $user; mysql_query("UPDATE `id_users` SET `user_session` = 1, `user_ip` = '{$_SERVER['REMOTE_ADDR']}' WHERE `username` = '{$_SESSION['username']}'"); $_SESSION['ip'] = $_SERVER['REMOTE_ADDR']; while ($row = mysql_fetch_assoc($query)) { $_SESSION['user_level_id'] = $row['user_level_id']; } /* setcookie("username", $_SESSION['username'], mktime()+(86400*30*90), "/"); setcookie("lastsave", time(), mktime()+(86400*30*90), "/"); */ header("Location: index.php"); } elseif($row['user_activation'] == '') { print''; } else { print ''; } } } else { print ''; } //already logged in } elseif (($_SESSION['user_level_id']) == '1' && $row['user_activation'] == '1') { print ''; if (isset ($_POST['logout']) ) { session_destroy(); setcookie("username",'',time()-(60*60*24*365) , "/" ); } if (isset ($_POST['admin_panel']) ) { header("Location: index.php?sec=admin"); } } elseif(($_SESSION['user_level_id']) >= 2) { print''; if (isset ($_POST['logout']) ) { session_destroy(); setcookie("username",'',time()-(60*60*24*365) , "/" ); } print_r($_COOKIE); } ?>

Well, the second would be the besst of the 2 site but i have to say that i didnt really saw improvement in your graphics skills.

the real question would be, do you have some php in your website coding...

well, sometimes when im tired to see the same wallpaper... i open photoshop and create something till i like the result then set it on

Both are real sport but they play it differently, but yeah... canada still made the hockey and football... i mean Ice Hockey and american football

i can see that people still use that explorer browser(No offence)

look to my site(signature) and tell me if its the kind of iframe you are looking for

1) Photoshop 2) Dreamweaver 3) Firefox 4) iTune (Always running when im on my pc) 5) -------------------- Thats it

Damn... im so old school... lol

You dont have a value for each of your date option. <select name="month" id="month"> <option selected="selected">1</option> <?php for($i=2; $i<=12;$i++){ echo" <option>".$i."</option>"; } echo"</select>"; ?> // Change it to <select name="month" id="month"> <option selected="selected" value="1">1</option> <?php for($i=2; $i<=12;$i++){ echo" <option value='$i'>".$i."</option>"; } echo"</select>"; ?>

php for noob is a great one

so as i can see, you need at least 2tables in your database, if you got a user registering system youll need an extra one to hold all users name/info etc. So exemple, you have few news(First table: RexiRex_News), then you have the table that hold all comments(Second Table: RexiRex_News_Comments) and like i said, you can have a 3rd one for user(3rd Table: RexiRex_Users) Now, when you post a news, it create a "id"(it will create an id to each news so they are unique) in your comments table you'll need a "parentid" column that will tell to php when you are on the news that have the id 7 to get all comments where parentid = 7 and when posting a comment, you have to create something like that so the page is: www.yourdomain.com/index.php?page=news&id=7 $id = $_GET['id']; // When submiting the comment $insertpost="INSERT INTO RexiRex_News_Comments(comment_author,comment_content,comment_date,comment_parentid) values('$name','$yourpost','$displaytime','$id')"; Hope it can help you in your project.

i would suggest you to not offer monthly payment... unless if you want these client to pay a small amount compared to the final price then get the site and go away. most of designer will use these type of payment paypal/credit card

as ive read about copyright last year, you dont have to pay and register for copyright as any artwork is automaticaly copyrighted to the creator from the date of its final release. Still if you get ripped or anyother reason that will involve pursuits again someone related to one or mutiple of your artwork, you'll need to pay and register for copyright. Also your works are still copyrighted for 75years after your death. There a lot of country that use the same law for artist copyright so just make a small research on the web for copyright law in your country to have the details.

Welcome to WDF Keane and enjoy your stay

Welcome to WDF Edward and enjoy your stay