Search results for query: *

I think I shot myself in the foot by not normalizing my forum schema. Here is what my table for forum posts looks like: messageID (unique, auto increment) threadID groupID (index) userID subject body date_added first_post (yes or no) So for a specific Group/Forum page, I am trying to get a...

I have two arrays like the following: $array1 = array("red", "red", "blue", "green", "blue"); $array2 = array("blue", "blue", "red", "red"); I want to count all of the matches between the two arrays; however, (counting) array_intersect does not work because each array has duplicates (which I...

Would it be conceivable to create a script to do a screen capture of a page?

I would like to be able to download a flash video file that I have uploaded to a site (i.e. youtube, google video). I parse the page and can create the actual file url (i.e.: http://youtube.com/player2.swf?video_id=phxIJoW330Y&l=165&t=OEgsToPDskIJNrC6JwNoaCzpBXyYqPZe) However, I am uncertain as...

Which is correct to have in URL's? +'s or %20 for spaces? I thought %20 was the correct way, but urlencode is giving me +'s instead. Thanks.

I have a list (<ul></ul>) that has some <span> tags in it. I would like to use DHTML to dynamically style this list based on different user selections through a form. On an onBlur of a field I want to change the color of *all spans* contained in <ul></ul>. Say <ul> has id="my_list" so I...

I am a member of about 20 different vbulletin based forums. I am stick of getting tons of email notifications on replies to my threads, so I want to write a script that will login and notify me of any new changes. I think I have everything, EXCEPT for the ability to login. Here are the names...

I am working with Blogger BETA to add links at the end of every post (ala Digg or Delicious style), but the problem is that before I can encodeURIComponent the text, the apostrophe's from the post I am storing into a variable break it. var title = &#39;<data:post.title/>&#39;; title =...

Here is my query: SELECT users.username FROM articles INNER JOIN users ON ( articles.userID = users.userID ) GROUP BY users.username ORDER BY articles.dateAdded DESC LIMIT 15 And it brings up *close* to expected results except that it leaves out certain users. Who should be there. And these...

I would like to get a rank (row # of ordered results) of an article based on its average rating in relation to all other articles. I have a ratings table that holds all of the individual votes cast by users (ratingID, articleID, userID, rating). So I need to order the articles by...

Here is the layout. I have the following 5 tables: users, groups, groups_members, groups_messages, groups_articles. I am trying to run a query that will count all new messages and articles from groups that a particular user belongs to and GROUP BY groups.group_name. The end result would look...

I've been reading over at php.net about the difference between persistent connections and a normal msyql_connect. I'm trying to decide which to use. PHP.net mentions using mysql_pconnect if you have a lot of "overhead" in establishing a connection. I'm not quite sure what this means. Any...

Is it common practice to use this? I've heard some say it costs more memory invoking the function and others say it should always be done.

Should I be using mysql_close() at the end of all my scripts? I've been told that using non-persitant connections will result in the connection closing once the script is finished. Thoughts? Thanks.

I'd like to figure out how to setup a commenting system that indents one level deep (ala Digg style). So each comment has a "reply" link and if clicked the new post goes right under the other (no matter what date). So the problem is how would you setup a query to order posts like that? Order...

So I am pretty new to php. I've picked up quite a bit but I'd like to know a little about performance. I've heard people mention "spawning a lot of instance of PHP puts a load on the server". Well what exactly causes an instance of php to start? Instead of echo'ing out a bunch of html, does...

When one uses a function inside a conditional like: if(move_uploaded_file($file_tmp, "$rand_name.$file_ext")) what exactly happens? Does the function run and if it is sucessful everything inside the conditional runs? If so, would this construct only work for functions that return true or...

Say I want to store a user profile in a "users" table but many of the fields are optional upon signup (e.g. "your website", "DOB", etc). Is there any problem in allowing null values for optional fields? I was always told that NULL values will make your queries incredibly slow. But it would be a...

I would like to wrap <li></li> tags around each newline. How would I go about this?

I'm a bit stumped as to how to approach this problem. I have a mail interface that shows message titles with a check box next to them which allows multiple messages to be deleted at once(very standard). But how can I do this AJAX style without a page refresh? Currently I just use a foreach...