Connecting to database

[mitzi]

Hi Guys!

Was wondering if you could help me out. This is kinda a php, mysql and html help thread all in one! I'm doing a project, and I must connect my website to a mysql database. I have come up with this code, but it doesn't seem to be working at all, when I enter a password and username (I have populated the databases) it just seems to refresh the page. Maybe a pair of fresh eyes can help as i've been at this for 2 days now.

I have attached the login file and the connect file. For some reason the connect file wont' work if i I have headers and footers in. Any ideas??

Thanks in advance for any help, so grateful 🙂

[mitzi]

Okay, I've changed the following:

          <label for="username" class ="fixed_required">User Name *</label> <!--change #3-->
          <input type="text" id="username" name="username" />
       </p>
       <p>
	<label for="password" class ="fixed_required">Password *</label> <!--change #3-->
          <input type="password" id="password"  name="password"/>

and I had a few password and pass_words in there that weren't matching so I've changed those.

Now this is the error I'm getting (but at least I'm getting an error, give me a clue where to go!!!

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\webs\test\login.php on line 16

[Haddman]

You could make the connection into a function and then call for it in the login page.

[bradgrafelman]

That error message most likely means your query failed. Use [man]mysql_error/man when a query fails to see what MySQL has to say (also echo out the query itself so you can visually inspect it).