Getting a search function running perplexed me, too, until I looked at the
MySQL docs. With the Full-Text Search function I got a search function
working in minutes.
http://www.mysql.com/doc/F/u/Fulltext_Search.html
Watch out for the weird bug that ignores duplicate rows, though. It can make
Hi all,
I'm wondering if there is a way to start an auto-increment field at a number
other than 1. I'm working on a table meant to store large amounts of users,
each with their own unique ID, but my employer wants the UIDs to be a four-
digit number, rather than starting at 1 -- but they still
The way I do this is a very simple bit of code:
Outside the "while" statement, add the line:
$column = 1;
Then, inside the "while" statement, take the statements out and
instead do something like this:
$column++;
if ($column > 3)
{
echo "";
Hi all,
Does anyone know a quick and easy way to select a random record from a
database? I'm looking to put together a simple random quote generator, a la
linux's "fortune."
Any help would be much appreciated.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
Actually, now that I think of it... how would you move from one record to
the next, if not querying by userid?
Optimally, I would like to have a page that displays one row from a table,
and links that will allow a user to go to the next or previous row via
hyperlink. At first glance I can't think
Actually, I didn't think of that. That may work.
Thank you, Mr. Williamsen and Mr. Cox for your suggestions. I will try out
both solutions.
- Original Message -
From: "Todd WIlliamsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 12, 2002 10:09 PM
Subject: Re: [PHP
Hello,
I am attempting to put together a page whereby results from a database are
displayed, and previous / next hyperlinks allow the user to "flip" through
records, one at a time. I attempted to do this by using a unique ID (that
auto increments)
and then including links like so at the bottom o
Hello,
I am attempting to put together a page whereby results from a database are
displayed, and previous / next hyperlinks allow the user to "flip" through
records. I attempted to do this by using a unique ID (that auto increments)
and then including links like so at the bottom of the page:
-
