Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function affil_vypis_detail($id){
- $dotaz = "SELECT * FROM affil_kampan WHERE id='$id'" ;
- $vysledek = mysql_query( $dotaz ) or die( mysql_error() );
- while ( $radek = mysql_fetch_array( $vysledek ) ) {
- $id=$radek['id'];
- $id_plochy=$radek['id_plochy'];
- $id_affilu=$radek['id_affilu'];
- $klicova_slova=$radek['klicova_slova'];
- $referal=$radek['referal'];
- $vzhled=$radek['vzhled'];
- $pocet_prvku=$radek['pocet_prvku'];
- $nazev=$radek['nazev'];
- $poznamka=$radek['poznamka'];
- $dotaz2 = "SELECT id, id_domeny, nazev FROM reklamni_plochy WHERE id='$id_plochy'" ;
- $vysledek2 = mysql_query( $dotaz2 ) or die( mysql_error() );
- while ( $radek2 = mysql_fetch_array( $vysledek2 ) ) {
- $id_domeny= $radek2['id_domeny'];
- $dotaz3 = "SELECT url FROM domeny WHERE id='$id_domeny'" ;
- $vysledek3 = mysql_query( $dotaz3 ) or die( mysql_error() );
- while ( $radek3 = mysql_fetch_array( $vysledek3 ) ) {
- $reklamni_plocha = $radek2['nazev']. " - ". $radek3['url'];
- }
- }
- $dotaz4 = "SELECT id,nazev,url FROM affil_soubory WHERE id='$id_affilu'" ;
- $vysledek4 = mysql_query( $dotaz4 ) or die( mysql_error() );
- while ( $radek4 = mysql_fetch_array( $vysledek4 ) ) {
- $affil = $radek4['nazev'];
- $affil_url = $radek4['url'];
- $affil_id = $radek4['id'];
- }
- }
- $affil_vypis["id"]=$id;
- $affil_vypis["affil"]=$affil;
- $affil_vypis["affil_url"]=$affil_url;
- $affil_vypis["affil_id"]=$affil_id;
- $affil_vypis["klicova_slova"]=$klicova_slova;
- $affil_vypis["referal"]=$referal;
- $affil_vypis["pocet_prvku"]=$pocet_prvku;
- $affil_vypis["vzhled"]=$vzhled;
- $affil_vypis["nazev"]=$nazev;
- $affil_vypis["poznamka"]=$poznamka;
- $affil_vypis["reklamni_plocha"]=$reklamni_plocha;
- return $affil_vypis;
- }
Add Comment
Please, Sign In to add comment