Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : creating a link using a php variable

[stickygoblin]

hi

i know me again!!!

i'm stumped again with the insertion of a variable into a url string to place in a database:

PHP Code:


$link = "http://www.rwascentenary.com/counties/$County.php";

$sql = "INSERT INTO county_tbl SET Link ='$link'"; 


any suggestions as to how i would place the variable $County to name the file to be linked to.

if you have any suggestions as to how i would create the file - that would be really useful too as i know it's going to be tricky.

regards

sticky

[Loon]

PHP Code:

$link = 'http://www.rwascentenary.com/counties/'.$County.'.php'; 


[stickygoblin]

now when i try and place this into the database using the code:

PHP Code:

     $sql = "INSERT INTO county_tbl SET " .
                "County ='$County'" .
                "Link ='$link'"; 


its returning an error of:

Error adding submitted county: You have an error in your SQL syntax near 'Link ='http://www.rwascentenary.com/counties/really.php'' at line 1

??

[Loon]

$sql = "INSERT INTO county_tbl (County, Link) VALUES ('$County', '$link')";

[stickygoblin]

cheers thanks for the help.

do you have any idea where i can find a tutorial for how to create a php page (so the link goes somewhere)