d_barszczak

Thats great!!! Do you know of any good tutorials or books that would help me with mysql function as i have learned basic queries but dont seem to be able to find anything more advanced. Thanks.

Hi all, I am trying to design some reports for a script that i am developing but im trying to cut down the amount of queries that it uses if i can help it. The following query will show me all the unique urls in my table. SELECT DISTINCT `url` FROM `hcl_counter`; What i would like is to do is also display the number of times it appears all in one query getting a result similar to url , Occours http://www.google.com, 234 http://www.scripts2go.co.uk, 145 and so on... I would normally use the first query and then have php cycle through to get me the numbers but i wondered if i could do this with one query. All help is much appreciated.

Genius! Genius! Genius! Genius! Genius! Genius! Genius! Genius! Genius! Genius! Genius! Genius! Genius! Genius! What a guy. Just when i was about to give up on php & mysql and take up something easier like heavy weight boxing smart85 has saved the day. Thanks a lot smart85!!

I am creating a hitcounter script / traffic monitor and one of the stats i need is the users screen resolution. I can only get this from javascript. I then need javascript to pass the variable to php where i can save the value in a mysql database along with other bits of data it collects. I have tried ajax but the counter can be used on any website and ajax will not work cross domain. Please Please someone help me with this.

Thanks for that, Sounds a little complicated. All i need is one value to get from javascript to php so it can be stored in a database. Is it then possible for javascript to write a cookie at the begnining of the page and have php pick it up at the end?

OK This is a problem Any tips on cross browser ajax scripting??

Hold on a sec!!! It works when the ajax.php script is on the same domain. Please dont tel me this is a limitation of ajax.

hi all, xmlHttp.open("GET", "http://my.website.co.uk/ajax.php", true); The above script gives me a object error but xmlHttp.open("GET", "ajax.php", true); does not but the script is still not running can any one help me!!!

Thank you xenophobia. Is that cross browers compatible?

Wow, now im really confused. Thanks for a great explaination though. This regex stuff is really twisting my melon. Do you know of any good tutorials on the subject?

Hi all, I have created a form that i would now like to check over with javascript which i think i know how to do but after that has passed i don't know how to submit the form with a javascript command.

I know what this function does but i have no idea how. I just wondered if anyone can explain the code in red to me. preg_match_all('/(?<=href=)[\'"]?([^\s"\'>]+)/', $html, $matches);

Ok so here is an example of my query. I understand how i could use the php function but how would i iplement the mysql function. $query = "INSERT INTO (username, password, email, enabled) VALUES ('admin','pass','me@my.com','1'); "; Which would be the prefered method and why?

Thanks, cant find LAST_INSERT_ID() on php.net but this seems to do the same thing. mysql_insert_id() Is this the same function or am i not looking hard enough?

Hi all, This is probably very simple but i can't for the life of me figure this out. I have an auto increment on one of my columns labled 'id' that i use as an unique id fro each of my records. Is there anyway when i insert a record into my database i can find out which 'id' has been given to it. Thanks.

Can we see some of your code?

This would not work for html files though would it?

Hi all, I am developing a sandpit area where php developed wannabe's car practice there coding and i would like somhow to force a banner at the bottom of the page with with something like Hosted by scripts2go.co.uk but no idea how to do this. I think i need to do this at apche level but not sure. All help would be much apreciated.

Thank you, I like to try do things myself first but i have been scratching my head for weeks now. Kinda gutted you answered is so quickly. Thanks Again.

Hi all, I am developing a simple seach engine script that puts words found in a html document into a table notes the url and the occourances. What i would like it to do is find any hyperlinks that are in the html document and im not sure how to pick out the hyperlinks and place them in an array.

Thank you very much. Looks like i was going about it all the wrong way. That has been doing my head in for weeks now?

Thank you for your help. Im just looking through the nogray library now. www.scripts2go.co.uk/drawingboard/menu/menu-ie.php The above url takes you to the project im working on. If you click on Departments or Cross Curricular in ie it works but in ff it don't.

Creating a basic tree menu script but the following won't work. [code] function menu(varID) { if (document.all) { // IE code works fine as of 17-January-2007 if (document.all(varID).style.height == "100%") { document.all(varID).style.height="0%"; document.cookie = varID + "=closed; "; } else { document.all(varID).style.height="100%"; document.cookie = varID + "=opened; "; } } else if (document.getElementById) { // FF code not working. if (document.getElementById(varID).style.height == "100%") { document.getElementById(varID).style.height="0px"; document.cookie = varID + "=closed; "; } else { document.getElementById(varID).style.height="0%"; document.cookie = varID + "=opened; "; } } else { alert("This menu is not compatable with this browser."); } } [/code]

Figured it out. Needed to change connection mode to passive. ftp_pasv(connectionid, true)

I am trying to create an update scripts that is caperble of downloading it updates should the administrator wish to. ftp_get() port command successful I keep getting this error and i have no idea why.