Paul:
Several issues, including basic logic and security matters.
* calling mysql_query() without setting $sql.
* setting $query without ever calling mysql_query().
* not using mysql_real_escape_string() on values you're putting in the
SQL string.
* echoing input out as HTML without using htmlsp
> #select the specified database
> $rs = mysql_select_db( "test_db", $conn ) or die( "Err:Db" );
>
> #create
> $rs = mysql_query( $sql, $conn );
>
> $query = ("UPDATE tr_test_record
> SETtr_actualdata = '$actualdata', tr_actualresult =
> '$actualresult', tr_testnote = '$test
PaulCheung wrote:
I am using the MySQL Update for the first time and do not think I am
doing it correctly. I have checked coding examples and my coding (to me)
looks correct. but am not updating my table and I cannot see what it is
I am doing wrong.
Does it generate an error when you paste th
Hello,
Looks good to me. Maybe the where clause is never getting met.
- Ben
PaulCheung wrote:
I am using the MySQL Update for the first time and do not think I am
doing it correctly. I have checked coding examples and my coding (to
me) looks correct. but am not updating my table and I cannot
