hbalagh

does anyone know if it will work

anyone?

I need to run a find and replace UPDATE post SET pagetext = replace(pagetext, "/Deep Water Culture", "deep-water-culture"); is this ok and it will only replace /Deep Water Culture with deep-water-culture or do i have to worry about it finding other references without the / in it and replacing it with deep-water-culture??

I need a search feature like the one found at http://www.time.com/time/ (if you click in the search box u can see what I need) I found this script below and was wondering if anyone knew how to alter it do something very similiar to what time magazine's site does... http://www.mediacollege.com/internet/javascript/form/multi-search.html any help is greatly appreciated Thanks

thank u

we have this page where we want the background of each job row to be altering (like on most message boards) here is the code, all help is greatly appreciated.. <?php $ratings=array(); $jobId = $_GET['jobId']; $pg = (int)$_GET['pg']; if(!isset($pg)) $pg=1; if(empty($pg)) $pg=1; ////get a list of phrase ids to search in $query = " SELECT id, category_id, job_title, post_date, location, contact_info, description, banned FROM job_content ORDER BY id DESC "; $jobs = mysqli_query($g_link, $query); $k=1; while ($job = mysqli_fetch_assoc($jobs)) { $query = " SELECT id, name, description FROM job_category WHERE id=".$job['category_id']." LIMIT 1 "; $joballs = mysqli_query($g_link, $query); while ($joball = mysqli_fetch_assoc($joballs)) { $jobName = $joball['name']; } unset($joball); $postdate = convert($job['post_date'], 'Y-m-d', 'M,d'); $jobArrs[$k] = $job['id']."__".$job['category_id']."__".$job['job_title']."__".$jobName."__".$postdate."__".$job['location']."__".$job['contact_info']."__".$job['description']; $k++; } unset($job); $numpgs = ceil(count($jobArrs)/25); if( $g_link != false ) mysqli_close($g_link); ?> <div class="pageright"> <?php if(count($jobArrs)==0){ ?> <h3>Currently there is no jobs, do you want to <a href="job_add.php?jobId=<?php echo $jobId?>&jobName=<?php echo $jobName?>">post</a> one?</h3> <?php } ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr><td colspan="4"> <div style="float:left; width:50%;"><a href="job_add.php">POST A NEW JOB</a></div><div style="float: left; text-align:right; width:50%;"> <a href="job_viewall.php?pg=<?php echo $pg>1?$pg-1:$pg;?>">PREVIOUS</a> | <?php for($j=1;$j<=$numpgs;$j++) if($pg==$j) echo "$j | "; else echo "<a href=\"job_viewall.php?pg=$j\">$j</a> | "; ?> <a href="job_viewall.php?pg=<?php echo $pg<$numpgs?$pg+1:$pg;?>">NEXT</a></div></td></tr> <tr style="background-color:#666666; height:20px; color:#ffffff;"><th width=15% align="center">Post Date</th><th width=30% align="center">Job Title</th><th width=25% align="center">Category</th><th width=30% align="center">Location</th></tr> <?php for ($i=25*($pg-1)+1;$i<=25*$pg;$i++){ if($i<=count($jobArrs)){ $job=$jobArrs[$i]; list($id, $categoryid, $jobTitle, $jobName,$post_date,$location,$contact_info,$description)=explode('__',$job); ?> <tr bgcolor="#ffffff" border=1px height="30px"> <td align="center"><?php echo $post_date;?></td> <td align="center" class="capitalize"><a href="job_viewdetail3.php?jobId=<?php echo $id?>"><?php echo $jobTitle;?></td> <td align="center" class="capitalize"><a href="job_view3.php?jobId=<?php echo $categoryid?>"><?php echo $jobName;?></a></td> <td align="center" class="capitalize"><?php echo $location;?></td> </tr> <?php } } ?> <tr><td colspan="4"> <div style="float:left; width:50%;"><a href="job_add.php">POST A NEW JOB</a></div><div style="float: left; text-align:right; width:50%;"> <a href="job_viewall.php?pg=<?php echo $pg>1?$pg-1:$pg;?>">PREVIOUS</a> | <?php for($j=1;$j<=$numpgs;$j++) if($pg==$j) echo "$j | "; else echo "<a href=\"job_viewall.php?pg=$j\">$j</a> | "; ?> <a href="job_viewall.php?pg=<?php echo $pg<$numpgs?$pg+1:$pg;?>">NEXT</a></div> </td></tr> </table> <br /><br /> <br /> </div>