nowork :(

drag0n

D0ne

jpmoriarty

easiest way to see is to echo out your sql instead of having it put into the db. then you can copy and paste that sql into your db front end and see why it's not playing properly. Usually find it's an enum field or a field that you've not allowed to be null, but you're trying to make it null, that sort of thing.

drag0n

i did as you told but still got nothing, it just goes into db as "0" rating and votes do not get updated which I think is the MAIN problem. Somebody please look at my code and see whats wrong/.

Daveyz1983

Originally posted by drag0n
i did as you told but still got nothing, it just goes into db as "0" rating and votes do not get updated which I think is the MAIN problem. Somebody please look at my code and see whats wrong/.

Before Updating the rating and vote in to the database,
echo $savevotes and rates, and see whats the value, if its equals to 0, there is a problem with your calculation algorithem.

I await your test and your answer.

drag0n

Yes I got 0s for rating but nothing for votes.

Daveyz1983

This will mean that it has nothing got to do with the last database update/insertion. What you do is to echo the variables after every calculation from the moment you extract it from the database.

This will allow you to trouble shoot and know where the errors comes from..

e.g.

$sandy = $tommy + $andy;
echo $sandy;

$yoshi = $sandy $tommy $andy;
echo $yoshi;

and you trouble shoot from there.

drag0n

Yea it was a calculation error, I was doing way too much at once. I fixed it, thanks

Daveyz1983

So u've spot the error? Congrats 🙂