Clan Adverts

Sponsors

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme
Mech Warrior Online Xtreme Theme

User Box

Anonymous
38.107.179.220
Nickname:

Password:

Security Code
Security Code
Type Security Code


PND Downloads Feed

Phpnuke Downloads
How to Delete or Reset yo...
How to Delete or Reset your PHPNuke Admin Account
Lost your admin password ?  Cant login to your admin account ? This s...
Back Online & Stuff
Back Online & Stuff
Look at us with our nifty website back up and running… Seriously...
How to edit the admins in...
How to edit the admins in the forums
Here is a way to make someone admin in your forums on your Evo site. I...
Demo Splash Screen
Demo Splash Screen
Ped @ Clan Themes has released a simple splash screen entrance hack. ...
Free Phpnuke Business The...
Free Phpnuke Business Theme 6
This is the 6th Business theme for Phpnuke that Clan Themes has releas...
Tricked Out Slider
Tricked Out Slider
We have seen some great new things come out of Tricked Out News and th...

Custom Work

PHP Nuke Custom Work

www.clanthemes.com :: View topic - Sql update statement help..
Sql update statement help..

1 Replies / 1090 Views
Post new topic   Reply to topic  

   www.clanthemes.com Forum Index » General PhpNuke

View previous topic :: View next topic

crushedsouls
Reputation: 41.7 Add RepSubtract Rep
Local time: 12:00 PM

uk.gif

 Tree Hugger
Tree Hugger

0.04 posts per day
Medals: 0
Joined: Jan 12, 2008
Last Visit: 01 Jul 2011
Posts: 71
Points: 2545 
Post Sql update statement help.. Posted: Fri Aug 01, 2008 2:35 pm
Shop Purchases:Topsites Manager V1 PhpNuke Module
Ok so im building a little update for the Challenge_Form_Module in your downloads database...

However this is my first module that will use SQL statments, so far all is going well with the help of Untergang.

i am currently on the update part of the admin section, and as of yet i have this for the SQL Update line

$db->sql_query("UPDATE ".$prefix."_chusmodsettings SET logo='$logo' WHERE logo='$logo1'");

this works fine

However i need to update about 5 rows on the database, this is what i am trying

$db->sql_query("UPDATE ".$prefix."_chusmodsettings SET logo='$logo', lwidth='$logow' WHERE logo='$logo1', lwidth='$logowi'");

This is screwed

can anyone help me please

Thanks loads
 

 
View user's profileSend private messageVisit poster's website Reply with quote

crushedsouls
Reputation: 41.7 Add RepSubtract Rep
Local time: 12:00 PM

uk.gif

 Tree Hugger
Tree Hugger

0.04 posts per day
Medals: 0
Joined: Jan 12, 2008
Last Visit: 01 Jul 2011
Posts: 71
Points: 2545 
Post Re: Sql update statement help.. Posted: Fri Aug 01, 2008 9:21 pm
Shop Purchases:Topsites Manager V1 PhpNuke Module
Not to worry i worked it out

$db->sql_query("UPDATE ".$prefix."_chusmodsettings SET logo='$logo', lwidth='$logow' WHERE logo='$logo1'");
 

 
View user's profileSend private messageVisit poster's website Reply with quote
Post new topic   Reply to topic  
   www.clanthemes.com Forum Index » General PhpNuke


 
1 Replies / 1090 Views
Page 1 of 1
All times are GMT
Display posts from previous:   
 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
 

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke