MYSQL SINTAX

[jenniferG]

In the below  code,  the varfiable $INSERTINDEX is  fine,

but this query gives an error saying the query is empty

 

$INSERTINDEX=mysql_insert_id($conn);

$INDEXB=$INSERTINDX+$INDBASE;

$UPDATE_QUERY="UPDATE TABLE SIREQUESTTABLE

    SET INDEXB ='$INDEXB'

    WHERE INDEXA= '$INSERTINDEX'";

 

Thanks,

Jennifer

[AndyB]

$UPDATE_QUERY="UPDATE SIREQUESTTABLE

    SET INDEXB ='$INDEXB'

    WHERE INDEXA= '$INSERTINDEX'";

 

seems more rational.