is.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
I'm having an emotional outburst!!
*/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
with this name. The request is rejected.
Has anybody an explanation ?
You need to enclose the table name with backticks, eg:
CREATE TABLE `w4-1` (
name varchar(10) NOT NULL default '',
email varchar(30) NOT NULL default ''
);
hth
--
Jason Wong - Gremlins Associates
;
}
}
return($result);
}
}
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Peers's Law:
The solution to a problem changes the nature of the problem
| 0.200211824104387 |
| Magnet | 0.565105185438977 |
| Feng Shui| 0.811984655272201 |
| Candle | 0.953237160996755 |
+--+---+
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Boling's postulate
:
$select=$dbh-prepare(select * from $thetable where url is not null
order
by rand() limit 1);
I have tried everything, but nothing seems to work. Can anyone help.
Rob
The solution presented by Kodrik does work. What is the problem?
--
Jason Wong - Gremlins Associates
portion from myfield.
Thus you can have
WHERE HOUR(myfield) = 14
will select only those rows in myfield where the time is 2:XX PM.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
The Abrams' Principle:
The shortest distance between two points is off the wall
this:
SEC_TO_TIME(UNIX_TIMESTAMP(2001-11-03 16:11:50) -
UNIX_TIMESTAMP(2001-11-03 15:48:00))
which would return
00:23:50
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Universe, n.:
The problem.
*/
-
Before
On Thursday 29 November 2001 02:01, Auri Net SAC wrote:
Hi
please who knows a package that install apache + php + mysql in linux,
i know phptriad but its for windows
Thanks for your answer
rvj
ApacheToolBox http://www.apachetoolbox.com
--
Jason Wong - Gremlins Associates
are delimited with a '|' in the fields. If I wish to
select all records which contain 'christmas', what is the correct sql
syntax please?
(This should return records 1 and 3 from the example shown above)
SELECT * FROM table WHERE category LIKE '%christmas%'
should do the trick.
hth
--
Jason Wong
too many rows to
deal with.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Baker's First Law of Federal Geometry:
A block grant is a solid mass of money surrounded on all sides by
governors
name your multiselect fields as name[]. In
your case it would be zimmermulreg[]. This would then give you an
array when the form is submitted and thus make implode happy.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Mencken and Nathan's Ninth Law of The Average American
in commands and it just does another - What is that?
The - indicates that it is waiting for the rest of the query. You need
to end each query with a semi-colon. Thus:
mysql show tables;ENTER
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Professor Gorden Newell threw another
to the time at which the record was updated. You
should probably be using a DATETIME field for this.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
We'll cross that bridge when we come back to it later
type does not support binary encoding?
lease ... or i´ll do harakiri
You could try using a BLOB.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
After one week [visiting Austria] I couldn't wait to go back to the
United States. Everything was much more pleasant in the United
BY storyCategoryID;
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
HR 3128. Omnibus Budget Reconciliation, Fiscal 1986. Martin, R-Ill.,
motion that the House recede from its disagreement to the Senate
amendment making changes in the bill to reduce fiscal 1986 deficits.
The Senate
.
I think your problem is that you haven't quoted the VALUES that you're
inserting. Try:
$QRY = INSERT INTO bandbook (user, ect1, ect2...)
VALUES ('$userdb', '$ect1', '$ect2', ...);
print($QRY); ## For debugging
$rows=$dbh-do($QRY) || die Error;
hth
--
Jason Wong
Gremlins Associates
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
primary key of multiple fields. And I
also have a unique index on each of these fields. There are
1,734,291 bytes of data in the table with an average row length of
61.
Sometimes it's quicker to drop the indices, insert your data, then
recreate the indices.
hth
--
Jason Wong
Gremlins
18 matches
Mail list logo