Search results for query: *

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!

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

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...

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

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

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

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

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.

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...

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...

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.

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.

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.

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.

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...

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.

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.

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.

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

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.