Re: [PHP] Write from form to DB

2005-08-03 Thread George B
Jay Blanchard wrote: [snip] Yeah I am using "root" which has all permissions [/snip] Are you sure? Did you specifically GRANT ALL to root? When you did, did you flush the permissions? BTW, using root is a Bad Idead[tm]. [/snip] Also, check the mysql error log Thanks for all the help guys. It

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] > Also, check the mysql error log Never mind guys! I got it working! [/snip] C an you tell us how you got it working in the event someone else needs to duplicate your efforts? [/snip] Can you tell us what the problem was so that it is available for the archive? -- PHP General Mailing List

Re: [PHP] Write from form to DB

2005-08-03 Thread John Nichel
George B wrote: It does not seem to be putting anything into the DB. Gives no errors, but I check PHP My Admin, and there is nothing in the users and passwords field. I think something isnt working hmmm Without seeing more of your code, we won't be able to tell for sure, but if I was a

Re[2]: [PHP] Write from form to DB

2005-08-03 Thread Richard Davey
Hello Jim, Wednesday, August 3, 2005, 7:43:15 PM, you wrote: >> You could do that. The reason that I don't is because of the mixing of >> quote types. JM> So, is that a "Really Bad Thing(tm)", or is it just bad form? If the JM> former, why? It's in no way a "Really Bad Thing", probably just a

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] Jay Blanchard wrote: > [snip] > Yeah I am using "root" which has all permissions > [/snip] > > Are you sure? Did you specifically GRANT ALL to root? When you did, did > you flush the permissions? BTW, using root is a Bad Idead[tm]. > [/snip] > > Also, check the mysql error log Never mind g

Re: [PHP] Write from form to DB

2005-08-03 Thread George B
Jay Blanchard wrote: [snip] Yeah I am using "root" which has all permissions [/snip] Are you sure? Did you specifically GRANT ALL to root? When you did, did you flush the permissions? BTW, using root is a Bad Idead[tm]. [/snip] Also, check the mysql error log Never mind guys! I got it working!

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] Yeah I am using "root" which has all permissions [/snip] Are you sure? Did you specifically GRANT ALL to root? When you did, did you flush the permissions? BTW, using root is a Bad Idead[tm]. [/snip] Also, check the mysql error log -- PHP General Mailing List (http://www.php.net/) To unsu

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] So, is that a "Really Bad Thing(tm)", or is it just bad form? If the former, why? [/snip] I personally think it is just bad form. I also know that it can make trouble-shooting a bear sometimes. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/uns

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] Jay Blanchard wrote: > [snip] > It does not seem to be putting anything into the DB. Gives no errors, > but I check PHP My Admin, and there is nothing in the users and > passwords field. I think something isnt working hmmm > [/snip] > > There is a brilliant statement if there ever was

Re: [PHP] Write from form to DB

2005-08-03 Thread George B
Jay Blanchard wrote: [snip] It does not seem to be putting anything into the DB. Gives no errors, but I check PHP My Admin, and there is nothing in the users and passwords field. I think something isnt working hmmm [/snip] There is a brilliant statement if there ever was one! ROFLMMFAO!

RE: [PHP] Write from form to DB

2005-08-03 Thread Jim Moseby
> [snip] > Why not: > > $query = "INSERT INTO user (name,password) VALUES> > ('$username','$password')"; > [/snip] > > You could do that. The reason that I don't is because of the mixing of > quote types. So, is that a "Really Bad Thing(tm)", or is it just bad form? If the former, why? JM -

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] It does not seem to be putting anything into the DB. Gives no errors, but I check PHP My Admin, and there is nothing in the users and passwords field. I think something isnt working hmmm [/snip] There is a brilliant statement if there ever was one! ROFLMMFAO! Does the mysql user you

Re: [PHP] Write from form to DB

2005-08-03 Thread George B
Jim Moseby wrote: [snip] $query = "INSERT INTO user (name,password) VALUES ("'.$username.'","'.$password.'") "; Try that... should work. your query syntax is mangled. Backwards on your quotes Jay. Go home and get some sleep. ;) [/snip] Damn these corporate mergers! Corrected query $quer

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] Why not: $query = "INSERT INTO user (name,password) VALUES> ('$username','$password')"; [/snip] You could do that. The reason that I don't is because of the mixing of quote types. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Write from form to DB

