webguync

yea I do get the login prompt. I am using port 22. Can't get access still though.

is there a way to embed a flash file into an email and send that to someone and they be able to open up their email (such as gmail) and have the file play automatically? I have tried sending as an attachment, which requires downloading and clicking, but would prefer doing in the first way.

ok, thanks I will create a counter. I guess that is something for the PHP forum if I run into questions.

ok, well I am displaying the id info on a page using PHP so my numbering display is off now. The only other option I have is to re-upload my content to get the numbering order correct.

I have an auto incremented field in my table called id. The numbers were from 1-125. I had to delete one record with an id of 1. Now I want to change the numbering since it is from 2-125 now (back to 1 to the end). Is there a Query to do this without going into each individual record in PHP MyAdmin and doing it?

sorry, I forgot to mention it is a dedicated server.

I am trying to connect to my Linux server via PuTTy on my windows desktop. I have so far been unsuccessful. I called tech support of my hosting company (Media Temple), and all they could tell me is they could connect themselves. I don't think they were using PuTTy though. I am using the default setting. And putting in the correct host name. Then when the login prompt comes up. I put in ssh root@ipaddress.com. I keep getting access denied. I verified that the password I use is correct. and I believe the settings I am using are correct. Any other way to troubleshoot?

thanks for the response.

I noticed something weird on this page of my site . http://www.inspired-evolution.com/Graphics/ when you click in a graphic the header below the graphic moves up underneath the image prior to the click action. I am not sure if this is a CSS issue or JQuery since JQuery is being used to display the larger graphic. Anyway, here is the html/css code. Hoping someone may have some ideas. <div id="GraphicsContent"> <div id="Col1"> <dl> <dt>Better Health Naturally</dt> <dd> <a class="images" href="./images/BHN.jpg"><img class="last" alt="Better Health Naturally logo" src="./images/BHN_small.jpg" /></a> </dd> </dl> <dl> <dt>TREM USA</dt> <dd> <a class="images" href="./images/TREM_USA_Large.jpg"><img class="last" alt="TREM USA web graphic" src="./images/TREM_USA_Small.jpg" /></a> </dd> </dl> <dl> <dt>Arch Angel</dt> <dd> <a class="images" href="/images/imagine.jpg"><img class="last" alt="Imagine" src="/images/Imagine_small.jpg" /></a> </dd> </dl> <dl> <dt>Touche Touchet</dt> <dd> <a class="images" href="./images/ToucheTouchet_Large.jpg"><img class="last" alt="Touche Touchet Bakery" src="./images/ToucheTouchet_Small.jpg" /></a> </dd> </dl> </div><!--end col1 div--> <div id="Col2"> <dl> <dt>Groovy</dt> <dd> <a class="images" href="./images/GROOVY.jpg"><img class="last" alt="Groovy Graphic" src="./images/Groovy_small.jpg" /></a> </dd> </dl> <dl> <dt>Waterfall</dt> <dd> <a class="images" href="./images/waterfall_large.jpg"><img class="last" alt="Waterfall graphic" src="./images/waterfall_small.jpg" /></a> </dd> </dl> <dl> <dt>Electrifying</dt> <dd> <a class="images" href="./images/electrifying.jpg"><img class="last" alt="Electrifying graphic" src="./images/Electrifying_small.jpg" /></a> </dd> </dl> <dl> <dt>AllMedStar Logo</dt> <dd> <a class="images" href="./images/Allmedstarlogo.jpg"><img class="last" alt="Allmedstar Logo" src="./images/AMS_small.jpg" /></a> </dd> </dl> </div><!--end Col2--> </div><!--end graphic container--> /*used on graphics page*/ #GraphicsContent{ width:85%; margin:40px 0 auto 0; padding:0 60px 30px 60px; border:solid 1px #cbcbcb; background:#fafafa; -moz-box-shadow: 0 0 10px #cbcbcb; -webkit-box-shadow: 0 0 10px #cbcbcb; box-shadow: 0 0 10px #cbcbcb; overflow:auto; } #GraphicsContent dl{ opacity:1; } #GraphicsContent dl dt{ -moz-border-radius:18px; -webkit-border-radius:18px; border-radius:18px; /*IE 7 AND 8 DO NOT SUPPORT BORDER RADIUS*/ -moz-box-shadow:0px 0px 7px #000000; -webkit-box-shadow:0px 0px 7px #000000; box-shadow:0px 0px 7px #000000; /*IE 7 AND 8 DO NOT SUPPORT BLUR PROPERTY OF SHADOWS*/ background-image: -moz-linear-gradient(top, #697eff, #8fe1ff); background-image: -webkit-gradient(linear, center top, center bottom, from(#697eff), to(#8fe1ff)); background-image: -o-linear-gradient(top, #697eff, #8fe1ff); filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#697eff', endColorstr='#8fe1ff'); /*INNER ELEMENTS MUST NOT BREAK THIS ELEMENTS BOUNDARIES*/ /*Element must have a height (not auto)*/ /*All filters must be placed together*/ -ms-filter: "progid:DXImageTransform.Microsoft.gradient(startColorstr='#697eff', endColorstr='#8fe1ff')"; /*Element must have a height (not auto)*/ /*All filters must be placed together*/ background-image: linear-gradient(top, #697eff, #8fe1ff); -moz-background-clip: padding-box; -webkit-background-clip: padding-box; background-clip: padding-box; /*Use "background-clip: padding-box" when using rounded corners to avoid the gradient bleeding through the corners*/ /*--IE9 WILL PLACE THE FILTER ON TOP OF THE ROUNDED CORNERS--*/ width:100%; color:#fff; font-weight:bold; font-size:14px; margin-bottom:20px; text-align:center; margin:35px 0 35px 0; padding:5px 10px 5px 10px; opacity:1; } #GraphicsContent dd { -moz-border-radius: 10px; -webkit-border-radius: 10px; border-radius: 10px; color: #000; font-family: Arial, Helvetica, sans-serif; -moz-box-shadow: 3px 8px 4px #333; -webkit-box-shadow: 3px 8px 4px #333; box-shadow: 3px 8px 4px #333; -ms-filter: "progid:DXImageTransform.Microsoft.Shadow(Strength=4, Direction=135, Color='#333')"; filter: progid:DXImageTransform.Microsoft.Shadow(Strength=4, Direction=135, Color='#333'); background: #e3e3e3; padding:15px; margin:20px 0 20px 0; opacity: 1; } #GraphicsContent dd a.images{ text-align:center; background:none; } #Col1 { float:left; } #Col2 { float:right; }

