Hello

Just wondering if there were any programs to easily install php on the OS i stated. Something which installs both PHP and Apache and anything else needed. I tried to do it once but it failed so Im wondering about the programs.

Oh- and also MySQL!

Thanks"

Table: datadump

Columns: table- column- data

Data I want to insert: They are variables; $table- $column- $data

I know that the mysql_select_db and mysql_connect is ok and I will not give that for security reasons- but what about this syntax:

$sql = "INSERT INTO datadump (table- column- data) VALUES ($table-$column-$data)";

$mysqlquery = mysql_query($sql-$con);
if(!$mysqlquery)
{
die( Error: . mysql_error());
}

When I run the script with this syntax- I get the following error:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near table- column- data) VALUES (index-name-fruits) at line 1

Can you please tell me what to do?
Same problem after taking the first answerer s advice
Same problem again with second answerer s advice

I heed help to get my query working.
So far i need - some how to select rows from 2 different databases and tables located on the same server. Particularly i need to select rows from db1.table1 and ORDER it by column in db2.table2. Both tables have column ID.
Example of what i need:
SELECT table1.id-table1.country FROM db1 ORDER BY db2.table2.cities
Made it Work now- Also had to change db permissions for user to access multiple db s. Thanks Chris C.

I have purchased a cheap website off a friend for £30 a year- and the reason I done this was simply to try to get familiar with MYSQL and PHP- as I am going to be learing this in univesity in september.
I bought this website simply as a mess around to see how it works etc- but now Im really liking the idea of having this website and taking it more seriously.
I am 20 year old business and IT student- and therefore trying to make this work ould help me with my studies.

Im not really bothered if this doesnt take off- as it wasnt what i planned to do..
This is the website (not finished yet)

www.myrealestatehomes.org
As you can see I have no listings for houses or apartments etc up just yet- as i literally just got this up on the web about an hour ago! Im a little confused- as i thought it would have had a tool for passers by to add their property..
I have no idea where to get the housing listings from?
Would you say my nxt step is to contact agents- asking to promote their properties? x

Well I am looking for a web hosting service with the following requirments

It is free
Latest PHP
Latest MySQL
Safe Mode Off
Reasonable Space (at least 250 MB)
FTP
THE SITE DOSEN T STUFF UP 60% OF THE TIME

I have already tried x10hosting by my site keeps stuffing up and my cPanel dosn t work or anything.

Does anyone know what this error means:

Can t connect to MySQL server on imp1 (4) ?
Thank you. :)

I m not a programmer. I was trying to connect to connect to a literature message board and I ended up on a white page with that message. I was just wondering.
Sorry for the double wording.