Click here to Skip to main content
15,891,248 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
GeneralRe: Django trouble Pin
rastaVnuce23-Mar-10 4:41
rastaVnuce23-Mar-10 4:41 
GeneralRe: Django trouble Pin
Chris Austin23-Mar-10 4:47
Chris Austin23-Mar-10 4:47 
GeneralRe: Django trouble Pin
rastaVnuce23-Mar-10 5:00
rastaVnuce23-Mar-10 5:00 
Questioninfinite loop while using php's dir object..? Pin
cjoki19-Mar-10 11:31
cjoki19-Mar-10 11:31 
AnswerRe: infinite loop while using php's dir object..? Pin
chevu28-Mar-10 23:28
chevu28-Mar-10 23:28 
GeneralRe: infinite loop while using php's dir object..? Pin
cjoki29-Mar-10 4:53
cjoki29-Mar-10 4:53 
GeneralRe: infinite loop while using php's dir object..? Pin
chevu29-Mar-10 19:04
chevu29-Mar-10 19:04 
Questionquery help with table that has no primary keys Pin
scorpio2219-Mar-10 10:26
scorpio2219-Mar-10 10:26 
hello guys, i have a problem with a query.
I have a table actions which has no primary key. any one particular record can be identified by the combination of actionID, taskID and ProjectID which are the other fields in actions table.
Here is an example of the possible situations of entries in the actions table(so that you get an idea of what i am talking about)

ActionID 1 for taskID 1 of ProjectID 10-000
ActionID 2 for taskID 1 of ProjectID 10-000
ActionID 1 for taskID 2 of ProjectID 10-000
ActionID 1 for taskID 2 of ProjectID 10-001
ActionID 2 for taskID 2 of ProjectID 10-001
ActionID 3 for taskID 1 of ProjectID 10-000
ActionID 1 for taskID 1 of ProjectID 10-002
ActionID 1 for taskID 2 of ProjectID 10-003

When i am creating a new action for taskID 1 of ProjectID 10-000, then what i am doing is i am scanning the all the ActionIDs of the taskID 1 of ProjectID 10-000, ordered by ActionID and incrementing the last obtained ActionID by 1 to generate a new ActionID for the new action.

Now suppose the entries of ActionID for taskID 1 of ProjectID 10-000 in the database are 1,2,5,6,8,10,15,16, then according to my logic, the newly generated ActionID would be 17, but that is not what i want. I want the newly generated ActionID to be 3, because 3 is not present in the ActionID field of taskID 1 of ProjectID 10-000 combination .

In the above example, if i delete ActionID 2 for taskID 1 of ProjectID 10-000 and then when a new action is added to the same combination of taskID and ProjectID, i want the newly generated ActionID to be 2 and not 4 which is what i am getting from my logic.

Can anyone help me with this???
AnswerRe: query help with table that has no primary keys Pin
PHP_Guy22-Mar-10 11:01
PHP_Guy22-Mar-10 11:01 
QuestionCreating project setup Pin
sarang_k17-Mar-10 18:36
sarang_k17-Mar-10 18:36 
AnswerRe: Creating project setup Pin
PHP_Guy19-Mar-10 7:24
PHP_Guy19-Mar-10 7:24 
QuestionExporting HTML file to PDF format Pin
sarang_k11-Mar-10 22:47
sarang_k11-Mar-10 22:47 
AnswerRe: Exporting HTML file to PDF format Pin
Niall Barr11-Mar-10 23:07
professionalNiall Barr11-Mar-10 23:07 
QuestionUse PEAR's datagrid export to an excel sheet, but getting all unrecognized characters [modified] Pin
alexyxj11-Mar-10 8:44
alexyxj11-Mar-10 8:44 
QuestionStored Procedure with Php and MySQL Pin
scorpio2211-Mar-10 5:19
scorpio2211-Mar-10 5:19 
AnswerRe: Stored Procedure with Php and MySQL Pin
PHP_Guy19-Mar-10 7:46
PHP_Guy19-Mar-10 7:46 
GeneralRe: Stored Procedure with Php and MySQL Pin
scorpio2222-Mar-10 4:25
scorpio2222-Mar-10 4:25 
GeneralRe: Stored Procedure with Php and MySQL Pin
PHP_Guy22-Mar-10 10:44
PHP_Guy22-Mar-10 10:44 
GeneralRe: Stored Procedure with Php and MySQL Pin
scorpio2222-Mar-10 10:56
scorpio2222-Mar-10 10:56 
GeneralRe: Stored Procedure with Php and MySQL Pin
PHP_Guy22-Mar-10 11:21
PHP_Guy22-Mar-10 11:21 
GeneralRe: Stored Procedure with Php and MySQL Pin
scorpio2223-Mar-10 3:44
scorpio2223-Mar-10 3:44 
Questionphp - include_once Pin
thes3cr3t16-Mar-10 22:39
thes3cr3t16-Mar-10 22:39 
AnswerRe: php - include_once Pin
chevu7-Mar-10 22:37
chevu7-Mar-10 22:37 
AnswerRe: php - include_once Pin
PHP_Guy19-Mar-10 7:51
PHP_Guy19-Mar-10 7:51 
QuestionOrganize mysql results in html table with PHP Pin
pelikan20026-Mar-10 14:15
pelikan20026-Mar-10 14:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.