|
-
Jun 24th, 2002, 08:42 AM
#1
Thread Starter
Fanatic Member
2 Questions
1. How would I go about editing an entry?
2. How would make it only show then, then have a link that would show next 10
thanks
-
Jun 24th, 2002, 08:53 AM
#2
Member
Assuming we're talking about MySQL...
1.
Code:
UPDATE table SET column=value
2.
Code:
SELECT columns FROM table LIMIT first row returned, last row returned
-
Jun 24th, 2002, 09:37 AM
#3
actually #2 would be
SELECT columns FROM table LIMIT first row returned, # of rows returned
-
Jul 1st, 2002, 08:43 PM
#4
Member
Right, sorry.
Also elaborating on 1:
Code:
UPDATE table SET column=value, another column=another value... WHERE boolean LIMIT start row, total rows
-
Jul 5th, 2002, 02:56 PM
#5
Thread Starter
Fanatic Member
So for 1.
Can I do this
$sql = ("UPDATE cat SET title=$_REQUEST[title] WHERE id=1");
And it will update title?
If now how do I tell it where to update?
EDIT:Nevemind I was just missing some qoutes
Last edited by Gimlin; Jul 5th, 2002 at 03:07 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|