_tina_

Thank you, but won't that put each one on a new line? Thst i the problem I'm having. Thanks again.

Hi, I have a paragraph of text in a <p> tag. I need part of it to be a different color i.e. This is white text. This is blue text. This is white text. Do you know how I can achieve this? Thanks

Hi, I have three large images and three thumbnails. I want to rollover the thumbnails and change the large picture. Do you know how I can do this? All the examples I see seem to mainly do it for buttons. Thank you.

My table looks like: id, t_id, row1, row2, row3, row4, row5, row6, row7, row8, row9 id is the primary key t_id is a foreign key row1-9 ints There are multiple t-id's. This seems to be where the problem is. Thanks for the reply.

Does anyone have any idea on this? I'm trying to get the Average = (6+8+4+9+3+9+5+4+7)/9 = 6.111 / 2 and keep the result a number under 5. The user chooses 9 values (1-10) and I just want to add them all up, get the average and output the result as a number in the range of 1 to 5. Thank you

Sorry to reply to myself but I think I may have figured it out but am not quite sure if I'm getting the correct answer. SELECT ROUND(SUM( col1 + col 2 .... + col9 )/COUNT(*)*2)/2 as rating FROM table WHERE id = 5 Does this look correct? Thank you again

Hi, I have a query: SELECT ROUND(SUM(rating)/COUNT(*)*2)/2 as rating FROM table WHERE id = 5 I need to do the same query but this time with multiple columns. I have a table with 9 columns which hold ratings (integers 1 - 10). I need to get the average and divide by two. i.e: Average = (6+8+4+9+3+9+5+4+7)/9 = 6.111 / 2 Do you know how I can do this in one query? Thanks in advance.

Hi, I am using the following in a query: MATCH (bp.city, bp.state, bp.zipcode) AGAINST ('$location') [code] but II am not getting any results. Is there an equivalent to this using like? Thank you.

Hi, I am new to jquery. What I need to do is, if a person clicks a certain button and are not logged in, then a message will pop up prompting them to log in. I am using jquery.ui.min.js Does anybody know how to do this? Thanks in advance.

Great, this is just what I need. Thanks for the help with this.

Thanks for the reply. Yes, my date will look like - 2009-09-21 00:00:00 -

Hi, I have a MySql date in a variable. I need to test if it is three days after that date. Do you know how to do this? Maybe something like: if ( $date == date('Y-m-d', strtotime("+3 days")) ) .. but I can't seem to get it just right. Thanks in advance!

Hi, Thanks for the reply. Some, but not all links are on our site so this approach wouldn't really be the best for me. Is there another way to do this? Thanks

Hi, I have html emails and am trying to record to a database when and which link was clicked. How exactly would I go about doing this? Would a clear GIF method be used? Also, is it possible to have a count of how many times the email is viewed? Thank you in advance

Hi Neil, Thanks for the reply. So I will need to record every search term? Is this the only way to go about doing this? Thanks again

Hi, I need to display the most popular / most searched for terms. Do you know how to go about this? I hope my question isn't too vague. Thanks in advance.

Yes, it does this on my system too. However when I do this in Symfony, it has no effect, i.e. it completely ignores it and add's a "+".

That's exactly how I'm doing it ^. It's having no effect though. It seems to just completely ignore it.

Thanks for that, the reason I can't use rawurlencode is because I'm doing this project using the Symfony framework which is new to me and I can't it uses urlencode by default and there I can't seem to get it to use rawurlencode. This is why I'm looking for a work around. Like I said above, maybe replacing the + in an email with a %2B might solve this.

Would it work if I checked for an email address with a + and if there is one then replace t with a "%2B"?

Thanks for this. Just one question, I gather that this will strip out the + sign and leave 'spammersareassholes@wtf.com', is this correct? If so, how do I get the original email address, with the + sign, back on the next page?

Thanks for all the replies. I have looked into urlencode, apparently though, it is urlencode which add's the "+" in the first place and rawurlencode isn't an option. I am passing the paramaters along with a link i.e. <a href=link.com?param=1&param2=email etc. There is no maliciousness here on my part! It's just the client uses a "+" in his email address and wants to be able to do so in this system. Thanks again for all the replies.

Hi, I have an email address that I'm passing as a parameter. I need to convert email addresses that may have a plus sign "+" in them to the appropriate value. For instance, if the user submits their email address as user+userB@email.com, I am using urlencode and on the following page, I am getting user userB@email.com which is understandable. Is there some way I can get around this? I was thinking of something like: if( the email has a plus in it ) replace that with the proper code so the next page will understand and insert a + instead of a space End if I hope this makes sense and thank you in advance

Thank you very much for the help. It i now inserting into the db. Thanks again for the help

only remove the red This is what is one line from the CSV: "john", "E-Commerce Integration", "Notes notes",,,, I basically just want to take each field out, remove slashes, commas and just grab the text and insert into a database one row at a time. The extra commas at the end of each row are my problem. I am doing something like: $lineseparator = "\n"; $linearray = explode($fieldseparator,$line); $linemysql = implode("','",$linearray); $query = "insert into $databasetable ($fields) values('$linemysql');"; This is giving me the query correctly except it is adding quoted commas to the end as in: insert into TABLENAME values ('"name','data','data',,,,, ') Thanks.