mysql_fetch_row()

yvo

I would like send all UPDATE informations in a table.

It's my code...

All lignes with $t... it' for Template.

$req = "UPDATE membre set nom = 'yvo' where id = '189841';";
$toto = mysql_query($req);

while($db_data= mysql_fetch_row($toto))
{
$b=1;
while($b < $a)
{
$t->set_var("enr",$db_data[$b]);
$t->parse("ligne","e",true);
$b++;
}
$t->parse("listing","l",true);
$t->set_var("ligne","");

}
$t->pparse("MyOutput","page");

PHP send my =>Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource .

Help me please...

Yvo😕

dopey

It looks like your query is failing - try changing your query line to:

$toto = mysql_query($req) or die(mysql_error());

to see what's happening.

Cheers,
Andy.

Gargouil

you have a error in your sql statement

you should not put the " ; " in the query...

$req = "UPDATE membre set nom = 'yvo' where id = '189841';";

should be

$req = "UPDATE membre set nom = 'yvo' where id = '189841'";

yvo

My probem is not the query.
The database is update but i can not send the record(s) to a table in a other HTML page.

Yvo😕

KoshNaranek

NONSENS! The ";" at the end of the SQL-Statement is totally correct. Thats SQL :rolleyes:

I can't get the Problem - maybe it got lost in the translation 😉

SQL UPDATE's all rows, containing the specified "WHERE".
You don't have to do a loop for this!

The only result, that could be returned is "12 row(s) affected."
See doku "mysql_affected_rows"

Gargouil

not sure to understand what you want to do...

can you give me more details on what exactly you want to send to other page ?

KoshNaranek

I think, he wants to display the changed data :rolleyes:

I would redirect to the "display-Data"-section of the script...😉

Gargouil

simply have to memory the id then reload the modified data to the next page

yvo

How can i memory the id?
The user write the query.
The program execute the query and create a new page with the result of the query for printing.

Yvo😕

Gargouil

basically:

you do your update statement (you already know the id '189841')

now if i understant you call another page ?
then yo uhave few option.. session_register the var then reload it in the other page or pass it in the url when calling the page.. page.php?id=189841

and on your other page...
reload your data with a simple SELECT where id=...

yvo

With the example i can the id.

I recive the query in a variable so as $theQuery.

But the query can be Select, Update, Delete with a other where=...

Yvo

Gargouil

you are playing with fire 🙂

never permit to pass a query in argument..
suposse i go to your page and i create my own query ...

anyway

what i suggest you if do pass few hint in your call like ?type=SELECT or type=UPDATE then &id=... or any other vars...

and in your script do a select case

switch ($type)
{
case "SELECT": $query = "SELECT * from....";
break;
case "UPDATE": ....
}

somethime it's preferable to have larger part of code but better security, the shortest code isn't always the better