Jump to content

retrieve coding from data


Spraban9

Recommended Posts

SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`(SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from computerrepair union SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from computersale union SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from land union SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from house union SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from vechicle union SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from mobile)A order by postdate

hi friends

this coding is used to retrievee data from all table in descending order of posedate

but it is not working

Link to comment
https://forums.phpfreaks.com/topic/276264-retrieve-coding-from-data/
Share on other sites

create view alltable as(SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from computerrepair
union
 SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from computersale
 union
SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from land
 union
 SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from house
union
 SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from vechicle
union
 SELECT `title`,`city`,`address`,`description`,`contact`,`postdate`from mobile)order by postdate

 

this also not working

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.