g a numerical weight for each
> criterion if match and 0 if not; summing those and sorting by the sum
> column.
>
> I would do it in code, though - it may or may not be less efficient, but
> it'll be easier to maintain and read.
>
>
>
> On Tue, May 12, 2009 at 5:50 PM, bla
I have a hold car data such as color, model, make, year, etc. I want to
allow the user to answer some questions and I'll present them with the car
that 'best' matches their criteria. How do I do this? I still want to
return ones that don't match exactly but want the closer matches ordered at
the
Hello all,
I have a file where the data looks like this:
"1","23","345","45";
"34","4","444","1er";
I am then trying to load that data using the load data local infile
and this statement:
Load data local infile '/httpd/htdocs/sql/loader.sql' into table
vehicles fields terminated by ',' enclosed
Never mind, I just figured it out:
First, I copied the whole 'hits' table to 'hits_bak', then ran this:
INSERT INTO `csrtech_dirserv`.`hits`
SELECT `SID` , 2 AS `AID` , `Phrase` , `IP` , `Link` , `Time` ,
`Amt` , `F`
FROM `csrtech_dirserv`.`hits_bak`
WHERE `SID` =5
So that coppied al
We've got about 1,000 records in a table that have timestamps on them.
We've ran into a situation where we need to go back and update one field in
all of those records without altering the timestamp. since the timestamp is
automatically changed when the record is updated we are in a bind.
The sql
> You could do something like this:
>
> $start = 0;
> if (isset($_GET['start'])) {
> $start = 1 * $_GET['start']; //make sure it's numerical
> }
>
> then query:
> SELECT .. FROM .. ORDER BY date LIMIT $tart, 1
>
> display the comment
>
> $start++;
>
> provide a link to thispage.php?
Just realized my subject wasn't correct, we don't want the next field, we
want the next row...
Thanks!
> We have a DB of customer comments that we want to display one at a time on
> our web site. We want the web pages (wrote in php) to use a user
> name/password on the DB that has SELECT ability
We have a DB of customer comments that we want to display one at a time on
our web site. We want the web pages (wrote in php) to use a user
name/password on the DB that has SELECT ability and that's it.
What's the best way to cycle through the comments so that each page
requested gets the "next"
HERE `Name` = 'First Last' )'??? Or do I
need to run the inner select and get the ID myself, then run the outer
select? I admit, I know just enough SQL to wipe the database and drop all
the tables ;-), so any help would be greatly apreciate.
Thanks!
/dev/null
--
MySQL Gene
RE (condition='new' OR condition='used') AND
type='sail'
You probably don't need to use LIKE since the form fields will always
supply you with the same values.
-bill
web-dev wrote:
Hello,
I am attempting to search a table based on information passed from
Hello,
I am attempting to search a table based on information passed from a
submitted form.
The form contains details as follows:
(radio buttons)
Condition: O new O used
Type: O powerO sail
(textbox)
Make: [ ]
etc. etc. etc. ( it's a long list!)
If I write
Hi Erwin
Try
Select afield from atable where index=(select max(index) from atable);
[]s
Paulo Botelho
- Original Message -
From: "Erwin Hogeweg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 12:47 PM
Subject: Neede MySQL query Equivalent.
> Hi,
>
> Coul
lrwxrwxrwx 1 root root 11 Jan 19 13:28 /usr/lib/libc.so -> ./libc
.so.1
-rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Offici
al MySQL binary' --with-extra-charsets=complex --enable-a
13 matches
Mail list logo
