Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Newbie can't see the forest

by Malach (Scribe)
on Mar 06, 2002 at 20:16 UTC ( [id://149823]=note: print w/replies, xml ) Need Help??


in reply to Newbie can't see the forest

As a rule, if you provide some sample code, people will be a lot happier to help you (it shows you've put some work in yourself, and you're not getting other people to do it for you).

(And, if you do provide code, you really have to use strict; and use warnings; and (in this case) use CGI;, otherwise you tend to get jumped on.)

Looking at your question, I'm not entirely sure about your database structure, and how it ties in to the sample table.

It looks to me like you need to select it_ID, it_Name from items, and then loop inside that (with a while loop) selecting user_ID from (table name) where it_ID = (the result from the earlier query), and if you get a non-zero result, display the "click here for" link with a link to the history page.

I could be more clear, with code examples, but to be honest it's too early in the morning for me, and I haven't had a coffee yet :)

Hope that helps.

--
Malach
So, this baby seal walks into a club.....

Replies are listed 'Best First'.
Re: Re: Newbie can't see the forest
by Anonymous Monk on Mar 06, 2002 at 20:29 UTC
    As a rule, if you provide some sample code, people will be a lot happier to help you (it shows you've put some work in yourself, and you're not getting other people to do it for you).

    I'll try and not take offense, I've been busting my butt on this problem.

    I left out the code to keep it simple. It has to be a SQL problem and I thought that since the use of SQL in Perl programming is used so much, that there would be many Perl programmers with good SQL experience.

    (holding his tounge)

    thanks for your helpful advice (!)

      If you took offence, I'm sorry, it wasn't my intent to cause it.

      It's somewhat of a canon around here that posting code shows that you're actually working on the problem, and honestly stuck rather than lazy (or trying to get people to do your homework for you). Please note that I'm not suggesting that you're doing this, I'm just letting you know what seems to be considered standard here.

      Glad that someone could provide more help than I could at that time of the morning :)

      --
      Malach
      So, this baby seal walks into a club...

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://149823]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (2)
As of 2024-07-16 06:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.