RE: [PHP-DB] MySQL looks cached.

Thanks Russell and Steve. I forgot to add that this db call is working for about 5 other queries strings. So far this is the only string that isn't working. John On Wed, 17 Jan 2001, Steve Brett wrote: > don't know about mysql but in postgres echoing $the_call will return the id > of the resource. > > if you want the query result then you'll have to fetch that from $the_query > using something like > > $results = pg_fetch_array($thequery, 0) [substitute the mysql version of > pg_fetch) > > which will return the record at row 0 (result sets are zero indexed) as an > associative array. > > Steve > > > -----Original Message----- > > From: John Starkey [mailto:jstarkey@advancecreations.com] > > Sent: 17 January 2001 09:19 > > To: php-db@lists.php.net > > Subject: [PHP-DB] MySQL looks cached. > > > > > > I admit my newbie status but this is really odd even for me. :} > > > > I'm returning an int from MySQL. No matter what that number is it's > > returning as 3 until I refresh, when it becomes two. And on > > each refresh > > after that it toggles between 2-3. > > > > I've checked my functions by redeclaring the var right after > > the db call > > and everything is working fine. > > > > $the_query = "SELECT $something FROM somewhere WHERE > > RowName='$rowname'"; > > $the_call = mysql($db, $the_query); > > > > echo $the_call; > > > > Will rturn 2's and 3's as i stated above. UNLESS i redeclare $the_call > > before the echo. > > > > Any see what I'm doing wrong? > > > > Thanks, > > > > John > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > >