DiigIT Top Articles

<rss version="2.0">
<channel>
<title>DiigIT Top Articles</title>
<description>DiigIT</description>
<link>http://www.diigit.com/</link>
<lastBuildDate>Sun, 27 Dec 2009 07:45:56 PST</lastBuildDate>
<generator>DiigIT.com</generator>
<copyright>Copyright 2005-08, DiigIT</copyright>
<language>en</language>

<item>
      <title>How can you delete or detach database in order to move it to another place if the connections are open with the database.</title>
      <link>http://dotnet.diigit.com/ask-questions/delete-detach-database-order-move-another-place-connections.html</link>
      <description>ltpgtIn some cases you want to delete or detach database in order to move it to another placeltbr gtBut you cant do it if there are connections open with this database so you can use this procedure toampnbspstop all the connections with the databaseltpgtltpgtNoteltbr gtDont do this if the database on a production serverltpgtltpgtltbr gtCREATE PROCEDURE dbokillDataBaseConnections DatabaseName varchar50 WithMessage bit1ltbr gtASltbr gtSET NOCOUNT ONltbr gtDECLARE spidstr varchar8000ltbr gtDECLARE ConnectionKilled smallintltbr gtSET ConnectionKilled0ltbr gtSET spidstr  ltpgtltpgtIF dbidDatabaseName amplt 4 BEGINltbr gtPRINT No can doltbr gtRETURNltbr gtENDltpgtltpgtSELECT spidstrCOALESCEspidstr kill CONVERTVARCHAR spid  ltbr gtFROM mastersysprocesses WHERE dbiddbidDatabaseNameltpgtltpgtIF LENspidstr ampgt 0ltbr gtBEGINltbr gtEXECspidstrltpgtltpgtSELECT ConnectionKilled  COUNT1ltbr gtFROM mastersysprocesses WHERE dbiddbidDatabaseNameltpgtltpgtENDltpgtltpgtIF WithMessage 1ltbr gtPRINT CONVERTVARCHAR10 ConnectionKilled   Connections killed for DB   DatabaseNameltpgt </description>
      <pubDate>Thu, 24 Dec 2009 23:30:58 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/ask-questions/category/dotnet.html'>DOTNET</a></category>      
</item>

<item>
      <title>How to be a Creative Programmer</title>
      <link>http://dotnet.diigit.com/ask-questions/creative-programmer.html</link>
      <description>ltpgtltbgt1 Learn a new languageltbgtltbr gtProgrammers are constantly learning new languages either for fun or necessity Donamprsquot limit yourself to what just what you know and are comfortable with Branch out and learn a new skillltpgtltpgtltbgt2 Start from the ground upltbr gtltbgtIf youamprsquore going to write software you canamprsquot just start halfway through the project You have to start at square one Sometimes this is the best way to find a creative solution for a problem is to go back to the beginning and work forwardltpgtltpgtltbgt3 Question everythingltbgtltbr gtQuestioning everything means taking every assumption and making sure itamprsquos correct All programming starts with making the most basic assumptions and then building on those basic assumptions If something is wrong with the code at the base then the software isnamprsquot going to work well at allltbr gtSometimes creativity is limited by assumptions New solutions arrive when we tear down assumptions and start with fresh perspectivesltpgtltpgtltbgt4 Do it for funltbr gtltbgtIf you know any programmers theyamprsquore constantly building something Even when theyamprsquore done for the day on workrelated projects theyamprsquoll spend hours of time working on fun projects for themselves Their work is also their hobbyltbr gtContinually mulling over new ideas and solutions is something that shouldnamprsquot be a chore It should be something that you find yourself doing constantly like a reflex And it should excite youltpgtltpgtltbgt5 Never stop testing ideasltbr gtltbgtProgrammers are constantly benchmarking code to make sure that itamprsquos as efficient as possible Even the smallest change can bring a program or Web site to itamprsquos knees so constant testing and improvement is important to any bit of softwareltbr gtIdeas should be tested rigorously and refined on a consistent basis Your ideas will change over time it just depends how much Constantly evaluating them and just plain thinking them through is a great way to ampldquobenchmarkamprdquo your idealtpgtltpgtltbgt6 Find a passionltbgtltbr gtIf youamprsquove ever spent more than two minutes talking with a programmer about his work youamprsquoll find out very quickly that programmers have a passion for what they do They eat sleep and breathe programmingltbr gtDo you have a passion for your ideas and projectsltpgtltpgtltbgt7 Master your toolsltbgtltbr gtProgrammers constantly improve their knowledge and usage of their tools A great coder keeps tabs on software and is constantly finding ways to improve his usage of them Youamprsquoll seldom find a programmer who doesnamprsquot tweak his toolbox regularlyltbr gtNo matter what your skill set youamprsquore limited to your skill with the tools you use to create The more of an expert you are with your tools the more youamprsquoll be able to createltbr gtampnbspltpgtltpgtltbgt8 Start making abstract associationsltbr gtltbgtWhat if you used computers as telephonesltbr gtWhat would happen if you used a web site as a Word processorltbr gtWould people care about what other people are doing right nowltbr gtThe people behind projects like Skype Google Docs and Twitter all have one thing in common They fused seemingly abstract concepts together Taking whatifs and testing them is a great way to start thinking of things in a different more creative lightltpgtltpgtltbgt9 Think of structure as a tool not a limitationltbr gtltbgtPeople associate creativity with taking a giant blank canvas and letting our ideas flow without any sort of limiting structures However thereamprsquos a huge problem with this type of thinking Itamprsquos a great big creativity mythltbr gtSee limitations are everywhere We canamprsquot avoid them we can only hope to work with them A programmer embraces the limitations of his programming language or tools and works around them These limitations help him as they make a foundation to work from Sometimes discovering a new workaround will lead to an even bigger idea Necessity is the mother of inventionltpgtltpgtltbgt10 Donamprsquot rule anything out until you try itltbgtltbr gtYour kindergarten teacher was right There is no such thing as a stupid question If youamprsquore adhering to 3 and dismissing all assumptions you canamprsquot be certain itamprsquos not going to work until youamprsquove tested it How do you know it wonamprsquot work unless you try it You might be surprised Even if the proposed solution doesnamprsquot work it may help you find a solutionltbr gtSometimes itamprsquos just best to start with a prototype and try it out If your prototype doesnamprsquot work then trash it If it does youamprsquoll have stumbled upon something that just might workltpgtltpgtltbgt11 Always look for a simpler and more elegant solutionltbr gtltbgtA good programmer is one that understands that finding the simplest solution is always going to be better Complicated solutions lead toamphellip complications A practical approach to programming always works best in the long runltbr gtOur ideas sometimes become too complicated We get caught up in the novelty of the idea that we ignore how practical it really is The simplest way to solve a problem is often the best way to solve a problemltpgtltpgtltbgt12 Donamprsquot be afraid to build off the code of othersltbgtltbr gtThe beauty of the Internet is that the solution your looking for has probably already been done by someone else When building a new site I almost always use preexisting open source code Why recreate the wheelltbr gtPutting a great idea into motion doesnamprsquot mean you have to start from scratch to create it Use existing ideas and turn them in to something better Sometimes a great idea is only modifying something thatamprsquos already been done Gmail is a great example They ampldquoreinventedamprdquo email by adding useful features to traditional emailltpgtltpgtltbgt13 Donamprsquot be afraid to collaborateltbgtltbr gtSome of the best coding ampmdash or any creative projects for that matter ampmdash are done not just by one coder but by many excellent people inspired to work toward the same goal Assemble a great team use the most brilliant ideas no matter who they come from and let everyone contributeltpgtltpgtltbgt14 From the very basic create the beautifulltbr gtltbgtProgrammers often use some very basic code over and over and while those small bits of programming language arenamprsquot necessarily beautiful in and of themselves they can come together to create a final product that is amazing No matter what creative project youamprsquore working on pay attention to the details but most especially pay attention to the effect those details have on the overall pictureltbr gtampnbspltpgt </description>
      <pubDate>Thu, 24 Dec 2009 23:19:05 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/ask-questions/category/dotnet.html'>DOTNET</a></category>      
</item>

<item>
      <title>Five rules of variable naming</title>
      <link>http://dotnet.diigit.com/ask-questions/five-rules-variable-naming.html</link>
      <description>ltpgtltbgt1 Make your variable names long and descriptiveltbgtltbr gtVisual Studio has IntelliSense Eclipse has its own code completion and Im sure whatever IDE youre using can finish your variable names off for you too Using long names prevents the ambiguity of short or cryptic namesltpgtltpgtltbgt2 Put units in your variable namesltbgtltbr gtIf you are writing an engineering application you are going to be using variables with units Embed the unit name in the variable for example distanceInMMltpgtltpgtltbgt3 If you are using Camel Case dont capitalize commonly hyphened or combined wordsltbgtltbr gtLet me explainCallback is normally spelt as one word So pretty please dont call your variable callBackltpgtltpgtltbgt4 Never ever use the variable name templtbgtltbr gtThe only perfectly valid exception to this rule is when youre writing a swap functionltpgtltpgtltbgt5 int i is perfectly valid in a small loopltbgtltbr gtwhen your loop is half a dozen lines of code long or less int i is perfectly valid as a loop counter Its so widely used its almost expectedltbr gtampnbspltpgt </description>
      <pubDate>Thu, 24 Dec 2009 22:51:36 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/ask-questions/category/dotnet.html'>DOTNET</a></category>      
</item>

<item>
      <title>What condition property to set for VISTA</title>
      <link>http://dotnet.diigit.com/ask-questions/condition-property-set-vista_1.html</link>
      <description>ltpgtltspan classquotApplestylespanquot stylequotwordspacing 0px font medium Times New Roman texttransform none color rgb000 textindent 0px whitespace normal letterspacing normal bordercollapse separate orphans 2 widows 2 webkitborderhorizontalspacing 0px webkitborderverticalspacing 0px webkittextdecorationsineffect none webkittextsizeadjust auto webkittextstrokewidth 0pxquotgtltspan classquotApplestylespanquot stylequotfontsize 13px lineheight 15px fontfamily GeorgiaquotgtHiltbr stylequotlineheight 122emquot gtI have created a Setup Project inltspan classquotAppleconvertedspacequotgtampnbspltspangtltspan classquotyshortcutsquot idquotlw12616623840quot stylequotcursor pointer lineheight 122em borderbottom rgb0102204 1px dashedquotgtVisual Studio 2005ltspangtltspan classquotAppleconvertedspacequotgtampnbspltspangtand I want that the setup will run only inltspan classquotAppleconvertedspacequotgtampnbspltspangtltspan classquotyshortcutsquot idquotlw12616623841quot stylequotcursor pointer lineheight 122em backgroundcolor transparent borderbottomstyle none webkitbackgroundclip initial webkitbackgroundorigin initialquotgtWindows Vistaltspangt Fromltspan classquotAppleconvertedspacequotgtampnbspltspangtltspan classquotyshortcutsquot idquotlw12616623842quot stylequotcursor pointer lineheight 122em borderbottom rgb0102204 1px dashedquotgtWindows XPltspangtltspan classquotAppleconvertedspacequotgtampnbspltspangtor below it will show an customized error message set by me How will I proceedltspan classquotAppleconvertedspacequotgtampnbspltspangtltspangtltspangtltpgt </description>
      <pubDate>Thu, 24 Dec 2009 05:51:24 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/ask-questions/category/dotnet.html'>DOTNET</a></category>      
</item>

<item>
      <title>What condition property to set for VISTA</title>
      <link>http://dotnet.diigit.com//condition-property-set-vista.html</link>
      <description>ltpgtltspan classquotApplestylespanquot stylequotwordspacing 0px font medium Times New Roman texttransform none color rgb000 textindent 0px whitespace normal letterspacing normal bordercollapse separate orphans 2 widows 2 webkitborderhorizontalspacing 0px webkitborderverticalspacing 0px webkittextdecorationsineffect none webkittextsizeadjust auto webkittextstrokewidth 0pxquotgtltspan classquotApplestylespanquot stylequotfontsize 13px lineheight 15px fontfamily GeorgiaquotgtHiltbr gtltbr gtltspangtltspangtltspan classquotApplestylespanquot stylequotwordspacing 0px font medium Times New Roman texttransform none color rgb000 textindent 0px whitespace normal letterspacing normal bordercollapse separate orphans 2 widows 2 webkitborderhorizontalspacing 0px webkitborderverticalspacing 0px webkittextdecorationsineffect none webkittextsizeadjust auto webkittextstrokewidth 0pxquotgtltspan classquotApplestylespanquot stylequotfontsize 13px lineheight 15px fontfamily GeorgiaquotgtI have created a Setup Project inltspan classquotAppleconvertedspacequotgtampnbspltspangtltspan classquotyshortcutsquot idquotlw12616611390quot stylequotcursor pointer lineheight 122em borderbottom rgb0102204 1px dashedquotgtVisual Studio 2005ltspangtltspan classquotAppleconvertedspacequotgtampnbspltspangtand I want that the setup will run only inltspan classquotAppleconvertedspacequotgtampnbspltspangtltspan classquotyshortcutsquot idquotlw12616611391quot stylequotlineheight 122emquotgtWindows Vistaltspangt Fromltspan classquotAppleconvertedspacequotgtampnbspltspangtltspan classquotyshortcutsquot idquotlw12616611392quot stylequotcursor pointer lineheight 122em borderbottom rgb0102204 1px dashedquotgtWindows XPltspangtltspan classquotAppleconvertedspacequotgtampnbspltspangtor below it will show an customized error message set by me How will I proceedltspan classquotAppleconvertedspacequotgtampnbspltspangtltbr stylequotlineheight 122emquot gtltspangtltspangtltbr classquotAppleinterchangenewlinequot gtampnbspltpgt </description>
      <pubDate>Thu, 24 Dec 2009 05:49:04 PST</pubDate>
   <author><name></name></author>
         
</item>

<item>
      <title>Help about getting data in the form of pages </title>
      <link>http://dotnet.diigit.com/ask-questions/help-about-getting-data-form-pages.html</link>
      <description>ltpgtltspan classquotApplestylespanquot stylequotwordspacing 0px font medium Times New Roman texttransform none color rgb000 textindent 0px whitespace normal letterspacing normal bordercollapse separate orphans 2 widows 2 webkitborderhorizontalspacing 0px webkitborderverticalspacing 0px webkittextdecorationsineffect none webkittextsizeadjust auto webkittextstrokewidth 0pxquotgtltspan classquotApplestylespanquot stylequotlineheight 19px fontfamily times new roman new york times serifquotgtGood Day ltspan classquotAppleconvertedspacequotgtampnbspltspangtltbr stylequotlineheight 122emquot gtltbr stylequotlineheight 122emquot gtI haveampnbsp a database in whichampnbsp Item Master table i shaving almost 1000000ampnbspampnbsp no of recordsampnbsp and it takes almost 6 to 8 minutes to me to get those records and to show in a Grid basically to populate the Grid ltspan classquotAppleconvertedspacequotgtampnbspltspangtltbr stylequotlineheight 122emquot gtcan someone help me in regards of making it even faster almost like less thenampnbsp 2 minutes  i have also tried indexing ltspan classquotAppleconvertedspacequotgtampnbspltspangtltbr stylequotlineheight 122emquot gtltbr stylequotlineheight 122emquot gtI will be grateful if some can help me in this regards orampnbsp can help about Pagingampnbspampnbsp means instead of getting data in rows and columns  in the form of pages ltspan classquotAppleconvertedspacequotgtampnbspltspangtltbr stylequotlineheight 122emquot gtltbr stylequotlineheight 122emquot gtThanksltbr stylequotlineheight 122emquot gtltspangtltspangtltpgt  ltpgtltspan classquotApplestylespanquot stylequotwordspacing 0px font medium Times New Roman texttransform none color rgb000 textindent 0px whitespace normal letterspacing normal bordercollapse separate orphans 2 widows 2 webkitborderhorizontalspacing 0px webkitborderverticalspacing 0px webkittextdecorationsineffect none webkittextsizeadjust auto webkittextstrokewidth 0pxquotgtltspan classquotApplestylespanquot stylequotfontsize 19px lineheight 22px fontfamily courier monaco monospace sansserifquotgtHiltbr stylequotlineheight 122emquot gtif u can incorporate LINQ in your program then it will be quite easy for you as LINQ as built in support for paging records from database to applicationltbr stylequotlineheight 122emquot gtltspangtltspangtltbr classquotAppleinterchangenewlinequot gtampnbspltpgt</description>
      <pubDate>Thu, 24 Dec 2009 05:42:29 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/ask-questions/category/dotnet.html'>DOTNET</a></category>      
</item>

<item>
      <title>Help about Paging</title>
      <link>http://dotnet.diigit.com//help-about-paging.html</link>
      <description>ltpgtltspan classquotApplestylespanquot stylequotwordspacing 0px font medium Times New Roman texttransform none color rgb000 textindent 0px whitespace normal letterspacing normal bordercollapse separate orphans 2 widows 2 webkitborderhorizontalspacing 0px webkitborderverticalspacing 0px webkittextdecorationsineffect none webkittextsizeadjust auto webkittextstrokewidth 0pxquotgtltspan classquotApplestylespanquot stylequotwordspacing 0px font medium Times New Roman texttransform none color rgb000 textindent 0px whitespace normal letterspacing normal bordercollapse separate orphans 2 widows 2 webkitborderhorizontalspacing 0px webkitborderverticalspacing 0px webkittextdecorationsineffect none webkittextsizeadjust auto webkittextstrokewidth 0pxquotgtltspan classquotApplestylespanquot stylequotlineheight 19px fontfamily times new roman new york times serifquotgtGood Day ltspan classquotAppleconvertedspacequotgtampnbspltspangtltbr stylequotlineheight 122emquot gtltspangtltspangtltspangtltpgtltpgtltspan classquotApplestylespanquot stylequotwordspacing 0px font medium Times New Roman texttransform none color rgb000 textindent 0px whitespace normal letterspacing normal bordercollapse separate orphans 2 widows 2 webkitborderhorizontalspacing 0px webkitborderverticalspacing 0px webkittextdecorationsineffect none webkittextsizeadjust auto webkittextstrokewidth 0pxquotgtltspan classquotApplestylespanquot stylequotwordspacing 0px font medium Times New Roman texttransform none color rgb000 textindent 0px whitespace normal letterspacing normal bordercollapse separate orphans 2 widows 2 webkitborderhorizontalspacing 0px webkitborderverticalspacing 0px webkittextdecorationsineffect none webkittextsizeadjust auto webkittextstrokewidth 0pxquotgtltspan classquotApplestylespanquot stylequotlineheight 19px fontfamily times new roman new york times serifquotgtI haveampnbsp a database in whichampnbsp Item Master table i shaving almost 1000000ampnbspampnbsp no of recordsampnbsp and it takes almost 6 to 8 minutes to me to get those records and to show in a Grid basically to populate the Grid ltspan classquotAppleconvertedspacequotgtampnbspltspangtltbr stylequotlineheight 122emquot gtcan someone help me in regards of making it even faster almost like less thenampnbsp 2 minutes  i have also tried indexing ltspan classquotAppleconvertedspacequotgtampnbspltspangtltbr stylequotlineheight 122emquot gtltbr stylequotlineheight 122emquot gtI will be grateful if some can help me in this regards orampnbsp can help about Pagingampnbspampnbsp means instead of getting data in rows and columns  in the form of pages ltspan classquotAppleconvertedspacequotgtampnbspltspangtltbr stylequotlineheight 122emquot gtltbr stylequotlineheight 122emquot gtThanksltbr stylequotlineheight 122emquot gtltspangtltspangtltspangtltpgt </description>
      <pubDate>Thu, 24 Dec 2009 05:34:36 PST</pubDate>
   <author><name></name></author>
         
</item>

<item>
      <title>Jobs Maintenance Engineer - Electrical - Dubai</title>
      <link>http://windows.diigit.com/jobs_4/jobs-maintenance-engineer-electrical-dubai.html</link>
      <description>ltpgtltbgtMaintenance Engineer  Electrical  Dubailtbr gtltbr gtHiltbr gtltbr gtHere the placement for Maintenance Engineerltbgtltbr gtltbr gtampbullampnbspampnbspampnbsp Our clients have been providing Contracting and Engineering ampamp Design services with Head office in Dubai Branch Office in Abu Dhabi and partners in Bangalore  Indialtbr gtampbullampnbspampnbspampnbsp Theyampnbsp have vast experience in Design Installation and Testing ampamp Commissioning of MVHVEHV Power Transmission and Distribution Substations Power Cable Laying Installation Jointing and Termination SCADA Instrumentation and Automation Systemsampnbsp ltbr gtltbr gtltbgtThey require following skillsltbr gtltbr gtLocation  Dubailtbr gtltbr gtQualification  ltbr gtltbr gtampbullampnbspampnbspampnbsp 3 year diploma holderltbgtltbr gtltbr gtltbr gtltbgtExperience ltbgtltbr gtltbr gtampbullampnbspampnbspampnbsp About 5 years experience in maintaining and trouble shooting 11kV switchgear vacuum typeDistribution Transformers dry type and oil filled LV Distribution Panels with ACBs and MCCBs MCCmotor controll battery chargers UPSltbr gtltbr gtltbr gtltbgtWould you be interested ltbgtltbr gtltbr gtPlease send us your latest updated profile with contact noscurrent ampamp expected salary details and joining time ltbr gtrequired to priyakbsconsultant scomltbr gtltbr gtYou may also suggest this opening to your friends who may be interestedltpgt </description>
      <pubDate>Thu, 24 Dec 2009 03:15:12 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_4/category/windows_1.html'>Windows</a></category>      
</item>

<item>
      <title>Jobs Testing &amp;Commissioning Engineers - Electrical &acirc;�� Dubai</title>
      <link>http://windows.diigit.com/jobs_4/jobs-testing-commissioning-engineers-electrical-dubai.html</link>
      <description>ltpgtltbgtTesting ampampCommissioning Engineers  Electrical ampndash Dubailtbr gtltbgtltbr gtHiltbr gtltbr gtHere the placement forampnbsp Testing ampampCommissioning Engineers ltbr gtltbr gtampbullampnbspampnbspampnbsp Our clients have been providing Contracting and Engineering ampamp Design services with Head office in Dubai Branch Office in Abu Dhabi and partners in Bangalore  Indialtbr gtampbullampnbspampnbspampnbsp Theyampnbsp have vast experience in Design Installation and Testing ampamp Commissioning of MVHVEHV Power Transmission and Distribution Substations Power Cable Laying Installation Jointing and Termination SCADA Instrumentation and Automation Systemsampnbsp ltbr gtltbr gtltbr gtltbgtLocation  Dubailtbr gtltbr gtQualification  ltbr gtltbr gtPreferably BE graduatesltbgtltbr gtltbr gtltbgtExperience ltbgtltbr gtltbr gtAbout 5 years experience in testing of 11kV33kV switchgearRelays Transformers DC System etcltbr gtltbr gtWould you be interested ltbr gtltbr gtPlease send us your latest updatedampnbsp resume with current expected salary details andampnbsp required time to join to priyakbsconsultant scomltbr gtltbr gtYou may also suggest this opening to your friends who may be interestedltpgt </description>
      <pubDate>Thu, 24 Dec 2009 03:13:36 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_4/category/windows_1.html'>Windows</a></category>      
</item>

<item>
      <title>Jobs PURCHASE EXECUTIVE</title>
      <link>http://windows.diigit.com/jobs_4/jobs-purchase-executive.html</link>
      <description>ltpgtltbgtPURCHASE EXECUTIVEltbgtltbr gtltbr gtltbr gtltbgtJob Descriptionltbgtltbr gtltbr gtampbullampnbspampnbspampnbsp Having experience of 5 years in a mediumsized company handling purchase for both import and exportampnbsp ltbr gtSalary ltbr gtltbr gtampbullampnbspampnbspampnbsp Dhs 3500month  accommodationltbr gtltbr gtampbullampnbspampnbspampnbsp Salary negotiable and not constraint for right candidatesltbr gtltbr gtltbgtWould you be interested ltbgtltbr gtltbr gtPlease send us your latest updated profile with contact noscurrent ampamp expected salary details and joining time ltbr gtrequired to priyakbsconsultant scomltbr gtltbr gtYou may also suggest this opening to your friends who may be interestedltpgt </description>
      <pubDate>Thu, 24 Dec 2009 03:12:00 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_4/category/windows_1.html'>Windows</a></category>      
</item>

<item>
      <title>Jobs for LAB CHEMIST</title>
      <link>http://windows.diigit.com/jobs_4/jobs-lab-chemist.html</link>
      <description>ltpgtltbgtJob Description  ltbgtltbr gtltbr gtampbullampnbspampnbspampnbsp Minimum qualification BSCampnbsp Having at least 5 years experience of working in R ampamp D departmentltbr gtltbr gtSalary ampnbsp Dhs 3000month  accommodation ltbr gtltbr gtWould you be interested ltbr gtltbr gtPlease send us your latest updated profile with contact noscurrent ampamp expected salary details and joining time ltbr gtrequired to priyakbsconsultant scomltbr gtltbr gtYou may also suggest this opening to your friends who may be interestedltpgt </description>
      <pubDate>Thu, 24 Dec 2009 03:09:42 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_4/category/windows_1.html'>Windows</a></category>      
</item>

<item>
      <title>Network Administrator  at NEW YORK, NY</title>
      <link>http://windows.diigit.com/jobs_4/network-administrator-new-york-ny.html</link>
      <description>ltpgtPlease go through the below requirement and send me the suitable profiles with best rate and contact details to  mikethoughtwavesoftcom or kirancthoughtwavesoftcomltbr gtampnbspltbr gtltbgtREQ  Network engineerampnbsp ltbr gtLocation  NEW YORK NYltbr gtDuration 4 monthsltbr gtampnbspltbr gtJob Titleampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbsp Network Administratorampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbsp ltbr gtRequired skills CCNA Cisco Microsoft Access windows XP SAN ltbr gtampnbspDesired Skill ltbgtltpgtltpgtltbgtExtension Skills and Attributes ltbgtltbr gtlooking for a Network Engineer Need to have experience in Cisco Routers and Switches Need to be CCNA certified Will be require to mount switches load CISCO Configurations repatch network switches Remove Access points from there wall enclosures and retrofit themltbr gtampnbspltbr gtLooking forward to hear from you     ampnbsp ltbr gtThanks and Regards ltbr gtKiran Kumar Cltbr gtSenior Technical Recruiterltbr gtThoughtwave Software And Solutions Incltbr gt1444NFransworth Ave Suite 206  Aurora  IL 60505ltbr gtDirect  6302702794ampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbsp Fax 6306895746ltbr gtEMail  kirancthoughtwavesoftcomltpgt </description>
      <pubDate>Thu, 24 Dec 2009 01:38:04 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_4/category/windows_1.html'>Windows</a></category>      
</item>

<item>
      <title>Sr. SQL Developer (Expert) at Dayton, OH</title>
      <link>http://windows.diigit.com/jobs_4/sr-sql-developer-expert-dayton-oh.html</link>
      <description>ltpgtPlease go through the below requirement and send me the suitable profiles with best rate and contact details to  vijaygthoughtwavesoftcomltbr gtJob Title Sr SQL Developer Expertltbr gtClientampnbsp Will be disclosed if chosen for interviewltbr gtLocation Dayton OHltbr gtDuration 6 Months with a high possibility of extensionltbr gtRate Openltbr gtStart Date 142010ltbr gtReq IDltbr gtampnbsp122301 TWSS  Sr SQL Developer Expertltbr gtampnbspltbr gtltbgtDescriptionltbgtltbr gtampnbspDetailsltbr gt1 Software exp 810 yearsltbr gt2 Very Good at written and verbal communication with customer and has experience with working in USltbr gt3 At least 5 years of experience with SQL Database ampamp Designing and Developing Store Proceduresltbr gt4 Expert in SSISDTS package implementation ltbr gt5 Good ampamp independent Analytical and Trouble shooting skillsltbr gt6 Good experience in functional design on new Databases Should have done such independent implementationsltbr gt7 Good experience in store procedure optimization and writing reusable componentsltbr gt8 Should be motivated and apply well to needs of understanding customer businessltbr gtltbr gtltbgtDesirableltbgtltbr gtampbull Open to US or Indian profiles Skills are paramountltbr gtampbull Any VB scripting experience will be added advantageltbr gtWe will need 3 professional references at least one American reference for the candidate ltbr gtPlease check the skills before sending the profileltbr gtampnbspltbr gtThanks ampamp Regardsltbr gtVijay B Yasaramltbr gtThoughtwave Software and Solutions Incltbr gt1444 N Farnsworth Ave Suite 206Aurora IL 60505ltbr gtDirect 630 570 9354 Fax 630 689 5746ltbr gtURL httpwwwthoughtwavesoftcomltbr gtGtalk Vijaybhasker321 ltbr gtYahoo vijaybhasker123ltpgt </description>
      <pubDate>Thu, 24 Dec 2009 01:22:36 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_4/category/windows_1.html'>Windows</a></category>      
</item>

<item>
      <title>Oracle Applications Consultant BOULDER, CO</title>
      <link>http://oracle.diigit.com/jobs_1/oracle-applications-consultant-boulder-co.html</link>
      <description>ltpgtPlease go through the below requirement and send me the suitable profiles with best rate and contact details to  mikethoughtwavesoftcom or kirancthoughtwavesoftcomltbr gtampnbspltbr gtltbgtREQampnbsp  Oracle Applications Consultant ltbr gtLocationampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbsp BOULDER COampnbspampnbsp ltbr gtRateampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbsp DOEampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbspampnbsp ltbr gtampnbspltbr gtRequired skills ltbr gtOracle ATO Assemble to Order  PTO Pick to Orderampnbspampnbspampnbspampnbsp ltbgtltbr gtampnbspltbr gtDesired Skillampnbspampnbspampnbsp ltbr gtampnbspltbr gtDescriptionampnbspampnbspampnbspampnbspampnbsp ltbr gtWe are looking for an Oracle Applications Functional Consultant with over all 10 years of experience and atleast 35 years experience configuring Oracle ATO Assemble to Order  PTO Pick to Order Models with complex rulesltbr gtampnbspltbr gtampnbspltbr gtLooking forward to hear from you      ltbr gtampnbspltbr gtThanks and Regardsltbr gtampnbspltbr gtKiran Kumar Cltbr gtSenior Technical Recruiterltbr gtThoughtwave Software And Solutions Incltbr gt1444NFransworth Ave Suite 206  Aurora  IL 60505ltbr gtDirect  6302702794  Fax 6306895746ltbr gtEMail  kirancthoughtwavesoftcomltbr gtYahoo Id  kirankumar553yahoocomltpgt </description>
      <pubDate>Thu, 24 Dec 2009 01:21:13 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_1/category/oracle_3.html'>Oracle</a></category>      
</item>

<item>
      <title>Which is Batter Xampp or Wamp Server</title>
      <link>http://php.diigit.com/php-ask-questions/which-batter-xampp-wamp-server.html</link>
      <description>ltpgtHiltpgtltpgtI have to install local server in my companyltpgtltpgtPlease tell me which server is Best Wamp or XamppltpgtltpgtByeltpgtltpgtampnbspltpgt  ltpgtampnbspXampp Is Batter then WAMP server becauseltpgtltdivgtampnbspltdivgtltdivgt1 in Xampp their is no need of adding ampltphp the php files can work wit amplt only but in Wamp u need to add ampltphp so it is batterltdivgtltdivgt2 in Xampp it comes with SMTP serverltdivgtltdivgtampnbspltdivgt ltpgtXAMPP is more portable and comes with PEAR installedltpgt ltpgtits better not batterltpgt ltpgtampnbspI like batter better then XAMPP  on my bread Dltpgtltpgtomg your captcha is brokenltpgtltpgtltspan classquotApplestylespanquot stylequotfontfamily Arial Helvetica sansserif quotgtltbgtWarningltbgt includehomebigbazipublichtmlarraysphp lta hrefquothttpphpdiigitcomphpaskquestionsfunctionincludequotgtfunctionincludeltagt failed to open stream No such file or directory inampnbspltbgthomediigitcpublichtmlchkVcodephpltbgtampnbspon lineampnbspltbgt2ltbgtltbr gtltbr gtltbgtWarningltbgt include lta hrefquothttpphpdiigitcomphpaskquestionsfunctionincludequotgtfunctionincludeltagt Failed opening homebigbazipublichtmlarraysphp for inclusion includepathusrlibphpusrlocallibphp inampnbspltbgthomediigitcpublichtmlchkVcodephpltbgtampnbspon lineampnbspltbgt2ltbgtltspangtltpgtltpgtampnbspltpgtltpgtAndampnbspltpgtltpgtltspan classquotApplestylespanquot stylequotfontfamily Arial Helvetica sansserif quotgtno need of adding ampltphp the php files can work wit amplt ampnbsp you can chaneg it yourself in phpini  shortopentags  Onltspangtltpgtltpgtampnbspltpgtltpgtampnbspltpgtltpgtampnbspltpgtltpgtampnbspltpgt</description>
      <pubDate>Thu, 10 Dec 2009 11:21:58 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>qhcdilaw</title>
      <link>http://linux.diigit.com//qhcdilaw.html</link>
      <description> URLhttpxasicwxucomhqvoftqcURL  rlghtsth httpuitwchrycom kjfmtmgu txqbilfb  lta hrefquothttpdqrxrezlcomquotgtubabmvpqltagt  </description>
      <pubDate>Mon, 09 Nov 2009 19:41:54 PST</pubDate>
   <author><name></name></author>
         
</item>

