Archive for the ‘Tech Q&A’ Category

How to add a word while inserting the values into mysql?

Dear Friends,

I have a site where I received the keywords with coma separated.

$result=mysql_query("insert into sellingtool (keyword) values (‘$keyword);

Suppose I am inserting these keywords.
Juice, Orange Juice, Apple Juice.

And I want this result in data base.

Juice exporter, Orange Juice exporter, Appli Juice exporter.

Please help me our. Awaiting for your expert replies.

MySql deletion is a mystery. How can I detect what is deleting an entire row randomly?

I have a website running off a mysql database and in one table there is one column that is being deleted every so often and I can’t for the life of me work out why this is happening. I have spent so much time trying to work it out. What do I do next? Any ideas would be great.

How do I enter large amount of articles into a wordpress blog using mysql ASAP?

how do I insert those articles into mysql anyway? instead of I have to upload them one by one to wordpress. I am really a newbie in both mysql and wordpress.
Thank you in advance.

What is the best book to learn PHP and MySQL?

I already know a good amount of XHTML, HTML, and CSS, but little no none of PHP and No MySQL. So… Is there a book out there that does a good job explaining these PHP and MySQL to beginners?

How to check Outlook 2003 email from a different CPU?

How do I check my Outlook E-Mail from a different CPU?

How do I know the memory compatible with my computer?

I have an HP Media Centre M1070n, 512mb and I wanted to upgrade the memory because it’s slowing down. Is it easy to install?

What is the MySQL SELECT statement to return a distinct count of entries from multiple SQL tables?

I have three tables: City, Country, and Language. City and Country both have unique primary keys, but Language lists the languages that are spoken within a single country (identified by Country’s unique key) so that a single country might have multiple languages. I would like a single SELECT statement that returns the number of unique cities, the number of unique countries, and number of unique languages found in their respective tables. I believe nest SELECT statements are involved, but I have yet to solve this issue.

Is it okay if I defrag first my computer before I use it? Is defragmenting can scratch my harddisk?

Is defragmenting can harm my files if I defrag it when the computer says I dont need to drag the volume?