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 m

Re: MySQL ORDER BY or PHP Sort?

x27;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

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 th

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

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 > a

dealing with datetime

t 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/

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, p

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 Sii

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 absence

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, >

unable to save result ...

#x27; 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://l

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:

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 >

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

"$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 > erro

problems getting DISTINCT data

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 posti

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 i

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

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

RE: New DBTools version Available

rom 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: