RE: Join Suddenly Failing

2010-01-22 Thread Scott Swaim
so that only the last table (i.e. teamperson) was used for your JOIN Scott Swaim I.T. Director Total Care / Joshua Family Medical Care (817) 297-4455 Website: www.totalcareclinic.com NOTICE: The information contained in this e-mail is privileged and confidential and is intended

RE: SELECT by day

2009-09-29 Thread Scott Swaim
Try this SELECT * FROM `table_anw` WHERE DAYOFWEEK(datum) = 3; Scott Swaim I.T. Director Total Care / Joshua Family Medical Care (817) 297-4455 Website: www.totalcareclinic.com NOTICE: The information contained in this e-mail is privileged and confidential and is intended for the exclusive

Import a text file

2007-07-06 Thread Scott Swaim
the program Or write a script that adds a comma to the correct location. Does anyone have any suggestions or already have something that does this? Thanks in Advanced Scott Swaim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

reuse a results set

2004-04-21 Thread Scott Swaim
. but I can not figure out how to do this. If I use the mysql_free-result($qid_speaker) and then try to do the query again I get a mysql_fetch_object(): 12 is not a valid MYSQL result resource. TIA Scott Swaim Quality Corps, Inc.

Fw: reuse a results set

2004-04-21 Thread Scott Swaim
can not figure out how to do this. If I use the mysql_free-result($qid_speaker) and then try to do the query again I get a mysql_fetch_object(): 12 is not a valid MYSQL result resource. TIA Scott Swaim Quality Corps, Inc.

reuse results set

2004-04-21 Thread Scott Swaim
can not figure out how to do this. If I use the mysql_free-result($qid_speaker) and then try to do the query again I get a mysql_fetch_object(): 12 is not a valid MYSQL result resource. TIA Scott Swaim Quality Corps, Inc.

re-using a results set

2004-04-21 Thread Scott Swaim
. but I can not figure out how to do this. If I use the mysql_free-result($qid_speaker) and then try to do the query again I get a mysql_fetch_object(): 12 is not a valid MYSQL result resource. TIA Scott Swaim Quality Corps, Inc.

reuse a results set

2004-04-21 Thread Scott Swaim
can not figure out how to do this. If I use the mysql_free-result($qid_speaker) and then try to do the query again I get a mysql_fetch_object(): 12 is not a valid MYSQL result resource. TIA Scott Swaim Quality Corps, Inc.

sorry for the multiple post. my error

2004-04-21 Thread Scott Swaim

Re: re-using a results set

2004-04-21 Thread Scott Swaim
://www.php.net/mysql_data_seek -Original Message- From: Scott Swaim [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 2:47 PM To: Mysql Subject: re-using a results set I have a form that does the following ? while ($speaker = mysql_fetch_object($qid_speaker