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
> 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, tha
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
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
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
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
arrivet
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) VALU
> 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
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
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
.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,
>
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='ty
> 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:
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...
N
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 '".$somthingh
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 LI
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
> wh
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:
19 matches
Mail list logo