I tried that way, but still don't see the change to the iPad simulator. Maybe the simulator isn't accurate. <!--[if !IE]>--> <link type="text/css" rel="stylesheet" media="only screen and (max-device-width: 480px)" href="CSS/iPhone.css" /> <link type="text/css" rel="stylesheet" media="only screen and (min-device-width: 768px) and (max-device-width: 1024px)" href="CSS/iPad.css" /> <!--<![endif]--

I am trying to adjust my styles to fix a few things when I view the site on the iPad. I don't have an iPad, but I am using a simulator app I found on the internet (http://ipadpeek.com/). I created a specific style-sheet for the iPad and I am accessing it with the following code. <link rev="made" href="mailto:webguync@gmail.com" /> <link rel="stylesheet" media="only screen and (min-device-width: 768px) and (max-device-width: 1024px)" href="CSS/iPad.css"type="text/css" /> the style-sheet attributes are not getting picked up when I view in the simulator. I tried placing the code for the iPad specific style-sheet above and below where I am linking my main style-sheet and neither worked. Any ideas?

I checked my website on an iPad recently and it's a bit wonky in iPad web viewing and probably other hand held devices. I want to create a stylesheet targeting handheld devices only. What is the best way to accomplish this?

Thanks for the response. I will try that out and post again with more specific information.

