Maybe this Forum will help!?

[canox]

Hi all,

 

So I have this script.

Basically its form that connects to the database insterts rows in the databse onto the form. The user can change the values in the form and update the relevant row on the databse. BUT its not working...heres the code:

 

UPDATE $tbl SET name='$name', lastname='$lastname', grade='$overall' WHERE id='$id'

 

what is happening there!??

all the names correspond to the form correctly....

I am guessing something is worng with "UPDATE $tbl"??

 

Any help will be apprecieated....been driving me crazy!!

 

thanks,

[peranha]

What types of errors are you getting?  the query looks correct to me.

[canox]

thats the thing...

 

i am not getting any errors.... it returns successful.

the database is not being updated.

 

the permissions are correct....

[canox]

Heres the full code:

 

<?php

$name=$_POST['name'];
$lastname=$_POST['lastname'];
$overall=$_POST['overall'];
$tbl="term12008";

$host="localhost"; // Host name 
$username="innovati_grade1"; // Mysql username 
$password="merrigrade1"; // Mysql password 
$db_name="innovati_grade1"; // Database name 

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// update data in mysql database 
$sql="UPDATE $tbl SET name='$name', lastname='$lastname', grade='$overall' WHERE id='$id'";
$result=mysql_query($sql);

// if successfully updated. 
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='list_records.php'>View result</a>";
}

else {
echo "ERROR";
}

?>

[peranha]

$id is not being set in the code, is it set somewhere else, or am I just missing it

[canox]

BrILLIANT!

 

jeeez you know sometimes the stupidest things are the ones you will never se or think about...

 

thanks again,

 

[canox]

just a question...

 

how do you enter in multiple values into an address bar?

 

I want to retrieve data in the following php file by using the GET function...

However i want to retrieve different values

 

eg.

 

<td align="center"><a href="updatestudent.php?id=<? echo $rows['id']; ?>,tbl=<? echo $rows['term']; ?>">update</a></td>

 

in there i want to retrieve the ID value and the TERM value

 

thanks thanks,

[peranha]

$id = $_GET['id'];

 

$term = $_GET['tbl'];

[trq]

They need to be seperated by &

 

That would be...

 

<td align="center"><a href="updatestudent.php?id=<?php echo $rows['id']; ?>&tbl=<?php echo $rows['term']; ?>">update</a></td>

 

Always best to use the full <?php ?> tags too.

[canox]

thanks! im loving this forum