I sort of know why this is happening. Just not sure
how to correct it.
My query:
SELECT
Reg.firstname,Reg.lastname, Profiles.ProfileName
FROM Profiles
INNER JOIN Reg ON (Profiles.LID = Reg.RegID)
INNER JOIN PSkicerts ON Profiles.ProfileID =
PSkicerts.ProfileID)
where Profiles.Status != 2
I need to convert database values into php variables.
Let me explain:
i.e.
select firstbase, secondbase, thirdbase, home from
allstars where firstbase = 122;
Now I want to use all those field names as variables
with the same record information they would have if
you just ran the above
--- Jay Blanchard
[EMAIL PROTECTED] wrote:
My suggestion is that you work some basic PHP/MySQL
tutorials and use
the PHP general list ([EMAIL PROTECTED]) for
questions like
this. Make sure you have RTFM, STFA, and STFW before
posting, those guys
can be merciless.
Jay, thank you and I
I have a select, from, where, query set up.
There are a number of inner joins in it as well.
Now what I noticed is if there are some null fields in
the records, nothing will get returned. If I remove
those particular joins (where the NULLS are), the
record is returned.
Does this sounds like a
I'm creating a search form, the query is dynamic.
Meaning user can select 1 or all options.
All options translates to about 40 where statements,
including 1 -3 full text searches.
Is this too many where statements ? Do I need to watch
out for anything.
Looking for any advice on this issue.
I'm storing telephone number (US) in 10 digit
varchars. If I want to do a search on just the area
code, is there a way to limit it to just the first 3
digits of the string ?
Thank you
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
I'm storing telephone number (US) in 10 digit
varchars. If I want to do a search on just the area
code, is there a way to limit it to just the first 3
digits of the string ?
Thank you
Stuart
I'm trying something like this but still
--- sol beach [EMAIL PROTECTED] wrote:
Of course you do.
You are asking for all of Telephone to be returned.
Duh!
I'm trying something like this but still getting
back
the whole string:
select Telephone from SignUp
where
Left (SUBSTRING(Telephone,1,3), 3) LIKE '4%'
--- Roger Baklund [EMAIL PROTECTED] wrote:
It's a bit unclear what you are trying to do. Are
you trying to find all
numbers within a 3 digit area code, i.e. numbers
starting with some 3
digits? Or are you trying to find numbers with any
of the three first
digits equal to 4?
For the
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
--- Roger Baklund [EMAIL PROTECTED] wrote:
Yes, I had not included in my original post I wanted
just the area code returned. It works -
select SUBSTRING(Telephone, 1 ,3) from SignUp
where
Left (Telephone, 3) LIKE '4%' ;
Thank you
Stuart
or maybe it's me :)
Anyway here is my table
++--+
| RecordID | School |
| PID,AI,INT | Varchar|
++--+
| 108 | Columbia |
+|--+
| 108 | Princeton |
+|--+
| 108
--- [EMAIL PROTECTED] wrote:
There is nothing weird about that behavior. You
asked for all of the rows
where the School column has both of two different
values at the same time.
I thought joins were difficult to comprehend ;)
Try an OR instead or use the IN() operator.
WHERE
--- Roger Baklund [EMAIL PROTECTED] wrote:
The WHERE clause describes EACH of the rows you get
in the result. No
one row can have a value in the School column equal
to Columbia AND
Stamford at the same time. You should use OR
instead of AND.
Thank you Roger. That is one of the best
--- Heikki Tuuri [EMAIL PROTECTED] wrote:
Stuart,
you probably have
skip-innodb
in my.cnf.
Best regards,
Heikki Tuuri
Heikki - Nope , doesn't seem so. My.cnf is below.
Also, I'm guessing that if it was set to skip-innodb,
I wouldn't not have had the ability to change them
back.
I'm not sure what happened but when I ran some test
yesterday on a transaction it failed. Being puzzled
I started digging around. I have come to find out
that all the tables involved were now set to MyISAM.
Obviously transactions wouldn't work.
The odd thing that I'd like to figure out is how
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
I'm not sure what happened but when I ran some test
yesterday on a transaction it failed. Being
puzzled
I started digging around. I have come to find out
that all the tables involved were now set to MyISAM.
Obviously transactions wouldn't
Does DATEDIFF only work with actual dates input i.e
('2004-12-05'
Or couldn't I do :
Select DATEDIFF (StartDate, EndDate) AS DaysBtwn from
mytable?
(StateDate,EndDate are date columns from db)
I'm generating a syntax error on this above.
Stuart
--
MySQL General Mailing List
For
--- Paul DuBois [EMAIL PROTECTED] wrote:
There's a space beteeen the function name and the
following
parenthesis.
Yes, that and not remembering I'm still on 4.0.22 :)
Yeesh...sorry Paul.
Switched to TO_DAYS ..no diff I guess
Stuart
--
MySQL General Mailing List
For list archives:
I'm trying to build an insert query that will add a
value into a field , after the first insert query adds
the record.
Relevant table information:
+-+-++--+
| RecordID| InitOn | LenChoice | EndDate |
+ [PrimID,AutoInc]| [Date] | [int]
--- [EMAIL PROTECTED] wrote:
I think you need an UPDATE statement
UPDATE MyTable set EndDate=DATE_ADD(InitOn, INTERVAL
LenChoice DAY) WHERE
RecordID = value ;
Insert *always* creates new records if successful
and cannot be used to
modify them.
Update *always* updates recirds in
While what I'm working on is only a test database, I'd
like to see what I can preserve.
I used a data dumping program to create records in my
database. However I'm not sure how I messed up , but
here is the problem.
I have 1016 records in a particular table. The first
column is a Primary ID Int
I'm not even sure what this would be called, but maybe
someone (or more then one) can give me some pointers
and where to learn how this is down:
Someone does a search on my system:
1- I need a way to mark (somewhere) that the record
came up in a search. i.e. 700 records were returned
in a
--- Jay Blanchard
[EMAIL PROTECTED] wrote:
[snip]
1- I need a way to mark (somewhere) that the record
came up in a search. i.e. 700 records were returned
in a search, each one needs to a) be marked that it
came up in a search b) that number needs to be
incremented
2- Step further, out
--- Brent Baisley [EMAIL PROTECTED] wrote:
It depends on whether you are tracking info for
individual users
Individual users (lucky me!)
Now, if you want to keep separate logs for each
user, you need to
create a log table. The log table would have the
following fields:
I'm trying to paginate my record results. Running
into a sql syntax error that is boggling my limited
brain cells.
The print out of my statement as it is parsed:
This is before the error occurs, the first 15 records
return fine:
WHERE VendorJobs.Industry IN ('3') AND
VendorJobs.JobTitle LIKE
Note to self, check variables for typos before posting
to list!
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
While I'm figuring this needs to be addressed via my
scripting language wanted to ask here.
Customers will buy a block of time to use my service.
Time meaning number of days. 90, 45, 60, etc.
Here are the fields relevant to this question:
PostStart [Date]
LenChoice [int]
DaysLeft [int]
--- Bernard Clement [EMAIL PROTECTED]
wrote:
You will get your answers by reading carefully the
Date Time Functions
in the MySQL Reference Manual.
This will tell me how to automatically update the
column in question ?
Stuart
--
MySQL General Mailing List
For list archives:
I have a query statement set up for record returns
based on various where statements. The select
statement consists of a number of joins. One of those
joins includes a field that is marked no null.
Recently I did a mass insertion into the table. Into
this particular no null field were place 0's
--- Brent Baisley [EMAIL PROTECTED] wrote:
Quite possibly since 0 could also mean false
depending on your
comparison operator. For instance, using a generic
if statement, these
two would both evaluate to false:
if(0)
if(null)
You should be very specific when checking for NULL.
WHERE
--- Adams, Pat 006
[EMAIL PROTECTED] wrote:
You could add a where condition that's always true
to the main part of
the SQL statement so that you can just tack on more
clauses
conditionally.
$sql .= SELECT PostStart, JobTitle, Industry,
LocationState, VendorID
. FROM VendorJobs
Question - I'm creating a dynamic query (using PHP)
but my question I think is more related to mysql
syntax.
Right now I have these statements:
?php
$sql .= SELECT PostStart, JobTitle, Industry,
LocationState, VendorID FROM VendorJobs;
if ($s_Ind){
$sql .= WHERE VendorJobs.Industry IN
--- Rhino [EMAIL PROTECTED] wrote:
No offense, Stuart, but I really can't make out what
you are asking; the
question is bordering on incoherent.
Well it's probably true that I'm losing it :)
Chris though understood even through my inane
babbling.
Except while the statements are correct,
--- Chris [EMAIL PROTECTED] wrote:
What I tend to do in this situation is have a WHERE
array:
$sql .= SELECT PostStart, JobTitle, Industry,
LocationState, VendorID FROM VendorJobs;
$aWHERE = array();
if(isset($s_Ind)) $aWHERE[] =
VendorJobs.LocationState IN ($s_Ind)
I've had this going over on the php-general list.
Thought I would throw it out here . Running PHP 4.0.22
Keep getting this error -
SELECT PostStart, JobTitle, Industry, LocationState,
VendorID FROM VendorJobsSELECT PostStart, JobTitle,
Industry, LocationState, VendorID FROM VendorJobsWHERE
--- Jim Winstead [EMAIL PROTECTED] wrote:
You can't compare a column with a comma-delimited
list of numbers like
that...
What should the seperator be then ?
Thank you
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
--- Jim Winstead [EMAIL PROTECTED] wrote:
My point was that you can't compare a column with an
array
of numbers using the '=' operator. You have to use
the IN
operator, as in the line of code I posted:
Thank you Jim , it's working now!
Stuart
--
MySQL General Mailing List
For list
My database got hosed last night due to some version
upgrade.
Anyway an older copy was restored on the server. I
have a more recent backup on my local machine.
However, when I have done the data transfers I have
found that the table names were convereted to all
lower case.
I'm assuming when I
I apologize for the missing information.
First the server was on 4.0.20 now on 4.0.22. Apache
1.3.x not sure of the linux
The local machine is windows xp with mysql v. 4.0.20a
I did the data transfer running Navicat, so that may
not be so clear to anyone, but the only options that
were enabled:
I'm having a difficult time getting a query to work
correctly.
I'm not sure, if this is proprietary to Dreamweaver or
not (that is what I do my application development in)
Anyway I have created a search page that is dynamic
(meaning up to the user to choose the criteria)
It all works fine
I had a transaction script that was working fine.
Now I think it maybe due to a duplicate key error.
At least that is the error being printed out.
Here is the table Profiles_Skicerts[innodb]:
P_ID - PK, Normal Index (int)
Skicert - PK, Normal Index (varchar)
N_Year - int, allow null
L_Used - int,
Hope this is not a bad suggestion. I'd suggest also
looking at something like x-cart-gold. I't s a php
/ mysql product and very robust for online ecommerce.
If you want some ideas about what an online store
would need and should contain , you might get some
ideas.
I'm not promoting the product.
.
Now I'm not totally sure how a rollback would effect
the one Myisam query. I mean it wouldn't , since
rollback is alien to myisam, so I probably need to put
a line in there to (whatever a rollback is in myisam
language) as well.
Stuart
--- Egor Egorov [EMAIL PROTECTED] wrote:
Stuart Felenstein
I'm relatively new to all of this but just about
finished setting up a transaction myself.
I'm doing something like this:
this is in php:( i also have functions set up for
begin, rollback and committ.
You should also set autocommitt to 0 .
Hope this helps!
Stuart
function run_query($sql)
{
My statements are all working but I'm not sure if
things are set up correctly. I say this because at
one point the first $query failed, yet the rest of
inserts wre committed. Now I believe I need to set
autocommit to 0 , yet the query failed due to a syntax
error. Hence the rule about 0 records
give a
error, then you
don't know. You have to check each statement for
error and if no error
if found in all the statements then issue a commit
if not a rollback
Osvaldo Sommer
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 16, 2004 7
I have a slight dilemma. I am using transactions to
insert data into multiple tables. All but one table
is Innodb. That one is Myisam and it's left as such
because its one text column, so I want the benefits of
full text search.
Still I need this transaction to somehow include this
entry.
Two
I'm in the midst of writing out some code that will
take data from a huge form and write it to the
database.
All the tables for insertions are innodb so i'm going
(or trying too) with the one stop shop approach -
transactions.
Question:
The first table I write too has as it's first column
an
Sorry I found out about Last Insert_ID right after
writing this. I guess the correct sequence is
check manual then post to list ?
Stuart
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
I'm in the midst of writing out some code that will
take data from a huge form and write
Hi,
I am taking user input via a calendar widget (guess
it's js)
Apparently, mysql does not like the format
MM/DD/
Then again I tried it around , still no dice.
It's intended to go into a Date column.
Is there a way I can correct it right within my query
?
Stuart
--
MySQL General
Thanks , I know the page and have the links
bookmarked!
Stuart
--- Jeff Smelser [EMAIL PROTECTED] wrote:
On Thursday 14 October 2004 02:45 pm, Stuart
Felenstein wrote:
Apparently, mysql does not like the format
MM/DD/
Then again I tried it around , still no dice.
It's intended
No :),. cause it seems that those formats are for
outbound, db -.
I was looking for the other direction.
Stuart
--- Jeff Smelser [EMAIL PROTECTED] wrote:
On Thursday 14 October 2004 03:12 pm, Stuart
Felenstein wrote:
Thanks , I know the page and have the links
bookmarked!
So you got
Does application validation constitute all that is
needed for qualifying data prior to an insertion in
the database ?
Translated, If I have checked via my forms validation
things like required fields, character input, etc,
are there still checks through MySQL before the insert
happens ?
Thank
This maybe somewhat of a silly question.
Scenario - I am pretty much a noob at both relational
databases and web programming. I've built most of my
pages using a RAD tool that, for the most part, does a
decent job , if you keep it fairly simple.
One of the limitations is inserts updates are
See interspersed:
--- Joe Audette [EMAIL PROTECTED] wrote:
If you are saying the user would navigate through
multiple pages updating a table on each page and you
want to treat all the updates collectively as one
transaction, that is a bad idea.
I agree, that is what I am trying to not do.
Shawn,
When I read your examples, it is clear as a bell.
When I try to map it into my situation it becomes more
difficult to clarify :)
Using other job boards as examples, there are a couple
of ways to go.
Most of the bigger players offer job seekers the
ability to store 5 resumes online.
at this stage.
I need to understand
what data you are going to maintain verbally before
I can help you
translate it into storage requirements.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Stuart Felenstein [EMAIL PROTECTED] wrote on
10/06/2004 02:47:44 PM:
Shawn
See interspersed.
--- [EMAIL PROTECTED] wrote:
Let's do this verbally and maybe the database
structure will become
intuitively apparent
You are hosting a website that supports job seekers
(maybe more but let's
concentrate on just this side of it)
Yep, there is the employer side.
Great example and my apologies because as you know
we've been down this road before.
Side note - once again I did not provide my acutal
table names , this time they haven't been created as
of yet.
Let me skinny this down though a bit and focus on one
aspect of my design connundrum.
Remember
I've worked through some of this but still would like
some opinions. Maybe it's not clear but I haven't
received any responses.
Basically to tie the records together I will use the
recordID (auto incrementing) in every table where the
records are written.
Then I can grab everything out of
Two tables:
Table1 [innodb]
userID.
addtlfields.
Table2 [innodb]
memberID.
addtlfields.
I created a foreign key in Table2 for memberID to
userID
set to no action on both delete and update.
I get this error when I try to add a record to table
2:Cannot add or update a child row:
I think I may have discovered one of my issues, is
memberID in Table2 was primary key. Should not have
been. As far as the error messages in removing key,
I'm still unsure.
Stuart
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
Two tables:
Table1 [innodb]
userID.
addtlfields
I'm not sure , can't resolve in my mind if this is a
M2M or something else.
I have 5 tables, users may enter multiple records in
each table. The only trick is (for me) is how to tie
a unified record together across all of them.
I'll try to illustrate, and only use 2 tables to keep
it brief.
I have a field telephone.
Set to type :int:
Length: 11
It's not working correctly, and not sure if it's my
application or something I have wrongly set up for the
database.
We are talking about U.S. Telephone numbers here, so 7
digits (area code, exchange, unique number)
Now it seems everything
use a varchar or
char field.
Maybe someone could correct me but aren't regex for
strings only?
Gary
On Sat, 2 Oct 2004 04:59:45 -0700 (PDT), Stuart
Felenstein
[EMAIL PROTECTED] wrote:
I have a field telephone.
Set to type :int:
Length: 11
It's not working correctly
--- Paul DuBois [EMAIL PROTECTED] wrote:
Are you trying to store telephone number values with
the intermediate dashes? Such values are not
actually
numbers. You'll need to store them as strings, or
else remove the dashes.
Yes, they made all the difference.
Set the field type to varchar,
I want to move over 2 - 4 fields from a table in one
database , to a table in another. The field names are
not an exact match but they function identically (i.e.
username, password)
Whatever I'm using , web development garbage program
;) won't allow me to connect to 2 different databases
so I
of
other goodies.
www.it-map.com
Tim Hayes
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: 28 September 2004 08:23
To: [EMAIL PROTECTED]
Subject: Data fields from one database to another
I want to move over 2 - 4 fields from a table in one
database
scripting and data
value translation lookups.
Timk
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: 28 September 2004 09:57
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Data fields from one database to
another
So it will let me transfar
I'm back, trying to figure my way through a somewhat
confusing set of conditons.
Sort of doing a sanity check here.
First explanation:
I've put together a search (the database) form that
has 6 inputs.
Just to clarify, the fields are
1-JobTitle
2-City
3-Start
4-Industry
5-State
6-TaxTerm.
The
in doubt, spell it
out. Don't make the
query engine read your mind.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Stuart Felenstein [EMAIL PROTECTED] wrote on
09/22/2004 09:46:46 AM:
I'm back, trying to figure my way through a
somewhat
confusing set
$taxterm;
.
.
do the actual SQL call here.
Stuart Felenstein wrote:
I'm back, trying to figure my way through a
somewhat
confusing set of conditons.
Sort of doing a sanity check here.
First explanation:
I've put together a search (the database) form that
has 6 inputs.
Just to clarify
Pine
Stuart Felenstein [EMAIL PROTECTED] wrote on
09/22/2004 03:11:16 PM:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Not sure exactly what you mean by a SQL injection
attack. I'm thinking a string could be input as
opposed to an integer ?
The form itself constricts user to a set of choices.
Stuart
--- Harald Fuchs [EMAIL PROTECTED] wrote:
I think this is bad advice, even for a novice like
Stuart, because
It's all good information. I need to be thinking security as well as generating
proper efficient code. All is appreciated.
Stuart
Harald Fuchs [EMAIL PROTECTED] wrote:
In article ,
[EMAIL PROTECTED] writes:
I agree and I am sorry I forgot a very basic security practice. You must
always
as you want it
executed. Then do it.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Stuart Felenstein wrote on 09/13/2004 03:35:35 PM:
Shawn - You answered the right question. Since a SQL
statement is closer to my grasp right now , today,
trying that approach.
I think
I read through the parts of the manual that applied
but I might be missing something here.
I have a table where I'm trying to query the date with
a conditional statement. As you'll see , if 3 was the
condition then the statement should result in a list
of any entries made = current date.
It
Ok, never mind . I guess a conditional loop is not
needed.
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
background.
We all want to help but we aren't there looking over
your shoulder so we
can't see everything you see. We just need a little
help to visualize your
problem, OK?
Respectfully,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Stuart Felenstein [EMAIL
the correct value into my original
query)
Please let me know if I answered the wrong question,
OK?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Stuart Felenstein [EMAIL PROTECTED] wrote on
09/13/2004 11:54:02 AM:
Shawn, partially discourage but mostly
I'm having a hard time getting my arms around how a
system's date process should work. Interested in
knowing how a real, online system that delivers
services or products to customers might work. Right
now I'll just be operating in North America.
As an example - a user does online banking. A
Wondering if there is anyone on the list who knows
this product .
Thank you,
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've been meaning to follow up on this post.
Can either Peter or someone expand and provide an
example of get all information in a single query...
Thank you ,
Stuart
--- Peter Lovatt [EMAIL PROTECTED] wrote:
Hi
What I do is to try and get all information in a
single query and then use
I have this query (below) that on it's own , directly
into the database seems to return all the records just
fine. Apparently though feeding it into a php loop,
the lack of where is causing great distress(at least
to the author)
I'm wondering where to put it though. Before each
join ? And then
I'm confused about this response and am facing a
similar situation.
First, regarding the subject, what is the difference
between a PHP or whatever loop and a SQL query. All
the app code is doing is collecting the request and
handing it back to the database. The DBMS still has
to retrieve the
. One list will
make the PHP loop
simpler, smaller and faster.
On Sep 8, 2004, at 2:12 PM, Stuart Felenstein wrote:
I'm confused about this response and am facing a
similar situation.
First, regarding the subject, what is the
difference
between a PHP or whatever loop and a SQL query
Sorry, I'm not jumping in becasue I have an answer,
sorry Jeremy.
I posted a few days ago a question and wonder if this
thread , at least Shawn's response has any relevance
to my question.
That is! ; Is there really any difference between
using PHP to parse results back to the program or can
a
I'm hoping I can present this correctly. I'm trying
to determine how to set up my where condition as, 1
way has already failed me. While I continue to
figure this out (i'm a noob), I hope asking for some
advice here won't be too awful.
There is one main table where data is inserted and
that
understand
correctly.
Sorry, I might just be thinking outloud.
Please do not boot.
Stuart
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
I'm hoping I can present this correctly. I'm trying
to determine how to set up my where condition as, 1
way has already failed me. While I continue to
figure
it works in the 999,999,999 ways it should.
Thank you,
Stuart
--- Michael Stassen [EMAIL PROTECTED]
wrote:
Stuart Felenstein wrote:
I'm hoping I can present this correctly. I'm
trying
to determine how to set up my where condition as,
1
way has already failed me. While I continue
This maybe OT but perhaps somone has a clue here.
I am storing gifs in a Blob, well tinyblob field.
I was under the assumption they could just be
pulled out and shown on a web page similar to running
any other query.
Apparently not, someone have a hint ?
Thanks
Stuart
--
MySQL General
!
Stuart
--- Paul DuBois [EMAIL PROTECTED] wrote:
At 9:56 -0700 9/4/04, Stuart Felenstein wrote:
This maybe OT but perhaps somone has a clue here.
I am storing gifs in a Blob, well tinyblob field.
I was under the assumption they could just be
pulled out and shown on a web page similar to
running
Since the recent thread with Innodb table space, I
have had a concern for a while.
First, I use Navicat to administer mysql. This
includes table creation.
I don't notice this using a myisam table but when I
set up an innodb I find this item:
InnoDB free: 10240 kB
Does this mean the actual
In my web design I have a side bar to provide quick
info and links to account information.
Examples would be account basics:
Welome : Name, Company, Last Visit , ..
One idea that brings me to this question:
In the side bar I list out how many resumes member has
on file, so:
Title1 - Then
I'm tring to extract all records belonging to one ID
in a table.
BUT! I want to do it in piece meal. Meaning a record
at a time.
I am assuming I need some kind of count mechanism.
Example:
I want to see the first 3 purchases this member made.
Instead of grabbing them all in one shot, I want
Wait!! Don't answer...it's that LIMIT
thing.
:)
Stuart
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
I'm tring to extract all records belonging to one ID
in a table.
BUT! I want to do it in piece meal. Meaning a
record
at a time.
I am assuming I need some kind of count
://dev.mysql.com/doc/mysql/en/Tutorial.html
If, after exploring these two links, you still have
questions feel free
to post them and people will be glad to be of
assistance.
RTFM,
--V
Stuart Felenstein wrote:
I'm tring to extract all records belonging to one
ID
in a table
to your MySQL server version for the
right syntax to use near 'LIMIT -1' at line 1
Maybe formatting ?
Stuart
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
Wait!! Don't answer...it's that LIMIT
thing.
:)
Stuart
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
I'm
start with 0, not
with 1. In other words,
you may want to try Limit 0,1, not Limit 1,1.
Rhino
- Original Message -
From: Stuart Felenstein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 02, 2004 12:18 PM
Subject: Re: After I went searching
The query
a
screen that says So sorry but you already have your
limit of resumes on
file.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--8 prior responses mangled for space
---8--
Stuart Felenstein [EMAIL PROTECTED] wrote on
09/02/2004 01:05:31 PM
1 - 100 of 144 matches
Mail list logo