any ideas on how to achieve what I need?

Hi, I have a search form which pulls info from a MySQL table and there are a few enhancements I would like to make. 1) I would like the search terms in my results table hilited in red. I made a class in my stylesheet for this, but it isn't working so I am missing a step or two 2) I would like a display for the number of results returned. Example. "There were 3 results found in your search". 3) This isn't php related, but if anyone has any ideas why my JQuery slideup doesn't work with my results let me know. I have posted in the JavaScript section, but haven't gotten a response. My code. <html> <head> <link href="default.css" rel="stylesheet" type="text/css" media="screen" /> <script src="js/jquery.js"></script> <script src="js/jquery-fonteffect-1.0.0.js"></script> <script type="text/javascript"> $("#mirror").FontEffect({ outline:true }) </script> <script type='text/javascript'> var $ = jQuery.noConflict(); $(document).ready(function(){ $("#search_results").slideUp(); $("#search_button").click(function(e){ e.preventDefault(); ajax_search(); }); // $("#search_term").keyup(function(e){ // e.preventDefault(); // ajax_search(); // }); }); function ajax_search(){ $("#search_results").show(); var search_val=$("#search_term").val(); $.post("./find.php", {search_term : search_val}, function(data){ if (data.length>0){ $("#search_results").html(data); $(document).ready(function(){ $(".stripeMe tr").mouseover(function(){$(this).addClass("over");}).mouseout(function(){$(this).removeClass("over");}); $(".stripeMe tr:even").addClass("alt"); }); } }) } </script> <meta http-equiv="Content-Type" content="text/html; charset=iso- 8859-1" /> <title>Novo RPC Results Search Engine</title> <link href="default.css" rel="stylesheet" type="text/css" media="screen" /> </head> <body> <div id="mirror">Search RPC participants</div> <form id="searchform" method="post" action="find.php"> <div> <label for="search_term">Search RPC information</label> <input type="text" name="search_term" id="search_term" /> <input type="submit" value="search" id="search_button" /> </div> </form> <div id="search_results"></div> </body> </html> <?php define(HOST, "localhost"); define(USER, "username"); define(PW, "pw"); define(DB, "DBName"); $connect = mysql_connect(HOST,USER,PW) or die('Could not connect to mysql server.' ); mysql_select_db(DB, $connect) or die('Could not select database.'); $term = strip_tags(substr($_POST['search_term'],0, 100)); $term = mysql_escape_string($term); $sql = "SELECT * FROM Phase1A_1B_TotalScores_2011 WHERE CONCAT(last_name,first_name,employee_id,title,territory,district,Phase1A_Score,Phase1B_HS_Exam, Phase1A_HS_Exam_RT,Phase1B_HS_Exam ,Phase1B_HS_Exam_RT,Class_Date) LIKE '%$term%' order by last_name asc"; $string = ''; $string = "<table class='stripeMe' id='Results'><tr><th>Last Name</th><th>First Name</th><th>Employee ID</th><th>Title</th><th>Territory</th><th>District</th><th>Phase 1A Score</th><th>Phase 1B Score</th><th>Phase 1 Average</th><th>Phase 1A HS Exam</th><th>Phase 1A HS Exam Retake</th><th>Phase 1B HS Exam</th><th>Phase 1B HS Exam Retake</th><th>Class Dates</th><th>Awards</th></tr>"; $result = mysql_query($sql); /// This is the execution if (mysql_num_rows($result) > 0){ while($row = mysql_fetch_object($result)){ $string .= "<tr>"; $string .= "<td>".$row->last_name."</td> "; $string .= "<td>".$row->first_name."</td>"; $string .= "<td>".$row->employee_id."</td>"; $string .= "<td>".$row->title."</b>"; $string .= "<td>".$row->territory."</td>"; $string .= "<td>".$row->district."</td>"; $string .= "<td>".$row->Phase1A_Score."</td>"; $string .= "<td>".$row->Phase1B_Score."</td>"; $string .= "<td>".$row->Phase1_Average."</td>"; $string .= "<td>".$row->Phase1A_HS_Exam."</td>"; $string .= "<td>".$row->Phase1A_HS_Exam_RT."</td>"; $string .= "<td>".$row->Phase1B_HS_Exam."</td>"; $string .= "<td>".$row->Phase1B_HS_Exam_RT."</td>"; $string .= "<td>".$row->Class_Date."</td>"; $string .= "<td>".$row->Awards."</td>"; $string .= "<br/>\n"; $string .= "</tr>"; //print_r($row); } $string .= "</table>"; }else{ $string = "<span class='NMF'>No matches found!</span>"; // echo $sql; } echo $string; ?> and lastly my CSS /*search term styling*/ #search_term{ font-weight:bold; color:#f00; }

as an emendment to my problem, I have my row striping working now, but not the slide up. <html> <head> <script src="js/jquery.js"></script> <script type='text/javascript'> $(document).ready(function(){ $("#search_results").slideUp(); $("#search_button").click(function(e){ e.preventDefault(); ajax_search(); }); }); function ajax_search(){ $("#search_results").show(); var search_val=$("#search_term").val(); $.post("./find.php", {search_term : search_val}, function(data){ if (data.length>0){ $("#search_results").html(data); $(document).ready(function(){ $(".stripeMe tr").mouseover(function(){$(this).addClass("over");}).mouseout(function(){$(this).removeClass("over");}); $(".stripeMe tr:even").addClass("alt"); }); } }) } </script> <meta http-equiv="Content-Type" content="text/html; charset=iso- 8859-1" /> <title>Novo RPC Results Search Engine</title> <link href="default.css" rel="stylesheet" type="text/css" media="screen" /> </head> <body> <h1>Search RPC participants</h1> <form id="searchform" method="post" action="find.php"> <div> <label for="search_term">Search RPC information</label> <input type="text" name="search_term" id="search_term" /> <input type="submit" value="search" id="search_button" /> </div> </form> <div id="search_results"></div> </body> </html> I tried moving the slide up code after this line $("#search_results").html(data); but the JQuery is broken when I do that. Any ideas on what I need to do to get my slide up to work? I can post a link to my form if needed.

I think I like that better, much cleaner. Thx!

I have some SQL fpr a search form that I am working on which searches across a MySQL table. There are quite a few fields I want searchable and I currently have the code as such $term = strip_tags(substr($_POST['search_term'],0, 100)); $term = mysql_escape_string($term); $sql = "select * from Phase1A_1B_TotalScores_2011 where last_name like '%$term%' or first_name like '%$term%' or employee_id like '%$term%' or title like '%$term%' or territory like '%$term%' or district like '%$term%' or Phase1A_Score like '%$term%' or Phase1B_HS_Exam like '%$term%' or Phase1A_HS_Exam_RT like '%$term%' or Phase1B_HS_Exam like '%$term%' or Phase1B_HS_Exam_RT like '%$term%' or Class_Date like '%$term%' I understand it is not a good idea to use a bunch of OR clauses. Is there a way to simplify this?

I think I just need to add live() to my JQuery syntax, but not sure how I would go about doing that to this. $("#search_results").slideUp(); anyone done something like this previously?

any more ideas on this. Here is my latest attempt with my initial code commented out. <html> <head> <script src="js/jquery.js"></script> <script type='text/javascript'> $.get('find.php', function(data){ // insert new html from ajax $("#search_results").html(data); // html is now in page so can call jQuery methods on it $(".stripeMe tr").mouseover(function(){$(this).addClass("over");}) .mouseout(function(){$(this).removeClass("over");}); $(".stripeMe tr:even").addClass("alt"); }) //function ajax_search(){ // $("#search_results").show(); // var search_val=$("#search_term").val(); // $.post("./find.php", {search_term : search_val}, function(data){ //if (data.length>0){ // $("#search_results").html(data); // } //}) //} </script> <meta http-equiv="Content-Type" content="text/html; charset=iso- 8859-1" /> <title> Results Search Engine</title> <link href="default.css" rel="stylesheet" type="text/css" media="screen" /> </head> <body> <h1>Search results</h1> <form id="searchform" method="get"> <div> <label for="search_term">Search Results</label> <input type="text" name="search_term" id="search_term" /> <input type="submit" value="search" id="search_button" /> </div> </form> <div id="search_results"></div> </body> </html>

Hi, I am trying to pull data from a MySQL database using PHP and AJAX while displaying with some JQuery functionality. The form works as intended in that the data gets pulled, but my JQuery affects aren't working. A little research in another forum produced that I need to bind the data, but what I have tried so far hasn't worked. Here is the code. <html> <head> <script src="js/jquery.js"></script> <script type='text/javascript'> $(document).ready(function(){ $("#search_results").slideUp(); $("#search_button").click(function(e){ e.preventDefault(); ajax_search(); }); $("#search_term").keyup(function(e){ e.preventDefault(); ajax_search(); }); }); $(".stripeMe tr").live('mouseover',function(){$(this).addClass("over");}) .live('mouseout',function(){$(this).removeClass("over");}); //$.get('find.php', function(data){ // insert new html from ajax // $("#search_results").html(data); // $(".stripeMe tr:even").addClass("alt"); //}) function ajax_search(){ $("#search_results").show(); var search_val=$("#search_term").val(); $.post("./find.php", {search_term : search_val}, function(data){ if (data.length>0){ $("#search_results").html(data); } }) } </script> <meta http-equiv="Content-Type" content="text/html; charset=iso- 8859-1" /> <title>Novo RPC Results Search Engine</title> <link href="default.css" rel="stylesheet" type="text/css" media="screen" /> </head> <body> <h1>Search RPC results</h1> <form id="searchform" method="post"> <div> <label for="search_term">Search name/phone</label> <input type="text" name="search_term" id="search_term" /> <input type="submit" value="search" id="search_button" /> </div> </form> <div id="search_results"></div> </body> </html> the commented out get method is what I got from another forum and again I tried it and the Database display doesn't work.Right now the data displays, but I want it to slide in and it doesn't.

yes, that gives me what I need, thx!

apparently I am doing this wrong. I want my string results from a form that searches DB content to appear within HTML table, tr, td tags. I get the results fine, but the HTML part isn't appearing. How should I be doing this? <?php $string = ''; $result = mysql_query($sql); /// This is the execution if (mysql_num_rows($result) > 0){ while($row = mysql_fetch_object($result)){ echo "<table>"; echo "<tr>"; $string .= "<td>".$row->last_name."</td> "; $string .= "<td>".$row->first_name."</td>"; $string .= "<td>".$row->employee_id."</td>"; $string .= "<td>".$row->title."</b>"; $string .= "<td>".$row->territory."</td>"; $string .= "<td>".$row->district."</td>"; $string .= "<td>".$row->Phase1A_Score."</td>"; $string .= "<td>".$row->Phase1B_Score."</td>"; $string .= "<td>".$row->Phase1_Average."</td>"; $string .= "<td>".$row->Phase1A_HS_Exam."</td>"; $string .= "<td>".$row->Phase1A_HS_Exam_RT."</td>"; $string .= "<td>".$row->Phase1B_HS_Exam."</td>"; $string .= "<td>".$row->Phase1B_HS_Exam_RT."</td>"; $string .= "<td>".$row->Class_Date."</td>"; $string .= "<td>".$row->Awards."</td>"; $string .= "<br/>\n"; echo "</tr>"; echo "</table>"; } }else{ $string = "No matches found!"; } echo $string; ?>

that makes sense, thanks!

I thought this part of the code did that. Guess not huh? if (mysql_num_rows($result) > 0){ while($row = mysql_fetch_object($result)){ $string .= "<b>".$row->name."</b> - "; $string .= $row->phone."</a>"; $string .= "<br/>\n"; }