Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. KamranFeroz

    Count records with soundex and inner join!

    I've got the solution :) Query will be like that, SELECT COUNT(*) AS Expr1, MIN(Country) AS Expr2 FROM tblSurvey GROUP BY SOUNDEX(Country) ORDER BY MIN(Country) Thnx any way Von! Cheers!
  2. KamranFeroz

    Count records with soundex and inner join!

    Thnx Von for the reply, It seems that my result is not correct. The result getting through that query is e.g. Bahrain=841 instead of 29. The actual value is multiplied with the same and appears as result. Any solution will be highly appreciable. Web Programmer. http://www.kamranferoz.com
  3. KamranFeroz

    Count records with soundex and inner join!

    Hi, I'm trying to count no. of records using soundex() function in query, Query: "SELECT COUNT(*) AS Expr1, a.Country AS Expr2 FROM tblSurvey a INNER JOIN tblSurvey b ON SOUNDEX(a.Country) = SOUNDEX(b.Country) GROUP BY a.Country ORDER BY a.Country" I'm not...
  4. KamranFeroz

    Snapshot of remote website

    Thnx Bastien for your help, but this doesn't seems to work in my case. What I need is to get the image(jpeg or gif) of the website that will be entered manually in a form. Ne idea abt it.?? Web Programmer. http://www.kamranferoz.com
  5. KamranFeroz

    Snapshot of remote website

    Does any one have idea how to get the snapshot(thumbnail) of a remote URL through scripting. I need to get the thumbnails of website that submitts through the form like Alexa and many other search engines do. Web Programmer. http://www.kamranferoz.com
  6. KamranFeroz

    Applying Vlink color in CSS

    Thanx Vragabond and dkdude, I've got what I need. Thanx again for your help. Web Programmer. http://www.kamranferoz.com
  7. KamranFeroz

    Applying Vlink color in CSS

    I need to apply vlink color in my applied CSS. I'd tried all combination but did'nt work. Can any one help?
  8. KamranFeroz

    Date time grouping and count problem.

    If you've nothing todo with the time saved in the database then you might change the datatype of your field to "Date". By this you can easily calculate dates using date functions. Best of luck.
  9. KamranFeroz

    Data not Inserted?

    Some code left, pls discard above code, $result = mysql_query("SELECT DISTINCT t.Team Team FROM Teams t"); while ($row=mysql_fetch_array($result)) { $team1 = $row['Team']; $query = "INSERT INTO seedtmp3(TRN,Team,Fastest_Time,Venue) SELECT tt.TRN, t.Team, tt.Fastest_Time...
  10. KamranFeroz

    Data not Inserted?

    Try this, $result = mysql_query("SELECT DISTINCT t.Team Team FROM Teams t"); while ($row=mysql_fetch_array($result)) { $team1 = $row['Team']; $query = "INSERT INTO seedtmp3(TRN,Team,Fastest_Time,Venue) SELECT tt.TRN, t.Team, tt.Fastest_Time, v.Venue FROM Teams t LEFT JOIN...
  11. KamranFeroz

    Group By query in MySQL

    This might be bcoz ur using an alis "d" for table that is not visible in your "from" clause in "select" statement. Check this out. Best of luck.
  12. KamranFeroz

    MySQL PHP UNION JOIN LEFT RIGHT WHAT??

    What I understand is that you need to extract distinct firtname and lastname from both of your table. If this is so then try using distinct in your select clause. Best of luck.
  13. KamranFeroz

    convert database

    Make an export of the access table from MS Access and then Import them to MySQL. For Import, you can use PHPMyAdmin(i.e web based db control panel) or also you can use "MySQL-Front" (downloadable from net as freeware). Best of luck.
  14. KamranFeroz

    Warning: Cannot modify header information - headers already sent by

    This will prevent you having that error on that particular page. (1) ob_start(); (2) ob_end_flush(); write (1) at the top of your PHP page after opening PHP tag and (2) and the bottom before ending PHP tag of the page that causing you error. Best of luck.
  15. KamranFeroz

    Redirecting header() if codition is met

    If I got it in the right way, I think instead of directly open an popup window from your current page. You need a validater page that can validate your session first and then do the rest as you condition. like, On that particular click event that you are using to open an popup window, try to...
  16. KamranFeroz

    php results display issue

    Might that help you, before the while loop initialize $color = 0; if($color == 0) { echo &quot;<tr align='center'>&quot;; $color++; } else { echo &quot;<tr align='center' bgcolor='#E1E9FD'>&quot;; $color = 0; } That's working in my case very efficiently.
  17. KamranFeroz

    Will PHP persistent connections maintain temporary tables?

    Hi, Instead of using this hard work and making lot of imlicit temporary tables. Try to use cookies to maintain the users loggins or even the best one, Try to upgrade to PHP4 and use it's session option to maintain the session. That's the best possibility for your scenarion as I think. Good luck.
  18. KamranFeroz

    Running mysql on a NT server with internet access.

    Hi, U can acces MySQl from any where wether on ur local network or from Internet. Just what u have to do is to mention the remote host in the MySQL command to connect to the db.
  19. KamranFeroz

    FULL OUTER JOIN?

    Your query makes answer easier to understand... :)
  20. KamranFeroz

    auto increment problem

    let me explain first.. what ur trying to do? I mean how u r placing the data in the db? either by query or by the help of ne front end? Thats make easier to answer you.

Part and Inventory Search

Back
Top