Query not working?

[OwnYou]

(Sorry for posting this twice, I think I put it in the wrong forum before). In the following code, I am trying to get it to insert data into two rows in a table in a database. However, not matter what I try I just can't seem to get it to work. Any help would be much appreciated... Here is my latest effort:

<?php

$source = "[e-mail]";
$destination = "[e-mail]";


$link = mysql_connect('localhost', 'username', 'password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

$db_selected = mysql_select_db('mail', $link);
if (!$db_selected) {
   die ('error: ' . mysql_error());
}



$sql =    "INSERT INTO 'forwardings'
                       ('source', 'destination') VALUES ('$source', '$destination')";
mysql_query($sql);

mysql_close($link);
?>

[bpat1434]

Table names use back-ticks ( ` ) not quotes....

The main thing I see here is no error catching on the query line.... add an or die(mysql_error()) statement and see what that gives you:

mysql_query($sql) or die(mysql_error());

[OwnYou]

Using:

$sql =    "INSERT INTO `forwardings`
                       (`source`, `destination`) VALUES (`$source`, `$destination`)";
mysql_query($sql) or die(mysql_error()); 

mysql_close($link);
?>

For the query. It returns this: Unknown column '[e-mail]' in 'field list'

Hmmm...

[OwnYou]

Ah got it.

$sql =    "INSERT INTO `forwardings` (`source` , `destination`) VALUES ('$source' , '$destination')";
mysql_query($sql) or die(mysql_error()); 

mysql_close($link);
?>

Thanks guys.

[bpat1434]

this:

(`source`, `destination`) VALUES (`$source`, `$destination`)";

needs to be this:

(`source`, `destination`) VALUES ('$source', '$destination')";

As for your error... echo out the query before you run it... see if it's giving you what you expect...

[OwnYou]

I bet you to it 😉