benkyma

I'm building a javascript application that uses CSS transitions to fade the content container before swapping out the content and fading back in. It appears that Chrome waits for about half a second before beginning the transition. It usually then completes the transition really quickly and jerkily. In all other …

Hi, I want a script that will upload an image to a user's Facebook account. So far I have this code, but it's not working correctly. I seem to get an ID returned, but no image is uploaded to the profile: [ICODE] function do_post_request($url, $data) { $file= $data; $args = …

I've just removed and reinstalled mysql on my Amazon EC2 server. When I went to change the root password on the new install: sudo /usr/bin/mysqladmin -u root password 'MYNEWPASSWORD' I get an access denied error: error: 'Access denied for user 'root'@'localhost' (using password: NO)' Has it held onto the old …

Hi, I'm struggling with mod_rewrite. I need it to rewrite: [url]http://www.domain.com/C/V[/url] to: [url]http://www.domain.com/?category=C&video=V[/url] So far I have these two rules: [CODE]RewriteRule ^([^/\.]+)/?$ /index.html?category=$1 [L] RewriteRule ^([^/\.]+)/([^/\.]+)/?$ /index.html?category=$1&video=$2 [L][/CODE] but it doesn't seem to work. I'm not receiving any parameters through in my js on the other side. It also behaves …

I'm trying to retrieve values from a database and encode them as JSON for another script to grab. I'm doing this like this: [CODE]for($i=0; $i<7; $i++) { $nextDay = $i+1; $startDateTime = date("Y-m-d H:i:s", strtotime("-$i days")); $endDateTime = date("Y-m-d H:i:s", strtotime("-$nextDay days")); $query = "select count(*) as cnt from app_instances …

I've got a database which is getting quite large and slow to query. I only really need the last month of entries for most situations so I'm looking to create structure-copies of two of my tables and then regularly move data from the 'live' two into the 'archive' two if …

I have the following code which results in a mysql error. However, when I use this query in PHPMyAdmin it works fine. Can anyone see what is causing the error? [CODE] for($i=0; $i<10; $i++) { $nextDay = $i+1; $startDateTime = date("Y-m-d H:i:s", strtotime("-$i days")); $endDateTime = date("Y-m-d H:i:s", strtotime("-$nextDay days")); …

I need to make ten selections. One of all the datetimes in the last 24 hours, the next one from 24 hours to 48 hours, and on back in 24 hour blocks for the last ten days. I've tried various approaches to this, but this is what I currently have: …

I've spent a bit of time porting my database connection over to MySQL. It's taken a bit of time, but generally been fairly easy. However, one of my insert queries is currently failing due to an auto increment ID field. I have this insert query: [CODE]INSERT INTO entries(text, name, screen_name, …

I have to connect remotely to my MSSQL database. However, I am a little unsure as to the best way to do this. Can I connect directly to the database from my client machine, or would it be best to create some kind of local script that does the connection …

I've got an open connection with a stream reader pulling data in to my system and storing in a database. Everything works great, except occasionally the stream from the remote server stops and this makes my program crash. How can I catch this situation when it occurs, and maybe attempt …

I want to select from a table only when a field repeats more than once. For this I have: [CODE]Select title, Count(*) As Cnt From poss_titles where Cnt > 1 Group By Title Order By Cnt desc[/CODE] But it says invalid column name cnt. How should I refer to this …

I need to query a database of application titles and count the instances of each title. I've already got a list<string> of distinct values from a previous query, and now I need to count how many times each value occurs. I'm not sure if the query is correct, or how …

I need to query a database of application titles and count the instances of each title. I've already got a list<string> of distinct values from a previous query, and now I need to count how many times each value occurs. I'm not sure if the query is correct, or how …

I know that this is well-covered ground, but for some reason I have been unable to get this database connection working. This is my first project using .net systems instead of PHP/MySQL so I'm not quite sure how things are working. I've spent the morning trying different connection strings and …

I'm trying to connect to the twitter streaming api. At the moment I'm just trying to grab the incoming data stream, keep the connection open and write the data to the console. I can do this easily from a terminal using curl. The following code however runs, throws no errors, …