$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?
order by date not ID number help php
I am trying to orginize the following code to order by date not id number.any help would be greatCode: [Select]<?php // Status // 1. inshop // 2 in progress // 3 pending // 4 to be
code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page. The problem I have is that the pagination isn't working, and I can figure out why. I dont get any errors.Can you
include
Hi I have this way of licensing my PHP application, and I want to know if you guys can answer some questions with it.So there is the index.php on the server of the person who bought it
random generation
hii need help with generating thisnumbers from 1-12i want to generate in random order 60 times in total the numbers 1-12and generate 5 results from each number.so in the total of the 60 return result
confused between ' ' and " "
there is a php i set:$begin_date_query = mysql_query( "SELECT SUBDATE(due_date, INTERVAL $days_expected DAY) AS begin_date FROM baby WHERE baby_id = $_SESSION['baby_id']" );'coz of the
How to read posted binary data from a mobile device and post it to a web server?
Here is the senario...I have a mobile device (MD) that posts binary data to a Web Server (WS1) and that Web Server (WS1) posts that binary data (from the MD) to another Web Server (WS2).(MD)
Supress some serveroutput but not all
Hi,
include problem
I have my root folder as:Code: $root = $_SERVER["SITE_HTMLROOT"]; // the server rootWhy does this not work when I want to include a php file:Code: include "$root/form.php";But the
Login logout link help
Hi all,Im new to php and Im having trouble creating a login/logout link for my page that displays as: Log Out | My Account.when a member is signed in, And: Log In | Sign UpWhen no one is signed in.The
Cursor statement failed with errors
Following statement failed with the errors.