kalster

ty cyberRobot, that function example worked perfect.

Yes, I am asking for help. code, url, ect.

i need to change the color of a word in a string where the word is unknown (from $_POST) and may have one or more uppercase chars. code please.

Yes, you are correct, i forgot the mysql syntax. thank you.

I have noticed that some versions of mysql, the code below needs a ";" at the end of each line while other versions work with a "," and the end of each line. At what version of mysql did that change take place? $mySQL = "alter table users add `username` varchar(20) not null; add `location` varchar(100) not null; ";

Actually, i would like the line to be <p>example</p><br />

I have a line of text like this... <p>example<br /><br /><br /></p><br /> where the number of br tags before and after the </p> tag are unknown. I need the line displayed like this... <p>example</p><br /><br /></br /><br /> I need it in the preg_replace, where the part of the line begining with <p>example is untouched. Thank you in advanced.

No. Between < and >. After searching for a few hours I just found a solution to this problem. preg_replace('/br\s\s+/', 'br ', $text);

Is there a way to remove the white space seen between <br > or other html tags using preg_replace or something?

That gives me the user with the highest post count. What i need is the post count of the user that posted the most.

I have a mysql table like the following. post | username ______________ post1 | username1 post2 | username2 post3 | username1 I need a mysql count or max query that would get the highest post count of a user. At the table above, the post count would be 2 because username1 posted two times. Both the post and username data are unknown.

using php, how to delete values from an array and place those values in another array. Is it possible to take an array like this... Array ( [0] => Array ( [0] => var1 [1] => 1 [2] => var2 [3] => 2 [4] => 3 ) ) and make two arrays like this... Array ( [0] => Array ( [0] => 1 [1] => 2 [2] => 3 ) ) Array ( [0] => Array ( [0] => var1 [1] => var2 ) ) The word "var" inside of the array does not change value but numbers can change values.

The ? place-holder worked with a php for loop at bindParam.

with php, I think i can get the total count of $key from an array that is used in implode(). if not, then i will try your code. i will let you know tomorrow if the code works.

That cannot work because how many "?" is undetermined and the range is not known. the range can be anything from one onward. the query is "SELECT". is "select" safe from injection when not using a bindParam?