I'm having a lot of trouble with a simple query. Does anyone have any idea
why this might not be working?
The query:
SELECT * FROM `asio_linkpop_queries` WHERE `domain` =
'www.legendsandlore.com' AND `date` 1056957929
The row in the database:
domain | date
www.legendsandlore.com | 1057000554
- Original Message -
From: Kevin Stone [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 30, 2003 1:34 PM
Subject: Comparison Operators?
I'm having a lot of trouble with a simple query. Does anyone have any
idea
why this might not be working?
The query:
SELECT * FROM
If the integer value of the question number is not being used for sorting
then you can ensure a unique key value for each row by setting the column to
AUTO INCREMENT.
ALTER TABLE `questions_dbase`.`questions_table`
CHANGE `questionnumber` `questionnumber`
BIGINT(20)
DEFAULT '0'
You can avoid the step of extracting the row data by doing:
UPDATE mytable SET numclicks = numclicks + 1
-Kevin
-Original Message-
From: rory oconnor [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 8:44 AM
To: [EMAIL PROTECTED]
Subject: fast,efficient query for counting
I'm
Ahh.. I was about to reply but nevermind. The two functions you're talking
about are addslashes() and stripslashes(). Yes those are very handy. :)
snip
Does anyone know of an easy way to store html code in a mysql database,
and
then retreive it, in such a way that it can display the