This topic is locked

my code !

10/26/2010 4:00:31 AM
PHPRunner General questions
A
all3ssaf author

hi can you see my code
$SQL="UPDATE table1 SET NO=NO+'1'";

$rcx=CustomQuery($SQL);

return true;
this event in (print page : after record processed)
whit i want is :
When I select to print, I want to add no. ( 1 ) in the NO Field i Chosen to print not in all <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=15583&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />

A
ann 10/26/2010

Ahmad,
I'm not sure that I fully understand your problem.

Could you re-phrase it or describe more detailed what do you want to do in the event?

A
all3ssaf author 10/31/2010



Ahmad,
I'm not sure that I fully understand your problem.

Could you re-phrase it or describe more detailed what do you want to do in the event?


hi When i add this code to event in (print page : after record processed) .

**

$SQL="UPDATE table1 SET NO=NO+'1'";

$rcx=CustomQuery($SQL);

return true;

**
When I set a certain part of the table so I do print, this code adding 1 to each table in (NO) <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=54055&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
I want the code by adding 1 to the selected portion of the print only, not to all the table

kujox 10/31/2010



hi When i add this code to event in (print page : after record processed) .

**

$SQL="UPDATE table1 SET NO=NO+'1'";

$rcx=CustomQuery($SQL);

return true;

**
When I set a certain part of the table so I do print, this code adding 1 to each table in (NO) <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=54056&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
I want the code by adding 1 to the selected portion of the print only, not to all the table


Are you wanting to count the number of times that page is printed?
If you are then you may need to add a where condition on the end of the custom sql statement



UPDATE table1 SET NO=NO+1 WHERE MyID=123

A
all3ssaf author 10/31/2010



Are you wanting to count the number of times that page is printed?
If you are then you may need to add a where condition on the end of the custom sql statement



UPDATE table1 SET NO=NO+1 WHERE MyID=123



I want to be in automatic,when I Make a selection to print a line

automatic NO.1 is added to the selected portion of the printing
My problem is here



WHERE MyID=؟؟؟؟؟



What type instead of question marks, in order to know the selection location <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=54057&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />

kujox 10/31/2010



I want to be in automatic,when I Make a selection to print a line

automatic NO.1 is added to the selected portion of the printing
My problem is here



WHERE MyID=؟؟؟؟؟



What type instead of question marks, in order to know the selection location <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=54070&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />


The question marks should be your selected record number($data['Primary_Key']) and MyID should be the primary key. Can you post the record layout so I can see the unique field.

A
all3ssaf author 11/6/2010



The question marks should be your selected record number($data['Primary_Key']) and MyID should be the primary key. Can you post the record layout so I can see the unique field.


SELECT

ID,

NAME,

NO

FROM table1
and my Primary Key is (ID)