volunteers?

I am working on a project that is beyond my mysql/php knowledge... I'd welcome if someone would volunteer for programming php scripts for it... there are no deadlines, it's only a just for fun project.. anyone?

What kind of project? I might be interested. My current project leaves my hands soon, so I will be bored here... (college student stuck on campus)

The aim is to create a working semantic directory with tons of free services. All links in the db (mysql) will have xml elements to
identify data (for example, if you search for 1960, 1960 can mean the number 1960 or the year 1960. Search engines cant recognise the difference, xml tags <year>1960</year> and <number>1960</number> will help them.) You probably know that but one can never be too sure:-)

For this, I need some cool ideas on how to create sql queries, esp. data sorting is quite important:

and this is the 1st problem to solve:

say I got a table "test" with columns "Row" and "Text". For example

Row | Text
---------------------------------------------------
1 | blablabla <order>2</order> blabla
2 | hladdbla <order>1</order> haaabla
3 | alablabla <order>3</order> dblabla

Now what I need is to sort this table by the numbers inside the <order> tags. The result should be: row 2, 1, 3

I things like tried

SELECT * FROM `test` ORDER BY text='<order>%</order>'

without results. If you find out let me know:-)

As for the services... the site should offer free services integrated in one control area (free e-mail, blog, toplist, counter, etc.).
Custom written scripts doing the following will have to be written...

- usenet server monitoring script (not so easy)
- secure members area script (hard)
- links editing script (hard)
- mass email sending script (not so easy)
- links checking script (easy)
- blog script (easy)
- toplist + random link script (easy)
- counter (not so easy) (someone works on this already)
- irc server monitoring script (easy)
- irc data searchnig script (hard)
- personal ads design and script (not so easy)
- forums (not so easy)
- message board (easy)
- guestbook (easy)
- p2p networks monitoring script
- whois

(these scripts will be added as "modules" to the members area). All has to be custom-written to cooperate. The scrpits can be based on existing codes but has to be able to cooperate with the rest (will send details for each script) but should be free for commercial use if the whole thing should really start to work one day.

If you'd be able/willing to write any of these, just drop me a line.. thanks:-)

This seems a full on script. Im not sure how many volunteers your gonna get without any sort of payment.

Well I don't expect that someone would code the whole thing for me. I am programming the scripts as well, but being a single person, it takes lots of time. But every kind of help, every piece of code that takes the work of me is a blessing:-)

Contact me. I have some ideas.

--
Nakul Goyal
SEO, SEP, SEM Expert

Qualifications *** Master in Science (Information Technology), *** Bachelors in Computer Applications, MCP, *** Brainbench 'Most Valuable Professional', *** Brainbench Certified Internet Professional, *** Certified Internet Webmaster Associate.

Available to discuss via AOL, ICQ, MSN and Yahoo !! PM me for more info.