«

Hello and Good Morning,

I'll try to be as exact as possibl to what iam trying to do:

Today i decided to change entirely my index.pl page and template and to
create a new one.
I will no longer presentate religious scripts from my webpage but i
think its a good idea to create a webpage
that will show up a list of movies that i do have from the current drop
down menu that i already have or better just
tweak the already games.pl script to a movies.pl script that would
presentate the movies as it now have presentated the
games.

Users have to signup first and their username and password will be
stored in a mysql users database and then everytime
they visit my webpage they would have to log in first and after that
they are ready to view and select movies from
a dropdown menu and add them to a basket or something.

Then they will hit "done" and their selection would be stored in a mysql
order database that will have some connection
to the users database table.

Then if they want to see what they ordered they could be able to press a
"show what i ordered" button and then that will
be presenatte to them. I currently have a show.pl so that too is almost
ready except that its a cgi one and needs
converting to a template.

Will you please help me make the appropriate tweaks to the already
created scripts to implement that.
Iam trying too but unfortunately iam no expert.

Thank you.

ps. iam trying now to chnage the column names from games and otehr
database tables to more appropriate ones.



Do you agree with those names of the database tables and the columns in
it to what i want to do? Dis i pick them correctly?

I tried the names to be as much self-explanatory as i can:

$dbh->do( "CREATE DATABASE user (username text, password text, name
text, surname text, address text, phone text, mail text)" );
$dbh->do( "CREATE DATABASE userselect (username text auto_increment
primary key, moviename text" ) or die $!;
$dbh->do( "CREATE DATABASE userdesire (title text, remark text, mail
text, date text, host text )" ) or die $!;
$dbh->do( "CREATE DATABASE movies (moviename text, moviedesc text,
moviecount int )" ) or die $!;

Nikos wrote:

> Will you please help me make the appropriate tweaks to the already
> created scripts to implement that.

No. That isn't what this newsgroup is about.


> Do you agree with those names of the database tables and the columns in
> it to what i want to do? Dis i pick them correctly?

This newsgroup is not about choosing field names for your databases.

Scott Bryce wrote:
> Nikos wrote:
>
>> Will you please help me make the appropriate tweaks to the already
>> created scripts to implement that.
>
>
> No. That isn't what this newsgroup is about.
>
>
>> Do you agree with those names of the database tables and the columns
>> in it to what i want to do? Dis i pick them correctly?
>
>
> This newsgroup is not about choosing field names for your databases.


I will need some guidelines, i have already started it but i dont knwo
how to proceed.

Well i think columns names do matter because they have to be
self-explanatory and help user think why they are existing.

I don't know how to start to what i have asked, can you please help me out!
For starters i must have a button that a user will click in order to
sign up and then login with user name and password.

I just dont know hot to write it neither i can afforf paying someone
else to write it. I can though try step by step something.


ps. Hiring a Perl programmer write something costs 147$ per hour? Oh
boy, this job is a goldmine if someone knows how to program.

Nikos wrote:
> Scott Bryce wrote:
>
>> Nikos wrote:
>>
>>> Will you please help me make the appropriate tweaks to the already
>>> created scripts to implement that.
>>
>>
>>
>> No. That isn't what this newsgroup is about.
>>
>>
>>> Do you agree with those names of the database tables and the columns
>>> in it to what i want to do? Dis i pick them correctly?
>>
>>
>>
>> This newsgroup is not about choosing field names for your databases.
>
>
> I will need some guidelines, i have already started it but i dont knwo
> how to proceed.

Again, you are abusing the goodwill of the readers of this newsgroup.
Can you not see that you are being exceptionally rude? How many people
have to point out to you that you are behaving badly before you realise?
Are you actually reading any of this?

> I just dont know hot to write it neither i can afforf paying someone
> else to write it. I can though try step by step something.
So:

you don't know how to do something
you have had many, many, perfectly adequate explanations of what needs
to be done and how to modify your approach
you want someone else to do it all for you
you want them to do it for free

There is clearly something I'm not getting here.


> ps. Hiring a Perl programmer write something costs 147$ per hour? Oh
> boy, this job is a goldmine if someone knows how to program.
In which universe does EUR represent US dollars? EUR, funnily enough,
means Euros, thus chosen because it is a nice round number (at the
moment) in Sterling, if you know what that is. That isn't a typical rate
(I wish): it is a special rate for *you*. If you don't like my rates,
then I'm sure others here will be willing to give you alternative rates
and express them in currency units you understand.

I need to walk away.

Mark

Mark Clements wrote:

> you want someone else to do it all for you

No i'll do it but when i stuck i will ask for help.
At this moment i dont knwo how to evne start!


> then I'm sure others here will be willing to give you alternative rates
> and express them in currency units you understand.

I do understand Euros since i use them. I though it your first psot
asking for payment you were talking dollars.

Actually 1 Euro ~= 1 dollar

Nikos <> wrote:
> Scott Bryce wrote:
>> Nikos wrote:

>>> Do you agree with those names of the database tables and the columns
>>> in it to what i want to do? Dis i pick them correctly?
>>
>> This newsgroup is not about choosing field names for your databases.
>
> I will need some guidelines,


What would be the point of that?

You have demonstrated time and time again that you won't follow
good advice.


> Well i think columns names do matter


You seem to have reading comprehension issues as well.

Read what Scott wrote. Did he say that the column names do not matter?

No, he said that choosing the column names are OFF TOPIC here, as they
have no relationship to Perl (the topic of this newsgroup).

Nobody here gives a rat's ass about what column names you choose,
because that has nothing to do with Perl.


> I don't know how to start to what i have asked,


Yes you do...


> For starters i must have a button that a user will click in order to
> sign up and then login with user name and password.


.... start with a login webpage.

(you can get all of that done with ZERO Perl code, so making the
login webpage is off-topic here too.
)


> I can though try step by step something.


You have proven otherwise many many times already. What has changed?


> ps. Hiring a Perl programmer write something costs 147$ per hour?


Where did you get that figure?


> Oh
> boy, this job is a goldmine if someone knows how to program.


Most jobs that require extensive training pay well, that is no surprise.


--
Tad McClellan SGML consulting
Perl programming
Fort Worth, Texas

Nikos <> wrote in news:d4qvn4$gjt$:

> Mark Clements wrote:

>> then I'm sure others here will be willing to give you alternative rates
>> and express them in currency units you understand.

....

> Actually 1 Euro ~= 1 dollar

Try 1 Euro = 1.3 USD.

--
A. Sinan Unur <>
(reverse each component and remove .invalid for email address)

comp.lang.perl.misc guidelines on the WWW:
http://mail.augustmail.com/~tadmc/cl...uidelines.html

Tad McClellan wrote:
> Nikos <> wrote:
>
>>
>
>>ps. Hiring a Perl programmer write something costs 147$ per hour?
>
>
>
> Where did you get that figure?
>
>

Me, I'm afraid, in another thread, which Nikos managed to reply to in
this one. It was a special "sickener" price for him, except I clearly
quoted in Euros and he doesn't appear to be able to read.

Sinan has attempted to explain that USD and EUR are *not* at parity but
I doubt if Nikos will bother reading that.

I should know better than to introduce another potential source of
confusion.

Mark

Nikos wrote:

> Well i think columns names do matter because they have to be
> self-explanatory and help user think why they are existing.

Perhaps, but that is not a Perl issue.

> For starters i must have a button that a user will click in order to
> sign up and then login with user name and password.

Creating buttons is also not a Perl issue. Securing a web site is
probably too complex for your skill level.


> ps. Hiring a Perl programmer write something costs 147$ per hour? Oh
> boy, this job is a goldmine if someone knows how to program.

I'm going broke. But I'm not one of the better programmers here.

Nikos wrote:
>
> Will you please help me make the appropriate tweaks to the already
> created scripts to implement that.
> Iam trying too but unfortunately iam no expert.
>


you should start by buying a book "how to learn perl" or "how to learn
CGI". There will be many example-programs and you can learn
step-by-step. This is what books are for.
Then you will start changing the example-scripts and beeing able to make
your own scripts and then you'll have questions like "how do I lowercase
utf8-encoded text" and then this newsgroup will be looking forward to
help you. This is what the newsgroup is for. To answer specific questions.
But this newsgroup cannot help you when you dont have a clue about perl
and cgi.
And yes: databasenames are very important, but I'm sure you'll figure
out the correct names for yourself.

best,
peter

--
http://www.goldfisch.at/know_list