Pantho
-
Posts
3 -
Joined
-
Last visited
Never
Pantho's Achievements
Newbie (1/5)
0
Reputation
-
Forgive me but my knowledge on MySQL queries is not exactly grand. I have a database with around 10000 rows, but there are duplicates to some of these rows. Sometimes 1 or 2, sometimes 5 or 6 duplicates. My Top100 page looks a mess having 1 person take up 5 ranks, I need to remove duplicate values. Image to show what I mean: http://i50.tinypic.com/fkme5j.png
-
-edit Grrr this quote was supposed to be a modify, sorry ...
-
Been working on my website all day, finally got everything working apart from for some reason I can't use the main smf1_members memberName field the 3rd party application. So, would anyone care to quickly throw out there something along the lines off... Basically I want to search table: cashuser1 in colunm: uid for value $user_info['username'] If it does not exist, create $user_info['username'] Any chance of some quick help ? global $user_info; $cuser = $user_info['username']; if ($ccatch== ""){ mysql_query("INSERT INTO cashuser1 (uid) VALUES (".$cuser."' LIMIT 1" ); } -edit Thank you