Although you can store large binary data blobs (such as MP3s) in a database, I recommend you store the media files as normal files in the filesystem. Use the database to store meta data--that is data...

Yes, you can script a solution. The question then is, what programming languages are you comfortable with? If you are not a programmer, then you need to find one.

You can use ODBC drivers to...

MySQL does not have a direct function to produce this, but you may find the RAND() function helpful. Find RAND() on this page:
http://dev.mysql.com/doc/refman/4.1/en/mathematical-functions.html
...

I think you'll find my WAMP HOWTO (http://www.troywolf.com/articles/wamp_howto.htm) answers most of those questions. It is complete with PHP code examples to connect to your database.

I am running MySQL version 3.23.58. I copied and pasted your CREATE statement into a query window and executed it. It created the table successfully.

I don't KNOW what the problem is for you, but...

The error you describe sounds like it results from the mysql_select_db() (http://www.php.net/manual/en/function.mysql-select-db.php) function. If that's the case, am I to assume your mysql_connect()...

Thanks for the info and the link. The page at that link sells me on sticking with MyISAM I think.

And if what you describe is true, depending on the write frequency of a table, the row-level locking may be faster because additional updates are not waiting for the entire table to unlock. Sounds...

I'm very interested in this answer, too. Hopefully some light will be shed on this thread.

What version of MySql? 4.1 and newer support subqueries. If your version support subqueries, you can do something like this:

select *
from mytable
where a = 147
and id not in (select b from...

Dani,

My customer's MySql db's are tiny--nothing like your 1GB monster. ;) I simply use the mysqldump (http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html)command. As you most surely know, this...

I've looked into this "issue" myself a few times. First, I've been doing this long enough to vouch that you really do want to specificy exact columns. I only use '*' in my quick & dirty test code.
...

If you are comfortable doing so, email me the query you are using along with a display of the dataset you are getting. You can create the dataset display using code like this:
echo "<pre>\n";...

To make sure we are on the same page, you do understand why--right? If I have one event and 10 players and 5 of the players are signed up for the event, if I execute a query asking for all events and...

I'm fairly confident it is not possible to achieve what you want with a single query. Other SQL gurus are welcome to jump in to prove me wrong. ;)

If you are comfortable with PHP, what you...

Well, without fully knowing your business, first, I'd make those start, end, and added columns type DATETIME. I'd adjust my logic to store actual timestamps in those columns. That way, the data is...

I only got Bob, and you should only get Bob. Look at your sample data--the only player referenced in the attendance table is Bob. Since we are INNER JOINing with attendance, we'll only get players...

Sam, good work sending me the full structure with sample data. I simply ran that against my MySql server and ended up with your 3 tables and the sample data. Then I ran the original query I sent you....

The best I can gather from the documentation is that "signed" or "unsigned" refers to the plus or minus sign a person would traditionally use to indicate a positive or negative value. So an UNSIGNED...

For simply comparing 2 lists of words for matches, I'd leave the database out of it. You can store your results or the keywords in the database if you want, but for the actual comparison, check out...

It's called a "Cartesian product".
Mathematical explanation: http://en.wikipedia.org/wiki/Cartesian_product
SQL explanation: http://www.fluffycat.com/SQL/Cartesian-Joins/

Try this:...

I'm not exactly sure what you mean by "running the query through XML". I understand that MSSQL Server has an XML method to query--so maybe you are using that....in any case....

The query you show...

I think you are getting it, but I'm not sure. The points I'm trying to make are:

1. If you want to allow a user to be able to select more than one item in a SELECT list, you must use the MULTIPLE...

I'm so used to people developing against MySQL using PHP. I ignored the fact that in your earlier post, you posted ASP code. Sorry!

So do this in you HTML:

<select name="car" MULTIPLE>
...

If you have a select with options like so:

[All Cars]
Acura
Chevy
Ford
Toyota

It does not makes sense to select "[All Cars]" and "Ford", for example.

Um....Kennedy_f, what are you talking about? It seems like you are replying to a SQL Server related thread, but your post is a new thread in the MySQL forum! :eek: What's up?

This is a rather common thing, to have a dropdown list of options and you want the user to be able to select one or [All Options]. A common way to handle this is like so:

<select name="cars">
...

You could use a subquery, but subqueries are not supported in MySQL until 4.1. Many hosting companes are running 3.2, 3.3, or 3.4. What version of MySQL do you have? (PHP's phpinfo() command will...

Thank you for typing out your words. I'm not trying to hassle you--believe me, but some more tips to help you get good replies here on Daniweb or any forum:

Don't paste so much code to ask a...

Are the vowels missing on your keyboard? No, it seems your code snippet contains vowels. Is that txt msg speak? I guess I'm too old (at 33) to interpret. I definitely have no idea what "sth" means.

Your question is constructed in way making it difficult to read, but I have 1 thing for you.

"table" is a reserved word in MySQL (http://dev.mysql.com/doc/mysql/en/reserved-words.html). You should...

Well, to get started with MySQL, I recommend you go check out my WAMP HOWTO at http://www.troywolf.com/articles. You can just skip to the MySQL part if that is all you need.

I'm making the...

I was hoping someone with more specific experience would reply, but so far no takers.

Well....I am very experienced with both MSSQL and MySQL. ANSI standard SQL is the same on all RDBMS. However,...

ATTENTION ALL NEWBIES!

"supplied argument is not a valid MySQL resource" is almost always the result of an invalid SQL statement being passed to the database. When you are using a scripting...

If you only have 30 rows, just use normal search methods like:

$sql = "select name, age, sex from people where name like '%".$searchvar."%'";

You don't need fulltext indexes to search, but they...

I would think you would have done the same thing, but I started by going to www.mysql.org (http://www.mysql.org). I clicked downloads, scolled down to the full Windows Installer...ended up at this...

You have to have minimum three rows to get results with full text indexes. Really, you want more than that to get decent results. Thing is, MySQL tries to be smart and automatically ignores words...

Do not worry about the second error. The first error is causing the second. Fix the first, and the second goes away.

"Warning: Supplied argument is not a valid MySQL result" is exactly that--an...

Unfortunately, I do not know about the raw MySql files, so I can't answer that question. Hopefully another guru will reply with a solid answer about that.

What I can offer you is to tell you that...

First of all, it sounds like you don't have any graphical interface for MySql currently. Do you have phpMyAdmin? If not, GET IT!
http://www.phpmyadmin.net/home_page/

phpMyAdmin is a PHP...