request mysql...

[Tr3z3gu3T]

nu ma descurc cu ceva...

am 1 bz de date 2 table: movies, images.

Code:

include "input/connect.php"; $sql="SELECT movies.id, movies.zzz, movies.original_name, images.id, images.zzz, images.image FROM movies, images WHERE movies.zzz = images.zzz ORDER BY movies.id LIMIT 10"; $result = mysql_query($sql); while($row = mysql_fetch_row($result)) { ?> <?php echo $row['original_name']; ?> <br> <?php echo $row['image']; ?> <br> <?php } mysql_close($con); ?>

legatura dintre cele 2 este campul zzz prezent in ambele tabele
cum fac sa rezulte echo insa doar o singura data title => image , deoarece in mom de fata face echo la fiecare titlu => de fix X ori cate poze am in tabela cu imagini




tare as fi recunoscator pentru un pic de luminare.... ca deja nu mai pot cate variante am incercat si tot nu imi reuseste . multumesc
si daca nu prea m-am exprimat pe inteles... scuze nam dormit de ore bune cu asta

[Shocker]

Nu inteleg

FREAKZ COMMUNITY @ Facebook
WOW FREAKZ @ Facebook

[Tr3z3gu3T]

deci repet

am intr-o singura baza de date 2 tabele movies,images .

in images retin mai multe fielduri(poza2) pentru fiecare field din movies(poza1).

acum in index.php (exemplu) as dori sa afisez ultimele 10 id-uri retinute in movies si pentru fiecare ultimul id retinut in images unde movies.zzz = images.zzz

gen :

Code:

SELECT movies.*, images.* FROM movies, images WHERE (movies.zzz = images.zzz LIMIT 1) ORDER BY id LIMIT 10 DESC

dar comanda de sus nui buna

[nr913]

SELECT m.*, i.* FROM movies m, (SELECT k.* FROM images k, movies p WHERE k.zzz=p.zzz LIMIT 0,1) i ORDER BY m.id LIMIT 10 DESC

Attitude - A little thing that makes a BIG difference

[Shocker]

Nu poti cu un singur query. Cu unul iei ultimele 10 ids si cu al doilea iei imaginile corespunzatoare ID-urilor alora

FREAKZ COMMUNITY @ Facebook
WOW FREAKZ @ Facebook

[Tr3z3gu3T]

am rezolvat altfel pana la urma am retinut toate imaginile intrun camp in movies.images

Code:

@03d/4c36037a7b9aa102cc00003d/some-like-it-hot/jpg@1b6/4c30baeb5e73d63ccd0001b6/some-like-it-hot/jpg@a99/4bc9058d017a3c57fe001a99/some-like-it-hot/png@140/4c7ebc775e73d648e2000140/some-like-it-hot/jpg@157/4c7ebc535e73d648de000157/some-like-it-hot/jpg@146/4c7ebca05e73d648e2000146/some-like-it-hot/jpg@155/4c7ebcc05e73d648df000155/some-like-it-hot/jpg@15d/4c7ebcd35e73d648de00015d/some-like-it-hot/jpg

si am lucrat cu foreach, in unele cazuri index.php am extras prima poza in altele toate
bineinteles m-am folosit si de split("@",$row['images'])

cat despre query-ul tau nr913 ramane la bookmarks de testat pt proiectele viitoare thx

[Shocker]

Daca chair vrei asa foloseste implode() si explode() pe viitor, sau serialize() si unserialize()

FREAKZ COMMUNITY @ Facebook
WOW FREAKZ @ Facebook