Seeking Opinions

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]

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 (keywords) with

What's wrong with this code?

I have the following lines in my PHP doc. ?php mysql_select_db($database_TBAJobLink, $TBAJobLink); $updateSQL = sprintf(UPDATE JL_Resumes SET DateEdited=%s, Status=%s WHERE ResumeID=%s, $dateEdited, $status, $resumeID); mysql_query($updateSQL, $TBAJobLink) or die(mysql_error());

What's wrong with this code?

I have the following lines in my PHP doc. ?php mysql_select_db($database_TBAJobLink, $TBAJobLink); $updateSQL = sprintf(UPDATE JL_Resumes SET DateEdited=%s, Status=%s WHERE ResumeID=%s, $dateEdited, $status, $resumeID); mysql_query($updateSQL, $TBAJobLink) or die(mysql_error());

Multiple Select storing

-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

Test post to test new client

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

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 Achieve

Re: Analyze Dreaweaver's PHP/MySQL code

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 Kerr [EMAIL PROTECTED] wrote: Here are my questions... 1) Do I understand what's going on? 2) When I ECHO the variable created in Line 4

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

Keyword Searches

, 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.cancerreallysucks.org -- MySQL

Analyze Dreaweaver's PHP/MySQL code

on. And, maybe your answers will help others on the 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

Re: Keyword Searches

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 2004 14:26:22 -0500, Robb Kerr [EMAIL PROTECTED] wrote: Anyone created one? I've got a project that consists

What's Faster? MySQL Queries or PHP Loops?

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: http://lists.mysql.com/mysql

JOIN help

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.cancerreallysucks.org

List of associated records

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 Dreams

Display field of selected record from full table recordset

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

Select compare to current date

'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 http://www.digitaliguana.com

Random Record Retrieval

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 list archives: http

Fulltext searches

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://www.cancerreallysucks.org

Re: Fulltext searches

to search? With the FullText indexes you have only two match options are possible: MATCH(specs) AGAINST . . . and MATCH(manufacturer) AGAINST . . . If you're trying to search both at the same time you need a FULLTEXT index of (specs,manufacturer) Chris Robb Kerr wrote: Got

Receiving Emails

and 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

FULLTEXT search in form of MATCH...AGAINST

. 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 IGUANA Helping Digital Artists Achieve

Using PHP to copy tables

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 IGUANA Helping Digital Artists Achieve their Dreams http