RE: [PHP-DB] MySQL looks cached.

[John Starkey]

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:[EMAIL PROTECTED]]
> > Sent: 17 January 2001 09:19
> > To: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: 
> > [EMAIL PROTECTED]
> > 
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] MySQL looks cached.

[John Starkey]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]