Re: Seeking Opinions

On Fri, 25 Nov 2005 10:44:44 -0800, Johan wrote: >> Option One >> Related tables. Table one (clipart pieces) contains ClipartID and >> ClipartName fields. Table two (keywords) contains KeywordID, ClipartID and >> Keyword fields. This option will create an incredibly large related table >> (keyword

Seeking Opinions

alternate suggestions. Robb Kerr Digital IGUANA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What's wrong with this code?

I have the following lines in my PHP doc. The three variables - $dateEdited, $status and $resumeID - are defined in the top of the page. I'm getting a return of. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right synta

What's wrong with this code?

I have the following lines in my PHP doc. The three variables - $dateEdited, $status and $resumeID - are defined in the top of the page. I'm getting a return of. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right synta

Multiple Select storing

Table = Users Fields = ID, int, auto-increment Name, text Address, text Interests, text Thanx in advance for any help you might provide. If anyone knows of anything written on configuring this type of system, please include a link. Robb Kerr Digital IGUANA

Re: Test post to test new client

Thanx for the posts. The software seems to work great. It's actually an addition to MS Outlook that allows it to be used as a news client so that you don't have to run MS Outlook Express just to check newsgroups. Thanx again, Robb Robb Kerr Digital IGUANA Helping Digital Artists Ach

Test post to test new client

I'm posting to test a new newsgroup client. Please post several replies. Thanx, Robb

Re: Analyze Dreaweaver's PHP/MySQL code

> Additionally, the mysql_fetch functions are simply returning a portion > of the result of your previously executed query, so the database isn't > re-queried every time you loop through it. > > Hope this helps! > > > > On Fri, 10 Sep 2004 16:12:06 -0500, Robb Ke

Re: Keyword Searches

t; matches whole words. > > I haven't even begun to look at doing a fulltext search on a > description field, I've assumed that it would be a more expensive > operation. Good luck, and I'd like to hear if you run into any good > ideas. > > > On Fri, 10 Sep 20

Analyze Dreaweaver's PHP/MySQL code

soc($variableDefiningTheQuery)" does this mean that the database is queried every time through the loop? 4) I can't find "mysql_fetch_assoc()" in the MySQL documentation. What's this command do? I know this is a long post and a lot of quesitons. Just trying to understand w

Keyword Searches

truct this site. Also, if anyone knows of an online or published tutorial on this type project, it would be welcome. Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerr

Advanced Query Wizard

with conditionals and sorting from many tables at once. It has made my life considerably easier so I wanted to pass on the information. https://www.advancedextensions.com/products.htm Thanx -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams

JOIN help

ion I need. Of course, this example is very simple and my "real" SELECTs will include WHEREs and ORDER BYs. Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancer

What's Faster? MySQL Queries or PHP Loops?

ed. BTW, I've also posted this on the PHP board. Thanx -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- MySQL General Mailing List For list archives: h

Display field of selected record from full table recordset

d for display relative to the field contents of another recordset? Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- MySQL General Mailing List For

List of associated records

store which records from Interests the member has checked in their record of the Members table? Do you create a TEXT field in the Members table and save a comma-delimited string of InterestsIDs? Thanx. -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their D

Select compare to current date

WHERE 'year-field' <= year of current date What's the syntax for "year of current date"? Thanx in advance for your help, Robb Kerr Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams -

Random Record Retrieval

there something simpler. Unfortunately I don't know how to write a random number generator in PHP. Thanx in advance, Robb -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- MySQL General Mailing List For

Receiving Emails

download them? And, 40tude seems to have sporadic problems talking with this board but works great with several others to which I am subscribed. Is there something peculiar about this software for which I must compensate? Thanx in advance for the help, Robb -- Robb Kerr Digital IGUANA Helping

Re: Fulltext searches

>> FULLTEXT KEY `manufacturer` (`manufacturer`) >> >>

Fulltext searches

However, when I conduct a search, I get the following error message returned... Can't find FULLTEXT index matching the column list What's the problem? Thanx in advance, Robb -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://

Using PHP to copy tables

and don't want them backing up to their hard drive. I prefer to simply copy the tables to "backup" versions on the server so that if problems arise, I can log into the server and simply copy the "backups" to the originals. Thanx in advance. -- Robb Kerr Digital IGUA

FULLTEXT search in form of MATCH...AGAINST

rks as expected. However when I use... SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('following') it doesn't return any results. I've got several tables with FULLTEXT indexes and on none of them can I get this syntax to work. What's up? -- Robb Kerr Digital IGUA