2005-08-03 Thread Jim Moseby
> > [snip] > > > $query = "INSERT INTO user (name,password) VALUES > > > ("'.$username.'","'.$password.'") "; > > > > > > Try that... should work. your query syntax is mangled. > > > > > > > Backwards on your quotes Jay. Go home and get some sleep. ;) > > [/snip] > > > > Damn these corporate m

RE: [PHP] Write from form to DB

2005-08-03 Thread Jim Moseby
> [snip] > > $query = "INSERT INTO user (name,password) VALUES > > ("'.$username.'","'.$password.'") "; > > > > Try that... should work. your query syntax is mangled. > > > > Backwards on your quotes Jay. Go home and get some sleep. ;) > [/snip] > > Damn these corporate mergers! > > Corrected

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] > $query = "INSERT INTO user (name,password) VALUES > ("'.$username.'","'.$password.'") "; > > Try that... should work. your query syntax is mangled. > Backwards on your quotes Jay. Go home and get some sleep. ;) [/snip] Damn these corporate mergers! Corrected query $query = "INSERT I

Re: [PHP] Write from form to DB

2005-08-03 Thread John Nichel
Jay Blanchard wrote: [snip] $query = "INSERT INTO user (name,password) VALUES ($username","$password") would do the job but, it dosent. It gives a Parse error: syntax error, unexpected T_VARIABLE in C:\Program Files\Apache Group\Apache2\htdocs\php\login\registration_action.php on line 15 [/s

Re: [PHP] Write from form to DB

2005-08-03 Thread John Nichel
George B wrote: Ok, I got this far. include("config.php"); $username = $_GET['name']; $password = $_GET['pword']; echo "Username = " . $username . ""; echo "Password = " . $password . ""; $query = "INSERT INTO user (name,password) VALUES ($username","$password") $result = mysql_query($query) c

Re: [PHP] Write from form to DB

2005-08-03 Thread Richard Davey
Hello George, Wednesday, August 3, 2005, 6:50:07 PM, you wrote: GB> $query = "INSERT INTO user (name,password) VALUES ($username","$password") $query = "INSERT INTO user (name, password) VALUES ('$username', '$password')"; And don't forget to validate your user input before slamming it directly

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] >[snip] >$query = "INSERT INTO user (name,password) VALUES >($username","$password") > >would do the job but, it dosent. It gives a > >Parse error: syntax error, unexpected T_VARIABLE in C:\Program >Files\Apache Group\Apache2\htdocs\php\login\registration_action.php on >line 15 >[/snip] >

Re: [PHP] Write from form to DB

2005-08-03 Thread George B
Jay Blanchard wrote: [snip] $query = "INSERT INTO user (name,password) VALUES ($username","$password") would do the job but, it dosent. It gives a Parse error: syntax error, unexpected T_VARIABLE in C:\Program Files\Apache Group\Apache2\htdocs\php\login\registration_action.php on line 15 [/s

RE: [PHP] Write from form to DB

2005-08-03 Thread Jay Blanchard
[snip] $query = "INSERT INTO user (name,password) VALUES ($username","$password") would do the job but, it dosent. It gives a Parse error: syntax error, unexpected T_VARIABLE in C:\Program Files\Apache Group\Apache2\htdocs\php\login\registration_action.php on line 15 [/snip] $query = "INSERT I

RE: [PHP] Write from form to DB

2005-08-03 Thread Jim Moseby
> Ok, I got this far. > > include("config.php"); > $username = $_GET['name']; > $password = $_GET['pword']; > echo "Username = " . $username . ""; > echo "Password = " . $password . ""; > $query = "INSERT INTO user (name,password) VALUES > ($username","$password") > $result = mysql_query($query)

[PHP] Write from form to DB

2005-08-03 Thread George B
Ok, I got this far. include("config.php"); $username = $_GET['name']; $password = $_GET['pword']; echo "Username = " . $username . ""; echo "Password = " . $password . ""; $query = "INSERT INTO user (name,password) VALUES ($username","$password") $result = mysql_query($query) config is just all