rasta876

How do i achieve this?

Hello everyone, I hope you can help me. I have created a form in Flash and sent the information from the form the and email using PHP. I am hoping to send JApanese characters across too but when I try it appears as unrecognizable characters in the email. How do I fix this? Thanks

Hey all, When I echo something from my database as below: echo &row['sentence']; I get an output such as: Hello Todayis Monday How do I eliminate get a space between Today and is to get: Hello Today is Monday In the database the spacing is quite allright. Thanks

Finally, I tried using mysql_data_seek and it worked. Thank you all for your effort. $query="SELECT DISTINCT name FROM myTABLE"; $results=mysql_query($query); mysql_data_seek($results,2 ) //to get the second item. while($row=mysql_fetch_assoc($resluts)){ echo $row['name']"<br>"; }

If I can filter say 50 names(including the same name more than once) to just 5 names (no repitition) using DISTINCT and echo all five of them echo $row['name'] , how do I do the same thing but this time echo only one of the five without knowing the actual value, (something like echo $row + something unique for the each item)? I can do this echo $row['name']; to get John Susan Kerry Tim Mika I want to do something like this: echo $row[?????]; to get the second item which in this case would be: Susan and then when my table content changes, the code echo $row[????]; would still be referring to the second item, which would be a different name this time around. I hope you understand what I want

Thank you for the quick reply, however im looking for a different result. In my Table I have many rows with the same name (e.g.Susan many times), I used DISTINCT in my query to get rid of the repitition. Is it possible to echo one name from the results. For example referencing them by their position or something. I cant set $name = 'Susan' because this value will occasionally change in the table when updated. The names will be replaced by new ones. Id like to just get one.

Hello all, I used the code below to get the distinct names from my table How do I get the individual rows after the query (for example the first or second one, etc..). Id like to echo the rows individually as I like. The following code echoes all the names from the query $query="SELECT DISTINCT name FROM myTABLE"; $results=mysql_query($query); while($row=mysql_fetch_assoc($resluts)){ echo $row['name']"<br>"; } this shows for example: John Susan Kerry What do I do if Id just like to echo one name from the query? example: Susan

Hello, I am a newcomer, could someone help me. I have an XML file myXML.xml which Id like to use to update a mySQL database. Ive searched al over on parsing etc..

I would like to update the column called Checked in my database with the following code. The problems is the value received by the line $cbox0=$_POST['cbox0']; example cbox=yes is not being inputted in the database. I think the problem lies with Checked='$cbox' because when I change it to Checked='yes' the value goes into the database. Could someone let me know what Im doing wrong $cbox0=$_POST['cbox0']; $inserter = "UPDATE checkbox SET Checked='$cbox0' WHERE Name='cbox1' "; mysql_query($inserter); thanks.

Hello, I was able to get information out of Flash in XML format. IT is very simple, just nested tags. similar to the following. <PERSON> <Info> <Name>John</Name> <Age>27</Age> </Info> </PERSON> How do I get this into mySQL database with PHP. One column in the database is NAME an the other os AGE thanks!