Re: MySQL ORDER BY or PHP Sort?

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

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

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

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

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

dealing with datetime

. 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

Escaping #

) 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

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

User table problem

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

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

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

unable to save result ...

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

Creative solution with XML,PHP,MYSQL

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

Re: SQL statement in PHP

ghere\" 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

problems getting DISTINCT data

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

Re: turn $2000.00 into $1600.00 in 14 days

Thanks, I`ll try it out. - Original Message - From: "Aaron Williams" [EMAIL PROTECTED] To: "Siim Einfeldt aka Itpunk" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 02, 2001 10:55 PM Subject: Re: turn $2000.00 into $1600.00 in 14 days At 10:25 P

DbTools question/feature suggestion (EXCEL)

excel column X and write this to another column in the database table". It would be really great to have these features as well, this would make things much easier. So if possible, I would appreciate it. Or does anyone know of any other free tools that could handle it? Thanks Siim Einfe