Nexus10

Okay, I'm having problems with another query now also related to the above: $query = "UPDATE Users_recover SET 'key' = '$key' WHERE user_name = '$user_name'"; mysql_query($query) or die("Error: Action could not be completed. Please email [email protected] about this.<br />" . mysql_error()); Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''key' = 'baea9f5fb6eea96384efae608716d819' WHERE user_name = 'admin'' at line 1

Ah, that works thanks. So what was wrong with my original syntax?

$query = "INSERT INTO `Users_recover` SET `user_name`='{$user_name}' , `email`='{$email}' , `key`='{$key} "; mysql_query($query) or die("Problem with the query: $query<br>" . mysql_error()); Problem with the query: INSERT INTO `Users_recover` SET `user_name`='admin' , `email`='[email protected]' , `key`='78bef654a197cdc4189342034a3c5c1b You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''78bef654a197cdc4189342034a3c5c1b' at line 1

Only whatever error message I put inside the Die statement. No other error.

Empty database (Users_recover), no rows in it. user_name (varchar(20)) email (varchar(150)) key (varchar(150)) $query = "INSERT INTO Users_recover (user_name, email, key) VALUES ('$user_name', '$email', '$key')"; mysql_query($query) or die("Erro"); I echo'ed $user_name, $email and $key above the query and these are all fine.

$result = mysql_query("SELECT * FROM Users WHERE user_name = '$user_name'"); $result = mysql_fetch_row($result); $email = $result['email']; $userMoney = $result['money']; $userPoints = $result['points']; Hi, how can I get the above code to work where I can use $email = $result['email']; etc by subbing in the column name in between the square brackets? Currently $email and the other two are not receiving the values as something is wrong with my query I think.

Ah, that does it /register/ now works. Although how do I need to set up my file so that all my images (stored in am image folder in the food directory), css and include files work properly with it?

I uploaded the .htaccess file to both the main folder and the food sub directory as I wasn't sure which one it went in. register.php is in the food folder. The code you have there still does not work, same error as above.

Sorry, /food/register/ could not be found on the website. Perhaps you wish to return where you came from: http://www.mysite.com/food/index.php www.mysite.com Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.4) Gecko/20100611 Firefox/3.6.4 143.238.117.44 404 www.mysite.com when I enter http://www.mysite.com/food/register/ in the address bar.

It still doesn't work like that

That works for www.mysite.com/food/register but not www.mysite.com/food/register/

Umm I'm not sure what you mean then.

Options +FollowSymLinks RewriteEngine On RewriteBase / RewriteRule http://www.mysite.com/food/register/$ register.php [R=301,L] I go to http://www.mysite.com/food/register/ and it gives a 404 error saying /food/register/ could not be found on the server (it is uploaded in the directory).

This is what I have so far: Options +FollowSymLinks RewriteEngine On RewriteBase / #RewriteRule ^register(/)?$ apple/register.php [R=301] RewriteRule ^register\.php$ http://www.mysite.com/Food/Register/ [R=301,L] which does redirect http://www.mysite.com/Food/register.php to http://www.mysite.com/Food/Register/ although that gives a 404 error then. I want http://www.mysite.com/Food/Register/ to display in the address bar but to actually use register.php to do so. Any help please?

?

Okay, I'm confused. So far I've only added Options +FollowSymLinks RewriteEngine On RewriteBase / to my .htaccess file and have become lost now. I want to redirect http://www.mysite.com/food/account/ (and http://www.mysite.com/food/account) to http://www.mysite/food/account.php Can someone help me with this?

I'm not sure what this is called (hence I couldn't google it) although I think it is doen with PHP. Instead of redirecting people to mysite.com/help.php I want to redirect them to mysite.com/help/ where help.com (or another specified 'index' for that folder loads), how do I do this?

$result = mysql_query("SELECT * FROM Users WHERE user_name = '$user_name'"); $result = mysql_fetch_row($result); echo($result[2]); and it keeps echoing "frogQuery" (where frog is the password). It keeps tacking 'Query' on the end, how do I get just 'frog' returned?

Nothing echo's, not even '1'.

?

<?php // Back-end for user registration session_start(); include("config.php"); include("openDatabase.php"); $user_name = strip_tags($_POST["userName"]); // Strip_tags removes anything enclosed by < or > (i.e. scripts/html etc) $email = strip_tags($_POST["email"]); $password1 = strip_tags($_POST["password1"]); $password2 = strip_tags($_POST["password2"]); echo($email); $_SESSION['account_err'] = "" $_SESSION['register_userName'] = $user_name // Stores the entered data to repopulate the form if necessary if the user needs to correct anything $_SESSION['register_email'] = $email include("config.php"); // MYSQL connection details include("openDatabase.php"); // Connects to the database if (strlen($user_name) < 5){ // User name has be minimum 5 characters in length $_SESSION['account_err'] = "Error: User name must be 5 characters or longer."; endif if (strlen($email) < 6) // Poor check to check at least something has been entered into the field $_SESSION['account_err'] = "Error: A valid email address is needed!"; end if if ($password1 <> $password2){ // Checks if passwor $_SESSION['account_err'] = "Error: Password's do not match!"; else { if (strlen($password1) < 5){ // Password has to be minimum 5 characters in length $_SESSION['account_err'] = "Error: Password must be 5 characters or longer."; endif endif $errStatus = $_SESSION['account_err'] echo("Err status: $errStatus"); if ($_SESSION['account_err'] = ""){ // No errors in data submitted for registration $query = "INSERT INTO Users(user_name, date_registered, password, email) VALUES ($user_name, date("Y/m/d"), $password1, $email)"; mysql_query($query) or die("Error: Registration not saved. Please let us know at ???@???.com"); endif ?> when the above file is called after a user has submitted their details to register, this file loads in the browser but nothing occurs, no error or anything

Thanks, it works now

Error: data not inserted

?