<item>
      <title>Cold backup, shell script</title>
      <link>http://oracle.diigit.com/oracle-ask-questions/cold-backup-shell-script.html</link>
      <description>ltpgtcan anyone forward me shell scripting for cold backup realtimeltpgtltpgtscenarioaltpgt  ingen </description>
      <pubDate>Tue, 03 Nov 2009 01:16:08 PST</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/oracle-ask-questions/category/oracle.html'>Oracle</a></category>      
</item>

<item>
      <title>Error : unable to connect to visual studio's localhost web server</title>
      <link>http://dotnet.diigit.com/ask-questions/error-unable-connect-visual-studios-localhost-web-server.html</link>
      <description>ltpgtHelloltpgtltdivgtI created a simple web page in Microsoft Visual Web Developer 2005 Express EditionltdivgtltdivgtThen I pressed CtrlF5ltdivgtltdivgtBuild succeededltdivgtltdivgtNext I reseived an error messageltdivgtltdivgtltbgtampquotunable to connect to visual studios localhost web serverampquotltbgtltdivgtltdivgtDoes anybody know whyltdivgt   ltpgtFucking spam siteltpgt ltpgtThis is just a smart way to drive traffic for which you do not have any solution Fuck yourselfltpgt ltdiv idquotartbodyquotgtltpgtampnbspHelloltpgtltdivgtI created a simple web page in Microsoft Visual Web Developer 2005 Express EditionltdivgtltdivgtThen I pressed CtrlF5ltdivgtltdivgtBuild succeededltdivgtltdivgtNext I reseived an error messageltdivgtltdivgtltbgtampquotunable to connect to visual studios localhost web serverampquotltbgtltdivgtltdivgt ltpgtltbgtampnbspltugtunable to connect to visual studios localhost web serverltugtltbgtltpgtltpgtltbgtHi ltbgtltpgtltpgtmy name is kolithai am from srilankaltbr gtpresently i am doing a course in IT herei am doing net programmingltbr gti have installed visual studio 2005i get a error like this ltbr gtampnbspltpgtlth2gtunable to connect to visual studios localhost web serverlth2gtltpgtalso i cant insall SQL server express edition nowltbr gtfor some timeampnbspthis visual studio 2005 was working perfectlyafter that recently i got this roblem 1 week beforeafter thatampnbspi have formatted the pc twice and tryied to install visual studio 2005 twiceltbr gtstill i cant resolve the problemmy project as to delever with in another 2 weeks timetis is urgentltbr gtampnbspltbr gtpls help meltbr gtampnbspltbr gtkolithaltbr gtampnbspltbr gtlta hrefquotampquotampquotmailtokolithidmgmailcomampquotampquotquotgtltfont colorquot006f00quotgtkolithidmgmailcomltfontgtltagtampnbspltbr gtltspangtlta hrefquotampquotampquotmailtoknw97hotmailcomampquotampquotquotgtltfont colorquot006f00quotgtknw97hotmailcomltfontgtltagtltspangtltbr gtampnbspltbr gtampnbspltpgt   </description>
      <pubDate>Tue, 27 Oct 2009 21:27:41 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/ask-questions/category/dotnet.html'>DOTNET</a></category>      
</item>

<item>
      <title>difference b/w fal_client and fal_server</title>
      <link>http://oracle.diigit.com/tutorials-oracle/difference-bw-falclient-falserver.html</link>
      <description>ltpgtltbgtFALCLIENTltbgt ampltservicenameampgt of the current host database which will act as client for the archive log shippingltbr gtltbgtFALSERVERltbgt ampltservice nameampgt of the standby or remote database which will be shipping the archive logsltbr gtltbr gtthese parameters help in seamless switchoverfailover with DGltpgt  sd ltpgtampnbspgood  thanksltpgt</description>
      <pubDate>Tue, 27 Oct 2009 19:58:37 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/tutorials-oracle/category/oracle_1.html'>Oracle</a></category>      
</item>

<item>
      <title>Opportunties for for Senior PHP Developer for Xoriant Corporation</title>
      <link>http://php.diigit.com/jobs_2/opportunties-for-senior-php-developer-xoriant-corporation.html</link>
      <description>ltpgtPlease accept my Greetingsltbr gtltbr gtltbr gtltbr gtThis is Suchita Kedia and I am writing to you on behalf of Team Lease We offer recruitment solutions to almost all the top of the order IT organizations ampamp MNCs having their presence in Indialtbr gtltbr gtltbr gtI would like to inform you about an opening with ltbr gtltbr gtltbr gtltbr gtXoriant Corporation is a software product development company with global delivery centers offering a range of software development solutions to a variety of industries including finance telecom ecommerce customerfacing web publishers and others Xoriant has the expertise to participate at any stage of a productampacircampeuroamptrades lifecycle at our client partners ampacircampeuroampldquo Independent Software Vendors ISV Web 20 customers consumerfacing ecommerce engines softwareasaservice SaaS and so onltbr gtltbr gtWe understand the dynamically changing business scenarios of markets and the need of constant change management in the software industry We bring rapid development skills iterative prototyping and modular publishing and the capability to work closely with the client technology team Our flexibility in offering customized solutions to various clients makes us a competent outsourced software product development enterpriseltbr gtltbr gtltbr gtltbr gtThe Total IT experience should be at least 7  years and above and relevant experience 5 years and above ltbr gtltbr gtThe candidate should have onsite exposure ltbr gtltbr gtltbr gtltbr gtThe requirements are as followsltbr gtltbr gtSenior PHP Developer with 7 years of experience to be based in Mumbai ltbr gtltbr gtltbr gtIf this requirement interests you and you would like to explore this opportunity please mail us your updated resume in Word Format and also provide us the following informationltbr gtltbr gtltbr gtltbr gtFirst Nameltbr gtltbr gtLast Nameltbr gtltbr gtTotal IT Experienceltbr gtltbr gtCurrent Organizationltbr gtltbr gtQualificationltbr gtltbr gtDate of Birthltbr gtltbr gtCurrent CTCltbr gtltbr gtExpected CTCltbr gtltbr gtJoining Periodltbr gtltbr gtPreferred Locationltbr gtltbr gt2 Professional References ltbr gtltbr gtResidence No ltbr gtltbr gtOffice Contact Noltbr gtltbr gtImmediate Senior Name and Contact Numberltbr gtltbr gtReason for changeltbr gtltbr gtltbr gtltbr gtIF YOU ARE IMMEDIATE JOINEE OR YOU CAN JOIN WITHIN 15 DAYS PLS CALL ME 98203 88401 ASAPltbr gtltbr gtltbr gtltbr gtWe will revert back to you with more details on this requirement once we hear from youltbr gtltbr gtltbr gtltbr gtDo let us know if you have some references to provide for the same ltbr gtltbr gtFor any queries please feel to call me ASAPltbr gtltbr gtltbr gtltbr gtltbr gtltbr gtltbr gtltbr gtRegardsltbr gtltbr gtSuchita Kedialtbr gtltbr gtCareer Consultantltbr gtltbr gtTeamLease Services P Ltd 501 5th floor Chintamani Plaza Andheri  Kurla Road Andheri E Mumbai  400099 Fax02266936496 ltbr gtltbr gtMobile 9820388401 Direct No 02240009134 ltbr gtltbr gtEmail idsuchitateamleasecom ltbr gtltbr gtwwwteamleasecom ampacircampeuroampoeligPutting India to Workltpgt </description>
      <pubDate>Sat, 26 Sep 2009 18:32:59 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_2/category/php_3.html'>PHP</a></category>      
</item>

<item>
      <title>Jobs PHP Developer with Drupal - Chennai</title>
      <link>http://php.diigit.com/jobs_2/jobs-php-developer-drupal-chennai.html</link>
      <description>ltpgtHP Developer with Drupal  Chennai ltbr gtltbr gtHiltbr gtHere the placement for PHP Developer with Drupalltbr gtltbr gtOur client are looking for a 35 years in PHP Startup experience preferred ltbr gtampbullampnbspampnbspampnbsp Drupal experience highly preferredltbr gtampbullampnbspampnbspampnbsp Knowledge of MVC framework like CakePHP CodeIgnitor Zend Symfony neededltbr gtampbullampnbspampnbspampnbsp Strong OO conceptsltbr gtampbullampnbspampnbspampnbsp Good communication skills requiredltbr gtampbullampnbspampnbspampnbsp Candidates from good schools and colleges Engineers preferredltbr gtltbr gtWould you be interested ltbr gtltbr gtPlease send us your latest updated profile with contact noscurrent ampamp expected salary details and joining time required to radhakbsconsultant scomampnbsp ltbr gtltbr gtYou may also suggest this opening to your friends who may be interestedltpgt </description>
      <pubDate>Thu, 17 Sep 2009 20:34:13 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_2/category/php_3.html'>PHP</a></category>      
</item>

<item>
      <title>How to optimizing Query</title>
      <link>http://php.diigit.com/php-ask-questions/subject_2.html</link>
      <description>ltpgtHello AllltpgtltpgtPlease help me on optimizing following queryltbr gtQueryltbr gtltbr gtSELECT  FROM tblauction ta tblcategory tc WHEREltbr gttadisplayfrontyes AND taauctiontypepenny AND tastatusLiveltbr gtAND tcstatusenabled AND tccatidtacatid ANDltbr gttastartdateamplt20090728 053652 AND tacountries2 ORltbr gttacountries LIKE 2 OR tacountries LIKE 2 OR tacountries LIKEltbr gt2 OR 11 AND pregion1 OR pregion0 AND 11 ORDER BYltbr gttaenddate ASC LIMIT  0 10ltbr gtI found that this query might have caused the problem that I haveltbr gtmentioned in last post In my server error log I can see problems withltbr gtthis queryltbr gtltbr gtIt shows following message before query which I can not understandltbr gtQuerytime 5  Locktime 0  Rowssent 0  Rowsexamined 0ltbr gtltbr gtAny help will be appreciatedltbr gtltbr gtThanksltbr gtampnbspltpgt </description>
      <pubDate>Sun, 13 Sep 2009 19:52:58 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Classes &amp; returning values error in returning values</title>
      <link>http://php.diigit.com/php-ask-questions/classes-amp-returning-values.html</link>
      <description>ltpgtIm having a problem with classes ampamp functionsltbr gtltbr gtmainphp  main php scriptltbr gtampnbspfileclassphpltbr gtfunction myfunction1 ltbr gtfunction myfunction2 ltbr gtltbr gtOk  Summary of my situationltbr gtltbr gtMy main script activates  calls  myfunction1   It processes ok ltbr gteverything is fineltbr gtltbr gtthe function has a variable that I want   recltbr gtI echo this within  at the end of the function  It works fine ltbr gtltbr gtHowever I cannot seem to retrieve  the valueltbr gtltbr gtin my main script  I have ltbr gtltbr gtquestiontemp  new Questionlangltbr gtquestiontempampgtaddqandaquestion answerltbr gtltbr gtltbr gtand the end of the function I haveltbr gtltbr gtreturn rec  or return rec    etc  Several combinationsltbr gtltbr gtltbr gtIn my main script ive done a foreach loop on questiontemp  butltbr gtrec is not in it ampamp Ive echoed rec  Nothing returnedltbr gtltbr gtltbr gtltbr gtPS  Ive got 45 other routines ampamp they all work fine  Except this oneltbr gtltbr gtIs this a common error ltbr gtltbr gtrelooking at other functionsltpgt  ltpgtUse thisltbr gtltbr gtquestiontemp  new Questionlangltbr gtreturnvalue  questiontempampgtaddqandaquestion answerltbr gtprint returnvalueltbr gtltbr gtJust like a regular function if you have a value returned it will be passedampnbspthrough the function name  In a PHP object the method name is just a bit moreampnbspcomplex  In your case questiontempampgtaddquandaltbr gtltbr gtYou would not expect any internal variables to the functions or methods to beampnbspavailable outside since variables in PHP are local to these entities  This is aampnbspgood thingltbr gtltbr gtWith objects there are the additional issues of properties or methods which canampnbspbe public protected and privateltbr gtampnbspltpgt</description>
      <pubDate>Sun, 13 Sep 2009 19:34:21 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Autogenerate a Issue_id number </title>
      <link>http://php.diigit.com/php-ask-questions/issueid-number.html</link>
      <description>ltpgtHi allltpgtltpgti want to Autogenerate a Issueid number everytime the Add publish page Comes up to add a Issueltpgtltpgthow could i do that Including the date  like today would beltpgt  ltpgtIn MySQL an INT field can be given AUTOINCREMENT and PRIMARY KEY properties If a row is added with a 0 or null value for this field it will receive the next highest value which has not yet been assigned  On a regular signed INT this range goes from 1 to about 21 billion  If you need more look at datatypes like UNSIGNED INT or BIGINTltbr gtltbr gtOnce the row is added the PHP function mysqlinsertid will return the latest value for this AUTOINCREMENT field  There is also an equivalent MySQL function with the same name mysqlinsertidltbr gtltbr gtIf you want to use the number on the report form screen INSERT a minimal entry and get the mysqlinsertid value  Use UPDATE to add data from the form to the existing recordltbr gtltpgt ltpgtSpeaking of dates your computer clock seems to be off by a day or soltbr gtltbr gtIf you didnt want to use the AUTOINCREMENT feature I mentioned and really wanted to have the date be part of the issue number you could do so with the date function in PHP  I would suggest that using Year Month Day would allow for easier sorting in chronological orderltbr gtltbr gtYou will want to consider how to handle multiple entries for a given day  In DNS entries a popular serial number scheme involves YYYYMMDDNN where NN is a two digit number which is increased if there are multiple changes in a given dayltbr gtltbr gtnum  dateampquotYmdampquot  20080613ltpgt</description>
      <pubDate>Sun, 13 Sep 2009 19:32:36 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Passing an object in Class</title>
      <link>http://php.diigit.com/php-ask-questions/passing-object.html</link>
      <description>ltpgtI have a class calledampnbspinsertNewAccountampnbspthat is created as user and I wish to pass it to a procedureampnbspltbr gtltbr gtfunction insertNewAccountltbr gtshould be writtenltbr gtThank youltbr gtampltphpltbr gtltbr gt create the userltbr gtltbr gtinsertNewAccountuserltbr gtfunction insertNewAccount ltbr gtltbr gtampgtltpgt  ltpgtYou havent given us hardly anything to go on but Ill try and explain what I think you are askingltbr gtltbr gt instantiate classltbr gtu  new Userltbr gtltbr gt pass string billy to methodltbr gtuampgtinsertNewAccountbillyltbr gtltbr gtclass Userltbr gtltbr gtltbr gtfunction insertNewAccountuserltbr gtdo stuffltbr gtltbr gtltbr gtltpgt</description>
      <pubDate>Sun, 13 Sep 2009 19:29:58 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>session_start() can't access to my session variables</title>
      <link>http://php.diigit.com/php-ask-questions/please-help-have-problem-sessionstart.html</link>
      <description>ltpgti start a new session with  sessionstartltbr gtthen i set some session variable like this  SESSIONnamePOSTnameltbr gtand some another variablesltbr gtat bottom of page i set header to diffrent page  headerlocation indexphpltbr gtampnbspampnbspampnbsp exitltbr gtnow in new page indexphp i cant access to my session variables like SESSIONnameltbr gtwhats wrong  ltbr gtthanksltpgt </description>
      <pubDate>Sun, 13 Sep 2009 19:27:58 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>AVS Video Converter 6 memory error</title>
      <link>http://windows.diigit.com/ask-questions_2/avs-video-converter-6-memory-error.html</link>
      <description>ltpgtampnbspHi allampnbspltpgtltpgtI have installedampnbspltspan classquotApplestylespanquot stylequotfontsize 13px whitespace pre quotgtAVS Video Converter 6 and download the crack it is working for small file but for large file it givs Memory error ltspangtltpgtltpgtHow to solve this errorltpgtltpgtbyeltpgtltpgtampnbspltpgtltpgtampnbspltpgtltpgtampnbspltpgtltpgtampnbspltpgt   ltpgtdroidltpgt Halp on my aplikasi thx u ltpgtHiltpgtltpgtI have the same problem can anyone help Thksltpgt ltpgtyup solution is simple restart the Programm till it worksltpgt </description>
      <pubDate>Fri, 11 Sep 2009 01:11:32 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/ask-questions_2/category/windows.html'>Windows</a></category>      
</item>

