query help

loureiro

im getting a parse error and i dont know why. i've checked my code but i just simply cant find it!

    $query = "INSERT INTO 'Customer' VALUES ('','."$_POST["Name"]".','."$_POST["Address"]".','."$_POST["City"]".','."$_POST["State"]".','."$_POST["Country"]".','."$_POST["Email"]".','."$_POST["Phone"]".','."$_POST["Cell"]".','."$_POST["Fax"]".','."$_POST["Title"]".','."$_POST["Picture"]".','."$_POST["Signature"]".','."$_POST["Link1"]".','."$_POST["Link2"]".','."$_POST["Link3"]".','."$_POST["Link4"]".','."$_POST["Comment"]".','."$_POST["DistribNum"]".','."$_POST["SponsorName"]".','."$_POST["Package"]".','."$_POST["Version"]".','."$_POST["Design"]".','','')";

loureiro

this is the error i get

parse error, unexpected T_VARIABLE

jkohns

Check your QUOTES and CONCATENATOR-

should be:

".$_POST['variable']."

currently, they are reversed:

."$_POST['variable']".

causing the parse error

loureiro

thanks you are right. i did have them reversed. now it just plain doesnt work. i had it working a few days ago but now its not doing anything. im also positive i didnt touch it.

<?php
$db = 'Lifestyles'; // mySQL database name
$user = '***'; // mySQL username
$pw = '***'; // mySQL password
$mysql_access = mysql_connect("mysql", $user, $pw) or die("Unable to connect to MySQL");
mysql_select_db($db, $mysql_access) or die("Unable to select database");

    $query = "INSERT INTO 'Customer' VALUES ('','".$_POST["Name"]."','".$_POST["Address"]."','".$_POST["City"]."','".$_POST["State"]."','".$_POST["Country"]."','".$_POST["Email"]."','".$_POST["Phone"]."','".$_POST["Cell"]."','".$_POST["Fax"]."','".$_POST["Title"]."','".$_POST["Picture"]."','".$_POST["Signature"]."','".$_POST["Link1"]."','".$_POST["Link2"]."','".$_POST["Link3"]."','".$_POST["Link4"]."','".$_POST["Comment"]."','".$_POST["DistribNum"]."','".$_POST["SponsorName"]."','".$_POST["Package"]."','".$_POST["Version"]."','".$_POST["Design"]."','','')";

	mysql_query($query) or die("Query did not work");

    mysql_close($mysql_access);
    ?>

jkohns

Check that you're using the backtick (`) and not single-quotes (') for database, table, column, and alias names -

ie:

INSERT INTO Customer VALUES

not

INSERT INTO 'Customer' VALUES

stolzyboy

or to not confuse yourself with that crappy concatenation simply extract the post data and keep the vars inside the quotes, but single quote them like

<?
extract ($_POST);
$query = "INSERT INTO Customer VALUES ('', '$Name', '$Address', '$City State', '$Country', '$Email', '$Phone', '$Cell', '$Fax', '$Title', '$Picture', '$Signature', '$Link1', '$Link2', '$Link3', '$Link4', '$Comment', '$DistribNum', '$SponsorName', '$Package', '$Version', '$Design','','')";
?>

loureiro

Can somebody please nominate Stolzyboy for an award of some kind please! like a nobel prize or something! thanks a lot. Also thanks to jkohns. i did not know that! I had been using ' the entire time. I appreciate all your help in my ever increasing stupidity! thanks!

loureiro

$query = "SELECT customerID FROM Customer WHERE email='$_POST["Email"]'";

Parse error: parse error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING

sorry one last one! haha

jkohns

A case where trying to throw everything between double quotes isn't so friendly-

try this:

$query = "SELECT [/COLOR]customerID[COLOR=green] FROM [/COLOR]Customer[COLOR=green] WHERE [/COLOR]email[COLOR=green]='".$_POST['Email']."'";

stolzyboy

learn from your previous problems

<?
extract($_POST);
$query = "SELECT customerID FROM Customer WHERE email='$Email';";
?>

loureiro

im beggining to notice a trend here! haha. alright thanks a lot again guys. i appreciate it. i completely understand what i have to do now to get it to use a post variable! thanks!