Basic Sorts - How do you group items using id tag? Newbie Kickstart

Greetings - I am a absolute newbie to PHP/MySQL and would appreciate kickstart help

I have attempted tutorial at DMX Zone but failed without success.

See http://www.dmxzone.com/showDetail.as...=2&NewsId=4937

Basic Setup:

Database: MySQL
id Name
0 Fruit
1 Banana
1 Pineapple
1 Kiwi Fruit
1 Apples
0 Vegetable
6 Tomatoes
6 Peas
6 Carrots


Output required:
Fruit
Apples
Banana
Kiwi Fruit
Pineapple
Vegetable
Carrots
Peas
Tomatoes

Requirement:
Depending on designated id, all items starting with 0 become bold category headings listed in alphbetical order and all associated products matching that category would be listed - also in alphabetical order.

A working code sample - or suggested tutorial sites would be greatfully received

Thanks in anticipation

Bless ya heaps

AceTutor

PS. I'm using Dreamweaver 8 / PHP / MySQL (latest versions)

You are looking for basic PHP database articles?

Are you specifically looking for dreamweaver tutorials?

Thing is with dreamweaver, is that it generally does everything for you.... you never learn what is going on in the code.... you never learn php... in short, you never learn.

If this is acceptable, then I'm sure there are some basic tutorials around for dreamweaver.... but having never used dreamweaver, or any other tool that automates development, I wouldnt know. I'm sure others will have examples for you.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

You made this identical post in this forum back on the 31st Jul. Did you not like the response first time round?

Sorry if I have caused offence - the Forum software deleted my thread - in fact has deleted it twice - all replies were lost - my beef was losing it all so reposted again at the commendation of Rob Collyer.

Rob has no idea why the threads were broken - but everything deleted twice within 14 days - it had me wondering.

If you had given me a solution - thanks - but I would be most greatful if you would do it once again. Without a history in the forum I have nothing to refer to. What would be appreciated is a "working solution".

I trust no one else has suffered with the following message

That was in 31 July 2006 - then yesterday I get this:


I believe the "SERVER" behind this Forum is starting to get like the humans it controls.

Is this not a Cyber form of prejudice based on NAME and AGE. Next it will be race or religion.

Now that's said - I'm still a happy chappy

Thanks for your patience.

Spot ya soon!

Looking at the above PM messages, it now makes sense.

The thread was initially deleted (where it gets dumped in a trash area)

The second PM was received once the thread was finally emptied from trash.

I cant remember your post first time round, but obviously it was deleted by a moderator if you received a PM.

9 times out of ten, posts are deleted when they contain blatant adverts or general spam. I'm sure if this thread is kept free from both, then this wont happen again.

Anyway, to get back on topic...

BTW: We help, advice and teach people here.... I'm sure no-one will physically provide a working solution.... if they do, then you learn what exactly?
Others here may help you to help yourself and push you down the right road..... but the chances of them actually doing this in it's entirety for you is vastly remote...... it's not what we do.... it's not what we're about.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

Regardless I am still hanging in here waiting . . .

Your stated objective in your home page masthead makes it very clear that "our" Forum is about:


I look forward to any offered solutions. I don't have a copy to the response that UKGEOFF comments about, above.

If folks would kindly review the original tutorial on DMXZone and care to check it out - they could confirm its validity or otherwise. That is why I would appreciate a working example. That is why I posted the request in the first instance.


Thanks Rob for starting to see why the thread possibly disappeared.

The original deletion PM to me was made by
sypher
Elite Veteran

-----
Thread: Basic Sorts - How to group items using id tag?
Forum: PHP Forum
Reason: looking at your name, this is an advertisement
-----

Please check further - I am not impressed at the way this was handled. I would like to reveal the sequel to the above. Knowing now that the thread was in trash and could have been redemned when I made my appeal doesn't add up.

Sypher suggesting I repost changing wording to avoid the perception of me advertising just doesn't add up. Ace Tutor can't be that threatening as an alias.

I am sure your moderators are people of integrity!

Happy digging.

. . . and thanks

suggested php learning, ill tell you how i learned php. I read a simple tutorial and tried the things out, Echo, $, If/Elseif/Else, Function
Then i got the codes for pulling from a Mysql Database and putting into a mysql database from my friend. Since then ive just fidgeted with that and any code i can find on this page.
http://www.php.net/quickref.php
for example
MD5()
if your putting a username password into a database youll want to do something like this
$username = "Jack";
$password = "Jakie";
$encpassword = md5($password);
then a mysql query, insert into... ect.
that page tells you how to use each code, so i learned many commands that way

the other thing that helped was that i slaved over setting up my own php/mysql server, even though it took me about 6 hours, it was worth the haul, im so glad i have the server to experiment and learn on.

__________________
www.MonsterCoding.com - Website Programming and Development Services

Moderators come and go....
Some leave freely, some are *fired* as it were....

Not all moderator decisions reflect the general site or global moderator consensus. When you believe an unfair judgement has been made, thats what I'm here for. If no-one brings anything to my attention, I cannot act..... I cannot possibly read every post here personally.

Anyway, yes... the motto of this site and what we are about is to answer general web design and development questions.... and to advise and teach.

This DOES NOT mean, people can ask,

'How do I make a website like Amazon.co.uk..... can I have a working example please?'

People donate their time here.... we are all unpaid. We will only help you to help yourself.

In that respect, please post your code that you have done (attempted) so far.... and let us know WHERE it is going wrong, or what isnt working..... we can help you from there. If you have made zero attempt at this yourself and want us to just make it for you, then you are truly at the wrong site.... in that senario, you will need to part with some cash and visit rentacoder or something similiar.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder