tjburke79

Hello, I hope someone can help me out. I am trying to create a 301 redirect using a RewriteRule or a RedirectMatch example: /article/2002-03-17/247/test-subject-name-whatver.html I would like to redirect this and all other urls that are in the /article/ directory to my index page, is it possible redirect anything that is in the /articles/ directory? Thanks in advance

Hello, I was wondering if someone can help me out in formatting this time format so it is in a 24 hour format? $time = "9:33p EST"; Thanks for any help in advance

i am wondering if someone can help me out. i am trying to parse a field, and i need to split the field into 2 values. $Var = "+1.5-165"; or $Var = "-1.5+145"; i need +1.5 as on var and -165 as another, and it is possible that the numbers are switch around, so i can not use the explode function to spit them any body of a solution? thanks

got it, thank you very much for your help!

ok that looks like it should work, but when i run the query i get something like [bLOB - 34B] as the group_concat?

nobody has any idea? our should i be posting this in a php forum?

The Data field on the "Feeds" table will store the temporary information, so in the feed i can select the MemberID and explode $Data to get the latest PhotoID's for that MemberID... My problem is building that initial query and loops compile the information to create the insert query

I hope I have posted this in the right area but I am hoping someone can help me out. But its kinda mysql and php related... What I am trying to do is, query a members database to see if they have uploaded any new photos to there account. once i find out what photos are new, i would like to insert a single entry into a feeds table with field that has a comma separated value so that i can later use the explode function to see what new photos where uploaded in my members feed's application. // select latest uploaded photos SELECT MemberID, PhotoID FROM Photos WHERE DateTime >= '2011-05-04 13:02:18' ORDER BY MemberID this will output example... 1 | 11 1 | 15 1 | 89 2 | 68 so i guess where i am stuck is based on this select, how would i go about building a single entry per MemberID into my Feeds table? I would have to do use the loop and an implode function I am guessing but not to sure how to put it all together. // implode mysql result $comma_separated = implode(",", $array); what i need to do is compile the results so that i can make a single entry into my "Feeds" table per MemberID... insert one entry into feeds per MemberID an example would have to be like this.. INSERT INTO `Feed` (`MemberID`, `Data`) VALUES ('1', '11,15,89,97') INSERT INTO `Feed` (`MemberID`, `Data`) VALUES ('2', '68') I hope I explained myself on what I am trying to accomplish here. Any ideas or a better solution to what i am trying to do? I would rather have one entry then a new entry for every new photo. Thanks for your time.