Update Access DB

[john87423]

I am using SQL to update an Access DB here is the code:

<?php
	include 'DBConnect.php';

$ID = $_GET["ID"];
$name = $_POST['Name'];
$initials = $_POST['Initials'];
$password = $_POST['Password'];
$email = $_POST['Email'];

echo $ID;
echo $name;
echo $initials;
echo $password;
echo $email;

$records = $conn->Execute("UPDATE WebUsers SET Name='$name' Initials='$initials' Pass='$password' EMail='$email' WHERE ID=$ID");
?>

It gets the variables through but only when I hard code the values in the SQL statement does it work.

Someone please say why this is happening.
Any more code needed then say.
Cheers

[Sxooter]

The best way to troubleshoot such issues is to assign your query to a string, and print that out.

i.e.:

$query = "Select .....";
print $query;
query->execute($query);

That way you can see what it is you're trying to execute.

[john87423]

I did try what you suggested before hand and the SQL statement is correct:

UPDATE WebUsers SET Name='John' Initials='JJ' Pass='john' EMail='[e-mail]' WHERE ID=2
Fatal error: Call to a member function execute() on a non-object in C:\wamp\www\editUser.php on line 18

Line 18 is this:

$query->execute($query);

And still it is not updating the record.

Thanks

[john87423]

I have got the query working now as it gets the ID, its not populating the fields though:

<?php
	include 'DBConnect.php';

$ID = $_GET["ID"];

if(isset($_POST['submit'])) 
{	
	$ID = $_GET["ID"];
	$name = $_POST['name']; 
	$initials = $_POST['initials'];
	$password = $_POST['password'];
	$email = $_POST['email'];

	//$records = $conn->Execute("SELECT Name,Initials,Pass,EMail FROM WebUsers WHERE ID=$ID");
	print $query;
	$query->execute($query);

	header("Location: Users.php");
}

//echo "SELECT Name,Initials,Pass,EMail FROM WebUsers WHERE ID=$ID";
$records = $conn->Execute("SELECT Name,Initials,Pass,EMail FROM WebUsers WHERE ID=$ID");

$fv = $records->Fields("Name");
$fv1 = $records->Fields("Initials");
$fv2 = $records->Fields("Pass");
$fv3 = $records->Fields("EMail");
?>

<a href='Users.php'>User list</a><br>	

<form action="<?php echo $PHP_SELF;?>" method=POST>	
	<br><input type='text' name='name' value="<?php $fv->value; ?>"><br>
	<br><input type='text' name='initials' value='<?php $fv1->value; ?>'><br>
	<br><input type='text' name='password' value='<?php $fv2->value; ?>'><br>
	<br><input type='text' name='email' value='<?php $fv3->value; ?>'><br>
	<input type='submit' name='submit' value='Update'>
</form>

Cheers anyone

[mpb001]

$query->execute($query);

to
$conn->execute($query);

will remove the line 18 error

 
    $ID = $_GET["ID"]; 

if(isset($_POST['submit'])) 
{     
    $ID = $_GET["ID"];

why the assigning of ID twice?

[john87423]

Your right I only need to use the top ID assignement.

Changed what you said although they are still not being populated.

Cheers for reply

[mpb001]

No commas might be it..

Name='$name' Initials='$initials'

Also have you any way of turning on and displaying errors, i will help you. The eyes sometimes see what isn't there.