[PHP-DB] Delete duplications from a mysql-resultset

2003-02-22 Thread André Sannerholt
I know the SELECT DISTINCT function. But I need to delete duplications from the finished resultset. Is that in any way possible? The result-set is not like an usual array, is it? I've tried the unique_array function, but it didn't work. André Sannerholt -- PHP Database Mailing List (http

[PHP-DB] explode string variable

2003-03-08 Thread André Sannerholt
Hi everyone! Does anybody know how to stop an explosion of a string: Let me explain: $variable_aray=explode('-', $variable); I want the variable to be devided in only two other ones! If for example: $variable=Willy-Brandt-Platz-5 I want to have an array that looks like this:

[PHP-DB] Transfering variables

2003-06-06 Thread André Sannerholt
Hi everybody! I'm wondering how to transfer variables in a php-document to the same script after the form has been submitted!? Thanks. André -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] In Addition to 'Transfering variables'

2003-06-06 Thread André Sannerholt
I'm not sure if its get/post I need, beacause the variables are not a part of the form itself! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Seccond addition: 'Transfering variables'

2003-06-06 Thread André Sannerholt
Ok, the thing I accually want to do is to keep all the entries in one specific selection-option-box after the form has been submitted. I hope that is enough of explanation, because I cannot expect from you to go through my whole project... Regards, André -- PHP Database Mailing List

[PHP-DB] Optimize following Mysql-Query

2003-05-30 Thread André Sannerholt
JOIN Personen ON Master.NN=Personen.ID WHERE Personen.NAME LIKE '%$name%'); $result = mysql_query($abfrage2) or die(Anfrage results fehlgeschlagen); Regards André Sannerholt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Query takes to much time

2003-06-04 Thread André Sannerholt
Hi everybody, now I have the following qery that still needs to much time: select distinct Anschriften.ID as aid, Anschriften.PLZ as aplz, Anschriften.STRASSE as astrasse, Anschriften.HNR as ahnr from Anschriften inner join Master on Anschriften.ID=Master.A inner join Master as m on

[PHP-DB] Third addition: 'Transfering variables'

2003-06-10 Thread André Sannerholt
Ok, now I have made a simple example of what I want: My script is devided in a PHP and a HTML Part. I have kept out several queries, connections, table-tags etc. in the HTML part. Just imagine there are several entries in the select-tag that is named persona. What I want is to keep all the

[PHP-DB] Ignoring specific values in an inner join query?

2003-06-10 Thread André Sannerholt
Hi everybody. How to let mysql ignore specific values in an inner join query? In this case I want it to ignore Null-Values! $abfrage3=select distinct Anschriften.ID as aid, Anschriften.PLZ as aplz, Anschriften.STRASSE as astrasse, Anschriften.HNR as ahnr from Anschriften inner join Master on

[PHP-DB] Keeping entries of a select-box after submitting the form

2003-06-13 Thread André Sannerholt
Hi everyone, Well, I have already formulated my problem several times, always in a different way, but yet I have no solution. I try to say it as easy as it gets: I simply want one specific selction-box to 'keep' ALL options present after having submited the form! I'm thinking about a variable