RE: [PHP-DB] Dynamic SQL + result resource error

2001-07-08 Thread Mats Remman
wordsarray); next($wordsarray); $sql=$sql."$word)"; $i++; } bit into something like this $sep = ""; foreach( $wordsarray as $v ) { $sql .= $sep." $word "; $sep = " OR band LIKE "; } $sql .= ")"; Then retry the queries. oh an

RE: [PHP-DB] Newbie:Backend scripts

2001-07-06 Thread Mats Remman
windows 2000 has a command called 'at' .. which is somewhat like crontab. and there is no reason to run lynx and whatever. php for windows has an exe for a reason 'php.exe c:\path\to\phpfile.php' schedule that every two hours. Mats Remman PHP Developer/Mysql DBA Coretrek,

RE: [PHP-DB] Authomatic Sorting

2001-07-04 Thread Mats Remman
ql_fetch_row($res)) { echo "user id $i - username ".$row[0]; $i++; } this would print a list from 001 - 065 with every username in it. Mats Remman PHP Developer/Mysql DBA Coretrek, Norway +47 51978597 / +47 916 23566 > -Original Message- > From: Wilmar PĂ©rez [ma

RE: [PHP-DB] sql problem

2001-06-26 Thread Mats Remman
nd the database can be held to a minimum. Mats Remman PHP Developer, MySQL DBA Coretrek, Norway +47 51978591 / +47 91623566 > -Original Message- > From: Fai [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 26, 2001 5:55 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] sql p

RE: [PHP-DB] newbie: Trying to select a database in php

2001-06-20 Thread Mats Remman
Should be obvious here that you have a typo :) replace msql_select_db() with mysql_select_db() ;Mats Remman > -Original Message- > From: Paul Lockyer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 20, 2001 10:07 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] ne

RE: [PHP-DB] Am I missing something important here ?

2001-05-24 Thread Mats Remman
Oh my.. seems i didnt see the reference of $queryresult. ignore my comment :) but the first mysql_query is useless. ;Mats > -Original Message- > From: Mats Remman [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 24, 2001 12:35 PM > To: annabelle.imray; [EMAIL PROTECTED] &

RE: [PHP-DB] Am I missing something important here ?

2001-05-24 Thread Mats Remman
Your problem here is simply that the $queryresult gets lost in the function. It is never returned. change return true; into return $queryresult; Mats Remman > -Original Message- > From: annabelle.imray [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 24, 2001 1:02 AM >