mySQL database;

Dion · #1 (**permalink**) 09-17-04, 09:16 AM

Hi,
I've had a link exchange page hosted on my own pc. But now I have a free host. Everything is working correctly except for the url adding. This is the script which I use:

PHP Code:


			
01: <html>

02: 

03: <head>

04: 

05: <title>Untitled Document</title>

06: 

07: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

08: 

09: </head>

10: 

11: <body>

12: 

13: <?php

14: 

15: include_once ("./settings.php");

16: 

17: 

18: 

19: $user = $_POST["naam"];

20: 

21: $link = $_POST["link"];

22: 

23: 

24: 

25: $dbh = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");

26: 

27: $selected = mysql_select_db("$base",$dbh) or die("database error");

28: 

29: 

30: 

31:

32: $sql = "INSERT INTO `$basesites` ( `id` , `naam` , `link` ) " . " VALUES ( '', '$user', '$link' );" . " "; 

33: 

34: mysql_query($sql);

35: 

36: $res = mysql_affected_rows();

37: 

38: 

39: 

40: if($res > 0) {

41: 

42: $succes=1; //succesfully added to the database

43: 

44: } 

45: 

46: else {$succes=0;}    

47: 

48: if ($succes == 1){print "registration complete  " . "$res";}

49: 

50: else {print "<P>ERROR during registering: <br> " .  mysql_error() . "</P>";}

51: 

52: 

53: 

54: mysql_close($dbh);?>

55: 

56: <a href="index.php"><br>click page</a>

57: 

58: </body>

59: 

60: </html>

On another page I've got a little form where the $link and the $name are specified.
The problem is when I try to register I get this error:
"ERROR during registering:
You have an error in your SQL syntax near '; ' at line 1"

But I don't see the error, maybe some of you can help me with this one

<?Wille?> · #2 (**permalink**) 09-17-04, 09:37 AM

here is the error: (or should be atleast)

PHP Code:


			
32: $sql = "INSERT INTO `$basesites` ( `id` , `naam` , `link` ) " . " VALUES ( '', '$user', '$link' )";

Dion · #3 (**permalink**) 09-17-04, 09:39 AM

THANK YOU, it's working great now