Miles,
Being a net admin is an advantage you have. You know how to design databases and keep them running. :-D I too am a database administrator both in MSSQL and MySQL. Two different worlds eh? 😉 Ok... so your trying to think of how to hold all that information? One way you can do it is to create a database that will hold a common field (like the users ID number) and then everytime they add something it will track them that way. OR you could just put everything into a ; divided list. Such as your field in your database would have:
item1;item2;item3;
That is cool ... return that variable and check this little script out.
<?php
// Place field name here: :)
// Take your string and make it into an array, cutting it apart at the ;'s
$product_array = explode(";",$field_returned);
// Now display each part of the array as it's own variable. Uses foreach to do that. Easiest way possible.
foreach ($product_array as $temp_product)
{
// Display the product name.
echo "$temp_product<br>";
}
?>
OUTPUT TO BROWSER:
item1
item2
item3
I think I got your question answered for ya. If not post again. :-D
Chad
