call mysql code into php ?

[ejwf]

I have a mysql code to create new records in a database using @ as MySQL Variable flag........
This won't run as it stands in a php file, how do I call it in to a php code?
I want to run a php query then do something like a foreach statement that will run the mysql code foreach variable in the loop.......
any ideas?

[devinemke]

don't really undersdtand your question. mySQL queries can be excuted by using the [man]mysql_query[/man] function.

[ejwf]

thanks for your reply....
I should explain this a bit better ....

the mysql code I have is
SELECT
@ci:=tblConces.ConcesId,
@ed:=tblDateLog.EndDate,
@oe:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefOpenEarly DAY),
@di:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefDataIn DAY ),
@fr:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefFirstRemind DAY),
@sr:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefFirstRemind+tblConces.DefSecondRemind DAY),
@wf:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefFirstRemind+tblConces.DefSecondRemind+tblConces.DefWarningFlag DAY)
FROM
tblDateLog LEFT JOIN tblConces
ON tblDateLog.ConcesRef = tblConces.ConcesId
WHERE ConcesId = $Ref;
// I am hoping to set $Ref in a query earlier in the code

INSERT INTO tblDateLog ( ConcesRef, EndDate, OpenEarly, DataDueIn, FirstRemind, SecondRemind, WarningFlag )
VALUES (@ci, @ed, @oe, @di, @fr, @sr, @wf);

I want to put this in a FOREACH statment like;

$Query = "SELECT ConcesRef FROM tblDateLog";
$Result = mysql_query($Query);
WHILE ($row = mysql_fetch_array($Result))
$ConcesRef[] = $row["ConcesRef"];

FOREACH ($ConcesRef as $Ref)
{
SELECT
  @ci:=tblConces.ConcesId,
  @ed:=tblDateLog.EndDate, 
  @oe:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefOpenEarly DAY),
  @di:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefDataIn DAY ),
  @fr:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefFirstRemind DAY),
  @sr:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefFirstRemind+tblConces.DefSecondRemind DAY),
  @wf:=Date_Add(tblDateLog.EndDate, INTERVAL tblConces.DefFirstRemind+tblConces.DefSecondRemind+tblConces.DefWarningFlag DAY)
FROM
  tblDateLog LEFT JOIN tblConces 
  ON tblDateLog.ConcesRef = tblConces.ConcesId
WHERE ConcesId = $Ref;


INSERT INTO tblDateLog ( ConcesRef, EndDate, OpenEarly, DataDueIn,
                         FirstRemind, SecondRemind, WarningFlag )
VALUES (@ci, @ed, @oe, @di, @fr, @sr, @wf);
};

but if I run this I get
parse error, unexpected '@' for the line
@ci:=tblConces.ConcesId,

any ideas?

[ultk]

Looks like you're trying to use the built in procedural language of your DB.

Your best bet is to remove the @ci:= etc parts from your SELECT.

You will also need to split the insert apart from the SELECT.

Are you sure your database is MYSQL? Looks pretty bizarre to me but then again I don't do much in the console.

I think you'd do well to read the php manual for mysql functions and view some of the examples there.

http://www.php.net/manual/en/ref.mysql.php