update mit php - english [sorry]

Anon

i give a sql-update to mysql. no errormessage - no update ???

this is how i build the sql:
$sql_pub="update termin set pub=\"1\" where id=\"$id\"";

echo "$sql_pub<br>";

$result=mysql_query($sql_pub);

// i dont get response ... here
echo $result;

cordex

try this:

$sql_pub="update termin set pub=\"1\" where id=\"$id\"";
$result=mysql_query($sql_pub);
if(mysql_affected_rows($result) < 1)
{
echo "Update failed";
}
else
{
$sql_st = "SELECT * FROM termin WHERE id='$id'";
$sql_rs = mysql_query($sql_st);
$sql_ar = mysql_fetch_array($sql_rs);
echo "Das ID: $sql_ar[id] und, das pub: $sql_ar[pub]<BR>";
}

knickerlas

I'm no big SQL expert but I think I see the problem. The reason there is no $result is that your query is all wrong and thus not returning a result resuource ($result)

This will do it

// pub and $id = integers not strings right?
$sql_pub="update termin set pub=1 where id=$id";

echo "$sql_pub<br>";
$result=mysql_query($sql_pub);

// this will just return the text "reult resource (or something like that)
echo $result

Nick

knickerlas

Try a mixture of my response with Ben's I think he's might be closer to the mark.

Ben?

techek

I've read the other comments / solutions for your question and I was thinking :

When you UPDATE - is the database updated then?

As Ben writes, mysql_affected_rows() will return a number showing how many rows was CHANGED - so if you're updating one or more records and the data are equal / matches NO rows is affected. Have a look at mysql's UPDATE function and perhaps you should ask here again for more advice, code or help to your problem.

cordex

shrug You told him why, I just told him how.

Anon

hey thanks for helping i found the problem.
sounds a bit stupid but i didn'n select a database. i just connected in the script to the mysql-server and then i gave it the sql-update-statement. and i had an error while i tried to get an error-code.

its working now.
thanks for help

js wrote:

i give a sql-update to mysql. no errormessage - no update ???

this is how i build the sql:
$sql_pub="update termin set pub=\"1\" where id=\"$id\"";

echo "$sql_pub";

$result=mysql_query($sql_pub);

// i dont get response ... here
echo $result;