MySQL

[Ken]

Parse error: parse error, unexpected T_STRING in
C:\Apache2\Webpage\test_mysql.php on line 44

I receive the above error when trying to insert data into a database. The
statement used for insertion is:

LINE 44: INSERT INTO ad_data ('website') Values('w');

The database and table is working..

I can connect to the database and the table.
Table name is ad_data.
Column1 name is id which is the primary key, integer, and auto incrementing
Column2 name is website. Data in the website column is 'hhhh'

All columns are NULL except for id.

I can fetch data from the table. See below:

$db_query = mysql_query("SELECT website FROM ad_data") or die("Select
Failed!");
$db_results = mysql_fetch_array($db_query);
echo "Table data = ".$db_results[0]."<br><br>";

I have manually inserted data in the table.

Everything seems to be working.

Any suggestions for correcting the error in line 44?

Thanks for the help.

Ken

[Aggro]

Ken wrote:

LINE 44: INSERT INTO ad_data ('website') Values('w');

Is this supposed to be php or sql?

If sql, then:
INSERT INTO ad_data (website) Values('w');

[Aggro]

Ken wrote:

It is sql inside of
<?php
INSERT INTO ad_data (website) Values('w');
?>
Do I need to add any leading script if it is sql inside of php?

I am not the best person to answer php questions and this is not a group
for php, but personally when I used php, I used database like this:

<?php
$link = mysql_connect("localhost", "username", "password")
or die("Could not connect");
mysql_select_db("databasename")
or die("Could not select database");

$query = "SELECT * from tablename";
$result = mysql_query($query)
or die("Query failed");
?>

[Aggro]

Ken wrote:

It is sql inside of
<?php
INSERT INTO ad_data (website) Values('w');
?>
Do I need to add any leading script if it is sql inside of php?

I am not the best person to answer php questions and this is not a group
for php, but personally when I used php, I used database like this:

<?php
$link = mysql_connect("localhost", "username", "password")
or die("Could not connect");
mysql_select_db("databasename")
or die("Could not select database");

$query = "SELECT * from tablename";
$result = mysql_query($query)
or die("Query failed");
?>

[Ken]

It is sql inside of
<?php
INSERT INTO ad_data (website) Values('w');
?>
Do I need to add any leading script if it is sql inside of php?

Ken
"Aggro" <sp**********@yahoo.com> wrote in message
news:Q8***********@read3.inet.fi...

Ken wrote:

LINE 44: INSERT INTO ad_data ('website') Values('w');

Is this supposed to be php or sql?

If sql, then:
INSERT INTO ad_data (website) Values('w');

[Aggro]

Ken wrote:

It is sql inside of
<?php
INSERT INTO ad_data (website) Values('w');
?>
Do I need to add any leading script if it is sql inside of php?

I am not the best person to answer php questions and this is not a group
for php, but personally when I used php, I used database like this:

<?php
$link = mysql_connect("localhost", "username", "password")
or die("Could not connect");
mysql_select_db("databasename")
or die("Could not select database");

$query = "SELECT * from tablename";
$result = mysql_query($query)
or die("Query failed");
?>