Hi Olivier!
You could just put a primary key on your ID_msg field and the trouble would be gone.
I think in the future Nijel wants to implement checkboxes for deleting multiple
entries at once, so I guess he'll implement a different logic then anyways - I for
one would dislike seeing those huge form buttons on every page instead of hovering
links.
Maybe someone of the other developers wants to put a word on this...
Regards,
Garvin.
<quote who="Olivier Brouckaert">
my query is
SELECT Sujet,Message FROM forum WHERE ID_msg > 1000
but if you use a button for GET and POST you juste have to do this way
<form method="<?php if($primary_key || $length<2048) echo 'GET';
else echo 'POST';
?>" action="script.php">
<input type="hidden" name="where_condition" value="<?php
if($primary_key) echo
$primery_key; else echo $text; ?>">
<input type="submit" name="choice" value="Modify">
<input type="submit" name="choice" value="Delete">
</form>
and no javascript is used
----- Original Message -----
From: "Garvin Hicking" <squirrel(a)supergarv.de>
To: <phpmyadmin-devel(a)lists.sourceforge.net>
Cc: "Olivier Brouckaert" <oli.brouckaert(a)i-services.be>
Sent: Saturday, May 03, 2003 11:27 AM
Subject: Re: [Phpmyadmin-devel] Re: [Phpmyadmin-devel] bug : bouton et liens
dans l'affichage des r ésultats d'une requete
Hi Olivier!
or to take less place, a link with an onclick
attribute like this
<a href="#null"
onclick="document.myform.submit()">Modify</a>
We can't use a button, because then we would have to use javascript to
submit it via
GET. And we don't want phpMyAdmin to be
dependant on JavaScript.
On the other hand, if a button shows up in your table display, you're
doing
something wrong with your table layout anyways.
Use primary keys where
possible, and
you won't have to deal with extra length GET
methods...
But thanks for your consideration,
Garvin.
>----- Original Message -----
>From: "Olivier Brouckaert" <oli.brouckaert(a)i-services.be>
>To: <squirrel(a)supergarv.de>
>Sent: Saturday, May 03, 2003 10:36 AM
>Subject: Re: [Phpmyadmin-devel] Re: [Phpmyadmin-devel] bug : bouton et
liens
>dans l'affichage des r ésultats d'une
requete
>
>
>
>>ok but why not place a button for GET method as well ? If more than
2048
>>chars, use POST method, otherwise GET
method, and for the user that
would
>be
>
>>transparent
>>
>>----- Original Message -----
>>From: "Garvin Hicking" <squirrel(a)supergarv.de>
>>To: "Olivier Brouckaert" <oli.brouckaert(a)i-services.be>
>>Sent: Saturday, May 03, 2003 10:29 AM
>>Subject: Re: [Phpmyadmin-devel] Re: [Phpmyadmin-devel] bug : bouton et
>
>liens
>
>>dans l'affichage des r ésultats d'une requete
>>
>>
>>
>>>Hi Olivier!
>>>
>>>Thanks for translating that - the reason is because the Internet
>
>Explorer
>
>>doesn't
>>
>>>allow posting a form via a GET method when there are more than 2048
>
>chars.
>
>>So we use
>>
>>>the POST field whenever a request is larger that 2048 chars, and then
we
>>have to use
>>
>>>buttons.
>>>
>>>You could reduce that by placing primary keys on your table, so
>
>phpMyAdmin
>
>>doesn't
>>
>>>have to take so many chars into regard when building a unique
condition
>to
>
>>fetch
>>
>>>your data.
>>>
>>>Regards,
>>>Garvin.
>>>
>>><quote who="Olivier Brouckaert">
>>>
>>>>Hello
>>>>
>>>>when I show the result of a query "SELECT * FROM WHERE ..." in
>>
>>phpMyAdmin,
>>
>>>>sometimes the link Modify / Delete is replaced by a button.
>>>>
>>>>Why this and will it be fixed in phpMyAdmin 2.5.0 final release ?
>>>>
>>>>This is a strange bug because if there is sometimes a button, that
>
>means
>
>>>>there must be a condition which, when it is true, shows a button,
>>
>>otherwise
>>
>>>>a link. But why that test ?
>>>>
>>>>thanks
>>>>
>>>>Olivier
>>>>
>>>>----- Original Message -----
>>>>From: "Garvin Hicking" <squirrel(a)supergarv.de>
>>>>To: "Olivier Brouckaert" <oli.brouckaert(a)i-services.be>
>>>>Sent: Saturday, May 03, 2003 9:58 AM
>>>>Subject: Re: [Phpmyadmin-devel] bug : bouton et liens dans
l'affichage
>>des
>>
>>>>résultats d'une requete
>>>>
>>>>
>>>>
>>>>>Hi Olivier!
>>>>>
>>>>>Are you able to write in english? If yes, please do so. I'm
curious
>>what
>>
>>>>you're
>>>>
>>>>>writing about :)
>>>>>
>>>>>Regards,
>>>>>Garvin.
>>>>>
>>>>><quote who="Olivier Brouckaert">
>>>>>
>>>>>>Bonjour,
>>>>>>
>>>>>>lorsque j'affiche le contenu d'une requete SELECT dans
phpmyadmin,
>>>>parfois je vois
>>>>
>>>>>>un lien Modifier / Supprimer parfois ce lien est remplacé par un
>>
>>bouton.
>>
>>>>>>A quoi cela est-il du et est-ce que ce sera corrigé dans la
version
>>>>2.5.0 ?
>>>>
>>>>>>En tout cas c'est un étrange bug :) car s'il y a un bouton
qui
>>
>>apparait
>>
>>>>parfois il
>>>>
>>>>>>doit y avoir un test sur une condition qui, quand elle est à
vrai,
>>>affiche un
>>>
>>>>>bouton, sinon un lien. Mais pourquoi ce test ?
>>>>>
>>>>>Cordialement,
>>>>>
>>>>>Olivier Brouckaert
>>>>>webmaster(a)internetservices-fr.net
>>>>>
>>>>
>>>>
>>>>--
>>>>Bye,
>>>>Garvin.
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>-------------------------------------------------------
>>>This
sf.net email is sponsored by:ThinkGeek
>>>Welcome to geek heaven.
>>>http://thinkgeek.com/sf
>>>_______________________________________________
>>>Phpmyadmin-devel mailing list
>>>Phpmyadmin-devel(a)lists.sourceforge.net
>>>https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>>
>>>
>>>
>>>
>>>
>>
>>
>>--
>>Bye,
>>Garvin.
>>
>>
>
--
Bye,
Garvin.