[thelist] mysql help

[Mark Mckee]

Thanks BIll, i will give that a go.

i obviously need to be able to edit these categories and links within 
the database incase of incorrect entry etc.

I have tried setting up an edit page, but I am having real trouble. I 
dont know where I am going wrong. I have spent the night trying 
different methods and searching google to no avail.

can anyone point me int he right direction to get info on how to edit, 
update and delete rows in mysql, i just really do not seem to be getting 
it at all.


Bill Moseley wrote:
> On Mon, Oct 02, 2006 at 01:18:08AM +0100, Mark Mckee wrote:
>   
>> hi
>>
>> how can i thank you enough. iw as toying with the idea of having a 
>> second sql statement but had no idea how to implement it
>>     
>
> Mark, I'd just "select * from info order by category, title" then in a
> loop watch for a change in category and print a new heading.
>
>
> Overkill, but maybe you need two tables?  One for category and one for
> links?  Then in (fake) code that abstracts your tables and knows the
> relationships between the tables you do:
>
>     for $cat in $category->select_all;
>         print $cat;
>         for $link in $cat->links {
>             print $link;
>         }
>     }
>
>