<item>
      <title>need help ( php session )</title>
      <link>http://php.diigit.com/php-ask-questions/need-help-php-session.html</link>
      <description>ltpgti start a new session with  sessionstartltbr gtthen i set some session variable like this  SESSIONnamePOSTnameltbr gtand some another variablesltbr gtat bottom of page i set header to diffrent page  headerlocation indexphpltbr gtampnbspampnbspampnbsp exitltbr gtnow in new page indexphp i cant access to my session variables like SESSIONnameltbr gtwhats wrong  ltbr gtthanksltpgtltpgtampnbspltpgtltpgthere is my files ltpgtltpgtaphpltpgtltpgtltpgtltpgtsessionstartltpgtltpgtrequire configincphpltbr gtifissetPOST ltbr gtampnbsp foreachPOST as vampgtkltbr gtampnbspampnbspampnbsp ltbr gtampnbspampnbspampnbsp ampnbspampnbspampnbsp itemsvkltbr gtampnbspampnbspampnbsp ltpgtltpgtsqlampquotSELECT  FROM members WHERE usernameitemsuser AND passMD5itemsPassword ampquotltbr gtresmysqlquerysqlltbr gtrowmysqlfetchassocresltbr gtifrowusernameltbr gtampnbspampnbsp SESSIONtyperowtypeltbr gtampnbspampnbspampnbsp SESSIONnamerownameltbr gtampnbspampnbspampnbsp SESSIONfamilyrowfamilyltbr gtampnbspampnbspampnbsp SESSIONusernamerowusernameltbr gtampnbspampnbspampnbsp SESSIONdaterowdateltpgtltpgtltpgtltpgtheaderlocation adminphpltbr gtexitltpgtltpgtltpgtltpgtadminphpltpgtltpgtltpgtltpgtampltphpltbr gtsessionstartltbr gtifissetSESSIONadminltbr gtltbr gtampnbspampnbspampnbsp headerlocation indexphpltbr gtampnbspampnbspampnbsp exitltbr gtltbr gtrequire configincphpltbr gtltbr gtampgtltpgtltpgtltpgtltpgtltpgtltpgtltpgtltpgtltpgtltpgtampnbspltpgt </description>
      <pubDate>Wed, 09 Sep 2009 15:10:26 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Urgent Requirement OF PHP Developers GNT</title>
      <link>http://php.diigit.com/jobs_2/urgent-requirement-php-developers-gnt.html</link>
      <description>ltpgtHiltbr gtltbr gtWe have an urgent requirement of PHP developers having experience of 4 8 years for our UK Based client based in West Delhi This is really urgent requirement so please send your profiles ASAP at seedsoftalentgmailcom or Call me at 9873213070ltbr gtltbr gtRegardsltpgt </description>
      <pubDate>Fri, 04 Sep 2009 09:29:44 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/jobs_2/category/php_3.html'>PHP</a></category>      
</item>

