Hello Teddy:
Could you please be a bit more demonstrative? If I have a module in at Web
address on a Apache server with permissions 700, (Warren said he has his
scipt to 755, I think) how exactly do you believe a site visitor can access
the text of the script? Or how do you think another system us
Hi David:
I am assuming you are using DBI.
I am not quite sure what you are asking, but here is some code that might
help:
while ($hashref = $sth->fetchrow_hashref) #while there are records in the
query ...
{
DO SOME STUFF
}
The above code is a pretty traditonal way to deal with a statement h
Hi Grant:
The answer to your question depends on a lot of details. In most cases, the
solution you have chosen is just fine. The real question you need to answer
is, "Does your solution meet your needs?" If you can answer yes to this
question, your solution is fine.
Your solution gives you a coup
Your command says select 60 rows starting at row 30. You want "LIMIT 30, 30"
to get 30 rows.
Matt
- Original Message -
From: Mike At Spy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 9:56 AM
Subject: LIMIT in MySQL
>
> I must not be awake yet. Why is this
Actually there is a slightly better way to add a user.
Read the following entry in the mysql docs:
http://www.mysql.com/doc/en/GRANT.html
In fact you might want to read this whole section:
http://www.mysql.com/doc/en/User_Account_Management.html
Example:
grant select, insert on *.* to joeuser@loc
Hey Greg:
A slightly easier way to do this is to use a "timestamp" field. Timestamp is
just a standard mysql data type. When a record is added, it records the
current time. When a record is updated, the timestamp field will be set to
the time of the update.
http://www.mysql.com/doc/en/DATETIME.ht