O simplificare de cod

Threaded Mode | Linear Mode

O simplificare de cod

Author Message

Adry
De al casei

Posts: 50
Group: Registered
Joined: Mar 2008
Status: Offline
Reputation: 0
Lei: 158.51

Post: #1

O simplificare de cod

Am patru interogari in baza de date la 3 tabele diferite.

Cum as putea simplifica aceste operatiuni ?

This post was last modified: 05-03-2008 05:03 AM by Adry.

05-03-2008 04:58 AM

casperel
Designer incepator

Posts: 234
Group: Registered
Joined: Oct 2007
Status: Offline
Reputation: 0
Lei: 227.75

Post: #2

RE: O simplificare de cod

Nu mai bine gandesti tu mai bine structura tabelelor ?

http://www.zuma24.com - Joaca Zuma Online ;)
http://www.georgejipa.info - Blogging-ul... un continuu calcul matematic!

05-03-2008 05:44 AM

Reaper
Ucenic

Posts: 156
Group: Registered
Joined: Nov 2007
Status: Online
Reputation: 0
Lei: 170.51

Post: #3

RE: O simplificare de cod

Daca au aceeasi structura, acelasi nr de coloane folosesti UNION ALL:

PHP Code:

$q = "(SELECT * FROM table1";

$q1 = " UNION ALL (SELECT * table2)";

$q2 = " UNION ALL (SELECT * table3";

$q3 = " UNION ALL (SELECT * table4";

$q3 = "$q $q1 $q2 $q3";

  while($row = mysql_fetch_array($q3)){
     $var = $row['var'];
    } 

Dar observ ca ai structuri diferite, deci nu cred ca o sa-ti foloseasca...
Vezi poate te ajuta JOIN

Avatare si statusuri | Reap`s Blog
Agentii Imobiliare | Forex Trading

This post was last modified: 05-03-2008 07:33 AM by Reaper.

05-03-2008 07:32 AM

« Next Oldest | Next Newest »

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites

Forum Jump: