Daniel0

If they with parasites mean viruses and spyware I believe the truth is the opposite of what they say.

I wonder why they say things like "das ist totally wrong" and "viele young people". [quote=the ugly site]Viele Leute sagen, hey, diese Christen-Front ist doch ein Business von alten Kerlen. Aber [b]das ist totally wrong[/b]! In der Christen-Front sind [b]viele young people[/b] wie ich, und wir sind alles andere als von gestern! Cool![/quote]

I've tried that an advertisement said something about a specific part of the city (where I lived) which would as small as 5 square kilometers. I am just wondering how close they can get, and how the f*** they do it.

There is tutorials about pagination on PHPFreaks' main site.

Yeah it works. So in firefox press Ctrl+A (select all), right click and click on "View Selection Source". Edit: You can use FireFox' DOM inspector too.

I don't get your question, could you provide more details please? And it seems like it's more like a HTML question...

I see you placed some ads another place too: [URL=http://img509.imageshack.us/my.php?image=phpfreaksgoogleadsnk1.png][IMG]http://img509.imageshack.us/img509/4200/phpfreaksgoogleadsnk1.th.png[/img][/URL] The place the new one is placed is quite annoying, could be possible be moved somewhere else? Or at least centered? It only happens in the AJAX forum, so is it a bug?

[quote author=printf link=topic=110258.msg445408#msg445408 date=1159809928] Why in the world would he / she need to select all the records to get the newest one! [/quote] How would you sort them using a query if they are formatted in a strange way?

I'm afraid you posted in the wrong forum. This belongs in the forum about third-party scripts :) Edit: Hmm, well a mod/admin thought it belonged in the PHP installation forum.

Some replies are missing o_O

I don't know mssql, but just select all of them, but based on your code, try something this: [code]<?php function convert_date($date) { return mktime(0,0,0,substr($date,0,(strlen($date)==8 ? 2 : 1)),substr($date,-6,2),substr($date,-4)); } $RESULTDS=mssql_query("SELECT DISTINCT LH.[Employee Number], LH.[Lmo], LH.[Lda], LH.[LYR], LH.[Hours], LH.[Leave Code], M2.[HRYRAT], M2.[EMPNO], M2.[MANLAP], M2.[PAYCTR], M2.[MANLAC], M2.[MANLTC], M2.[MSKLAB], M2.[MSKLTC], M2.[MSKLAB], M2.[MSKLTC], M2.[NAMEMI], M2.[NAMEL], M2.[NAMEF], EH.[EPEDAT], EH.[ENETPA], LH.[LOCC], EH.[EGRSER], EH.[EREGHR], EH.[EDEDUC], EH.[EROTHR], EH.[EFWHD], EH.[ESSDED], EH.[EHOSPD], EH.[ELIFED], EH.[ECRUD], M2.[MCTDWH], M2.[MCTDCS], M2.[MO3TOT], M2.[MCTDLD], M2.[MCTDGE], M2.[MALPPP], M2.[MSLPPP], M2.[MWHSTA], M2.[MWHALL], M2.[MWHADD], EH.[EGARND] FROM LEAVHST LH INNER JOIN MASTERL2 M2 ON LH.[Employee Number]=M2.EMPNO  INNER JOIN EARNHIST EH ON EH.[EEMPNO]=M2.EMPNO WHERE M2.[EMPNO] = '".$_POST['employeenumber']."' and M2.[MSSNO] = '".$_POST['password']."' ORDER BY LH.[LYR] desc, LH.[Lmo] desc, LH.[Lda] desc"); while($RESULT=mssql_fetch_assoc($RESULTDS)) { $rows[] = $RESULT; } $most_recent_row = array(); foreach($RESULT as $row) { $timestamp = convert_date($row['whatever_the_field_name_is']); if(convert_date($most_recent_row['whatever_the_field_name_is']) < $timestamp) { $most_recent_row = $row; } } print_r($most_recent_row); ?>[/code]

Try this: [code]<?php foreach($_GET as $key => $val) { $keys[] = $key; $vals[] = "'{$val}'"; } $query = "INSERT INTO table (".join(',',$keys).") VALUES(".join(',',$vals.");"; echo $query; ?>[/code]

Just as a notice... $_GET is [i]always[/i] true as it by default is array(), so if($_GET) would be unnecessary. To do what I think you're trying to accomplish you should use this: [code]if(count($_GET)>0)[/code]

I've noticed advertisments and popup windows saying stuff like "bla bla in X" (where X is the city I live in). How do people detect what city I live in ???

[quote author=obsidian link=topic=110155.msg445337#msg445337 date=1159804920] just a note: i've noticed that the google ads get covered over when there is a code block appearing within the space that the ads take up. not sure of the best solution, but i will be pleased when they are moved up above the actual posts rather than within the first post itself. [/quote] I think wildteen's solution would be the best one.

I don't like the blue color. It's too dark (it's too #0000FF-ish).

1. Do not display text with images. 2. Why did you make that red box so high when there is not that much text? 3. I think your "welcome" page is lame. 4. I don't like your combination of colors. 5. I don't like frames. 6. http://schme16.selfip.com/Members/ -  ::)

Just test it on your computer with a WAMP/LAMP.

You do not have the required permissions to access the database dbname_dbname

Just put {$emp_name} inside the string containing the query.

Do [code]if(count($_POST)>0)[/code] instead.

[quote author=ober link=topic=110155.msg445295#msg445295 date=1159802881] How about we just go along with it and not come up with ideas to skirt around it, eh? [/quote] I just asked if it was against the TOS. I never suggested that you should do it.

You do not have access to open the file. Try changing the chmod value.

You can spilt up the words like this: [code]$words_array = explode(' ',$_POST['search']);[/code] You might want to look at full-text searching as well: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html Example: [code]SELECT * FROM stuff WHERE MATCH(title,body) AGAINST('the search string here');[/code] Or Google-like search: [code]SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+PHP -MySQL' IN BOOLEAN MODE);[/code]

AJAX questions belong in the AJAX forum ;)