[sqlite] requesting 2 tables about one select

[Artur Reilin]

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