macOS PHP database update question

[macfaninpdx]

Query failed: Unknown column 'uname' in 'where clause'

Finally, we found the cause of the problem! You do not have the fields set up (or not set up correctly) in your boyfight3 table. Can you set up the fields using DreamWeaver? How did you initially set up the database and the table?

 

[barr08]

I have a program that created the table:

http://nemo.mwd.hartford.edu/~bbarr/IIT310/Final/FinalPHPDB/createTable.php

<?php
	$server="localhost";
	$user="bbarr";
	$pass="******";
	$currentDB="bbarr";
	$testTable="boyfight3";

	$hookup=mysql_connect($server, $user, $pass) ;

	$dbNow=@mysql_select_db($currentDB, $hookup);
	
	$sql = "CREATE TABLE $testTable (ename varchar(30), email varchar(40), acnt varchar(4), cost varchar(10))";

	$result= @mysql_query($sql, $hookup) or die("Table not created." . mysql_error());

	if($result) {
		print "Table successfully created." ;
	}
?>

 

[macfaninpdx]

$sql = "CREATE TABLE $testTable (ename varchar(30), email varchar(40), acnt varchar(4), cost varchar(10))";

If you look closely at the CREATE TABLE SQL command, you will notice that the field you created is called ename, not uname as you are trying to select. Change the select statement in your updateData.php file to:

$query = "select * from $currentTable where ename = '$uname'";

and you will have to change it in the insert and update queries as well.

 

[barr08]

wow what a terrible typo...one sec

 

[barr08]

Awesome! no errors, but it doesn't update the fields.

My first field is BenCo/barr08@gmail.com/0001/1000

and i typed all of that, but instead of 1000, i typed 2000, into the dataUpdate html form, and nothing happened.

view fields:
http://nemo.mwd.hartford.edu/~bbarr/IIT310/Final/FinalPHPDB/retrieveDisplayAll.php

data update form:
http://nemo.mwd.hartford.edu/~bbarr/IIT310/Final/FinalPHPDB/dataUpdate.html

 

[macfaninpdx]

Awesome! no errors, but it doesn't update the fields.

Now THAT problem does lie in the code.
Here is your existing code (assuming you changed the uname to ename per above:

else
{

    /* Update */
    $row = mysql_fetch_assoc($result);

    /* Get the old ID */
    $id = $row["id"];

    /* Create the update query */
    $update_query = "update $currentTable set ename = '$uname', email = '$email', acnt = '$acnt', cost = '$cost' where id = '$id'";

    $result = mysql_query($update_query);

}

But I'm afraid the bit about "Get the old ID" won't do anything, since you are not using an id field. So you can remove the $id line and it's comment. And you can remove the $row = ... bit as well. So the new else block should become:

else
{
    /* Create the update query */
    $update_query = "update $currentTable set ename = '$uname', email = '$email', acnt = '$acnt', cost = '$cost' where ename = '$uname'";

    $result = mysql_query($update_query);

}

*Note the $update_query line was changed too.

 

[barr08]

IT WORKS!

check you pm