At 19:19 -0500 3/12/07, David T. Ashley wrote:
You might check out vBulletin. They might waive the license fee if
you ask nicely, or they may also have a policy when it is in support
of open-source software.
Hmmm - thanks for the suggestion, but this is strictly speaking a
commercial site, a
My apologies in advance if this is a bit off topic, but...
On a rather old site we have a dreadful old bulletin board system
based on Matt Wright's WWWBoard - all horrid text files and ancient
Perl code. We want to replace that with a decent forum system based
on MySQL and PHP, but there's no
At 13:19 -0800 3/12/07, Jeremy Cole wrote:
I just finished it. There were 56 questions, not counting the final
"give us your name" stuff for the prize. Most of the questions were
mandatory.
This seems to be a "fill out the form" type of survey system rather
than a self-adjusting system base
At 19:34 +0200 19/9/07, thomas Armstrong wrote:
I've got this table in mySQL:
item 1:
-- firstname: John (Johnie)
-- phone: 555-600-200
item 2:
-- firstname: Peter
-- phone: 555-300-400
I created this SQL query to find 'johnie':
SELECT friends.id FROM friends WHERE ((f
At 16:35 -0500 15/9/07, Mahmoud Badreddine wrote:
In one of my php scripts I make 2 successive calls of mysql_fetch_row using
the same Mysql Result.
In the first call the desired result is achieved, but in the second one it
isn't.
I have something like
while($someArr=mysql_fetch_row($result))
{
At 13:34 -0400 10/9/07, Baron Schwartz wrote:
Looks like you've found the solution you need. The only other
suggestion I have is to use UNION ALL if you don't need to eliminate
duplicate rows in the UNION, because there's some overhead for
checking for them.
Hi Baron
Thanks for this, and I
At 11:01 -0400 10/9/07, Baron Schwartz wrote:
The entire UNION can then be ordered by relevance. You could also
just add in an arbitrary number in each UNION, to get the effect of
ordering by where in the hierarchy the match is found.
Actually, your pointing me towards UNION may have done the
At 11:01 -0400 10/9/07, Baron Schwartz wrote:
>I've built similar systems with a series of UNION queries. Each UNION has a
>column for "relevance", which can be a sum of CASE statements, such as
>
>IF(, 1, 0) + IF(, 1, 0) AS relevance...
>
>The entire UNION can then be ordered by relevance. You
I'm sure there must be an accepted technique for this, but it's
something I haven't tried before, so if anyone can point me in the
right direction I'd be grateful.
I'm writing a search facility for a site where the data is stored in
several tables - let's say 5 for this example - and I want to
At 17:37 -0700 7/10/06, Cabbar Duzayak wrote:
I am using mysql_pconnect from PHP to connect to our mysql server.
...
Is there a way to configure mysql so that it will kill a process after
a certain period of idle time, just like Apache does?
I may be barking up the wrong tree here, but as I
At 15:01 -0700 7/10/06, David Blomstrom wrote:
Thanks. Is this something I can do through phpMyAdmin?
Yes! Easy:
First, create the database - just the database, no tables or anything
- on the Mac.
Next, go to the database on the PC in phpMyAdmin and without
selecting a table in the sidebar
Pe 27 Sep 2006, la 10:29, Chris <[EMAIL PROTECTED]> a scris:
>Did you try using a space (' ') as the separator? Did you get an error?
And at 7:41 + 27/9/06, [EMAIL PROTECTED] wrote:
Yes, I did.
...
So, I need to specify somehow that the fields are delimited by any
number of spaces...
At 11:40 -0400 26/9/06, Zembower, Kevin wrote:
IF(ISNULL(SELECT lv.langversionid
FROM langversion AS lv
JOIN baseitem AS b3 ON lv.baseitemid =
b3.baseitemid
WHERE lv.langid = "1"
AND b.baseitemid = lv.basei
At 10:41 +0200 15/9/06, Dominik Klein wrote:
I have a table with primary key "id". Another field is "date". Now I
want the last n entries, sorted by "date".
Is this possible in one SQL statement?
ORDER BY `date` DESC LIMIT n
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.c
No, I don't generally go along with underhand political activity. :-)
(but I expect that's an old joke - I haven't been MySQLing all that
long, you see...)
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Any inaccuracies in this index may be explained by the fact
that
At 8:49 -0500 9/8/06, Dan Buettner wrote:
Chris, I'm not aware of a way to use "ordinary" SQL (insert, update)
for this, but the use of a stored procedure would work for you. I've
not done it with MySQL (never had a need) but did things like this
extensively with Sybase.
In rough terms:
CREATE
I have a field representing the chances the user has to get a
password right, which is initially 3. I would like, if possible in a
single query, to be able to decrement it if it's still > 0 and return
the value. Something like this:
UPDATE table
SET chances = IF(chances > 0, chances - 1, 0)
WH
At 1:00 +0200 4/8/06, Johan Höök wrote:
what you can do is:
SELECT [fields]
FROM [table]
WHERE id IN (id1,id2,id3...)
ORDER BY FIELD([field],value1,value2,value3,...)
Ooh - so I can. I didn't know that wrinkle for
order by - though I did wonder if something like
that should be possible.
Th
Yes, I have looked at the docs and can't find what I'm looking for.
I'm doing a very simple query:
SELECT [fields]
FROM [table]
WHERE id IN (id1,id2,id3...)
Is there a way to return the results in the order they appear in the IN list?
I'm sure there's something obvious and simple, but as a rel
At 11:10 +0200 30/7/06, Jørn Dahl-Stamnes wrote:
select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as
rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner
join participants as p on (p.race_id=r.id) where s.receipt=1 and
p.rider_id=236 and fee > 0 grou
At 17:31 -0700 23/7/06, [EMAIL PROTECTED] wrote:
The logic is that it follows the natural spoken format, i.e.
"July 23, 2006"; which became the written standard; which...
Hmmm. Is 'July the 23rd, 2006' any more natural to say than 'the 23rd
of July, 2006'? I think we probably say either, equal
At 15:43 +0100 23/7/06, John Berman wrote:
I have a table called: submissions and each record has an approvedate field
which stores the date mm/dd/
Why? If you're storing the date in this format you can only be
storing it as a string (char, varchar or text), so no wonder you're
having tro
At 14:16 +0200 18/7/06, Mike van Hoof wrote:
And for the everything in utf8... will try this next time i get this
kind of a problem...
When you do, you'll need to send out the proper header from your php scripts:
header ('Content-type: text/html; charset="UTF-8"');
and put this in your MySQL c
At 13:40 +0200 18/7/06, Mike van Hoof wrote:
Well.. gonna try some text-converting in php then...
And yeah, it really needs to be a blob field... not my choice, but
we got a CMS which operates on field types from MySQL... and a blob
field wil generate an WYSIWYG field... but i think i am going
I've found something that works (in MySQL 5, anyway), but I don't
know whether it's accepted practice.
If I want to find all records with a date in, say, March 2006, it
works if I use "datefield like '2006-03%'" because it's a string.
This seems kind of obvious and a lot tidier than doing "da
At 20:27 +0800 9/7/06, M & B Neretlis wrote:
the order comes out of sequence showing 10.11.12.13 etc before the number 2---
Can anyone help me out
$query = @mysql_query("SELECT * FROM tips WHERE user_id = $user_id
AND comp_id = $comp_id ORDER by round DESC");
while ($result = @mysql_fetch_a
At 16:13 +0100 29/6/06, Pooly wrote:
If you know the picid previously retrieved, then the clause (caption
LIKE '%searchterm%' OR title LIKE '%searchterm%' OR blurb LIKE
'%searchterm%') is redundant, isn't it ?
No, because those details may well be different for different
instances of the same
At 22:04 +0100 28/6/06, I wrote:
I have two tables: pix and sections, the relevant bits of which are:
pix (2,421 rows):
picid varchar(7) not null
sectionid smallint(5) unsigned not null
caption text null
picid and sectionid are a joint primary key
I'm sure this is an elementary problem, but I can't get my head round it.
I have two tables: pix and sections, the relevant bits of which are:
pix (2,421 rows):
picid varchar(7) not null
sectionid smallint(5) unsigned not null
caption text null
pici
At 15:47 +0200 23/6/06, Jørn Dahl-Stamnes wrote:
Yes, I forgot to say that I was using PHP...
Oh, I think the clue was in the subject line. :-)
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Revolution: an abrupt change in the form of misgovernment.
-- Ambrose Bie
At 14:38 -0500 22/6/06, mos wrote:
If you want a more thorough book on PHP & MySQL there is:
PHP and MySQL Web Development (3rd Edition) (Developer's Library) (Paperback)
by Luke Welling, Laura Thomson
I can't speak about the third edition, as I got started using what
appears to be the first.
At 23:00 +0100 14/6/06, Graham Reeds wrote:
1) You may have a bogus hidden character in your SQL file. If you
look at it with a text editor (BBEdit, TextWrangler, etc), with the
"show invivisbles" feature on, do you see unusual stuff? Sounds
strange but I've seen stranger.
Took a brief look
I wrote:
> My problem isn't quite the same as the original poster's, but I
suspect the solution may be the same. However, I'm having trouble
> running the myisamchk command.
I'm using the Unix Terminal in Mac OS X, with MySQL 5.0.19, and it
won't let me get beyond a certain point in the
MySQL 5.0.19 running in Apache 2 on Mac OS X 10.4.6
I've been dipping my newbie toe into the murky waters of full text
searching, but not with a great deal of success. I have a complex
search set up which searches nine tables (potentially a whole bunch
more, but for the present purpose...), fi
At 7:38 -0500 8/6/06, Jimmy Guerrero wrote:
"The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my
sequel"), but we don't mind if you pronounce it as "my sequel" or in some
other localized way."
Miss Quill?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
At 15:19 +0100 7/6/06, Rob Desbois wrote:
With the CHANGE clause of ALTER TABLE statement, you must provide
the column definition, so something like this is what you need:
ALTER TABLE actors CHANGE director_id actor_id MEDIUMINT UNSIGNED NOT NULL;
or whatever your original definition is.
Wo
At 0:09 +1000 8/6/06, Mark Sargent wrote:
ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);
for changing the name of a column, right? So, why doesn't the below work?
mysql> ALTER TABLE actors CHANGE director_id actor_id;
I'm no great expert myself, but off the top of my head, may
At 18:34 +0100 4/6/06, Chris Sansom wrote:
I'm stumped! How exactly do I go about this?
It's OK - I sorted it out. Turns out I needed to use upper case for
the .MYI. Doh!
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Old professors never die; they just
At 14:02 +0300 1/6/06, Remo Tex wrote:
If you change the character set when running MySQL, you must run
myisamchk -r -q --set-collation=collation_name on all MyISAM tables.
Hi
My problem isn't quite the same as the original poster's, but I
suspect the solution may be the same. However, I'm h
At 19:44 +1000 31/5/06, Logan, David (SST - Adelaide) wrote:
I would agree, I have found it useful as well. It does have a few
limitations (well the versions I've used)
Actually, having just mildly sung its praises, there do seem to be
some bugs in the latest version I installed on my local ma
OK, so I suggested phpMyAdmin.
Dan Trainor said:
I highly suggest staying away from PHPMyAdmin.
and, even more helpfully, 'Anthony' wrote:
:-\
Fine - from this I gather phpMyAdmin is perhaps not a Good Thing.
Now, giv
At 10:23 +0200 30/5/06, Anthony wrote:
:-\
Very helpful - thanks.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
What contemptible scoundrel has stolen the cork to my lunch?
-- W.C. Fields
-
At 14:02 -0700 29/5/06, Dan Trainor wrote:
I highly suggest staying away from PHPMyAdmin.
Why in particular?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
The world is proof that God is a committee.
-- Bob Stokes
--
MySQL General Mailing List
For list archives:
At 12:31 -0700 29/5/06, AndrewMcHorney wrote:
I understand that there is a free gui that will allow an
administrator or user to create databases and maybe even add, update
and modify rows in tables. It is something like MySQL Controller.
Does this still exist and what is the link?
Maybe you'r
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE content.page_id = page.id
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE content.pa
At 22:10 +0100 20/5/06, Keith Roberts wrote:
Probably the most efficient place to do this sort of field
checking would be using javascript in the browser. That
would stop the bad addresses even being sent down the line
to the server in the first place.
Sure, but if you're being conscientious ab
At 12:29 -0500 16/5/06, Mike Blezien wrote:
trying to figure out why I keep getting this error with the following query:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS
mins FROM account a LEFT JOIN calls c ON c.account_id = a.id WHERE
c.calldate >= DATE_SUB(NOW(),INTERVAL 14
Following my post about this complex search I'm trying to do...
In the initial post I said I'd tried adding:
left join table_ga as tga on tga.id = r.id
left join table_a as ta on ta.ida = tga.ida
or:
left join (table_ga as tga inner join table_a as ta) on
(tga.id = r.id and ta.i
At 16:09 +0100 11/5/06, I wrote:
Not long ago, some highly knowledgeable people here kindly helped me
out with a fairly complex query...
...
That's all fine and dandy, but now I need to extend this to a
further four tables...
What I should have added is that for the moment this has to be
p
Not long ago, some highly knowledgeable people here kindly helped me
out with a fairly complex query...
Finding names of people (and other info) where one or more fields
match the search string in up to five tables (abstracting somewhat):
select distinct
id, firstname, lastname,
At 9:53 +0100 10/5/06, Critters wrote:
A user was able to log into my site using:
1' and '1' or '1
in the username and password box.
I ran the query
SELECT * FROM members WHERE name = '1' and '1' or '1' AND password =
'1' and '1' or '1'
And it returned all rows.
Interesting - I found just
At 13:28 -0400 9/5/06, Rhino wrote:
The reason you are getting so many rows has nothing to do with the
way you are using the count(*) function and adding the different
count() results together. The problem is that you are doing your
joins incorrectly... In your case, I think you need to change
Here comes a newbie question...
I want to get a total of entries from four tables which all match a
particular id. The result for the id I'm testing (21) should be 233.
In my naivety, I thought something like this would work:
select count(a.id) + count(b.id) + count(c.id) + count(d.guide_id)
At 11:10 -0500 25/4/06, gerald_clark wrote:
Yes. 3.23 was not correct in the order of precedence.
This has been answered many times here.
Sorry - I haven't been on the list all that long.
You need to change your comma join to an inner join.
Lovely! That's it - many thanks.
At 17:15 +0100 2
At 15:56 +0200 25/4/06, Barry wrote:
And you don't see any misdone queries when you echo them, right?
Hope you checked that.
Hi Barry
I was wrong about its being a PHP issue: it's
definitely a MySQL error. I realised I hadn't
handled the error in such a way that I could see
what it was, but
At 15:56 +0200 25/4/06, Barry wrote:
Updating is always such a bad idea ;P
Do you know: never touch a running system? ^_^
Hmmm...
And you don't see any misdone queries when you echo them, right?
Hope you checked that.
Yes, they look just fine - in any case they're unchanged from when it
wa
As a relative newbie, and an almost total newbie to the use of left
joins, I'm aware that there's some difference in the way joins work
between MySQL 3.x and 5.x, but in my ignorance I can't figure out
what the heck it is from reading the 'upgrading' pages on
dev.mysql.com.
When I first joine
I've just found convert()...
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
I used to think I was indecisive, but now I'm not so sure.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT
Having done my upgrade from version 3 to 5, I'm looking forward to
the benefits of language support beyond the confines of Western
Europe. However, it seems I need to convert the database I have now.
We have material in the database at the moment in English, Dutch,
Italian, Portuguese and Span
At 19:14 +0100 14/4/06, Philippe Poelvoorde wrote:
Have a serious look at :
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
There is many things likely to
At 19:14 +0100 14/4/06, Philippe Poelvoorde wrote:
Have a serious look at :
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
I will definitely do this. Me
At 8:32 -0700 13/4/06, paul rivers wrote:
Going from 3 to 5 can break a number of important things. For example, join
syntax semantics and precedence rules have changed since 3, and it is
certainly possible this could break your code in important and dramatic
ways.
You should plan on spending
At 11:56 +0200 13/4/06, Barry wrote:
Make a real downgradeable SQL Dump (without collations n stuff) and
have it saved.
Upgrade to MySQL 5.x and execute that sql dump.
Be warned that for example CONCAT behaves in a different way than in 3.x.
If you have PHP scripts with some functions in their
Our web host is currently running MySQL 3.23.something, but we're
shortly to be upgraded to MySQL 5.
Can I be sure that this is absolutely backwards compatible? Are there
any nastinesses lurking that I should know about that might cause my
databases to collapse in a heap? My use of MySQL (as m
At 17:20 +0200 11/4/06, Barry wrote:
Japanese say here: Ganbatte! (Do your best!)
Oh, so true! DYB! DYB! DYB!
Hmmm - now you've confused me a bit. Quoting from the section in
the DuBois book:
"...a LEFT JOIN forces the result set to contain a row for every
row in the left side table, wheth
At 17:05 +0200 11/4/06, Barry wrote:
Once you get a hang on JOINs you will love it =)
Yeah - it certainly seems promising. Better do some more reading!
Just remember:
everytime you do something like this: WHERE table1.id = table2.id
You will be safer and faster to use JOINs because that's wh
At 16:37 +0200 11/4/06, Barry wrote:
select [what you want]
from t1
LEFT JOIN t2 ON t2.id = t1.id
LEFT JOIN t3 ON t3.id = t1.id
LEFT JOIN t4 ON t4.id = t1.id
LEFT JOIN t5 ON t5.id = t1.id
LEFT JOIN t6 ON t6.id = t1.id
where
t2.text like '%search_term%' OR t3.text like '%search_term%' O
At 9:28 -0500 11/4/06, mos wrote:
If you keep it in 5 different tables, the search will be as
slow as molasses in January because of the joins. I'd recommend
using FullText search on the text field.
Hi Mike
Thanks for the rapid response! OK - I've set all those text fields as
FullTex
First I should say I'm using MySQL 3.23.x because that's what's
currently available on our host's server. An upgrade to 5.x is
promised any time now, but I'm not holding my breath! So, with that
in mind...
I'm trying to do quite a sophisticated search across several tables
and am running into
70 matches
Mail list logo
