Structuring SQL
Posted: Fri Jul 21, 2006 3:33 am
Pimptastic | Please use
The values of the variables are
the sql that is echoed to the page is
Hope someone can help
Many Thanks
Jamie
Pimptastic | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Hi all,
Im having a bit of a problem structuring an sql update query.
the code I am trying to use is listed belowCode: Select all
$sql_quest = 'UPDATE `tblChart` SET `Score` = '.$avg.' WHERE `Question` ='.$QuestCR.'';Code: Select all
$avg = 4.77;
$QuestCR = Q1;Code: Select all
UPDATE tblChart SET Score = '4.77' WHERE Question ='Q1'Many Thanks
Jamie
Pimptastic | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]