using maths in sql? - Codewalkers

Codewalkers Forums Sponsor:

March 29th, 2004, 11:01 AM

treelo

Contributing User

Join Date: Apr 2007

Posts: 121

Time spent in forums: 28 m 39 sec
Reputation Power: 2

using maths in sql?

can anyone tell me how to type this code up, ive been given the advice that this should work but it doesnt

php Code:

Original - php Code
$winner = "UPDATE predictions SET points = '05' WHERE winner = '". $row['winner'] ."' AND result = '".$row['result'] ."' AND round = '".$row['round'] ."' +01 AND fight_id = 'fight2'";

$winner = "UPDATE predictions SET points = '05' WHERE  winner = '". $row['winner'] ."' AND result = '".$row['result'] ."' AND round = '".$row['round'] ."' +01 AND fight_id = 'fight2'";

its the "round = '".$row['round'] ."' +01" that im looking at fixing as it doesnt work in its current state

anyone know if this is possible?

March 29th, 2004, 12:29 PM

Blindeddie

Join Date: Apr 2007

Location: NJ - USA

Posts: 2,152

Time spent in forums: < 1 sec
Reputation Power: 4

RE: using maths in sql?

do you get any kind of error?

March 29th, 2004, 12:32 PM

treelo

Contributing User

Join Date: Apr 2007

Posts: 121

Time spent in forums: 28 m 39 sec
Reputation Power: 2

RE: using maths in sql?

i found out what was wrong sorry

i had several statements but didnt run each one so my code was only running the very last one

Viewing: Codewalkers Forums > Other Technologies > Database Help > using maths in sql?

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump