mysql query with single quotes in a variable

Posted on 16th Feb 2014 07:03 pm by admin

$sitedetails = "INSERT INTO vars (address, sitename, description, ownername, theme) VALUES ('$url', '$sitename', '$description', '$ownername', '$theme') ";
mysql_query($sitedetails) or die(mysql_error()); // site details in mysql

If say $sitename = "scott nicol's blog"; - this will give me:
Code: 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 's blog test', 'scott nicol', 'scott nicol', 'default')' at line 1
I know it's due to the single quite in 'nicol's', how do I keep the quote, but stop this error?

Your Answer:

Login to answer

Other forums

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s

mysq_num_rows
Hi,

I want to use:

Code: if(mysql_num_rows($ergebnis2)==2)
how can the value 2, be

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.

Auto fill in input value based on User_ID
Hello,

I'm looking form some input on the following problem.

User loads page ->

simple php table loop
Hi all,

I've the following code

<?php // Create category options

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

Need a fuction to count entries in a field
Hi
I need a fuction to count how many times a email address is entered in to a field.

I ma

Parse error: parse error in C:wampwwwlogspagesmembers.php on line 16
I dont see the problem with this, I always get Parse error: parse error in C:wampwwwlogspagesme

Session problem?!?
Hello All! I am very new to the php world but I am working on fixing things that a previous programm