cant update

[karq]

<?php
//votame formi data
$pealkiri=$_POST["peal"];
$uudis=$_POST["uudis"];
$num=$_POST["id"];
//Tuli ikka õigest kohast
if (!isset($pealkiri) || !isset($uudis)) {
echo "<center><b>Kuskil oli viga, proovi uuesti</b><br />";
echo "<a href='muuda.php'>Tagasi</a><center>";
}//kui tuldi valest kohast
//Kui väljad on tyhjad;
elseif (strlen($pealkiri || $uudis)==0){
echo "<center><b>Täida väljad</b><br />";
echo "<a href='muuda.php'>Tagasi</a><center>";
}
//Kontrollime kas session on olemas
else {
session_start();
if (session_is_registered("kasutaja")) {
include "db.php";
//uuendame databaasi
$uue="UPDATE uudis SET pealkiri='$pealkiri' and uudis='$uudis'
WHERE num='$num'";
if (mysql_query($uue,$con)) {
echo "<center><b>Databaas uuendatud</b><br />
<a href='muuda.php'>Tagasi</a></center>";
}
else {
echo mysql_error();
}//kui ei saanud uudendada
}//kui kõik oli ok
else {
echo "<center><b>Te pole sisse loginud</b><br />";
echo "<a href='logi.php'>Logi sisse</a><center>";
}
}
?>

 

Why dosent it update that table?

[fenway]

I assume you're not getting mysql errors... so please echo each one of those update queries.

[revraz]

Or use mysql_error after your querries to see if you are getting an error.

[karq]

the problem is some where here

//Kontrollime kas session on olemas
else {
session_start();
if (session_is_registered("kasutaja")) {
include "db.php";
//uuendame databaasi
$uue="UPDATE uudis SET pealkiri='$pealkiri' and uudis='$uudis'
WHERE num='$num'";
if (mysql_query($uue,$con)) {
   echo "<center><b>Databaas uuendatud</b><br />
   <a href='muuda.php'>Tagasi</a></center>";
}
else {
   echo mysql_error();

[fenway]

That's not really good enough... echo $uue... what is the mysql_error(), if any?

[karq]

It dosent give any error. It just dosent work.

[fenway]

It dosent give any error. It just dosent work.

As requested before, please echo the sql query.

[karq]

It dosent give any error. It just dosent work.

As requested before, please echo the sql query.

echo mysql_query($update,$con);

 

and the output is 1

[fenway]

It dosent give any error. It just dosent work.

As requested before, please echo the sql query.

echo mysql_query($update,$con);

 

and the output is 1

Sigh... not the output of the query, the query string itself -- $uue.

[revraz]

Another question, why are you running mysql_query on $update when your query is $uue?

 

It dosent give any error. It just dosent work.

As requested before, please echo the sql query.

echo mysql_query($update,$con);

 

and the output is 1

[c0rnf3d]

$uue="UPDATE uudis SET pealkiri='$pealkiri' and uudis='$uudis'

 

should be a comma there, not AND

 

 

(but i could be wrong.... im a newb)

[revraz]

You're dead on

[karq]

the comma dosent change anything, still the samething

[c0rnf3d]

do a mysql_query($uue,$con) or die(mysql_error())

and see what that returns