necrotic — Wed, 08 May 2002 21:21:48 +0000

So.... something like:

<strong>
Table | Field(s) | Type        | Attributes | Null | Default | Extra</strong>
--------------------------------------------------------------------
users | user     | varchar(20) |            |  No  |         |      |
users | password | tinytext    |            |  No  |         |      |
--------------------------------------------------------------------

Peter J. Boettcher — Wed, 08 May 2002 20:52:50 +0000

Database structure means the design and layout of your database. This includes the names of your tables, the field names in those tables as well as the data types of those fields.

necrotic — Wed, 08 May 2002 20:50:19 +0000

It inserts both the Username and Password but only displays the Password... I didn't edit the Get script. What do you mean db structure? Like I said, I'm new to this.

Mark Hensler — Wed, 08 May 2002 06:34:04 +0000

Everything is getting inserted ok?
Just the password is being successfully retrieved?
Have you altered the get script?

Can you post the database structure?

necrotic — Tue, 07 May 2002 20:55:49 +0000

Now it inserts it into the database but doesn't display with the get script. It shows only the password. You can find both scripts here(insert) and here(get)

Mark Hensler — Tue, 07 May 2002 06:29:41 +0000

alright, that's progress..

Make sure that your connection info is correct (username, password, hostname, database name). I believe mySQL is case sensitive.

necrotic — Tue, 07 May 2002 00:03:35 +0000

Now I get the error:

<?php
QUERY ERROR: No Database Selected QUERY: INSERT INTO users (user,password) VALUES ('necrotic','darkone') 
?>

Mark Hensler — Mon, 06 May 2002 23:05:15 +0000

one thing.. you forgot a semicolon..

<?php
 echo $PHP_SELF<strong>;</strong>
?>

I don't see anything else wrong with it.

try testing $result and printing errors...

<?php
$result = mysql_query($sql);

if (!$result) {
    echo \"QUERY ERROR: \" . mysql_error() . \"\n\";
    echo \"QUERY: $sql\n\";
}
?>

necrotic — Mon, 06 May 2002 22:45:06 +0000

The insert script:

<?php
<html>
<body>

if ($submit) {
  // process form

  $db = mysql_connect(\"localhost\", \"USERNAME\", \"PASSWORD\");

  mysql_select_db(\"testdb\",$db);

  $sql = \"INSERT INTO users (user,password) VALUES ('$user','$password')\";

  $result = mysql_query($sql);

  echo \"Thank you! Information entered.\n\";

} else{
  // display form

  <form method=\"post\" action=\" echo $PHP_SELF\">

  Username:<input type=\"Text\" name=\"user\"><br>

  Password:<input type=\"Text\" name=\"password\"><br>

  <input type=\"Submit\" name=\"submit\" value=\"Register\">

  </form>

} // end if

</body>
</html>
?>

I checked the table before and it was empty, so I think it's the insert script.

Mark Hensler — Sun, 05 May 2002 06:13:52 +0000

The original printf() statement is ok. I don't see anything wrong with that script. Does it produce any errors?

Have you checked the mySQL DB to make sure that there is data inside the table?

Posting the insert script will help.