<item>
      <title>Implement php script (web scraper)</title>
      <link>http://php.diigit.com/php-ask-questions/implement-php-script-web-scraper.html</link>
      <description>ltpgtHi allltpgtltpgtIm still learning here arent we all and Im trying to figure out how to create a web scraper and Ive looked at a bunch of tutorials and examples but Im confused on how to implement them if I have the code in say myscraperphp file  how do I ampquotcallampquot the script to run  Im looking to eventually do 2 things first is to scrape links off a page and store them in file as well as adding them to a page The next would be to download files from those links and store them   As I said Im confused as to how to ampquotrunampquot the scraper Can anyone give me some insight into this  An example would be great but Im more interested in learning the how toltpgtltpgtThanksltpgt </description>
      <pubDate>Wed, 26 Aug 2009 02:19:18 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Multiple pic file uploads </title>
      <link>http://php.diigit.com/php-ask-questions/multiple-pic-file-uploads.html</link>
      <description>ltpgtHello everyoneltpgtltpgtIm working on a database driven website where for each item cars there will be 3 pictures to upload the upload will be via a protected page non public and im looking for information or example of how to do two things one multiple image files and how to store them i will be using mysql for the database would it be better to store the images in the database or in the file system with name or path or something stored in the database instead ive been able to do this for one picture but not sure how to do it withltbr gtmultiplesltbr gtltbr gtcan someone give examples of how to do this or point me to a tutorial to learn how to do it ltbr gtltbr gtThanks in advanceltbr gtltpgt </description>
      <pubDate>Wed, 26 Aug 2009 02:16:24 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Creating a teaser/excerpt</title>
      <link>http://php.diigit.com/php-ask-questions/creating-teaserexcerpt.html</link>
      <description>ltpgtI have a site that has HTML content in a database  Id like to create from this HTML a short teaser or excerpt  Its been difficult toltbr gtfind any sort of code that does this thats not a plugin for something like wordpress  Currently I am stripping the HTML tags andltbr gtcreating the teaser from X number of words  Id like to be able to do this without losing the tags but the problem is that I cant findltbr gtcode that do it ampquotproperlyampquot read take into account any possible closing tagsltbr gtltbr gtHas anybody seen anything like thisltbr gtltbr gtThanksltpgt  ltpgtIs the data in the database full HTML including the HEAD and BODY elements or is it just what you would normally expect to find inside a HTML BODY elementltbr gtltbr gtThere are a number of ways to do this using REGEX strreplace striptags etcltbr gtltbr gtREGEX would be easier but the server load may become a problem on a busy siteltbr gtltbr gtI assume you want ALL of the remaining tags in the remainder of the HTML or do you specifically want only the matching closing tagsltpgt ltpgtIf you only want the matching closing tags then REGEX will be too difficult UNLESS you know which specific tag names to matchltbr gtltbr gtAlternatively you may use simpleXML group of functions but you will need a way to predict and select the parent object that you requireltbr gtltbr gtIf you send an example of the HTML or links and what you want extracted then we can suggest some codeltpgt ltpgtAs you say theres a brute force method where you throw a bunch of close tags and hope that you catch the most likely ones  Otherwise you need to have a way to put the HTML in a structure like XML and walk it to the break point so you can keep track of what tags need to be closedltbr gtltbr gtSince Javascript knows a bit more about the HTML it may be a solutionltbr gtltbr gthttpsnipplrcomview3618closetagsinahtmlsnippetltbr gtltbr gtAnother approach would be to strip away all but basic text markup tags italic bold etc  The striptags function will allow you to list permitted tags which are not strippedltbr gtltbr gthttpusphpnetstriptagsltbr gtltbr gtObviously if you are showing the first part of a long table youd want to decide if you are going to break it at a row ending amplttrampgt or some other placeltpgt ltpgtIts just what you would find in a BODY or DIV tagltbr gtltbr gtltbr gtThats not a problem the site isnt that busyltbr gtampgt I assume you want ALL of the remaining tags in the remainder of theltbr gtltbr gtJust the matching closing tags  As it is now I get a teaser but I lose paragraphing and formatting bolding etcltpgt</description>
      <pubDate>Wed, 26 Aug 2009 02:14:30 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Optimizing query</title>
      <link>http://php.diigit.com/php-ask-questions/unknown_1.html</link>
      <description>ltpgtHello Allltbr gtPlease help me on optimizing following queryltbr gtltbr gtI found that this query might have caused the problem that I haveltbr gtmentioned in last post In my server error log I can see problems withltbr gtthis queryltbr gtltbr gtIt shows following message before query which I can not understandltbr gtQuerytime 5  Locktime 0  Rowssent 0  Rowsexamined 0ltbr gtltbr gtAny help will be appreciatedltbr gtltbr gtThanksltbr gtQueryltbr gtltbr gtSELECT  FROM tblauction ta tblcategory tcltbr gt SELECT  chews up RAM  specify the field names if possibleltbr gtWHERE tadisplayfrontyesltbr gtAND taauctiontypepennyltbr gtAND tastatusLiveltbr gtAND tcstatusenabledltbr gtAND tccatidtacatidltbr gtAND tastartdateamplt20090728 053652ltbr gt amplt is two comparisons  use amplt insteadltbr gt A time stamp would be much faster if this is stringltbr gtAND ltbr gtltbr gttacountries2ltbr gtOR tacountries LIKE 2ltbr gtOR tacountries LIKE 2ltbr gtOR tacountries LIKE 2ltbr gtltbr gt LIKE is the biggest resource consumer and you have three of themltbr gtORltbr gtltbr gt11 AND pregion1ltbr gtltbr gt WTF just use pregion1 one evaluation instead of fourltbr gtORltbr gtltbr gtpregion0 AND 11ltbr gtltbr gtltbr gtORDER BY taenddate ASCltbr gtLIMIT  0 10ltbr gtltbr gtThis query is a monster The LIKE is a big resource eater The time would be much faster as a UNIX time stampltbr gtltbr gtYour indexing may be the problem as wellltbr gtltbr gtI would be looking at breaking into a number of queriesltbr gtUse tacountries2 in the first and if it yelds no results then use theltbr gttacountries LIKE 2 OR tacountries LIKE 2 OR tacountries LIKEltbr gt2ltpgt  ltpgtyour query is ltbr gtSELECT ltbr gtFROMltbr gttblauction taltbr gttblcategory tcltbr gtWHEREltbr gttadisplayfrontyesltbr gtANDltbr gttaauctiontypepennyltbr gtANDltbr gttastatusLiveltbr gtANDltbr gttcstatusenabledltbr gtANDltbr gttccatidtacatidltbr gtANDltbr gttastartdateamplt20090728 053652ltbr gtAND ltbr gtltbr gttacountries2ltbr gtORltbr gttacountries LIKE 2ltbr gtORltbr gttacountries LIKE 2ltbr gtORltbr gttacountries LIKE 2ltbr gtltbr gtORltbr gt 11 AND pregion1ltbr gtORltbr gtpregion0 AND 11ltbr gtltbr gtORDER BYltbr gttaenddate ASCltbr gtLIMIT 0 10ltbr gtthe field pregion belongs to which tableltpgt ltpgtAND ltbr gtltbr gttacountries2ltbr gtOR tacountries LIKE 2ltbr gtOR tacountries LIKE 2ltbr gtOR tacountries LIKE 2ltbr gtltbr gt LIKE is the biggest resource consumer and you have three of themltbr gtltbr gtThis query is a monster The LIKE is a big resource eater The time would be much faster as a UNIX time stampltbr gtltbr gtYour indexing may be the problem as wellltbr gtltbr gtI would be looking at breaking into a number of queriesltbr gtUse tacountries2 in the first and if it yelds no results then use theltbr gttacountries LIKE 2 OR tacountries LIKE 2 OR tacountries LIKEltbr gt2ltbr gtltbr gtIt also may be worth looking at using a regular expression using MySQLs RLIKE clause  With it you should be able to get this down to one clauseltbr gtltbr gtIndexes as indicated on the error page will be important to the performance of a query like thisltbr gtltbr gtThere is an ability for MySQL to turn on logging for slow queries  I also think that EXPLAIN has some application on tuning like you are trying to do hereltbr gtltbr gtAt least your host has a mechanism for monitoring and warning on CPU usageampnbsp Many do notltpgt</description>
      <pubDate>Wed, 26 Aug 2009 02:10:31 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>SSL: as a transport WAMP</title>
      <link>http://php.diigit.com/php-ask-questions/ssl-transport-wamp.html</link>
      <description>ltpgtHelloltbr gtltbr gtHas anyone installed SSL as an inbound transport for WAMPltbr gtltbr gtI am NOT trying to use httpslocalhost for outbound data and I dont need to install a secure certificateltbr gtltbr gtI am trying to make outbound connections withltbr gtfsockopensslsomedomaincom 433  so that I can send secure POST data to a secure server and have it respond with secure data ie the security certificate is on the external serverltbr gtltbr gtAny hints pleaseltbr gtltbr gtI am using the latest version of WAMP 2ltpgt </description>
      <pubDate>Wed, 26 Aug 2009 02:05:03 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Reusing code</title>
      <link>http://php.diigit.com/php-ask-questions/reusing-code.html</link>
      <description>ltpgtHelloltbr gtltbr gtI am trying to replace the number of repeated code with require functionltbr gtRequiring another PHP page that has only text the online code view Source shows the text from the other php file and hides the codeltbr gtltbr gtRequiring the Header file that repeats on every page shows all code and treated as a regular HTML fileltbr gtltbr gtHeader php has ampltheadampgt amplttitleampgtampltbodyampgt picture table etc When it is all uploadedltbr gtSome HTML tags are showing twiceTAGS from the main page and from calling pageltbr gtltbr gtShould it show HTML codeltbr gtltbr gtThanksltpgt  ltpgtYour explanation is a bit confusingltbr gtltbr gtThe include function will always parse the included file for php no matter what the file extension is php opening and closing tags are required or the code will be displayedltbr gtltbr gtBy convention the extension php is used to prevent others from using a browser to see your code by entering the url to the included file directlyltbr gtltbr gtIf the included file is just html then htm html or even txt is fine as a file extensionltbr gtltbr gtOther extensions such as inc are used but generally only when the included files are outside of the http directory tree so they cannot be accessed with a browser to reveal the code withinltbr gtltbr gtFor html headers and footers there is one common issue and that is the page title in the head elementltbr gtltbr gtOne way around this is to assign the variable title before including the file and having the file like this ltbr gtamplthtmlampgtltbr gtampltheadampgtltbr gtltbr gtamplttitleampgtampltphp echotitle ampgtamplttitleampgtltbr gtampltheadampgtltbr gtampltbodyampgtltbr gtObviously doing it this way requires the file to be parsed for phpltbr gtltbr gtAnother way is stream the file through php Make header like this ltbr gtamplthtmlampgtltbr gtampltheadampgtltbr gtamplttitleampgtamplttitleampgtltbr gtampltheadampgtltbr gtltbr gtampltbodyampgtltbr gtltbr gtAnd do this in php Assuming the above code is called headertxt ltbr gtltbr gtampltphpltbr gttitle  Home Pageltbr gttitle  amplttitleampgt  title  amplttitleampgtltbr gtheader  filegetcontentsheadertxtltbr gtheader  strreplaceamplttitleampgtamplttitleampgt title headerltbr gtechoheaderltpgt ltpgtPerhaps you might like to look at SSI Server Side Includes This is an alternative that doesnt have the overhead of loading php Or you can use a mix of SSI and phpltbr gtltbr gtPersonally I try not to have too much code php or HTMLJS etc duplicated on a site Some times it is unavoidableltbr gtltbr gtSome sites go too far and they end up with bottlenecks that cause tread timeouts On a good server this should not be an issue but in a shared server environment sometimes the repeated disk access to a single file like one CSS file that serves the whole site not enough RAM to cache will drop threadsltpgt ltpgtThanks for the detailed answer that makes senseltbr gtltbr gtI have a few more questionsltbr gtltbr gt1 the part of the code I am trying to make to work is in ampltbodyampgtthat includes a picture Its a part of the web banner that is on  every pageltbr gtIs assigning variable for the image a regular way to include pictures into reusable codeltbr gtltbr gt2The code that  can be previewed locally shows ltbr gtltbr gtampltphpltbr gtrequiremenuphpltbr gtltbr gtampgtltbr gtmenuphp is a regular html fileltbr gtOnline browser renders and shows whole code that was called from another page Mainly the purpose is  to make pages easer and faster to load and not to have to paste the same html code into every pageltbr gtltbr gtIs it how it should be expectedltbr gtltbr gtI also have Java Script code that is included into every page and also included into remote fileltbr gtPhp treats it the same way Online in code  shows builtin JS  html code Just like it never been moved into another fileltbr gtJS is for drop down menultpgt</description>
      <pubDate>Wed, 26 Aug 2009 02:03:57 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Installing PHP on a IIS Server</title>
      <link>http://php.diigit.com/php-ask-questions/installing-php-iis-server.html</link>
      <description>ltpgtHelloltbr gtltbr gtIm trying to install PHP on a IIS Server and Im seeming to be running in to some problemsltbr gtltbr gtHere are the problemsltbr gt1 When I install PHP the sapi directory is not installingltbr gt2 I setup PHP accordingly but the page is not runningltbr gtltbr gtAny help would be good Thank youltpgt </description>
      <pubDate>Wed, 26 Aug 2009 01:47:05 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>best suggested hosting company for larger database website?</title>
      <link>http://php.diigit.com/php-ask-questions/best-suggested-hosting-company-larger-database-website.html</link>
      <description>ltpgtI have a site that has 10000 products and using osCommerce Rightnow we are in plan of changing the hostingltbr gtltbr gtWhat you guys suggest Have anybody has any such experienceltbr gtRegardsltpgt  ltpgtFor larger sites or fast websites I would always recommend a VPS virtual private serverltbr gtMost require you to know Linux but some come with excellent support and web interfaces to manage the VPS There are also VPS built on Windows but they tend to be a bit more expensive I would never run a web server on Windows but people have been know to do crazy things A VPS is a step up from shared hosting and towards your own dedicated serverltbr gtltbr gtThe best company I have used so far is slicehostcom They offer cheap VPS and fast support My current server uptime with them is around 470 days I dont think slicehostcom will provide you with a web management control panel so you need to know Linux My only complaint with them is that they only accept credit card payments AFAIK they are a child company of RackSpacecomltbr gtltbr gtI just signed up with knownhostcom yesterday They offer a managed VPS solution so you dont need to know much about server management They also offer you a choice of web interfaces to manage your server I dont use the web interface since I know my way around the command line knowhostcom accepts credit cards and PayPalltbr gtltbr gtAs far as shared hosting providers are concerned I cant recommend any I have used GoDaddy Yahoo Omnis Dotster and a few others GoDaddy and Dotster where the worst of the four mentioned Horribly slow shared SSL slow page loads at times database issues  you name it The experience with shared hosting providers made me look for an alternative Now that I use virtual private servers I would only consider shared hosting for a tiny static websiteltbr gtltbr gtYou may want to head over to httpwwwwebhostingtalkcom to find user reviews of hosting companiesltpgt ltpgtWho have you looked atltbr gtI personally like Dot 5 and Monster Host Both have good php support Unlike Godaddy not a suggestion who seems to not have stable php platform Dot 5 I have never worried aboutltpgt</description>
      <pubDate>Wed, 26 Aug 2009 01:45:36 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Account Exceeded CPU Quota</title>
      <link>http://php.diigit.com/php-ask-questions/account-exceeded-cpu-quota.html</link>
      <description>ltpgtI came across this when I was using the site This Account Has Exceeded Its CPU Quotaltbr gtltbr gtPlease contact this sites webmasterltbr gtltbr gtWait a few minutes and use your browsers ampquotBackampquot button or click here to try againltbr gtltbr gtIf you are the webmaster your account may have gotten this error for one or more of the following reasonsltbr gtltbr gt Your account has used more than its share of the cpu in      the past 60 second sliding windowltbr gt Your account has too many concurrent processes running simultanouslyltbr gt Your account has consumed too much memoryltbr gt Your site was recently very busy trying to run      inefficient scriptsltbr gtltbr gtThe solution would be to optimize your applications to use less CPU Adding appropriate indeces to your SQL tables can often help reduce CPUltbr gtUsing static html documents instead of painful php scripts will practically eliminate CPU usage I have been able to bring up a new browser and use the site again but I thought I should know why it appeared onltpgtltpgtThanksltpgt  ltpgtYou should have a countries table containing all the countryID and countryNamesltbr gtltbr gtThen you should have an auctioncountry table which has fields for auctionID and countryID  You would use this table to look up whether an auction is available in a specific countryltbr gtltbr gtExtra coding but extra speedltbr gtltbr gtPlus you would be able to provide a list of auctions available in a countryltbr gtltbr gtI live in Spain you would be able to quickly give a list of auctions available here Otherwise I would just keep clicking through all the auctions being told that they werent available in Spain and after the first two or three I would give up and go awayltpgt ltpgtOK so my guess about your logic was a bit off but neverthelessltbr gtI have used countries field to store the country ids like 1 5 23 ampgt in above exampleltbr gtmy guess about the final result in that you were storing a commseparated list of country IDs was right And this way of storing data remains wrongltbr gtltbr gtcreate a separate table of countries you already seem to have one actually and create a connecting table containing as indexed fields only the ID of the auction and the ID of the country Use this rather than the countries field and search straight away for a value Study a bit about making JOINsltbr gtltbr gtAh one more thing against your ampquotsolutionampquotltbr gtYou were using ampquotLIKEampquot in the following wayltbr gtampquotWHERE tacountries2 OR tacountries LIKE 2 OR tacountries LIKE 2 OR tacountries LIKE 2ampquotltbr gtltbr gtNow consider what happens when the first country listed for an auction has number 12 the value stored being something like 12 15 35 Or that theltbr gtlast country in the list is anything like 21 22 23 or 202 the value stored being 11321 or 335201ltbr gtYour query would falsely include those auctions as wellltbr gtAnd now what if the auction was available ONLY in country ampquot2ampquot The field would contain a plain ampquot2ampquot without a comma and the auction would still be omitted from the listltbr gtltbr gtIt is very simple if you are looking for a number dont use text related functions like ampquotLIKEampquot And multiple values do NOT belong in a single cell If there is one or a fixed low number of times a value needs to be stored use one or n fields in one table to store the values If there is a need to store a value once or any nonpredefined amount ofltbr gttimes that a value needs to be stored use a socalled connecting or linking table Otherwise database maintenance soon will become hellltpgt ltpgtThe above explains it either one of your scripts is generating too much load endless loop or your website has a lot of visitors Visitors will run your scripts every time they load a webpage so the more visitors the more load your visitors generate on the server Since shared hosts tend to oversell the server they dont like websites with a lot of loadltbr gtThis is pretty much how ISPs work as well ISPs connect as many people as they can to their service hoping that none of the users will attempt to use the service at the same time or use more then heshe shouldltbr gtltbr gtIf this is your website you may want to optimize your scripts to reduce server load or move to a better hosting company I posted a little review of two VPS providers yesterday with the subjectltbr gtltbr gtampquotbest suggested hosting company for larger database websiteampquotltpgt ltpgttastatusLiveltpgtltpgta few ways to optimiseltbr gt1 dont select ampquotampquot unless you really need all the fields in both tables Just state the fields you need insteadltbr gt2 create indexes on tadisplayfront taauctiontype tastatus tcstatus and tacountriesltbr gt3 DEFINITELY CREATE INDEXES ON tccatid and tacatidltbr gt4 think of a different way to organise tacountries A country can only be one and there is only a limited number of countries in this world I thus see no reason whatsoever to use ampquotLIKEampquot to search a countrycode Why thisltbr gtampquotWHERE tacountries2 OR tacountries LIKE 2 OR tacountries LIKE 2ltbr gtOR tacountries LIKE 2ampquot ltbr gtltbr gtLets just guess your country is coded like abc where a is continent b the country and c the state say europe france iledefrance then why not make a table contionents a table countries and a table states Or when not wanting the joins involved and given the number of possible countries is limited anyway create in the countries table three distinct fields that you can index and search an exact matchltbr gtltbr gtAnother guess is that you coded the country say netherlands 2 and its neighbours belgium 1 luxemburg 3 germany 4 and that in your table now netherlands has a field containing 234 indicating its neighbours and correspondingly belgium has a field with content 1345 and so on guess you want only people from the country itself and its neighbours to bid Rather than doing this you cound create a table countryneighbours with two fieldsltbr gtcncountryID and cnneighbourID Every country will have one or more than one entries in this table Now instead of doing a ampquotLIKEampquot search where you try to localise info in altbr gtcommacomposed string you do a straight search on either one of two indexed numerical fields you search the country number or you search the neighbouring country numberltbr gtltbr gtLIKE is something you use to search something vague in undefined content You should avoid it to seek something as well defined as a specific country in a listing with a limited number of options Do not store series of numbers in one field separated by commas Use separate fields always X related numerical data per record or a secondltbr gttable notfixed number of related numerical data insteadltbr gtltbr gtOf course when reforming the countries table make sure you create indexes on fields you will later use to conduct searches That is what indexes are all aboutltbr gtltbr gtORDER BY taenddateltbr gtSo one more field that needs either to be indexed or be of a date or time typeltbr gtltbr gtHope this helpsltbr gtltpgt ltpgtThank You for Responseltbr gtI am sorry for not explaining my problem clearly What situation I have is Admin choose the countries where the auction should go Live or you can say those countries where auction is available for bidding Now say admin added an auction for countriesUSAid 1 France id 5 and Japanid 23ltbr gtI have used countries field to store the country ids like 1 5 23 in above example Now above auction should be available to only users who logged in from USA France and japan regions and obviously not for others As you might guess now I need to find out whether users country idampnbsp is in countries fieldltbr gtltbr gtPlease post your valuable suggestion how can I found whether country id is in countries field or notltbr gtltbr gtHope it makes senseltbr gtThanksltpgt ltpgtThe whole technique is wrong Sorry ltbr gtltbr gtCountries dont move and we dont get a new country every week or have one disappearltbr gtltbr gtSo why calculate in anyway proximity on every page loadltbr gtltbr gtYou could number countries so that you can use something likeltbr gtWHERE ABSusercountry  auctioncountry amplt 3ltbr gtltbr gtBetter still just have a table for each regioncountry that indexes the groups of regionscountries to include auctions fromltbr gtltbr gtThen the calculation only has to be done once when building the index table and the query can OR the regions so that it is so so so much faster than LIKEltbr gtltbr gtWhen I have a complex issue like this I do the number crunching on a PC and use the development server to directly connect to the live database and make the necessary changesltbr gtltbr gtSure MySQL can do complex number crunching but it is NOT good at it and it will cost dearly in server performanceltbr gtltbr gtWhy repeat calculation that only need to be done onceltbr gtltbr gtThanksltpgt ltpgtThe whole technique is wrong Sorry ltbr gtltbr gtCountries dont move and we dont get a new country every week or have one disappearltbr gtltbr gtSo why calculate in anyway proximity on every page loadltbr gtltbr gtYou could number countries so that you can use something likeltbr gtWHERE ABSusercountry  auctioncountry amplt 3ltbr gtltbr gtBetter still just have a table for each regioncountry that indexes the groups of regionscountries to include auctions fromltbr gtltbr gtThen the calculation only has to be done once when building the index table and the query can OR the regions so that it is so so so much faster than LIKEltbr gtltbr gtWhen I have a complex issue like this I do the number crunching on a PC and use the development server to directly connect to the live database and make the necessary changesltbr gtltbr gtSure MySQL can do complex number crunching but it is NOT good at it and it will cost dearly in server performanceltbr gtltbr gtWhy repeat calculation that only need to be done onceltbr gtltbr gtThanksltbr gtltbr gtPS send a link to the country codes you are using and some indication of what you consider close enough for inclusion for auctions then we can send some suggestionsltpgt</description>
      <pubDate>Wed, 26 Aug 2009 01:41:07 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Howto: fix the DOCUMENT_ROOT problem on WAMPServer with VHOST</title>
      <link>http://php.diigit.com/php-ask-questions/howto-fix-documentroot-problem-wampserver-vhost.html</link>
      <description>ltpgtHello allltpgtltpgtI am hoping someone can suggest a better solution than I have here for the DOCUMENTROOT problem in WAMPServerltbr gtltbr gtThe problem is that if you are developing a site in Cwampwwwwebsite theltbr gtDOCUMENTROOT points to Cwampwwwltbr gtltbr gtThe default build of WAMPServer 20 appears to try to get around this problem by passing the full URI to the environment rather than the remaining part of the URI from the current folder locationltbr gtltbr gtSo if you are trying to access Cwampwwwwebsitetranslatedindexphp and you have the htaccess file Cwampwwwwebsitehtaccess you would expect the access request would be passed to the htaccess file as the URI translatedindexphp but in WAMPServer it is passed as Cwampwwwwebsitetranslatedindexphp  This obviously makes writing REGEX for RewriteRule and RewriteCond very different to a live server Also with SSI subfolders of a website directory are requested from the DOCUMENTROOT folder So if you are trying to access Cwampwwwwebsitessiheaderhtm with a relative path Apache looks for Cwampwwwssiheaderhtmltbr gtltbr gtThis creates a mess when having to use SSI or MODREWRITE as both of these are specific to the DOCUMENTROOTltbr gtltbr gtHere is the VHOST solution for Windows XP PRO SP3 and WAMPServer 20 Apache 2211ltbr gtltbr gtVHOST is a way to point a hostname directly to a folder so that that folder then becomes the DOCUMENTROOTltbr gtltbr gtFirst choose a hostname I dont recommend you use a TLD or dotted domain name as the OS may attempt to resolve this through DNS so use a hostname of example rather than examplecomltbr gtltbr gtNow you have to tell the OS and browser what IP address to look for the host nameltbr gtltbr gtOn Windows XP open ltbr gtCWINDOWSsystem32driversetchostsltbr gtThere you will see ltbr gt127001       localhostltbr gtAdd the following assuming you chose example as hostname ltbr gt127001       exampleltbr gtltbr gtNow you have to tell Apache where to look for filesltbr gtOpen ltbr gtCwampbinapacheApache2211confhttpdcongltbr gtand remove any  or spaces before ltbr gtInclude confextrahttpdvhostsconfltbr gtltbr gtOpen ltbr gtCwampbinapacheApache2211confextrahttpdvhostsconfltbr gtltbr gtHere you will see something like ltbr gtampltVirtualHost 80ampgtltbr gtServerAdmin somoneltbr gtltbr gtDocumentRoot ampquotCwampwwwampquotltbr gtServerName localhostltbr gtErrorLog ampquotlogslocalhosterrorlogampquotltbr gtCustomLog ampquotlogslocalhostaccesslogampquot commonltbr gtampltVirtualHostampgtltbr gtltbr gtAdd something like this ltbr gtltbr gtampltVirtualHost 80ampgtltbr gtServerAdmin somoneltbr gtDocumentRoot ampquotCwampwwwexampleampquotltbr gtServerName exampleltbr gtErrorLog ampquotlogsexampleerrorlogampquotltbr gtCustomLog ampquotlogsexampleaccesslogampquot commonltbr gtltbr gtampltVirtualHostampgtltbr gtltbr gtThe ServerAdmin is the default FROM address for system generated email and is also displayed as a contact email for server failure pagesltbr gtltbr gtYou will have to Restart Apache but mor importantly you may also need to reboot so that the OS sees the changes to the hosts fileltpgt </description>
      <pubDate>Wed, 26 Aug 2009 01:18:18 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Memory Error</title>
      <link>http://php.diigit.com/php-ask-questions/memory-error.html</link>
      <description>ltpgtFatal error Allowed memory size of 16777216 bytes exhausted tried to allocate 238 bytes in virtualuserse1574416642webgraphsbarophp on line 81ltbr gtltbr gtThats a ram usage error  rightltpgt </description>
      <pubDate>Wed, 26 Aug 2009 01:16:08 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>PHP Mail function</title>
      <link>http://php.diigit.com/php-ask-questions/php-mail-function_1.html</link>
      <description>ltpgtHelloltpgtltpgtI have used windows OS and Xampp control  But I cant send a mail to my yahoo ID I got a problem with PHPampacircampeuroamptrades mail  which was not sending any email messages outIm sending you my php coding If you see any problem or any mistake in my code then plz tell me and suggest me how i can sendltbr gtltbr gtAnd I did some changes in sendmailiniltbr gtsendmailltbr gtltbr gtyou must change mailmydomaincom to your smtp serverltbr gtsmtpservermailmydomaincomltbr gtltbr gtsmtp port normally 25ltbr gtltbr gtsmtpport25ltbr gtltbr gtif your smtp server requires authentication modify the following two linesltbr gtltbr gtauthusernameusernameltbr gtauthpassworddrowssapltbr gtltbr gtif your smtp server uses pop3 before smtp authentication modify theltbr gtfollowing three linesltbr gtltbr gtpop3servermailmydomaincomltbr gtpop3usernameusernameltbr gtpop3passworddrowssapltbr gtmy code is hereltbr gtampAcirc ltbr gtmailhtmlltbr gtamplttable widthampquot400ampquot borderampquot0ampquot alignampquotcenterampquot cellpaddingampquot3ampquot cellspacingampquot1ampquotampgtltbr gtltbr gtamplttrampgtltbr gtamplttdampgtampltstrongampgtContact Form ampltstrongampgtamplttdampgtltbr gtamplttrampgtltbr gtamplttableampgtltbr gtltbr gtamplttable widthampquot400ampquot borderampquot0ampquot alignampquotcenterampquot cellpaddingampquot0ampquot cellspacingampquot1ampquotampgtltbr gtltbr gtamplttrampgtltbr gtamplttdampgtampltform nameampquotform1ampquot methodampquotpostampquot actionampquotsendcontactphpampquotampgtltbr gtamplttable widthampquot100ampquot borderampquot0ampquot cellspacingampquot1ampquot cellpaddingampquot3ampquotampgtltbr gtltbr gtamplttrampgtltbr gtamplttd widthampquot16ampquotampgtSubjectamplttdampgtltbr gtamplttd widthampquot2ampquotampgtamplttdampgtltbr gtamplttd widthampquot82ampquotampgtampltinput nameampquotsubjectampquot typeampquottextampquot idampquotsubjectampquot sizeampquot50ampquotampgtamplttdampgtltbr gtltbr gtamplttrampgtltbr gtamplttrampgtltbr gtamplttdampgtDetailamplttdampgtltbr gtamplttdampgtamplttdampgtltbr gtamplttdampgtamplttextarea nameampquotdetailampquot colsampquot50ampquot rowsampquot4ampquot idampquotdetailampquotampgtamplttextareaampgtamplttdampgtltbr gtltbr gtamplttrampgtltbr gtamplttrampgtltbr gtamplttdampgtNameamplttdampgtltbr gtamplttdampgtamplttdampgtltbr gtamplttdampgtampltinput nameampquotnameampquot typeampquottextampquot idampquotnameampquot sizeampquot50ampquotampgtamplttdampgtltbr gtltbr gtamplttrampgtltbr gtamplttrampgtltbr gtamplttdampgtEmailamplttdampgtltbr gtamplttdampgtamplttdampgtltbr gtamplttdampgtampltinput nameampquotcustomermailampquot typeampquottextampquot idampquotcustomermailampquot sizeampquot50ampquotampgtamplttdampgtltbr gtltbr gtamplttrampgtltbr gtamplttrampgtltbr gtamplttdampgtampampnbspamplttdampgtltbr gtamplttdampgtampampnbspamplttdampgtltbr gtamplttdampgtampltinput typeampquotsubmitampquot nameampquotSubmitampquot valueampquotSubmitampquotampgt ampltinput typeampquotresetampquotltbr gtltbr gtnameampquotSubmit2ampquot valueampquotResetampquotampgtamplttdampgtltbr gtamplttrampgtltbr gtamplttableampgtltbr gtampltformampgtltbr gtamplttdampgtltbr gtamplttrampgtltbr gtltbr gtamplttableampgtltbr gtltbr gtsendcontactphpltbr gtampltphpltbr gt Contact subjectltbr gtsubject ampquotsubjectampquotltbr gt Detailsltbr gtmessageampquotdetailampquotltbr gt Fromltbr gtheaderampquotfrom name ampltmailfromampgtampquotltbr gtltbr gt Enter your email addressltbr gtto karthickcse06ltbr gtltbr gtsendcontactmailtosubjectmessageheaderltbr gtltbr gt Check if message sent to your emailltbr gt display message ampquotWeve recived your informationampquotltbr gtifsendcontactltbr gtecho ampquotWeve recived your contact informationampquotltbr gtltbr gtelse ltbr gtecho ampquotERRORampquotltbr gtltbr gtampgtltbr gtltbr gtWarning mail functionmail SMTPltbr gtserver response 550 The address is not valid inltbr gtCxampphtdocstest2sendcontactphp on line 12ltbr gtERRORltbr gtampnbspltpgt </description>
      <pubDate>Wed, 26 Aug 2009 01:14:32 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>How to send Mail using PHP form</title>
      <link>http://php.diigit.com/php-ask-questions/send-mail-using-php-form.html</link>
      <description>ltpgtHelloltbr gtltbr gtPlease any one can suggest me  how do i send a mail in localhost using PHP I try to sending a mail but i cant do it  Some SMTP error has been occurred ltbr gtHow do i edit the phpini file Please  if any one can know send me step by step procedure its very helpful to meltpgtltpgtthank youltpgt  ltpgtHiltpgtltpgtThough you didnt tell your OS I think this tutorial will help youltbr gtltbr gthttpgunnerpresscomwebdevhowtosendemailwithxampponwindowsxpltpgt</description>
      <pubDate>Wed, 26 Aug 2009 01:12:28 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Create a user</title>
      <link>http://php.diigit.com/php-ask-questions/create-user.html</link>
      <description>ltpgtHelloltbr gtltbr gtAny one can help meHow do I create the login page using PHP If i signupthe user name and password can stored in database ltbr gtexample of yahoo login pageltbr gtltbr gtthank youltpgt </description>
      <pubDate>Wed, 26 Aug 2009 01:09:07 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>RSS Scrapper</title>
      <link>http://php.diigit.com/php-ask-questions/any-help-this-rss-scrapper.html</link>
      <description>ltpgtHai Friendsltbr gtltbr gtCan you help for this taskltbr gtltbr gtI dont know how to start this workltbr gtltbr gtt have no idea for this taskltbr gtltbr gtSo if anyone know this concept please help meltbr gtltbr gtotherwise give any link for this taskltbr gtThe Task is thatltbr gtltbr gtWere looking for a developer that can add the next functions to theltbr gtWPOMatic Wordpress Plugin based in SimplePie RSS Scrapperltbr gt1 To add an option for feed autotranslation via Google Translator API autodetecting original language and selecting output languageltbr gt2 To add a script that can get the full feed instead of only the excerpt See the Webampamp39s breaking stories chosen by people like you Check outltbr gtYahoo Buzz httpinbuzzyahoocomltpgt </description>
      <pubDate>Wed, 26 Aug 2009 01:07:58 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>WAMPServer SSI</title>
      <link>http://php.diigit.com/php-ask-questions/wampserver-ssi.html</link>
      <description>ltpgtHello allltpgtltpgtI am hoping someone can help with a WAMPServer issueltbr gtltbr gtThe normal document root for WAMPServer is Cwampwww and this causes problems when I developing for websites that are in a subfolder of this directoryltbr gtltbr gtIdeally the Document root should be the folder below wampwwwltbr gtltbr gtMost of the time a simple change to scripts will get around this but I now have a more complex issueltbr gtltbr gtI am running Server Side Includes and these always start from the document rootltbr gtltbr gtSo if I have wampwwwmywebsitecomindexshtml and I have my SSI inltbr gtwampwwwmywebsitecomssiltbr gtltbr gtWhen I try to include ssitemplatehtm the server is looking for wampwwwssitemplatehtm instead ofltbr gtwampwwwmywebsitecomssitemplatehtmltbr gtltbr gtI really dont want to set up a VHOST just for the SSI as I will forget that it has to be accessed from the VHOST instead of the index page in wwwltbr gtltbr gtWhat I am hoping to achieve is to have the situation where IF the current HTTP folder is NOT www than the DOCUMENTROOT becomes the directory below www where the HTTP is accessingltbr gtltbr gtAny suggestions pleaseltpgt </description>
      <pubDate>Wed, 26 Aug 2009 01:04:39 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>How to convert my php based urls into SEO friendly?</title>
      <link>http://php.diigit.com/php-ask-questions/convert-php-based-urls-into-seo-friendly.html</link>
      <description>ltpgtHelloltpgtltpgtMy current CMS based website has the following type of urlsltbr gtltbr gtwwwwebsitecomcategoriesphpid7ltbr gtltbr gtI want to make it user friendly by not showing the PHP and ID thing I know it is possible via htaccess files but no idea how to doltbr gtltbr gtAny ideas on thisltbr gtI am using PHPMySQLltbr gtThanksltpgt  ltpgtYou might want to look at Drupals htaccess file  It uses modrewrite to achieve this  You should be able to look at just the RewriteEngine and RewriteRules lines to create something customltpgt ltpgthtaccess can take you from this URL to wwwwebsitecomcategories7 but this does not make the URL any more search engine friendlyltbr gtltbr gtFor SEO you need wwwwebsitecomcategoriesselfcontainedappartmentsinLA for exampleltbr gtltbr gtYou have to make the unique descriptive keys for the URL and store them in MySQL and then use htaccess to convert the URL so as to include the php file name and keyltbr gtltbr gtWhen you do this there are at least two new issues One is that you need to exclude special URL characters such as ampamp    from the created URLltbr gtltbr gtAnd the other is validation as there is a new opportunity for MySQL injectionltbr gtltbr gtWith the original system validation can be as simple as id  0 ltbr gtGETid and this will always resolve to an numberltbr gtltbr gtWith the new system someone could enter the URLltbr gtwwwwebsitecomcategoriesOR201 to see more than they should or even worse ltbr gtwwwwebsitecomcategoriesOR2013BDROP20 to wipe your tablesltpgt ltpgtNo i am not using Drupalltbr gtThe CMS is made by me The site contains Categories and Articles insideltbr gtthose categoriesltbr gtCheckout the following linkltbr gthttpwwwflawlessplasticsurgeryguidecomltbr gtltbr gtltbr gtltbr gtltbr gtltbr gtltbr gtltbr gtltbr gtltpgt ltpgtThanks a lot for the infoltbr gtcan you please briefly explain thisltbr gtltbr gt htaccessltbr gtHow can i extend the above rule to the following urlsltbr gthttpwwwsitecomviewArticlephpmenuSun20GlassesampampmainmenuID13ampamparticleID8ltbr gtampamptitleBlack20Sun20Glassesltbr gtThanks againltbr gtltbr gtNote We post below the previous text in this groupltbr gtltbr gtYou didnt give an example of the URL that you want to rewrite the above URLltbr gttoltbr gtIt can be rewritten but there may be issues like the number of IDs An order for the IDs can be assumed as long as the URL is not being generated from a POST or GET method HTML ampltFORMampgt as some browsers send the IDs in a different order As a straight php generated URL the order is fineltbr gtltbr gtAnother consideration is are all of the IDs required or is it ok forltbr gtsome to be missing if so which onesltbr gtltbr gtUnmatched URLS goto ERROR 404ltbr gtltbr gtRewrite Mod Rewrite Rules are REGEX You can google REGEX but be warned it takes time to get used toltbr gtltbr gtI will try to explain ltbr gtRewriteRule string to match string to replace withltbr gtltbr gt donates the start of the string in this case it is the URL with theltbr gthttpwwwwebsitecom truncated off the startltbr gtThen the text categories must match after the start of the stringltbr gtThen it must match  which means one or more charactors that are NOTltbr gt  ltbr gtThe  mean save these charactors for the rewriten URLltbr gtthe  mean a group of acceptable charactorsltbr gtand the  inside the  means NOTltbr gtthe  means one or moreltbr gtthe saved charactors are represented by 1ltbr gtyou can have several sets of save charactors by using sets of  and theyltbr gtthen become 1 2 3 etcltbr gtltbr gtthe categoriesphpid1 means the new file name technicaly URL isltbr gtcategoriesphpid with the saved charactors attachedltbr gtltbr gtThe second url that you gaveltbr gtviewArticlephpmenuSun20GlassesampampmainmenuID13ampamparticleID8ampamptitleBlack20Sun2ltbr gt0Glassesltbr gtis not the best for SEOltbr gtfor SEO it should beltbr gtviewArticlephpmenuSun20GlassesampamptitleBlack20Sun20GlassesampampmainmenuID13ampampartltbr gtltbr gticleID8ltbr gtto map this toltbr gtviewArticleSun GlassesBlack Sun Glasses138ltbr gtltbr gtI need to know which fields menu title IDs ARE required and which ones are NOTltpgt ltpgtSuperb Helpltbr gtThanks a lotltbr gtYou really explained it all in just few words ltbr gtltbr gtThe URL that i gave you contains everything mandatoryltbr gtHere is the siteltbr gthttpwwwflawlessplasticsurgeryguidecomltbr gtltbr gtAnd here is one of the example link that wanted to be SEO Friendlyltbr gthttpwwwflawlessplasticsurgeryguidecomviewArticlephpmenuFacial20Procedultbr gtltbr gtampltlistgroups09ampltlistgroups0940ozwebwizcomampgtampgtltbr gtltbr gthttpwwwsitecomviewArticlephpmenuSun20GlassesampampmainmenuID13ampamparticleID8ltbr gtltbr gtampamptitleBlack20Sun20Glassesltbr gtltbr gtltbr gtviewArticlephpmenuSun20GlassesampampmainmenuID13ampamparticleID8ampamptitleBlack20Sun2ltbr gt0Glassesltbr gtltbr gtviewArticlephpmenuSun20GlassesampamptitleBlack20Sun20GlassesampampmainmenuID13ampampartltbr gticleID8ltpgt ltpgtJust looking at the REGEX again I am not sure the escape is requiredltbr gtbefore the  within the  so it may need to be ltbr gtArticleltbr gtltbr gtAlso I forgot to mention the L at the end of the RewriteRule lineltbr gtltbr gtMod Rewrite in htaccess slows server performance so the L tells it not toltbr gtcheck for rewrites again that would slow the server even moreltbr gtltbr gtMod rewrite in htaccess converts the new filename back to a URL and then requests the new URL so it would otherwise test the rewrite rule again without the Lltbr gtltbr gtDont use R or Rxxx as this is not SEO friendlyltbr gtltbr gtAlso do you need Article ltbr gtltbr gtPerhaps ltbr gtBreast ProceduresBreast AugmentationmainmenuID13ampamparticleID8ltbr gtltbr gt viewArticlephpmenu1ampamptitle2ampamp3 Lltbr gtltbr gtSome safer urls ltbr gtBreastProceduresBreastAugmentationmainmenuID13ampamparticleID8ltbr gtBreastProceduresBreastAugmentationmainmenuID13ampamparticleID8ltpgt ltpgtOk we live and we learn ltbr gtltbr gtThe problem is that the query string is not a part of REQUESTURIltbr gtltbr gtThe easy solution is to drop the query string alltogether ltbr gtltbr gtviewArticlephpmenuBreast20ProceduresampampmainmenuID13ampamparticleID8ampamptitleBreastltbr gt20Augmentationltbr gtshould become ltbr gtviewArticleBreast ProceduresBreast Augmentation138ltbr gtltbr gtthe new REGEX should be ltbr gt htaccessltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI viewArticleltbr gtRewriteRule viewArticleltbr gtviewArticlephpmenu1ampamptitle2ampampmainmenuID3ampamparticleID4 Lltpgt ltpgthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmainm enuID13ampamparticleID8ltbr gtltbr gtltbr gtBut i enabled a debugging by adding the following lines into the httpdconfltbr gtampgt ampltIfModule modrewritecampgtltbr gtltbr gt127001   18Aug2009071707 0700ltpgt ltpgtviewArticlephpmenuBreast20ProceduresampampmainmenuID13ampamparticleID8ampamptitleBreastltbr gt20Augmentationltbr gtltbr gtI would sugest ltbr gtArticleBreast ProceduresBreast AugmentationmainmenuID13ampamparticleID8ltbr gtltbr gtArticleltbr gtviewArticlephpmenu1ampamptitle2ampamp3ltpgt ltpgtviewArticlephpmenuBreast20ProceduresampampmainmenuID13ampamparticleID8ampamptitleBreastltbr gt20Augmentationltbr gtltbr gtOK here is my htaccess fileltbr gtltbr gt htaccessltbr gtRewriteEngine Onltbr gtRewriteRule ltbr gtviewArticlephpmenu1ampamptitle2ampamp3 Lbltbr gtltbr gtltbr gtBut it is giving me this errorltbr gtInvalid command RewriteEngine perhaps misspelled or defined by a moduleltbr gtnot included in the server configurationltbr gtAny ideasltbr gtltbr gtMany Thanksltpgt ltpgtNow after that httpdconf edit the Apache error has been resolved but now i am having 404 errorltbr gtltbr gthtaccess file contains thisltbr gtltbr gt htaccessltbr gtltbr gtltbr gtAnd this is the URL that i am trying to useltbr gtltbr gthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmainmltbr gtenuID13ampamparticleID8ltbr gtltbr gtAny ideasltbr gtMany Thanks Guysltpgt ltpgthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmainmltbr gtenuID13ampamparticleID8ltbr gtltbr gtRight now my htaccess file isltbr gtltbr gt htaccessltbr gtltbr gtltbr gtAnd the URL that i am using isltbr gtltbr gthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmainmltbr gtenuID13ampamparticleID8ltbr gtltbr gtltbr gtBut still i am having the 404 errorltbr gtThe error log shows thisltbr gterror client 127001 File does not exist CwampwwwfpsviewArticleltbr gtltbr gtAny commentsltbr gtThanksltpgt ltpgtI removed the NC No Case Sensitivity and put an escape before the  in theltbr gtltbr gt htaccessltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI viewArticleltbr gtRewriteRule viewArticleltbr gtviewArticlephpmenu1ampamptitle2ampamp3 Lltbr gtltbr gtthis is much the same ltbr gt htaccessltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI viewArticleltbr gtRewriteRule viewArticleltbr gtviewArticlephpmenu1ampamptitle2ampamp3 Lltbr gtltbr gtor a bit more restrictive ltbr gt htaccessltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI viewArticleltbr gtRewriteRule viewArticle 09azAZ 09azAZltbr gtviewArticlephpmenu1ampamptitle2ampamp3 Lltbr gtltbr gtYou can also use R browser redirect instead of L Last so that you can see the rewritten url just for testingltpgt ltpgtThere is a space missing in the rewrite rule ltbr gt htaccessltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI Article NCltbr gtRewriteRule Articleltbr gtviewArticlephpmenu1ampamptitle2ampamp3 Lltbr gtltbr gtTo find problems look in ltbr gtCwampbinapacheApache2211logslocalhosterrorlogltpgt ltpgtI created a file htaccess on the root dir and pasted the followingltbr gtltbr gt htaccessltbr gtltbr gtltbr gtAnd when i check in my localhost it says Internal Server Error I checked with the Apache Error Log and it gives the following errorltbr gtltbr gtltbr gtI am using WAMP ver 20 and PHP ver 526 Any ideasltbr gtThanksltbr gtltbr gtYour post are confusing to read We post BELOW the previous text in this groupltbr gtltbr gtopen CwampbinapacheApacheput your version number hereconfhttpdconfltbr gtexample  CwampbinapacheApache2211confhttpdconfltbr gtand take out the  before ltbr gtLoadModule rewritemodule modulesmodrewritesoltbr gtat about line 116ltpgt ltpgtOOPSltbr gtltbr gtYes you need some key like Article and a rewrite test I normally do this in httpdconfltbr gtltbr gtArticleBreast ProceduresBreast AugmentationmainmenuID13ampamparticleID8ltbr gtltbr gt htaccessltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI Article NCltbr gtRewriteRule Articleltbr gtviewArticlephpmenu1ampamptitle2ampamp3 Lltpgt ltpgtOKltbr gtI created a file htaccess on the root dir and pasted the followingltbr gtltbr gt htaccessltbr gtltbr gtAnd when i check in my localhost it says Internal Server Error I checked with the Apache Error Log and it gives the following errorltbr gtltbr gtltbr gtviewArticlephpmenuBreast20ProceduresampampmainmenuID13ampamparticleID8ampamptitleBreastltbr gt20Augmentationltpgt ltpgtviewArticlephpmenuBreast20ProceduresampampmainmenuID13ampamparticleID8ampamptitleBreastltbr gt20Augmentationltbr gtltbr gtltbr gthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentation138ltbr gtltbr gtltbr gthtaccess file containsltbr gt htaccessltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI viewArticleltbr gtRewriteRule viewArticleltbr gtviewArticlephpmenu1ampamptitle2ampampmainmenuID3ampamparticleID4 Lltbr gtThis is the error from apacheerrorlogltbr gtalert client 127001 Cwampwwwfpshtaccess RewriteRule cannotltbr gtcompile regular expressionltbr gtviewArticleltbr gtltbr gtltbr gtAny Ideasltbr gtI am still stuck ltbr gtPlease adviceltbr gtThanksltpgt ltpgtviewArticlephpmenuBreast20ProceduresampampmainmenuID13ampamparticleID8ampamptitleBreastltbr gt20Augmentationltbr gtltbr gtltbr gtThis is the error from apacheerrorlogltbr gtalert client 127001 Cwampwwwfpshtaccess RewriteRule cannotltbr gtcompile regular expressionltbr gtviewArticleltbr gtltbr gtAny Ideasltbr gtThanksltpgt ltpgtThis is not a problem with the htaccess and it doesnt make sense to try and change it in the htaccess as you would have to write an exclude rule for all the file types css png jpg ect ltbr gtltbr gtThe real problem is that your HTML has things like ampltimg srcampquotpicturejpgampquotltbr gt so the BROWSER is adding the pathltbr gtltbr gtThe simple solution is to change your HTML to ampltimg srcampquotpicturejpgampquot ltbr gtltbr gtIf you really want to do it in htaccess then you need something like ltbr gtltbr gtRewriteCond REQUESTFILENAME pngcssjpgltpgt ltpgthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentation138ltbr gtltbr gtBut now comes a new problem all the linked materials CSS Javascript Images everything that is linked are now having additional folder paths of ampquotviewArticleBreast20Proceduresampquotltbr gtThe CSS file is located at the root folderltbr gthttplocalhostfpsstylecssltbr gtltbr gtBut after that htaccess file the css is being looked atltbr gthttplocalhostfpsviewArticleBreast20Proceduresstylecssltbr gtltbr gtAny ideas on how to solve thisltbr gtltbr gtCurrently the URL i am using isltbr gtltbr gthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmainmltbr gtenuID13ampamparticleID8ltbr gtamplthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmailtbr gtnmenuID13ampamparticleID8ampgtltbr gtltbr gtAnd the htaccess fileltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI viewArticleltbr gtRewriteRule viewArticleltbr gtviewArticlephpQUERYSTRINGampampmenu1ampamptitle2 Lltbr gtltbr gtltbr gtPlease adviceltbr gtltbr gtMany many thanksltpgt ltpgtOk I found the problem Once again sigh it came down to the DOCUMENTROOT problem in WAMPServerltbr gtltbr gtBecause the DOCUMENTROOT in WAMPServer is the directory above the normal DOCUMENTROOT WAMPServer passes the full file path to the RewriteRuleltbr gtREQUESTURI instead of just the remaining URI from the current folderltbr gtThis includes the Cwampwwwltbr gtltbr gtSo the RewriteRule has to drop the extra trash at the beginning of the URIltbr gtltbr gtSince I have had so much trouble with this I have changed it so that NONSEO friendly information is put into the QUERYSTRINGltbr gtltbr gtSo the new URL format is like this ltbr gtviewArticleBreast ProceduresBreast AugmentationmainmenuID13ampamparticleID8ltbr gtltbr gtThe Rewrite and REGEX is ltbr gt htaccessltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI viewArticleltbr gtRewriteRule viewArticleltbr gtviewArticlephpQUERYSTRINGampampmenu1ampamptitle2 Lltbr gtltbr gtThis has been tested on WampServer 20 Apache 2211ltbr gtltbr gtIt passes the following to viewArticlephpltbr gtltbr gtmainmenuID13ltbr gtarticleID8ltbr gtmenuBreast Proceduresltbr gttitleBreast Augmentationltbr gtltbr gtLet me know if you want changes that arent obviousltpgt ltpgtI played with this until I was totally frustrated I was testing it on WAMPServer 20 and I think the problem is that it is running on a windows platformltbr gtltbr gtMODREWRITE works in an unusual way from a htaccess file The reality is that by the time a httpd request gets to the file system where htaccess is it is too late to do a URL rewrite so a FixIt module takes over and reads the rewrite and converts the resulting file path to a http path and then starts a new sub hpptd thread with the new request The new thread passes the information back to the parent thread as if the new thread was the file system So here is the confusion for me about using forward or back slashes and I suspect that is the problem when running Apache on windowsltbr gtltbr gtThis is the point that I got to ltbr gt htaccessltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI viewArticleltbr gt RewriteRule viewArticleltbr gtviewArticlephpmenu1ampamptitle2ampampmainmenuID3ampamparticleID4 Lltbr gt RewriteRuleltbr gt09azAZ 09azAZ 09azAZltbr gt09azAZltbr gt viewArticlephpmenu1ampamptitle2ampampmainmenuID3ampamparticleID4 Lltbr gt RewriteRule viewArticle viewArticlephpdata1 Rltbr gtRewriteRule viewArticle viewArticlephpsuccesstrue Rltbr gtltbr gtAnd it is rewriting over a rewrite and then failing when the resulting file system path of too longltbr gtltbr gtPerhaps through copy and past there are some non unix carriage returns or something like that I dont know and I probably wonk get back to for a whileltbr gtltbr gtIf I have made a mistake in the first place then I am the least likely to spot itltbr gtltbr gtPerhaps someone else can see itltpgt ltpgtThanks for the help but its still not working ltbr gtI also noticed that even the links are changed every linkable element is being searched inside this folderltbr gthttplocalhostfpsviewArticleBreast20Proceduresstylecssltbr gtltbr gtI tried adding both of the provided scripts into the htaccess file but noltbr gtuse ltbr gtltbr gtAdding ampquotampquot on every link would be very lengthy so i guess we should be using htaccessltbr gtI also tried adding  before the CSS file like this hrefampquotstylecssampquotltbr gtBut now after that it is looking for this file on the very root I know it will be solved when we work with real domains but for development on localhost it would be a problem as after adding this every file is being searched inside the localhost like thisltbr gthttplocalhoststylecssltbr gtltbr gtinstead of thisltbr gthttplocalhostfpsstylecssltbr gtltbr gtI know i can add fps instead of just single  but i think we better should not do it file by file as there are so many files What you commentltbr gtMany Thanksltpgt ltpgthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmainmltbr gtenuID13ampamparticleID8ltbr gtltbr gthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmainmltbr gtenuID13ampamparticleID8ltbr gtltbr gtI also noticed that even the links are changed every linkable element is being searched inside this folderltbr gthttplocalhostfpsviewArticleBreast20Proceduresstylecssltbr gtltbr gtI tried adding both of the provided scripts into the htaccess file but no use ltbr gtltbr gtAdding ampquotampquot on every link would be very lengthy so i guess we should be using htaccessltbr gtI also tried adding  before the CSS file like this hrefampquotstylecssampquotltbr gtBut now after that it is looking for this file on the very root I know it will be solved when we work with real domains but for development on localhost it would be a problem as after adding this every file is being searched inside the localhost like thisltbr gthttplocalhoststylecssltbr gtinstead of thisltbr gthttplocalhostfpsstylecssltbr gtltbr gtI know i can add fps instead of just single  but i think we better should not do it file by file as there are so many files What you commentltbr gtMany Thanksltpgt ltpgtThanks for the help The link is working perfectltbr gtBut now comes a new problem all the linked materials CSS Javascript Images everything that is linked are now having additional folder paths of ampquotviewArticleBreast20Proceduresampquotltbr gtThe CSS file is located at the root folderltbr gthttplocalhostfpsstylecssltbr gtltbr gtBut after that htaccess file the css is being looked atltbr gthttplocalhostfpsviewArticleBreast20Proceduresstylecssltbr gtltbr gtAny ideas on how to solve thisltbr gtltbr gtCurrently the URL i am using isltbr gtltbr gthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmainmltbr gtenuID13ampamparticleID8ltbr gtamplthttplocalhostfpsviewArticleBreast20ProceduresBreast20Augmentationmailtbr gtnmenuID13ampamparticleID8ampgtltbr gtltbr gtAnd the htaccess fileltbr gtRewriteEngine onltbr gtRewriteCond REQUESTURI viewArticleltbr gtRewriteRule viewArticleltbr gtviewArticlephpQUERYSTRINGampampmenu1ampamptitle2 Lltbr gtltbr gtltbr gtPlease adviceltbr gtltbr gtMany many thanksltbr gtthe above would probably be better as ltbr gtRewriteCond REQUESTFILENAME pngcssjpgltbr gtltbr gtLet me know if you need some assistanceltpgt ltpgtI had to take my cat to the vet so I am bit slow off the mark this morningltbr gtltbr gtYou said ltbr gtBut you didnt mention what the error wasltbr gtltbr gtI am often annoyed by this DOCUMENTROOT problem with WAMPServerltbr gtltbr gtOne solution is to have a one htaccess file on the development system and a different one on the live server I dont think that this is the best solution because a incorrect htaccess file will very quickly crash an entire siteltbr gtltbr gtAnother solution is to create a VHOST for the development system I couldnt be bothered doing this on my system because a work with a lot of sites and remembering the VHOST would be a painltbr gtltbr gtIt may suit your situation if you are only working with a small number of sitesltbr gtltbr gtLet me know what the problem was error message for the last two exclusion RewriteCondsltbr gtltbr gtAre you willing to set up VHOST I can tell you how if you tell me the versions of the components of your development environment including the OS This will mean that the DOCUMENTROOT is the same as the live server and any htaccess files would be the sameltbr gtltbr gtI will wait to hear from you and in the mean time I will go and look at how I previously setup VHOST on my dev systemltpgt</description>
      <pubDate>Tue, 25 Aug 2009 22:59:56 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>PHP Mail function</title>
      <link>http://php.diigit.com/php-ask-questions/php-mail-function.html</link>
      <description>ltpgtHelloltbr gtltbr gtI want to send a mail in local host using through PHP but I cant send it Please suggest me how to send a  mail using PHPltbr gtWarning mail functionmail SMTP serverltbr gtresponse 550 The address is not valid inltbr gtCxampphtdocstest1sendcontactphp on line 11ltbr gtERRORltbr gtltbr gthere Im sending you php code ltbr gtltbr gtMailhtmlltbr gtampltform nameampquotform1ampquot methodampquotpostampquot actionampquotsendcontactphpampquotampgtltbr gtltbr gtsubjectampltinput nameampquotsubjectampquot typeampquottextampquot idampquotsubjectampquot sizeampquot50ampquotampgtampltbrampgtltbr gtampltbrampgtltbr gtDetailamplttextarea nameampquotdetailampquot colsampquot50ampquot rowsampquot4ampquot idampquotdetailampquotampgtamplttextareaampgtampltbrampgtltbr gtltbr gtampltbrampgtltbr gtNameampltinput nameampquotnameampquot typeampquottextampquot idampquotnameampquot sizeampquot50ampquotampgtampltbrampgtltbr gtMailampltinput nameampquotcustomermailampquot typeampquottextampquot idampquotcustomermailampquot sizeampquot50ampquotampgtampltbrampgtltbr gtltbr gtampltbrampgtltbr gtampltinput typeampquotsubmitampquot nameampquotSubmitampquot valueampquotSubmitampquotampgtltbr gtampltinput typeampquotresetampquot nameampquotSubmit2ampquot valueampquotResetampquotampgtltbr gtltbr gtampltformampgtltbr gtsendcontactphpltbr gtampltphpltbr gt subjectltbr gtsubject ampquotsubjectampquotltbr gt Detailsltbr gtmessageampquotdetailampquotltbr gt  senderltbr gtmailfromampquotcustomermailampquotltbr gt Fromltbr gtheaderampquotfrom name ampltmailfromampgtampquotltbr gtto karthickcse06ltbr gtsendcontactmailtosubjectmessageheaderltbr gtifsendcontactltbr gtecho ampquotWeve recived your contact informationampquotltbr gtltbr gtelse ltbr gtecho ampquotERRORampquotltbr gtltbr gtampgtltpgt  ltpgtSending PHP email from Windows servers is often problematic  Unike Unix and Linux systems most Windows systems dont have an SMTP server for PHP to useampnbsp It is often necessary to edit the phpini file and set an external SMTP serverampnbsp After any change to phpini restart the webserver program for the changes to take effectltbr gtltbr gtPerhaps you have that part set up correctly  To find out you should make the most basic test possible someting on the order ofltbr gtltbr gtmailampquotkarthickcse06ampquot ampquottest messageampquot ampquotthis is a testampquotltbr gtltbr gtSee if this line in PHP tags when run through the webserver will transmit an email to your account  Watch the spam folderltbr gtltbr gtTwo other areas which could cause problems in your implementation are the From address  From addresses often dont work as well on Windows as they do from Unix systems  Hence your ability to set them at all may be limited  The usage of ampquotreal nameampquot ampltemailampgt for the address may also fail in some casesltbr gtltbr gtOne thing to keep in mind is that the From address is set up in an email header value in the fourth argument of the mail function  You can pass almost anything in that variable but whether it will be interpreted by the SMTP server is the potential issue  For standardscompliant servers you have to follow the expected spelling capitalization format and line ending for the header  In this case it should beltbr gtltbr gtheader  ampquotFrom emailrnampquotltbr gtltbr gtNote that ampquotFromampquot is capitalized and there is one space after the colon  The rn is a representation of the carriage return ASCII 13 and newline ASCII 10 characters which are part of the standard for line endings on email  They will work in double quotes but not single quotesltbr gtltbr gtYour example script should not be used on the web since it is fairly easily hacked and could be used to send spam email from your domainIP and quickly get your machine on a blacklist  For one thing you are doing no input validation of the form variables being passed to the mail functionltpgt ltpgtTo learn PHP try these websitesltbr gtltbr gthttpwwwtizagcomphpT  An easy introductionltbr gthttpwwww3schoolscomphp  More in depth coverageltbr gtltbr gthttpwwwphpnet  Complicated I use it mostly for referenceltpgt ltpgtThis error means that the mail server is not accepting the format of the email address I believe it could be the email address youre sending to sending from or using for authorizationltbr gtltbr gtWhat I would suggest doing is to echo the to and header variables so you can make sure that they are properly formatted Also check to see if you need to use an email address rather than just a user name for SMTP auth particularly if youre sending via a mail server on a different boxltpgt ltpgtI had this exact same problem with phps mail under debian I could send to my private email but not to my yahoo email I believe yahoo is analyzing the headers and figure out that you are sending via php so they block itltbr gtltbr gtI get much better luck using an smtp class With an smtp class you are actually sending it out through a mail server of your choice instead of trying to create your ownltbr gtCheck this one out httpwwwphpclassesorgbrowsepackage3029htmlltpgt ltpgtI believe that is backwards When you use the mail function it is my understanding that it is connecting to your own SMTP server or one that you are authorized to use to deliver the mail Hence the need to specify a server in the phpini fileltbr gtltbr gtWhen you use an SMTP class they are typically using a socket connection directly to the recipients mail server This makes it easier to do things like sending HTML email or including attachmentsltbr gtltbr gtthat said unless youre doing this to learn php I agree that an SMTP class such as the one is a much more efficient way to do itltpgt ltpgtHelloltpgtltpgtI have used windows OS and Xampp control  But I cant send a mail to my yahoo ID I got a problem with PHPampAtildeampcentampacircampsbquoampnotampacircampbdquoampcents mail  which was not sending any email messages outIm sending you my php coding If you see any problem or any mistake in my code then plz tell me and suggest me how i can sendltbr gtltbr gtAnd I did some changes in sendmailiniltbr gtsendmailltbr gtltbr gt you must change mailmydomaincom to your smtp serverltbr gtsmtpservermailmydomaincomltbr gtltbr gt smtp port normally 25ltbr gtltbr gtsmtpport25ltbr gtltbr gt if your smtp server requires authentication modify the following twoltbr gtlinesltbr gtltbr gtauthusernameusernameltbr gtauthpassworddrowssapltbr gtltbr gt if your smtp server uses pop3 before smtp authentication modify theltbr gt following three linesltbr gtltbr gtpop3servermailmydomaincomltbr gtpop3usernameusernameltbr gtpop3passworddrowssapltbr gtltbr gtmy code is hereltbr gtampltsnipampgtltbr gtltbr gtWarning mail functionmail SMTPltbr gtserver response 550 The address is not valid inltbr gtCxampphtdocstest2sendcontactphp on line 12ltbr gtERRORltbr gtltbr gtltbr gtemail servers do a lot of checking before they are willing to receive email so using a php class that does NOT cache email is not a good idealtbr gtltbr gtSome servers will always respond to a new IP with service temporarily unavailable so without a cache then email will failltbr gtltbr gtApart from blackwhitegrey IP lists many email servers will also check a SPF record that is associated with a domain in the zone fileltbr gtltbr gtIf your using a development environment then your best off just using some external SMTP server The problems you will have here are  Some ISPs block port 25 so you have to use port 26 Some servers require pop before SMTP authentication Some server will reject phps default mail headers so you have to change them with the header functionltpgt</description>
      <pubDate>Mon, 24 Aug 2009 03:53:39 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>End entire php script from within IF statement?</title>
      <link>http://php.diigit.com/php-ask-questions/end-entire-php-script-from-within-statement.html</link>
      <description>ltpgtIm trying to write an IF statement so that if the condition is met an error statement is displayed and the entire program quitsltbr gtltbr gtIve triedltbr gtltbr gtampltphpltbr gtif conditionltbr gtecho ampquotBad inputampquotltbr gtampgtltbr gt elseif second conditionltbr gtblahltbr gtblahltbr gtltbr gtecho ampquotProgram completeampquotltbr gtampgtltbr gtltbr gtbut it doesnt workltbr gtltbr gtAny suggestionsltpgt  ltpgtSplitting it up will just make it easier to maintain the code in case you want to change the validation or the email part There is not reason to use a boolean use a string or integer for example The later will probably generate faster executing code Something like thisltbr gtltbr gtsendemail  no Default to false is usually a good idealtbr gtltbr gtDo your input validation  spam detection hereltbr gtltbr gtDone validating inputltbr gtltbr gtTime to send message or return information to the userltbr gtswitchsendmailltbr gtltbr gtcase noltbr gtecho Sorry an unknown error occurredltbr gtmail Send mail to webmaster due to errorltbr gtbreakltbr gtcase spamltbr gtecho Sorry our software thinks that you are a spammer because ofltbr gtXXXX Please adjust input and try againltbr gtbreakltbr gtcase invalidltbr gtecho Mhh it looks like you did not supply all required informationltbr gtbreakltbr gtcase yesltbr gtmailltbr gtecho Information sent out thank youltbr gtbreakltbr gtdefaultltbr gtecho Sorry an unknown error occurredltbr gtmail Send mail to webmaster due to errorltbr gtbreakltbr gtltbr gtThe end result will be the same but you will create easier to maintain code by splitting it into sectionsltpgt ltpgtYes I see how I could do that  but from my point of view thats no easier than a bunch of IFELSE statementsltbr gtltbr gtAdditionally Im not just putting up walls to keep spammers out  I also have to deal politely with valid customers who input bad data As inltbr gtltbr gtampquotIm sorry but we require you to enter a phone number so we can contact you in the event of an emergency such as a well pump outage power outage tornado or hurricane or all of the aboveampquotltbr gtltbr gtOrltbr gtltbr gtampquotIm sorry but it seems you have neglected to enter your Last Name Please go back and correct thisampquotltbr gtltbr gtltbr gtUnfortunately most of the hijacking attempts weve experienced seems to come directly from the webpage rather than an indirect bot attack  I suspect many of them come from the same frat brats from the local college who make spurious reservations and have broken into our campground to steal for their so called Treasure Hunts and commitltbr gtvandalism  So I think adding a Captcha system would be a lot of work for little result and pss off our actual customersltpgt ltpgtYour code wont work because the tags ampltphp ampgt control the parse engine and not the flow of executionltbr gtltbr gtSo with your code php would read ltbr gtampltphpltbr gtif conditionltbr gtecho ampquotBad inputampquotltbr gtampgtltbr gtand noting more so the error is because of the missing ltbr gtltbr gtwrite it this way ltbr gtltbr gtampltphpltbr gtif conditionltbr gtecho ampquotBad inputampquotltbr gtdieltbr gt elseif second conditionltbr gtblahltbr gtblahltbr gtltbr gtecho ampquotProgram completeampquotltbr gtampgtltpgt ltpgtThat didnt work either  I had already tried EXIT and EXIT so I didnt even try DIE  Howeverltbr gtWhen I removed the curly brace  after DIE it workedltbr gtltbr gtThank you  Now I can simplify the script  I had discovered that BREAK workedbut that meant I would have to do the whole thing as a massively nested IF statementltbr gtltbr gtWere having a twofold problem with receiving email reservations from a form using CGIemail we run a small campground  Spammers keep trying to hijack our form  even after we spam proofed it by not using any variables in header though WE still get the spamltbr gtltbr gtThe other problem is between the legitimate users and their chairs  People who mistype their own email address who assume we recognize them by their first names after all they were here just 4 years ago forget to specify the reservation type etcltpgt ltpgtusing CGIemail we run a small campground  Spammers keep trying to hijack our form  even after we spam proofed it by not using any variables in header though WE still get the spamltbr gtltbr gtYou could try to splitting it up Instead of doing all the work inside a lot of ifelse statements you can create a variable which defaults to false and controls if the form should be submitted Something like thisltbr gtltbr gtsendmsg  falseltbr gtltbr gtif testing condition for valid input ltbr gtsendmsg  trueltbr gtltbr gtNow test if the email should be send outltbr gtif sendmsg  true ltbr gtmailltbr gtelseltbr gtechoLooks like you provided invalid inputltbr gtBTW you can find a questionanswer based CAPTCHA system by following the URL below It is designed to keep spammers out by offering a nonstandard problem to solveltbr gthttpwwwnetworktechnologiesorgtinyphpid1ltbr gtltbr gtHere is an example of how it can be used to protect a contact formltbr gthttpwwwnetworktechnologiesorgtinyphpid5ltpgt ltpgtProbelm with this lineltbr gt1 ltbr gtNameampltinput typeampquottextampquot nameampquotname2ampquot valueampquotampltphp echo POSTname ampgtampquot ampgtltbr gtltbr gtchange thisltbr gtNameampltinput typeampquottextampquot nameampquotname2ampquot valueampquotampltphp echo POSTname2 ampgtampquot ampgtltbr gt2ltbr gtsqlampquotINSERT INTO example VALUESltbr gtPOSTname POST ageampquotltbr gtchange thisltbr gtsqlampquotINSERT INTO example VALUESltbr gtPOSTname2 POST ageampquot ltpgt ltpgtHelloltbr gtltbr gtI am sending you php code I want to insert data in mysql through php form But i cant do thisIf you see any problem or any mistake in my code then plz tell me and suggest me how i can post the data in mysql databaseltbr gtltbr gtmy code is hereltbr gtampltform methodampquotpostampquot actionampquot1phpampquotampgtltbr gtltbr gtNameampltinput typeampquottextampquot nameampquotname2ampquot valueampquotampltphp echo POSTnameampgtampquot ampgtltbr gtltbr gtageampltinput  typeampquottextampquot valueampquotampltphp echo POSTageampgtampquot ampgt ltbr gtampltinput typeampquotsubmitampquot nameampquotsubmitampquot valueampquotcreatampquot ampgtltbr gtltbr gtampltformampgtltbr gtampltphpltbr gtcon  mysqlconnectampquotlocalhostampquotampquotrootampquotampquotampquotltbr gtif conltbr gtltbr gtdieCould not connect   mysqlerrorltbr gtltbr gtselected mysqlselectdbampquotfmcampquotltbr gtsqlampquotINSERT INTO example VALUESltbr gtPOSTnamePOSTageampquotltbr gtif mysqlquerysqlconltbr gtltbr gtdieError   mysqlerrorltbr gtltbr gtecho ampquot1 record addedampquotltbr gtmysqlcloseconltbr gtampgtltpgt ltpgtI only posted an example of how you COULD not it The method of multiple return values from your validation ifelse gives you better control of what you returnltbr gtltbr gtWhy attempt to validate data at all if you intend to pass all data as valid because you think that your customers can not fill out a contact form properly or that you are scared of customers calling you on the phone If the form requires too much data or if too many customers fail to fill it out correctly then the form is poorly constructedltbr gtltbr gtAs far as the ampquotSend mail to webmaster due to errorampquot goes As I said this is a suggestion not code written for you take it modify it and make it work for you or not Use the mail part as a debugging guide for your possible validations I run multiple domains some are high traffic I would guess higher traffic then a camping ground and I always look at the ampquotfailedampquot validations to ensure my code is not flagging customers as spammersltpgt ltpgtI already have it split into sections for each form fieldltbr gtltbr gtexamine form fieldltbr gtdisplay error message and quit on bad input ie empty fieldltbr gtdisplay error message and quit on possible injection inputltbr gtset variable on good inputltbr gtltbr gtThe problem with your paradigm is that our customers will see feedback like ampquotSorry an unknown error occurredampquot or ampquotSorry our software thinks that you are a spammer because of XXXXampquot andltbr gtltbr gtA  Get frustrated and stop trying we lose customersltbr gtB  Feel insulted and stop trying we lose customersltbr gtC  Call us on the telephone at all hours of the day and night to make reservationsltbr gtltbr gtThere are only 2 of us running our campground so answering the phone constantly gets very frustrating and time consuming  As it is we have to have TIVO to watch TV at allltbr gtltbr gtAnd the most important thing to remember in business is that ampquotThe customer always THINKS theyre right  no matter how wrong they areampquotltbr gtltbr gtI have the framework of my program written and it not only tells customers that they did something wrong  it tells them WHAT they did wrong IE ampquotPlease do not use the character ampquotampquot in the Special Instructions fieldampquotltbr gtltbr gtThen it immediately exitsltbr gtltbr gtAnd as for ampquotSend mail to webmaster due to errorampquotltbr gtltbr gtOhltbr gtMYltbr gtGODltbr gtltbr gtDo you have any idea how much email we get every day as it is  Can you imagine receiving an email EVERY TIME a spammer tries to hijack our sendmail form or a customer forgets to select a form elementltbr gtltbr gtI need to do a little more work on what Ive got then I plan to upload it to the files section for anyone who would like to examinetest drive itltpgt</description>
      <pubDate>Mon, 24 Aug 2009 03:30:25 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Errors when inserting into Mysql</title>
      <link>http://php.diigit.com/php-ask-questions/errors-when-inserting-into-mysql.html</link>
      <description>ltpgtThe above code is DANGEROUS You are inserting unescaped unvalidated data into your SQL database This can be a source of all kinds of problems and possibly security issues You are also missing your field names on your INSERT command Here is how I would rewrite the aboveltbr gtampltPHPltbr gtcon  mysqlconnectampquotlocalhostampquotampquotrootampquotampquotampquotltbr gtltbr gtSee if name is set escape data for SQL if it isltbr gtif issetPOSTname  true ltbr gtname  mysqlrealescapestringPOSTnameltbr gtelse Set to null in case name is emptyltbr gtname  nullltbr gtSame as in name aboveltbr gtif issetPOSTage  true ltbr gtage  mysqlrealescapestringPOSTageltbr gtelseltbr gtage  nullltbr gtltbr gtEnsure that name and age information is not emptyltbr gtif name  null  age  null ltbr gtltbr gtltbr gtI would do further validation at this point like ensuring that age is an integer and name is a valid name consisting of lettersltbr gtltbr gtltbr gtselected mysqlselectdbampquotfmcampquotltbr gtsqlampquotINSERT INTO examplenameage VALUESnameageampquotltbr gtif mysqlquerysqlconltbr gtdieError   mysqlerrorltbr gtecho ampquot1 record addedampquotltbr gtmysqlcloseconltbr gt else ltbr gtDisplay contact formltbr gtltbr gtltbr gtI think this is it the above should work nowltpgt  ltpgtOoops this part needs to beltbr gtltbr gtEnsure that name and age information is not emptyltbr gtif name  null ampampampamp age  null ltpgt ltpgtI cant understand itltbr gtplz clear the defination of this codeltbr gtltbr gtif issetPOST name  true ltbr gtltbr gtifissetvariable is the same asltbr gtifissetvariableTRUE so I dont at all know whay they have chosenltbr gtifissetvariableTRUEltbr gtifissetvariable would be fineltbr gtltbr gtPOSTname relates toltbr gtampltinput nameampquotnameampquot typeampquottextampquot ampgtltbr gtltbr gtname  mysqlrealescape string POSTname ltbr gtmysqlrealescapestring is to prevent MySQL injection hacking attemptsltbr gtThe ampampampamp means booleen ANDltbr gtltbr gt means assignment as in a  1ltbr gt means if loosly equal to with out testing variable typeltbr gt means booleen exactly equal to and DOES test variable typeltbr gtltbr gtI would write this code this wayltbr gtltbr gtname  ltbr gtage  ltbr gtifissetPOST nameltbr gtltbr gtname  mysqlrealescape string POSTnameltbr gtltbr gtSame as in name aboveltbr gtifissetPOST ageltbr gtltbr gtage  mysqlrealescape string POSTageltbr gtltbr gtEnsure that name and age information is not emptyltbr gtifname   ampampampamp age  ltbr gtltpgt ltpgtI cant understand itltbr gtplz clear the defination of this codeltbr gtltbr gtif issetPOST name  true ltbr gtname  mysqlrealescape string POSTname ltbr gtelse Set to null in case name is emptyltbr gtname  nullltbr gtSame as in name aboveltbr gtif issetPOST age  true ltbr gtage  mysqlrealescape string POSTage ltbr gtelseltbr gtage  nullltbr gtEnsure that name and age information is not emptyltbr gtif name  null ampampampamp age  null ltbr gtltbr gtplz i m waiting your replyltpgt ltpgtWhat version of PHP are you using I have never seen thisltbr gtifissetvariableTRUEltbr gtanywhere and when I try this I get a syntax errorltbr gtAs far asltbr gtif issetvariable  true ltbr gtvsltbr gtif issetvariable ltbr gtis concerned I used the former becauseltbr gta it makes reading the code more naturalltbr gtb when sending complicated code back and forth I have received less questions this wayltbr gtc I dont like to rely on language defaults when I can avoid itltbr gtBoth are valid it is a matter of choiceltbr gtampgt name  ltbr gtltbr gtI dont write my code this way because it is easier to forget to set a variable to a default value in large scripts Doing a simple ifelse here will either copy the value of POSTfoo to the variable or define it as null Doing it all in one go will make it harder to screw up since you dont have to scroll up to the ampquotgive variables a default valueampquot section So this is how I do it all the time unless I use a special functionltbr gtif issetPOSTfoo  true ltbr gtfoo  POSTfooltbr gtelseltbr gtfoo  nullltbr gtI usually write the above in one line since I use a wide screen monitor but this will be chopped to hell in emailsltbr gtltbr gtWhen writing ifelse with only one line  is not required You just need to be careful when you modify your code or you get a syntax errorltbr gtHere is an exampleltbr gta1ltbr gtb2ltbr gtValidltbr gtif a  b ltbr gtecho a and b have the same valueltbr gtelseltbr gtecho a and b do not contain the same valueltbr gtltbr gtSyntax Errorltbr gtif a  b ltbr gtecho a and b have the same valueltbr gtecho This is multi line and should contain ltbr gtelseltbr gtecho a and b do not contain the same valueltbr gtltbr gtSame as above but validltbr gtif a  b ltbr gtltbr gtecho a and b have the same valueltbr gtecho This is multi line and contains ltbr gtelseltbr gtecho a and b do not contain the same valueltbr gtKainat as far as an explanation of mysqlrealescapestring is concerned I would point you to the PHP documentation and this really great website in the second linkltbr gtltbr gthttpwwwphpnetmanualenfunctionmysqlrealescapestringphpltbr gtltbr gthttplmgtfycomqphpsqlinjectionltpgt</description>
      <pubDate>Mon, 24 Aug 2009 03:10:42 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/php-ask-questions/category/php.html'>PHP</a></category>      
