tutoriale photoshop, brushes, patterns, gradient
Site afiliat proiectului Wtricks.com
   
   
  REGULAMENT | Search | Members | Calendar | Help  
 


Post Reply  Post Thread 
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 ?


Finalizate - >      | Adry.ro | Utile.php | Cercetasii | Yahoo Secrets |
In constructie -> |   worldoffifa.com   |
Un programator mediocru traieste cu impresia ca 1 kB = 1000 B. Un programator adevarat e convins ca 1 km = 1024 m

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

05-03-2008 04:58 AM
Visit this users website Find all posts by this user Quote this message in a reply
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
Find all posts by this user Quote this message in a reply
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
Find all posts by this user Quote this message in a reply
Post Reply  Post Thread 

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

Forum Jump:

 

 Invatam Net
Esti nou pe aici? Vorbeste-ne despre tine.
Citeste articole si tutoriale unice.
Ai un site? Iti putem oferi un review.

  Parteneri

  

  

  UNIX, Linux, Programare si Scripting pentru incepatori

  

-->