hey guys!

I ne= ed your=20 help in writing a php name-day searcher script.

here's what ive don= e:=20

i have the hostname, login and pw defined in a file, this one calls= it:=20
<?php require_once('rubin_nevnapok.php'); ?>

then i made = the=20 query, where (sorry for not translating the variable names, would be easier= for=20 you to understand 3D""=20 )=20
the "nevek" table contains the names, the honapok table has the month n= ames=20 and the "nevnapok.nap" tells which day of the month has the name (nevek.nev= ).=20
hope you understand me, i'm a bit confused 3D""=20 =20

<?php
mysql_select_db($database_rubin_nevnapok,=20 $rubin_nevnapok);
$honap_szama =3D Date("m");
$nap_szama =3D Date("= d");=20
$query_mainevnap_lekerdezes =3D "SELECT nevek.nev, honapok.honap_kod,= =20 nevnapok.nap FROM nevek INNER JOIN (honapok INNER JOIN nevnapok ON=20 honapok.honap_kod =3D nevnapok.honap_kod) ON nevek.nev_kod =3D nevnapok.nev= _kod=20 WHERE honapok.honap_kod =3D '$honap_szama' AND nevnapok.nap =3D '$nap_szama= '";=20
$mainevnap_lekerdezes =3D mysql_query($query_mainevnap_lekerdezes,=20 $rubin_nevnapok) or die("MySQL hiba! webmaster@rubinfleur.hu " . mysql_erro= r());=20
$row_mainevnap_lekerdezes =3D mysql_fetch_assoc($mainevnap_lekerdezes);= =20
$totalRows_mainevnap_lekerdezes =3D mysql_num_rows($mainevnap_lekerdeze= s);=20
?>

so here comes the important code, which i need help in...= :=20

<?php
if ($totalRows_nevnapok_lekerdezes <=3D 0) {=20
$hibauzenet =3D "Ilyen n=E9v nincs az adatb=E1zisban: ";
print $hib= auzenet;=20
print $p_name;}
else
{echo $row_nevnapok_lekerdezes['nev']; do {=20
echo " napja:";
echo "<br>";
echo=20 $row_nevnapok_lekerdezes['honap'];
echo " ";
echo=20 $row_nevnapok_lekerdezes['nap'];
echo ".<br>";
} while=20 ($row_nevnapok_lekerdezes =3D mysql_fetch_assoc($nevnapok_lekerdezes)); } ?= >=20
here if the totalrows is 0 then the name ($p_name entered in a html for= m=20 btw) was not found in the database and prints an error message (which is bt= w=20 $hibauzenet). from now comes the problem:
one day (one date) CAN have m= ore=20 names, and
one name CAN be on more days...

now what happens is = that=20 if theres a name that has more days, the name is written once and the=20 corresponding dates ('honap' is the month, 'nap' is the day) are printed (i= f=20 there are more dates of the specific name, if there is only one, that one i= s=20 printed).
BUT the mysql query as you can see, querys using WHERE nevek.= nev=20 LIKE "%$p_name%"... this has a reason: there should be matches if the user= =20 enters only a part of the name, and
therefore if they enter only one le= tter=20 (say "a") there will be a lot of names, the ones containing that letter... = and=20 in this case, only the first match of the name is printed,and all the other= =20 dates...
So how can i make the script write the "nev" if there are diff= erent=20 names, but i want it to write the name only once if the specific name has t= wo or=20 more dates according to the database?

i know should've expressed my= =20 problem simplier but i couldn't 3D""=20 for=20 that, i apologise! but i hope you have my point and can help me!=20

unfortunately i'm not a php expert, i tried some things but they di= dn't=20 work for me... i tried to do the printing with a for, where the $i keeps=20 changing while it checks if the consecutive result rows=20 (mysql_result($nevnapok_lekerdezes,$i) and $eredmeny2 =3D=20 mysql_result($nevnapok_lekerdezes,$i+1)) are the same, and if they are, wri= tes=20 the name only once, but i might have screwed it up because it did not do wh= at i=20 meant it to do 3D""=20 =20

there's another problem: my language has characters that the regula= r=20 code tables do not contain, in html they are shown by: "ő" "ű". s= ome names=20 contain some of these, and they are not found by the above script, although= i=20 have added them to the mysql database... for example if there's a name like= =20 "Dezs=F5" (hope you will see this correctly, the last letter is the 337), i= t's not=20 found if i enter
exactly this into the search field, but is found if i = do a=20 query with "Dezso"
written in the field (now it's the same letter, but = has=20 no commas on its top), it is found, and the printed name is not Dezso but D= ezs=F5,=20 so the database keeps the special letter, just can't find it!
what do y= ou=20 suggest?

regards,
lowdog
lowdog@axelero.hu

ps: i attach here the create tables, just to make t= he=20 above more understandable:

CREATE TABLE honapok (
honap_kod tinyint(2) NOT NULL default= =20 '0',
honap text NOT NULL,
PRIMARY KEY (honap_kod)=
)=20 TYPE=3DMyISAM COMMENT=3D'honapok';

CREATE TABLE nevek (
nev_kod smallint(6) NOT NULL default=20 '0',
nev text NOT NULL,
PRIMARY KEY (nev_kod)
= )=20 TYPE=3DMyISAM COMMENT=3D'nevek listaja';

CREATE TABLE nevnapok (
= =20 entry_kod smallint(6) NOT NULL default '0',
nev_kod smallint(6) N= OT=20 NULL default '0',
honap_kod tinyint(2) NOT NULL default '0',
&= nbsp;=20 nap tinyint(2) NOT NULL default '0',
PRIMARY KEY =20 (entry_kod)
) TYPE=3DMyISAM COMMENT=3D'a=20 nevnapok...';