Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Search Box and 'Phakt'

Author  Topic 

fxcolin
Starting Member

1 Post

Posted - 2002-03-02 : 03:25:19
I'm using Phakt and Dreamweaver UD
I'm trying to develop a recipe database with 2 tables, recipes and authors with a LEFT JOIN and pulling the records with 1 textbox on the same page using LIKE.

I have apache, php 4.06 and MySQL set up on my PC.
For testing purposes I have only 6 records in my database with a LIMIT of 2.

Everything seems to work great except for one problem.
when I input a search word which I know will pull 3 records, it says found 1 to 2 of 3. Now, when I click 'next' the whole database gets pulled 'found 3 to 4 of 6'.

this thing has been pulling my hair out for the last few days.
This must be a pretty basic problem, Am I missing a statement of some sort. Can someone offer a suggestion ??
Thanks alot







Edited by - robvolk on 03/02/2002 09:40:33

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-03-02 : 09:43:19
Moved this to Other Topics.

We're not really up on mySQL, PHP or Dreamweaver (and I've never even heard of Phakt), we focus on MS SQL Server here.

You might try http://dbforums.com as they have a mySQL forum there.

Go to Top of Page
   

- Advertisement -