Re: MySQL ORDER BY or PHP Sort? Oops.
Well I think mysql doesnt allow you to do this that simple as mysql
doesnt know how you want to sort it exactly. So my suggestion would be to
give a value to each series, eg. Baby = 1,
Genesis=2,Super=3,Predator=4,Millennium=5 and then order by series.
Cheers
Siim Einfeldt
> One more thing, very important: I want to specify the Series sort order,
> not alphabetically, but by a non-obvious way
> (Baby>Genesis>Super>Predator>Millennium)...
>
> --
>
> I want to select about 25 rows from a table, and sort them by two
> criteria. First, by each row's Series field ("Baby", "Genesis", "Super",
> "Predator", "Millennium" are the various Series, and the order I'd like
> the rows in the array). Within each Series, I'd like the rows sorted by
> their Price field, ascending. For example:
>
> Baby $5
> Baby $10
> Baby $15
> Genesis $20
> Genesis $35
> Genesis $50
>
> ...and so on.
>
> Now, I know how to structure my MySQL Select statment such that the rows
> it pulls from the table will be either sorted by Price OR by Series, but
> not both, in the way I'd like. Does anyone know if it's possibly to do
> this in the Select statement itself? (I'd rather do it that way, than
> resort in PHP.)
>
> Thanks!
>
> ...Rene
>
> ---
> René Fournier
> [EMAIL PROTECTED]
>
>
> -
> 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 PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL ORDER BY or PHP Sort?
> Now, I know how to structure my MySQL Select statment such that the rows > it pulls from the table will be either sorted by Price OR by Series, but > not both, in the way I'd like. Does anyone know if it's possibly to do > this in the Select statement itself? (I'd rather do it that way, than > resort in PHP.) Id I understood you wrong, then ignore this post, but any other way just use ORDER BY series,price - this works good:) Cheers Siim Einfeldt - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Pictures in mysql
I know you most likely want to add the full source of teh pics to database, but this is nt a good idea. The best way would be to just write the picture location to the database. If you write the pictures itselves, then it will make the database rather big. I have one database over 45mb and all that only because of the pictures. Now making the backups, etc isnt too easy. Cheers S. > Hello friends. > > I am a newbie in mysql and web programming. > > Can someone please tell me where I can find some info on putting pictures > into mysql fields and also how I can use a web interface to add the > pictures to the database. > > Thanks > Denis > > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
lotus -> mysql
Hi, I need to convert lotus database to mysql, how to do it? Right now the lotus datbase in a text file...what can I do it now? Thanks Siim Einfeldt - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INET_ATON
I think this is supported from 3.23...not sure though, but might be:-)
> hey folks,
>
> i just tried using INET_ATON() and INET_NTOA() and i keep getting syntax
> errors
>
> near '("100.100.100.100")' at line 1
>
> no manner of quoting that i can think of solves this. i tried the examples
> at the bottom of http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
> and they got the same error.
>
> am i missing something easy here? is this a known issue? perhaps a version
> thing? i am running 3.22.32.
>
> thanks,
> mike
>
> -- mike cullerton
>
>
>
> -
> 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 PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dealing with datetime
Hi,
Just working here on a php-mysql project and came to a weird problem, See
this:
mysql_query("UPDATE trackvisits SET
hitcount=hitcount+1,refreshtime=now(),lastlength=now()-arrivetime WHERE
username='$visitor'");
Especially notice the lastlength=now()-arrivetime . Both lastlength and
arrivetime are datetime fields, so at least in theory this query should
update the lastlength field and set it to the right value
(=now()-arrivetime), but it actually just sets the lastlength value to
-00-00 00:00:00 . The arrivetime does have just a bit smaller value
than now(), at least some minutes.
Any idea why this might not work?
Thanks
Siim EInfeldt
Itpunk music Web
www.itmusicweb.co.uk
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Escaping #
Hi,
I have loads of # characters in my database and now I need to make a
duplicate of it (so assumably will have to escape the needed chracters
manually), but how could I escape #? Generally speaking it should be \#,
right? But if do two INSERTs in a row for example:
INSERT INTO table (one) VALUES ('\#something');
INSERT INTO table (one) VALUES ('\#somethingelse');
It gives an error, it still thinks # is ment as a comment. What would be
the solution?
Thanks
Siim EInfeldt
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can you Help me? I have Appostroph problem
> select ID from table where sentence = '".does't take."' I think that should do the trick. Or if not...hopefully you're using mysql in combination with some other programming languages like asp or php or...in php you just use addslashes() function bvefore sending a query to mysql. Cheers Siim - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User table problem
Hi, I have a problem with mysql users. I can`t connect to database with any user when I use password. Eg, if from the command line I try to connect like mysql -h myhost -u myuser -p and then on the password line write my password, it gives permission denied... If I try to go in just without password, I can get in, but this I don`t have lots of permissions. The problem exists in all users, including root. The passwords have been set, that`s for sure and it even used to workany ideas what might be wrong? Thanks Siim Einfeldt - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error 127 from table header !!!
Try REPAIR TABLE absences; This should do the trick:-) > Hy! > > I have a problem I couldn't solve by my one. Here is a sample of mysql > client output: > > mysql> use lumina; > Database changed > mysql> select * from absences; > ERROR 1030: Got error 127 from table handler > > The table absences exists. I tried to delete it and create it again and I > get the same error. What is wrong? > > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how do you select by date?
.WHERE monthcol=MONTH(now()). I think this should work. > Hi =) > > Could you help? I have a table with a datetime field and I'm trying to > figure out how to format an SQL query to select records only from within > the current month. Any help would be greatly appreciated. > > Thanks, > > -Ed > > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unable to save result ...
Hi-
I just crashed my computer and after restart it gives me this message on
some SELECT queries:
Warning: MySQL: Unable to save result set in
c:/apache/htdocs/neobt/otherservices.php3 on line 382
On line 382 I have: $gething = mysql_query("SELECT * FROM etc WHERE
type='transfer' AND subid='type4'"); But that`s just one example of very
many...
What might the problem be?
Thanks
Siim Einfeldt
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: Creative solution with XML,PHP,MYSQL
> Maybe Flash is an option? Well, I know I could probably do it some way in flash (if I had experiences with it), but this is just a bit out 'of the box'. But still, thanks for offering. Siim - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creative solution with XML,PHP,MYSQL
But I`m pretty sure it is possible with XML, in theory at least, I get the data from the database, I write it into array, put into xml and then deal with it - that`s how I imagine it. DHTML doesn`t seem the best way to do it...but then maybe it`s just me. cheers Siim Einfeldt > I'm afraid XML isn't going to help you - you need to investigate DHTML > options, although you'll be lucky to find a solution which is > compatible across both Netscape and IE. > > regards, > > P > > On Sat, 17 Feb 2001, Siim Einfeldt > aka Itpunk wrote: > > > Hi everybody, > > > > I want to implement ordering something on a website without refreshing the > > page. Lets say i have four columns in the html table - name,age,skill and > > phone. All these are links - under these are the information, eg: > > Name Age Skill Phone > > Siim 23 php 051... > > Tony 18 html 132... > > > > Now, when i click on the name, it should order the listings by name, if I > > click on the age, I get the listing ordered by age and etc,etc. Generally > > it is easy to do it, but how to do it without refreshing the page every > > time I want to order by something else? > > > > It should be possible with XML; I get the data from mysql database with > > php, I write it into an array and ... now how could I make it function the > > way I just described? Could someone point me some already written code or > > explain me in detail how to do it? > > > > > > Thank you, > > Siim Einfeldt > > > > PS: Sorry about sending this message to so many lists, but I haven`t seen > > this kind of code anywhere, but at the same time I know it is possible. > > > > > > - > > 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 PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creative solution with XML,PHP,MYSQL
Hi everybody, I want to implement ordering something on a website without refreshing the page. Lets say i have four columns in the html table - name,age,skill and phone. All these are links - under these are the information, eg: Name Age Skill Phone Siim 23 php 051... Tony 18 html 132... Now, when i click on the name, it should order the listings by name, if I click on the age, I get the listing ordered by age and etc,etc. Generally it is easy to do it, but how to do it without refreshing the page every time I want to order by something else? It should be possible with XML; I get the data from mysql database with php, I write it into an array and ... now how could I make it function the way I just described? Could someone point me some already written code or explain me in detail how to do it? Thank you, Siim Einfeldt PS: Sorry about sending this message to so many lists, but I haven`t seen this kind of code anywhere, but at the same time I know it is possible. - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL statement in PHP
Take a look at your query once again: "select/../"Consultancy"/.../" You can have "" inside "". The ways to do it, so that it would work: -> use '$somethinghere' instead of "$something" or -> use \"$somethinghere\" instead of second "$something" or -> use '".$somthinghere."' instead of ... Cheers Siim Einfeldt > Can anybody help with this > > If I put the following statement in PHP my browser tells me that there is an > error on the line. > > //create sql statement > $sql = "select Business_Name,Trading_Details where Business_Type = > "Consultancy" and Bassingbourn != "0" from Main"; > > If I remove > > where Business_Type = "Consultancy" and Bassingbourn != "0" > > It work fine, but no variation of the above line works. Am I missing > something really obvious. Please help as I am very quickly becoming bald. > > > Matt. > > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems getting DISTINCT data
SELECT DISTINCT estitle,id,lepingid FROM main WHERE litsents='something' ORDER BY lepingid Now, lets suppose I have 20 entries with the exact same information (or at least estitle and lepingid are the same). What if I wanted to get only one entry with the same information? I could do it with LIMIT 1, but this case it would only give me one entry. But I have there entries with different estitles as well. So how could I manage to get entries only with different estitles? Thanks, Siim Einfeldt - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: turn $2000.00 into $1600.00 in 14 days
I get an awful lot of spam to my private email as well, I could filter them, but does anyone know what is the best way to actually get to know where and from who the email has come from (as the from addresses lie 99% of the cases)? yeah, I know this is offtopic, but still! Siim Einfeldt > where i live this is illegal. > i hope these jerks don't have my email address. > can you do anything about this TEnon? > > > At 11:14 PM -0500 2/1/01, <[EMAIL PROTECTED]> wrote: > >New Concept in Gifting! > >Join A Team Of 6 And 7 Figure Earners > > > >The sole purpose of this Activity is to enable us to bless more > >people and to change lives by helping others receive gifts, which > >will enable the receiver to share their blessings with others! > > > >* Gift $2000 to prosper over $16,000 > > > >* No dues or membership fees > > > >* Introduce only two into this private activity > > > >* No purchases, no quotas, no selling! > > > >* No meetings, conference calls, no pressure! > > > >* Participation is by invitation only and of your own free will. > > > >* 6 & 7 figure income earners as leadership > > > >Interested? The program is moving fast call 1-310-706-2050 ext. 4594 > >for more details. > > > >Please leave your: > > > >Name > >Email address > >Phone number (with area code) > >Time zone and best time to call > > > >1 310 706 2050 ext. 4594 > >24 hours a day > > > > > >To be removed send an email to: [EMAIL PROTECTED] > > > >- > >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 PROTECTED]> > >To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: New DBTools version Available
Thank you. > Both things are really implemented, in one way or another. > > To secure your servers parms just uncheck Save Password in the > Options=>Preferences. This way every time you start DBTools it will ask you > the passwords to connect. > > Importing from MSEXCEL it's already done and working. Just choose XLS files > in the wizard and point the location to the directory where your files are > in. > > Let me know if these worked. > Hope this helps. > > Crercio O. Silva > > -----Original Message- > From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]] > Sent: quarta-feira, 10 de janeiro de 2001 20:01 > To: Crercio Osmaildo da Silva > Subject: Re: New DBTools version Available > > > > > Some suggestions about the features that could be thought about in the > future: > -> the program should be accessible only with password > -> Import wizard for getting data out of excel file > > > cheers > Siim Einfeldt > > > > > > - Added a HTML help system > > - Fixed bugs in the Import and Import Text Wizard > > - Added mysql_escape_string to the import/export wizards > > - Fixed some memory leaks > > - New mySQL data access object to make DBTools more reliable and faster > > > > You can see all the news/changes and download the new version at > > http://dbtools.vila.bol.com.br > > > > DBTools is a Win32 application to manage mySQL Databases. Here's some > > features: > > > > - Totally Free > > - Manage Databases,Tables, Columns, Indexes and Users > > - Query Editor to run multiple statements at once > > - User Privilege manager > > - Import Wizard to import data/structure from > > MSAccess/FoxPro/Dbase/Clipper/Paradox/ODBC datasources > > - Import Text Wizard to import from fixed and delimited text files > > - Export Wizard to dump in delimited text or SQL files > > > > See all the features and get more information at our website. > > > > []'s > > > > Crercio O. Silva > > > > > > > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
