Select after update...

[tcardoso]

Hi, I'm kind of noob in PHP...

I make several selects to a table, then I make one update and several selects again on the table...

The update seems to not commit, but if I put $sql->commit(); my execution of program dies there (like exit() or die())...

What should I do?

Thanks,
Telmo Cardoso

 

[jpadie]

you have not really given us much information.

commits are only relevant if your database server does not autocommit.

perhaps you could help us further by :

telling us what database you are using
sharing the schema if it is relevant
sharing your code.

 

[tcardoso]

My mistake...I was not doing things properly...

I didn't post the code because its huge sorry and thanks anyway

 

[vacunita]

You can post just the relevant section, in this case, just the part where you build the the update statement and send it to the DB. Still you haven't told us what DB you are using, and how your tables are set up.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[jpadie]

@vacunita

i read from the OP's reply that he had now sorted it out.

 

[vacunita]

I read that he was sorry for not posting the code, and that since it was so huge, he wasn't going to, but you may be right Jpadie, and hopefully he did resolve it.




----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[tcardoso]

I did resolve it... sorry for not being explicit enough

Thanks vacunita