Search Results

Search found 5 results on 1 pages for 'mathon12'.

Page 1/1 | 1 

• DB structure for Twitter home/Facebook wall?

  - by mathon12

  Basically a live feed of all your friends' recent posts. In a stupid sort of approach I think I'd start by building a query like: SELECT * FROM tblposts WHERE userid=friend_id_1OR userid=friend_id_2...... and so on Where friend_id_% is the userid of a friend from your friends list. But this must be a very inefficient way of doing it, right? Is there any faster way of doing this in MySQL? Maybe some clever DB schema? (I know FB uses Hadoob but I'm not experienced enough to go that far :( )

  Read the article

• VPS nameserver setup?

  - by mathon12

  Hi, I bought a VPS a few days back and had a domain name registered. It gave me 2 nameservers. I only have shell access (no Cpanel/WHM) and it's running CentOS 5. I can visit my site with http://IP/ but not with http://domain.com. What changes do I need to make so that I can visit my site with http://domain.com. I'm really new at this and any help would be greatly appreciated. Thanks.

  Read the article

• Fetch pages translated by Google? (PHP)

  - by mathon12

  Hi, I have a bunch of big txt files (game walkthroughs) that I need translating from English to French. My first instinct was to host them on a server and use a PHP script to automate the translation process by doing a file_get_contents() and some URL manipulation to get the translated text. Something like: http://translate.google.com/translate?hl=fr&sl=en&u=http://mysite.com/faq.txt I found it poses two problems: 1) there are frames 2) the frame src values are relative (ie src="/translate_c?....") so nothing loads. Is there any way to fetch pages translated via Google in PHP (without using their AJAX API as it's really not suitable here)?

  Read the article

• Problem with auto increment primary key (MySQL).

  - by mathon12

  I have 2 tables each using other's primary key as a foreign key. The primary keys for both are set to auto_increment. The problem is, when I try to create and entry into one of the tables, I have no idea what the primary key of the entry is and can't figure out what to put in the other table as a foreign key. What should I do? Do I drop auto_increment altogether and cook up a unique identifier for each entry so I can use it to address the created entries? I'm using PHP, if that's relevant. Thanks.

  Read the article

• Closest previous element with certain ID (with prev())?

  - by mathon12

  I have a big div wit a lot of smaller divs within it. Say, <div id="parent"> <div id="child1"> </div> <div id="child1"> </div> <div id="child2"> </div> <div id="child1"> </div> <div id="child1"> </div> </div> If I'm currently at the last 'child1', how dow I get to the top most child1 with prev()? For me it breaks when it reaches 'child2'.

  Read the article

1