</item>

<item>
      <title>Broken pipe: core_output_filter: writing data to the network</title>
      <link>http://linux.diigit.com/ask-questions_1/broken-pipe-coreoutputfilter-writing-data-network.html</link>
      <description>ltpgthi allltpgtltpgtI am getting this error on my Apache server but all my sites are working fine  but when i brows any page it give this error in apache log fileampnbspltpgtltpgtFri May 01 035517 2009 info client 12216081186 32Broken pipe coreoutputfilter writing data to the networkltbr gtFri May 01 035517 2009 info client 12216081186 32Broken pipe coreoutputfilter writing data to the networkltbr gtFri May 01 035517 2009 info client 12216081186 32Broken pipe coreoutputfilter writing data to the networkltbr gtFri May 01 035525 2009 info client 12216081186 32Broken pipe coreoutputfilter writing data to the networkltbr gtFri May 01 035525 2009 info client 12216081186 32Broken pipe coreoutputfilter writing data to the networkltbr gtFri May 01 035525 2009 info client 1211489166 104Connection reset by peer coreoutputfilter writing data to the networkltpgtltpgtPleas help me to solve this errorltpgt   ltpgthadesswltpgt</description>
      <pubDate>Wed, 19 Aug 2009 08:04:51 PDT</pubDate>
   <author><name></name></author>
   <category><a href='http://.diigit.com/ask-questions_1/category/linux.html'>Linux</a></category>      
</item>
   </channel>
</rss>