help please

[spearchilduser]

im trying to get it so that if a user accepts a job then some details from one tbale get inserted into nother table so a tracker can activate

the code im using is :

mysql_query("SELECT User_ID,User_Longitude,User_Latitude  INTO user_location FROM quotes) or die (mysql_error));

 

but im know its not of the correct format as im putting it in :

 

if($sql)
$msg = "Taxi Accepted sucessfully.";
      mysql_query("SELECT User_ID,User_Longitude,User_Latitude  INTO user_location FROM quotes) or die (mysql_error());
else
$msg = "Taxi not Accepted sucssfully try again.";
echo "$msg";

[smerny]

you have no brackets around your if and else blocks... ie: if(conditional) { block } else { block }

[spearchilduser]

if($sql)

{

      $msg = "Taxi Accepted sucessfully.";

      mysql_query("SELECT User_ID,User_Longitude,User_Latitude  INTO user_location FROM quotes) or die (mysql_error());

}

      else

      {

$msg = "Taxi not Accepted sucssfully try again.";

echo "$msg";

      }

still not working

[samshel]

Check this.

 

http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-select-into-table.html

[spearchilduser]

doesnt really explain the probelm with my statement thanks so

 

[premiso]

doesnt really explain the probelm with my statement thanks so

 

 

Actually it does. Read the syntax and read the page. MySQL does not support "SELECT INTO" sybase syntax, instead it is

 

INSERT INTO table_name (col1, col2) SELECT somecol1, somecol2 FROM table_name WHERE ....

 

If you are going to ask for help, actually look at the answers given before dismissing them.

 

So your statement, which was missing an ending quote should be from this:

mysql_query("SELECT User_ID,User_Longitude,User_Latitude  INTO user_location FROM quotes) or die (mysql_error));

 

To:

mysql_query("INSERT INTO user_location (id, longit, lat) SELECT User_ID,User_Longitude,User_Latitude FROM quotes") or die (mysql_error()));

 

You will need to change "id, longit, lat" to be what column names that data needs to go into.

[spearchilduser]

i appolosie im tired and didnt see the difference in my statement and the statement shown on the link so thank you