Muncey

Thanks a lot! Will check out the link.

Both lol, you use the info between the bbcode. For example... [bbcode]test[/bbcode] Then $a = "www.randomsite.com/ ".$x Where $x = the data between the bbcode.. in this case it would be test. After that you take $a and gather the information from the url. So you'd find "Title:" and get the information after that...

Pull the data from another site. So when [album]____[/album] is put in the part inbetween the album brackets is taken and put into the url and then it takes the relevant data from the url. EG. [album]RandomName[/album] Would get data from www.albumsite.com/RandomName/ and it would then take the information from there.

Hi, was planning on making a bbcode and i wanted to know how to get data from a site. For example a site displays information about albums. Link example: albumsite.com/albumname/ Each album has it's own page but all the pages are layed out the same... for example: Artist: Name here Album Title: Title here Year: Year here ect. How do i pull the data out of artist/album title ect depending on what is put inbetween the bbcode. [album]albumname[/album] Hope that makes sense, Thanks in advanace.

Im confused, what do i store the date as?

Well i made it so when somebody clicks a certain button it logs the date in a database then it pulls it out when needed and matches it to todays date and if it matches it displays Today, instead of the date. Im trying to do the same thing but for Yesterday, so i need to match the date in the database to the date of yesterday. How do i find the date then take away a day? Im using date('F d, Y'); btw... i need to take a day away but im not sure how. Thanks in advance.

My bad, needed to add 30 on.

No problem now, i used an array instead and it got it fine.

Well im making a very basic forum system and i've got everything done and im just editing it making it gradually better. I have a topic table in the database with topic id and forum id (the id of the forum the topic is in). So i did a query "select forum id from topics where id = $_GET['id']" thats basically it... i echoed the result and got "Resource id #7" What does this mean? I thought it ment id = 7 but it's not, it's 2. I need the forum id it's in so i can match that id to the forum in the forums table so i can then retrieve the name of the forum and display it. Thanks in advance.

Unsure of what you mean, what exactly am i storing as a date type? Im inporting $date into the database under join_date... what do i need $date to equal in order to make the date display as something i can use for various things such as how many days been a member but also display join date as xx/xx/xx

So is that how it's done on this site? If so that's enough for me to go ahead with it. The thing im making is very basic and will be improved, im just thinking of a way that will work but not cause too many problems for now.

If i was to make a last active field in a members table in my database and had it update the field every page they went on, would this effect anything like speed? I was just thinking if say 100 people are using it at the same time and it's updating the database EVERYTIME someone clicks on a different part of the site, it may get a bit slow or something? Will this happen or is it fine to do this?

Basically im putting a join date into the database but i don't want it displayed as a date, i want it as pure numbers so that i can use it to work out things such as how long they've been a member, comments per day (by dividing the posts by how many days they've been a member) ect ect So whats the best way of putting that into the database? I have a vBulletin forum and looked in the database at what they had for the join date and i saw stuff like 112823... is that seconds or something? I also need to display the date as a real date xx/xx/xx so that must be possible aswell.

Im having some trouble with my mysql query, basically im trying to add a integer to a field called "group". I tried: $group = 6; and adding $group to the field $group = "6"; and adding it to the field also tried group)VALUES('6' but again im getting a syntax error. Any help please? Im pretty sure my field is set to an int so that shouldn't be the problem.

Never thought of that! Thanks a lot, i would also check for the -- which comments out the rest of the query.