hi, thanks martin for your answer. I tried it, but it put me the names with the the number.
array(6) { [0]=> array(4) { [0]=> string(10) "Aion Diary" ["name"]=> string(10) "Aion Diary" [1]=> string(1) "2" ["type"]=> string(1) "2" } ... } The thing is, that the type should not be "2", it should be "blog". Since i want to output the code like: foreach($all_waiting_sites as $waiting_site) { echo '<li>'.$waiting_site['name'].' ('.$waiting_site['type'].')</li>'; } This should be a list of sites, which are pending for site rating and every site should have the site type written in the braces: Testing Site (Blog) Second Site (Game) with best wishes > Hi, > > this requires a simple join: > > select siterate.name, sitetype.name > from siterate > join sitetype on sitetype.id = siterate.type > where sitetype.status!=1 > > This supposes that for every entry in siterate, there exists an entry in > sitetypes with sitetype.id = siterate.type > > It seems to me that you might want to read up on SQL. > > Martin > > Artur Reilin schrieb: >> I need help with my query. >> >> I have two tables: >> >> sitetypes( >> id integer primary key not null, >> name text >> ) >> >> siterate( >> id integer primary key not null, >> type integer not null, >> status integer not null, >> ... >> ... >> ) >> >> This is my currently query: >> $all_waiting_sites = sqlite_array_query('select name,type from >> '.$databasename.'siterate where status!=1 order by name',$db); >> >> And i like that my query, that makes the type integer from siterate into >> the name text from sitetypes. >> >> Thanks forward for helping me. >> >> with best wishes >> >> >> Artur Reilin >> sqlite.yuedream.de >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users