# My first MYSQL usage!

**URL:** <https://forum.kirupa.com/t/my-first-mysql-usage/183096>\
**Category:** random\
**Created:** [March 23, 2006, 7:36pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096 "2006-03-23T19:36:04Z")\
**Posts on this page:** 18\
**Page:** 1

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [March 23, 2006, 7:36pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/1 "2006-03-23T19:36:04Z")

</div>

i dunno were else to put it 😑 so i put it in random 🙂

Ok i have been wondering how to use flash and im sure everyone knows my just plain "STUPID:h: " but alough im a time wasting idiot “I confess” i have succsesfully made a cool MYSQL login and create new user page!. I hope to use this later on in web design life.

steps

1. put anything you want into the login area and click login. Invalid or incorrect username and pass.
2. copy and paste the username and pass from login area to the account creation area click create.
3. try loggin in again YaAHOO it works.

If you have problems with this email me ([EMAIL](mailto:support@pencaderweb.co.uk)), i dont mind if you say “TOO BASIC!!!” because this is just a tester and later on i will be making a bussiness opr anything that springs to mind using login with MYSQL

good thing is - INSTANT ACCESS NO ACTIVATION EMAILS!!

---

<div class="post-metadata">

**Author:** ![eilsoe](https://avatars.discourse-cdn.com/v4/letter/e/9fc348/32.png) [@eilsoe](https://forum.kirupa.com/u/eilsoe)\
**Post date:** [March 23, 2006, 7:37pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/2 "2006-03-23T19:37:56Z")

</div>

a link?

---

<div class="post-metadata">

**Author:** ![Templarian](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/templarian/32/7152_2.png) [@Templarian](https://forum.kirupa.com/u/Templarian)\
**Post date:** [March 23, 2006, 7:40pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/3 "2006-03-23T19:40:21Z")

</div>

link (and yes this is very basic lawls).

---

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [March 23, 2006, 7:42pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/4 "2006-03-23T19:42:41Z")

</div>

soz [www.pencaderweb.co.uk/MYSQL/index.php](http://www.pencaderweb.co.uk/MYSQL/index.php)

The forum didnt work just them for me

---

<div class="post-metadata">

**Author:** ![Templarian](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/templarian/32/7152_2.png) [@Templarian](https://forum.kirupa.com/u/Templarian)\
**Post date:** [March 23, 2006, 7:46pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/5 "2006-03-23T19:46:26Z")

</div>

You can create a username thats already in the table. Might want to fix that.

---

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [March 23, 2006, 7:48pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/6 "2006-03-23T19:48:21Z")

</div>

ok ill try and fix it if i had the brain to lol.

---

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [March 23, 2006, 8:27pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/7 "2006-03-23T20:27:35Z")

</div>

> [@Templarian](#):
>
> You can create a username thats already in the table. Might want to fix that.

Anyone know a code to do what Templarian is wanting me to fix???:sen:

---

<div class="post-metadata">

**Author:** ![Seb\_Hughes](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Seb\_Hughes](https://forum.kirupa.com/u/Seb_Hughes)\
**Post date:** [March 23, 2006, 8:38pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/8 "2006-03-23T20:38:41Z")

</div>

> [@chris.jones071@](#):
>
> Anyone know a code to do what Templarian is wanting me to fix???:sen:

$checkusername = mysql\_query(“SELECT \* FROM users WHERE username = “"$\_POST[‘username’]"””);

if($checkusername \> 1) {  
echo “Username taken”;  
exit();  
} else {  
rest of sign up code in here  
}

---

<div class="post-metadata">

**Author:** ![eilsoe](https://avatars.discourse-cdn.com/v4/letter/e/9fc348/32.png) [@eilsoe](https://forum.kirupa.com/u/eilsoe)\
**Post date:** [March 24, 2006, 6:42am UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/9 "2006-03-24T06:42:03Z")

</div>

also might wanna star out the password input field… 😉

---

<div class="post-metadata">

**Author:** ![anon1712571](https://avatars.discourse-cdn.com/v4/letter/a/9dc877/32.png) [@anon1712571](https://forum.kirupa.com/u/anon1712571)\
**Post date:** [March 24, 2006, 7:03am UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/10 "2006-03-24T07:03:32Z")

</div>

the first tute i ever learnt and it was easy as heck- yet i still suck at php…

---

<div class="post-metadata">

**Author:** ![Seb\_Hughes](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Seb\_Hughes](https://forum.kirupa.com/u/Seb_Hughes)\
**Post date:** [March 24, 2006, 4:00pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/11 "2006-03-24T16:00:49Z")

</div>

> [@darkmotion](#):
>
> the first tute i ever learnt and it was easy as heck- yet i still suck at php…

:lol:, ill try and help ya lol. I might start on a new guets book for ya

---

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [March 24, 2006, 4:50pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/12 "2006-03-24T16:50:15Z")

</div>

Ok i read your posts and i will do the following -

1. Star The Input Of The Password Field  
2.Try and fix the Username problem 🙂

@SEB

$checkusername = mysql\_query(“SELECT \* FROM users WHERE username = “”$\_POST[‘username’]”"");

if($checkusername \> 1) {  
echo “Username taken”;  
exit();  
} else {  
rest of sign up code in here  
}

What do you mean “rest of sign up code here”?

---

<div class="post-metadata">

**Author:** ![Seb\_Hughes](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Seb\_Hughes](https://forum.kirupa.com/u/Seb_Hughes)\
**Post date:** [March 24, 2006, 6:22pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/13 "2006-03-24T18:22:17Z")

</div>

> [@chris.jones071@](#):
>
> Ok i read your posts and i will do the following -
> 
> 1. Star The Input Of The Password Field  
> 2.Try and fix the Username problem 🙂
> 
> @SEB
> 
> $checkusername = mysql\_query(“SELECT \* FROM users WHERE username = “"$\_POST[‘username’]"””);
> 
> if($checkusername \> 1) {  
> echo “Username taken”;  
> exit();  
> } else {  
> rest of sign up code in here  
> }
> 
> What do you mean “rest of sign up code here”?

Its self explanatory

---

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [March 24, 2006, 7:54pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/14 "2006-03-24T19:54:40Z")

</div>

Ok sorry seb and thanks its fixed now View it here [http://www.pencaderweb.co.uk/MYSQL/V1/index.php](http://www.pencaderweb.co.uk/MYSQL/V1/index.php)

---

<div class="post-metadata">

**Author:** ![nightshade](https://avatars.discourse-cdn.com/v4/letter/n/41988e/32.png) [@nightshade](https://forum.kirupa.com/u/nightshade)\
**Post date:** [March 24, 2006, 8:01pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/15 "2006-03-24T20:01:18Z")

</div>

Congrats!.. _sigh_ i remember my first PHP/MySQL login script. Back at school…my ICT teacher was well impressed! lol he was useless… (skills: basic knowledge of HTML etc…)

---

<div class="post-metadata">

**Author:** ![Templarian](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/templarian/32/7152_2.png) [@Templarian](https://forum.kirupa.com/u/Templarian)\
**Post date:** [March 24, 2006, 8:01pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/16 "2006-03-24T20:01:27Z")

</div>

nice work.

---

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [March 24, 2006, 8:10pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/17 "2006-03-24T20:10:44Z")

</div>

thanks im very happy i figured out how to that lol as the welsh would say

"Well Chuffed:smirk: "

---

<div class="post-metadata">

**Author:** ![chrisclick](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/chrisclick/32/1991_2.png) [@chrisclick](https://forum.kirupa.com/u/chrisclick)\
**Post date:** [March 24, 2006, 9:07pm UTC](https://forum.kirupa.com/t/my-first-mysql-usage/183096/18 "2006-03-24T21:07:29Z")

</div>

ok, i have updated it a lil bit and now it shows the last user to create an account and shows amount of records the data base has :nerd: