It seems to me you want to retrive n records based on the page number the user is in.
Here is what i use to page $limit records at a time using PHP:
$sql_select = "SELECT * FROM myTableName limit $offset , $limit";
$result = mysql_query($sql_select) or die ("Queryproblem: " . mysql_error());
Patrick Sherrill wrote:
Ensure you have a timestamp(14) field. This will provide the required
Thanks all but I reposted and the problem was my primary key being a BIGINT
which Access can't display. I should have closed off both threads.
--
MySQL General Mailing List
For list archives: http://list
Careful! I should clarify ... before you do the delete,
make sure the columns really do uniquely identify that row with
> select * from table where col2='some value'
and col4='some other value'
...without the limit clause.
Delete will delete everything that matches the where clause!
Mike
Hi,
You need to delete using a where clause and column values unique to
that row. Try "SELECT * from table limit 10,1" see if you can find some
value(s) which is unique to that record (irrelevant whether its defined
as a primary key). Eg, maybe col2 and col4 can uniquely id
The record you want t
On Wed, 2004-03-31 at 16:08, Chris Boget wrote:
> I have 2 tables (looks best in fixed width font):
>
> test_items
> +---+--+
> | name | rec_num |
> +---+--+
> | Book | 1|
> | Game | 2|
> +---+--+
>
> test_attributes
> +---+-
Marvin Cummings wrote:
I'm wondering if someone could help me figure out why I'm getting this error
when attempting to use phpMyAdmin to connect to mysql:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the
connection. You should check the host, username and password in
Ok. I'm using the default config.inc.php file which has 'config' as the
'auth_type'. I change this to HTTP and I'm prompted to enter a username and
password. I try root and its password and get "You are not authorized to
view this page". This happens regardless of the account I use. I know I'm
miss
I see $cfg all over the place and no mention of HTTP. Where should I be
looking for this?
Thanks
-Original Message-
From: Eve Atley [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 03, 2004 9:36 PM
To: Marvin Cummings
Subject: Re: Unable to connect to mysql with phpmyadmin
In the confi
I'm wondering if someone could help me figure out why I'm getting this error
when attempting to use phpMyAdmin to connect to mysql:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the
connection. You should check the host, username and password in
config.inc.php and make
Hi all,
I have positively identified the row I want to delete using:
'SELECT * FROM table LIMIT 10,1'
This has returned 1 record and I now want to DELETE the record.
How do I identify this record in my DELETE statement?
(using 'DELETE FROM table LIMIT 10,1' does not work)
NOTE : I can't ident
Ensure you have a timestamp(14) field. This will provide the required
uniqueness for Access (Jet).
I hope this helps.
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's First ISP
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: "Adam" <[EMAIL PROTECTED]>
To: "
There are two ways of handling this, the long way and the short way.
The long way is to prefix each ambiguously named column with the full table
name, as you have been doing. That *should* have worked for you since that
seems to be what you are doing in your example. Or did you literally write
"la
Osvaldo's question is a good one. How are you connecting to the MySQL
instance?
I use MySQL and Access as you are, but I use a MySQL instance running
on OS X. However, I don't have that problem. I use linked tables to
bring the MySQL tables into MS Access.
I have had quirky behavior when execu
* Brad Tilley
> > create table computers
> > select * from desktops, laptops where
> > desktops.field_1 = laptops.field_1
> > ...
> Thank you Matt, I am using Mysql 3.23.58 on RH Linux 9... UNION isn't
> supported on this version.
You can do it in two steps:
CREATE TABLE computers SELECT * FR
Thank you Matt, I am using Mysql 3.23.58 on RH Linux 9... UNION isn't
supported on this version.
On Saturday 03 April 2004 15:20, Matt Chatterley wrote:
> To select the contents of both into one table, you most likely want to use
> the 'UNION' operator:
>
> SELECT * FROM desktops
> UNION
> SELEC
To select the contents of both into one table, you most likely want to use
the 'UNION' operator:
SELECT * FROM desktops
UNION
SELECT * FROM laptops
If you create the computers table before hand (you can see how you would
create either of the others with SHOW CREATE tablename), then you can just
d
Hello,
I am a mysql newbie. Recently, I've been given the task of joining two tables
within the same DB into one table. Currently, the tables are named 'desktops'
and 'laptops'... ultimately, I would like one table named 'computers' Both
tables have the exact same fields... they fields even hav
Hi,
I'm using a kernel 2.4.25 system (Slackware distro) installed
with gcc 3.2.3.
I've tried both 4.0 and 5.0 source tarballs and when
configured with :
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql \
--with-openssl
and compiled, I always end up with:
gcc -DDEFAUL
* beginner aka ltcmelo
> I'm creating a e-commerce app and, consequently, a big
> database. I've searched around mysql docs and realizes
> that exists some especial (or better) kinda tables.
I suppose you meant "table handlers".
> In my small experience i'd choose InnoDB tables for my
> database,
Hi,
i'm new around here.
I'm creating a e-commerce app and, consequently, a big
database. I've searched around mysql docs and realizes
that exists some especial (or better) kinda tables.
In my small experience i'd choose InnoDB tables for my
database, is this the best option for a e-commerce
datab
* Eldon Ziegler
> I've been unable to select or set an enum field by using the
> string values.
> Numeric values work correctly.
> SHOW CREATE TABLE gives the following:
>
> CREATE TABLE `Organizations` (
>`OrgID` int(11) NOT NULL auto_increment,
>`Organization` varchar(50)
I've been unable to select or set an enum field by using the string values.
Numeric values work correctly.
SHOW CREATE TABLE gives the following:
CREATE TABLE `Organizations` (
`OrgID` int(11) NOT NULL auto_increment,
`Organization` varchar(50) NOT NULL default '',
`
Thanks a lot, I think I have enough to validate the syntax (sort of).
Ahmad Khashan
Michael Stassen <[EMAIL PROTECTED]> wrote:
Khashan wrote:
> **None of these are "table level" modifiers**
>
> Sorry, I guess I used the wrong terminology. I am aware of the table
> options available. What I me
Sorry, I spoke too soon.
I just made a test case of a proc calling a proc, which works,
so I must have a different problem.
- Still would like to know if a function will ever be able to issue a
SELECT tho.
Cheers
Mike
-Original Message-
From: Michael Pheasant [mailto:[EMAIL PROTECTED]
Morning :)
1. You sure can, e.g:
CREATE PROCEDURE `user_authenticate`(IN sUserName VARCHAR(25), IN sPassword
CHAR(32), OUT sUserCookie CHAR(32))
BEGIN
DECLARE iUserID INT;
DECLARE iLogID INT;
SELECT MD5(CONCAT(UserID,NOW())) INTO sUserCookie FROM users WHERE UserName
= sUserName AND Password =
Hi,
1) Can a stored procedure call another stored procedure?
Ie, can you do 'call someproc()' from within a stored procedure?
2) Also, will a function ever be able to issue a SELECT query?
I am using mysql-5.0.1-alpha (built froms ource) , winXP & win2k.
The mysql daemon crashes without an er
26 matches
Mail list logo
