regoch

gonna try, thanks for help!

I got mysql with list if people and one of field in base is date of birth in date format. So I have two questions. 1. Hot to get poeple age from date of brith field? 2. How to get all people that are younger then 45 years.

echo "<p><a href='/products/product.php?ID=".$result['ID']." 'class='productlink'' 'rel='nofollow''>".$result['description']."</a> <a href='/products/product.php?ID=".$result['ID']."><img src='".$result['awImage']."'/> </a>

echo "<a href='#' onClick='window.open('".mysql_result($result, $i, 'te_link')."');'>link text</a>"; This?

No problem, finaly I help somebody, not getting helped, haha!

$info_id = $_POST['info_id']; $info_dodatni_posao = join(", ", $_POST['info_dodatni_posao']); $qry = "UPDATE tz_info SET info_dodatni_posao='$info_dodatni_posao' WHERE info_id='$info_id'"; $result = @mysql_query($qry); I add join() in second line and get all multiple post in one field in database with , between like this Full Time, Full Time Rotational, Freelance

foreach($results as $result){ echo "<p> <strong>".$result['description']."</strong> <br><a href='/products/product.php?ID=".$result['ID']." rel='nofollow'>".$result['description']."</a> <a href='/products/product.php?ID='".$result['ID']."><img src='".$result['awImage']."'/> </a> </p>"; } Try this, to me its working!

join() do the work! Thanks!

Hi! I got this script for inserting jobs from multiple select, but can not get it work. I wonna all data from "select info_dodatni_posao" to get in one variable and put it in mysql database. I try this way thats below but not working! Any ideas? When I remove [] i get it to put just one job in mysql even if i select 3 or more. test.html <select multiple="multiple" name="info_dodatni_posao[]" id="info_dodatni_posao[]"> <option value='Certified Beauty Therapist'>Certified Beauty Therapist</option><option value='Certified Dive Master'>Certified Dive Master</option><option value='Certified Diver'>Certified Diver</option><option value='Certified Hair Dresser'>Certified Hair Dresser</option><option value='Certified Personal'>Certified Personal</option></select> test.php $info_id = $_POST['info_id']; $info_dodatni_posao = $_POST['info_dodatni_posao[]']; $qry = "UPDATE tz_info SET info_dodatni_posao='$info_dodatni_posao' WHERE info_id='$info_id'"; $result = @mysql_query($qry);

Thanks!

If is this posible? To have 3-4 pictures on page, user chose one, type in messagge and friends e-mail and send. So friend gets in mail picture and message from user, not just link where he can see picture, but picture insert in mail.

Thanks!

1. So I have to ask my hosting? 2. You think javascript or jquery?

1. How big pdf file can be uploaded to hosting? I work on page for news company, and they won.t to upload via cms actual number of news. Is it posible via cms or must be via ftp. I got this script for upload pdf that working fine. <form action="" method="post" name="fileForm" id="fileForm" enctype="multipart/form-data"> <center> <table> <tr><td style="width:150px;">Naziv PDF-a HR: </td><td><input name="pdf_ime_hr" type="text" class="textfield" id="pdf_ime_hr" /></td></tr> <tr><td style="width:150px;">Naziv PDF-a EN: </td><td><input name="pdf_ime_en" type="text" class="textfield" id="pdf_ime_en" /></td></tr> <tr><td style="width:150px;">Odaberi pdf za upload:</td><td><input name="upfile" type="file" size="36"></td></tr> <tr><td style="width:150px;"></td><td align="lef"><br/><input type="submit" name="Submit" id="Submit" value="Pošalji" /></td></tr> </table></center> </form> <?php $novost_id = $_GET['novost_id']; if (isset($_POST['Submit'])){ $pdf_ime_hr = $_POST['pdf_ime_hr']; if ($pdf_ime_hr == '') { echo "Niste upisali naziv PDF-a"; } else { ?> <div id="result"> <table width="100%"> <?php function getExtension($str) { $i = strrpos($str,"."); if (!$i) { return ""; } $l = strlen($str) - $i; $ext = substr($str,$i+1,$l); return $ext; } $pdf_naziv = stripslashes($_FILES['upfile']['name']); $extension = getExtension($pdf_naziv); $extension = strtolower($extension); $ran_name = rand () ; $pdf_naziv = 'kus'.$ran_name.'.'.$extension; $allowed = array('pdf'); $uploadLocation = "../pdf/$pdf_naziv"; if(in_array($extension, $allowed)) { if(move_uploaded_file($_FILES['upfile']['tmp_name'], $uploadLocation)) { $pdf_ime_hr = $_POST['pdf_ime_hr']; $pdf_ime_en = $_POST['pdf_ime_en']; echo " <table width='400px' align='center' cellspacing='0'> <tr bgcolor='#E6e6e6' height='26'> <td align='center' width='100%' colspan='2'><strong>Potvrda</strong></td> </tr> <tr bgcolor='#F6f6f6'> <td align='center' style='border-left:#E6e6e6 1px solid;border-bottom:#E6e6e6 1px solid;'><img src='images/valid.png'></td> <td align='center' width='80'% style='border-right:#E6e6e6 1px solid;border-bottom:#E6e6e6 1px solid;'><strong>".$pdf_naziv." uspješno unesen.</strong></td> </tr> </table><br />"; mysql_query("INSERT INTO pdf SET pdf_naziv='$pdf_naziv', pdf_ime_hr='$pdf_ime_hr', pdf_ime_en='$pdf_ime_en', pdf_novost='$novost_id'"); } else{ echo " <table width='400px' align='center' cellspacing='0'> <tr bgcolor='#E6e6e6' height='26'> <td align='center' width='100%' colspan='2'><strong>Potvrda</strong></td> </tr> <tr bgcolor='#F6f6f6'> <td align='center' style='border-left:#E6e6e6 1px solid;border-bottom:#E6e6e6 1px solid;'><img src='images/warning.png'></td> <td align='center' width='80'% style='border-right:#E6e6e6 1px solid;border-bottom:#E6e6e6 1px solid;'><strong>PDF nije unesen.</strong></td> </tr> </table><br />";; } } else { echo "Pokušali ste uploadati datoteku koja nije PDF"; } ?> </table> </div> <?php } } ?> 2. Is it posible to add on page script that change desktop background. Exapmle i have 3 pictures for wall paper and user choose wich to put as desktop background?

RewriteRule ^hr/fotogalerija/(.*)/(.*)/(.*)$ /galerija.php?id_galerije=$1&galerija_seo=$2&page=$3 After hours spend, htacess solved thing!