[Hyde]

I believe the error is in your SQL query. On the line

WHERE Password = 'farts';";

you have two semi-colons, that could be it.

[renewaltopics]

Hyde, on 29 July 2012 - 02:27 PM, said:

I believe the error is in your SQL query. On the line

WHERE Password = 'farts';";

you have two semi-colons, that could be it.

I changed it...

<?php

$con = mysql_connect("localhost","register","mysql");

if (!$con)

{
die("Could not connect: " . mysql_error());
}

mysql_select_db("users");


$query = "UPDATE users SET Email= '$_POST["email"]'
WHERE Password = 'farts'";

$result= mysql_query($query);

mysql_close($con);

echo "Hi";

?>

It still gives a blank error page

[Hyde]

By the way :

• Use [code] tags when pasting code
  
• Don't use die(), implement error reporting in a nice way
  
• Don't use mysql_ and learn PDO instead
  
• Don't put a capital letter as the beginning of row names

[renewaltopics]

I plan to use PDO library in the future, but for now, i need to update this data.

<?php

$con = mysql_connect("localhost","register","mysql");

if (!$con)

{
die("Could not connect: " . mysql_error());
}

mysql_select_db("users");


$query = "UPDATE users SET Email= '$_POST["email"]'
WHERE Password = 'farts'";

$result= mysql_query($query);

mysql_close($con);

echo "Hi";

?>


Still accepting all answers

[Ruku]

Find out for yourself; run this in a terminal/command prompt:

php -l file.PHP

[renewaltopics]

Ruku, on 29 July 2012 - 02:45 PM, said:

Find out for yourself; run this in a terminal/command prompt:

php -l file.PHP

How do I find code bugs in a command prompt?

[TheEmpty]

renewaltopics, on 29 July 2012 - 02:49 PM, said:

How do I find code bugs in a command prompt?

By running that command.

[renewaltopics]

can somebody just tell me my error? im sorry for being impatient i just need to have this page completed in 3 hours.

[TheEmpty]

renewaltopics, on 29 July 2012 - 03:21 PM, said:

can somebody just tell me my error? im sorry for being impatient i just need to have this page completed in 3 hours.

Then study and read your assigned reading?

[renewaltopics]

I keep trying to change certain things in the code, but i cant seem to crack this bug. Can someone please help me, id really appreciate it

[callumacrae]

I don't he's capable of more one point at a time

Try this line:

$query = "UPDATE users SET Email= '$_POST["email"]'
WHERE Password = 'farts'";

[renewaltopics]

am i getting an answer please?

callumacrae, on 29 July 2012 - 03:33 PM, said:

I don't he's capable of more one point at a time

Try this line:

$query = "UPDATE users SET Email= '$_POST["email"]'
WHERE Password = 'farts'";

thats the same exact thing as my error code

[callumacrae]

In PHP, how do you put an array element in a string?

[renewaltopics]

callumacrae, on 29 July 2012 - 03:36 PM, said:

In PHP, how do you put an array element in a string?

string implode ( array $pieces )

[callumacrae]

Nope. I meant like this:

$a = "abc $abc abc";

But with

$abc['abc']

instead of

$abc

[renewaltopics]

yeah its a different method of writing an array. so whats the point?

[callumacrae]

If you know how to do it, you know how to solve your problem.

[renewaltopics]

ok, but i dont know where the porblem is... ive done the same thing before and it worked. so thats why im very confused where my error is

[callumacrae]

$a = "b $c["d"] e";

That code isn't valid, do you see why?