Displaying 1 result from an estimated 1 matches for "modify_timestamp".
2006 Jan 10
0
Paginate with two tables ?
...d answer
(problem is little diffrent)
Hello, I have problem with display information from two tables using
paginate..
Here is code.
##### SQL
create table subscribers (
id integer not null auto_increment,
name varchar(32) not null,
surname varchar(64) not null,
create_timestamp DATETIME not null,
modify_timestamp DATETIME not null,
primary key (id));
create table contracts (
id integer auto_increment,
subscriber_id integer,
service_id integer,
sign_date timestamp,
representative varchar(128) not null,
constraint fk_subscriber foreign key(subscriber_id) references
subscribers(id),
primary key(id));
There...