Register Members List Search Today's Posts Mark Forums Read

Closed Thread
 
Thread Tools
  #1  
Old 11 Feb 2002, 18:17
RogueFrequency RogueFrequency is offline
 
Join Date: Feb 2002
Newreply.php help

On the forum I help run, I would like to have user groups AND user status based on post counts. So a person might be a member of a group called "Abc Def" and might have 304 posts making them a "Xyz".

------------------------
Username
Member of Abc Def
Xyz

Avatar stuff

304
------------------------

There is only 1 $usertitle that is shared by groups and post count user status.
I tried to add a new value into:
$DB_site->query("INSERT INTO post (postid...
But I got the error of unknown colume and stuff. Where are they defined?
  #2  
Old 11 Feb 2002, 19:32
Chen's Avatar
Chen Chen is offline
 
Join Date: Sep 2001
RogueFrequency, please go to this page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.
__________________
Chen Avinadav
Formerly vBulletin.org Owner and Founder

chen@avinadav.com
  #3  
Old 11 Feb 2002, 19:50
RogueFrequency RogueFrequency is offline
 
Join Date: Feb 2002
I'm not licensed, I HELP run the forum. Does this mean you can't help me?
  #4  
Old 11 Feb 2002, 20:06
FWC's Avatar
FWC FWC is offline
 
Join Date: Oct 2001
Originally posted by RogueFrequency
I'm not licensed, I HELP run the forum. Does this mean you can't help me?
Have the owner of the license enter your name of the page FireFly gave you. You won't get any help until your name is there.
__________________
FWC
F5 Hosting
White Sox Interactive Forums
  #5  
Old 11 Feb 2002, 20:36
RogueFrequency RogueFrequency is offline
 
Join Date: Feb 2002
Alright can you just answer one question until I can get a hold of him and get the license info?

What is the difference in
$DB_site->query("INSERT INTO user... and
$DB_site->query("UPDATE user... ?
  #6  
Old 11 Feb 2002, 20:55
Mark Hensler's Avatar
Mark Hensler Mark Hensler is offline
 
Join Date: Oct 2001
Just like it sounds....

an UPDATE query updates an existing record
an INSERT query puts a new record into the DB

But then... you get stuff like UPDATE INTO.
  #7  
Old 11 Feb 2002, 21:12
RogueFrequency RogueFrequency is offline
 
Join Date: Feb 2002
I knew that What I meant was if I use INSERT on xyz when xyz is already there, then it overrights it or replaces it?
BTW, I got in contact with my friend (the license owner) and he said he would put it on the site under my name tonight.
  #8  
Old 12 Feb 2002, 03:46
Mark Hensler's Avatar
Mark Hensler Mark Hensler is offline
 
Join Date: Oct 2001
INSERT will never overwrite. It will either insert a new record, or give an error.
  #9  
Old 12 Feb 2002, 03:56
RogueFrequency RogueFrequency is offline
 
Join Date: Feb 2002
I'm crossing my fingers that the way to get around that isn't extremely complicated, but I won't ask any more questions until I get the licence.
  #10  
Old 12 Feb 2002, 10:51
Chen's Avatar
Chen Chen is offline
 
Join Date: Sep 2001
Then you could ask this in the appropriate forum. See ya there.
__________________
Chen Avinadav
Formerly vBulletin.org Owner and Founder

chen@avinadav.com
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 03:35.

Layout Options | Width: Wide Color: