Adding points to an existing accout???

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

Post by Joe »

No the points are way below the limit...
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

then there is somehting wrong wiht your code.. post the code your using there
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post by tim »

if your going to use that type of set-up

try $row = mysql_fetch_assoc($result);

to

$row = mysql_fetch_array($result);
User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

Post by Joe »

Hey tim thanks a lot. That worked great. I never even thought!

Cheers


Joe 8)
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post by tim »

Illusionist wrote:then there is somehting wrong wiht your code.. post the code your using there
if you was indeed refering to me, your incorrect. the code I showed you was basically it. theres another SQL statement but that only get the number to display on the field... the update code I showed was inside a generic if statement that deals nothing with the process.

my table (counter) consist of only one column (count) and has a BIGINT attritube. I can use /set count = count+100 and it works

I can set it to whatever, so maybe my generic single table or somehting has a fault/whatever but it works for me...

/not trying to argue with you again so i'm going to end this discussion with this post. your regular expression link was helpful too btw, kudos for that
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

uhhh... im kinf od confused as to what your talking about... but... no i was talking about his code not adding the points. And ur welcome for the regexp link!
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post by tim »

Joe wrote:Hey tim thanks a lot. That worked great. I never even thought!

Cheers


Joe 8)

no problem, mysql_fetch_assoc only retrieves associative arrays, mysql_fetch_array retrieves both associative array and number indicies(what you need)
if u cared to see why it didnt work.
Post Reply