Re: Re: Pear DB or mySQL problem

I verified that running in mySQL client works .... But for a PHP page, it does not. - K "Bob Bell" <bobbell@zk3.dec.com> wrote in message news:20020923120129.GA102629@zk3.dec.com... > It works for me both directly via the mysql client *AND* with the PHP > mysql code you give below. mysql 3.23.51 and php 4.2.1. > > On Mon, Sep 23, 2002 at 04:47:12AM -0700, Kerry Kobashi <kkobashi@thegrid.net> wrote: > > Its not PEAR... as I wrote straight mySQL code ... I get the same result on > > successive calls > > Its almost as if the cursor for mySQL is stuck at either the first or last > > position in my table...... > > > > $link = mysql_connect($dbHost, $dbUser, $dbPassword) or die("Could not > > connect"); > > print "Connected successfully"; > > mysql_select_db($dbName) or die("Could not select database"); > > > > $query = "select * from quotations order by rand() limit 1"; > > $result = mysql_query($query) or die("Query failed"); > > $line = mysql_fetch_row($result); > > echo $line[1]; > > mysql_close($link); > > > > Is it a PHP or mySQL problem? > > > > > > "Kerry Kobashi" <kkobashi@thegrid.net> wrote in message > > news:20020923102358.96656.qmail@pb1.pair.com... > > > Windows NT 4.0 > > > IIS 4.0 > > > PHP 4.2.2 > > > mySQL 3.23.52 > > > Using PEAR > > > > > > $sql = "select * from $tablename order by rand() limit 1"; > > > $db->query($sql); > > > > > > I continue to get the same record > > > > > > > > > > > > > > -- > Bob Bell <bobbell@zk3.dec.com> > ------------------------------------------------------------------------- > "UNIX *is* user friendly. > It's just selective about who its friends are." > -- Author unknown