Whats wrong with this MySQL??

[Vivid Lust]

I get the 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 '' at line 1

 

Code:

 

<?php

   # Connect to mysql
  $link = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  
   # Store data in database
  $sql = "INSERT INTO ".$dbname.".".$table;
  if (!mysql_query($sql)){echo mysql_error();};
   
   # Create url
  $sql2 = "SELECT 'id' FROM ".$dbname.".".$table." WHERE 'name'=".$name." and 'email' =".$email;  

?> 

Thanks for any help. 
?>

[AndyB]

Crikey!  There's so much wrong that the best thing to do would be for you to read a simple tutorial before attempting anything else.

 

A good starting page is http://www.tizag.com/mysqlTutorial/mysqlselect.php

[fenway]

.... like not inserting any data, for example.