I have recently moved my scripts from Lycos.co.uk to portland.co.uk. Free hosting.
I have registered the MySQL database on portlandsql.co.uk, and I can access it with the phpMYadmin onportland.co.uk's member portal.
The preoblem is, I cannot insert the info into the db. I can display it, edit it, but not insert it. The only way I can insert data is through PHPmyADMIN, but not though my scripts. Mind, the scripts worked while I was on lycos, so maybe there's some kind of limitation?
I have a simple user database, not a forum or phpnuke (that is not even allowed 🙂 )
So, can anyone tell me what my problem is? Here is the script I use.
<html>
<head><title>Sign up!</title><head>
<body>
<?php
$db = mysql_connect("sql-01.portlandpremium.co.uk","blah","blah101");
mysql_select_db("blah",$db);
$continu=1;
if ($name == "")
{
print("Your name is needed !<br>");
$continu=0;
}
if ($continu == 1)
{
$sql="INSERT INTO roster (callsign, name, email, experience, prev_va, password) VALUES ('$callsign', '$name', '$email','experience', '$prev_va', '$password')";
mysql_query($sql, $db);
print("Thank you for signing up!") ;
}
else
{
print("<a href=form.html>back</a>");
}
?>
</body>
</html>
Thanks.