Re: Re: Fwd: Re: [PHP-DB] search error

2006-11-24 Thread chris smith

--
$query1 = "SELECT distinct link_id, url, title, description,  $fulltxt, size
FROM ".$mysql_table_prefix."links WHERE link_id in ($inlist)";
  $result = mysql_query($query1);
  echo mysql_error();


and what does $fulltxt contain when you get the error?

I suspect you have a problem with the quotes in that string.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Fwd: Re: Fwd: Re: [PHP-DB] search error

2006-11-22 Thread Asif Qureshi


Note: forwarded message attached.
 
-
Sponsored Link

Mortgage rates near 39yr lows. $420,000 Mortgage for $1,399/mo - Calculate new 
house payment--- Begin Message ---
I have this code already, have a look at this few lines of code, which is 
already existing.
  --  
  $query1 = "SELECT distinct link_id, url, title, description,  $fulltxt, size 
FROM ".$mysql_table_prefix."links WHERE link_id in ($inlist)";
  $result = mysql_query($query1);
  echo mysql_error();
  -
  I have experience of past I would get number of responses, and php database 
mailing list had many members world wide, only single response, why?
  --
  In previous code, posted, can you have a look in case tables have been joined 
properly to respond to query and give proper search results.
  

Chris <[EMAIL PROTECTED]> wrote:
  Asif Qureshi wrote:
> Here I narrow down the problem.

I meant narrow down the problem in your code.

Add

echo "mysql error? " . mysql_error() . "
";

after your mysql_query calls for example.

-- 
Postgresql & php tutorials
http://www.designmagick.com/


 
-
Everyone is raving about the all-new Yahoo! Mail beta.--- End Message ---
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Fwd: Re: [PHP-DB] search error

2006-11-22 Thread Chris

Asif Qureshi wrote:

Here I narrow down the problem.


I meant narrow down the problem in your code.

Add

echo "mysql error? " . mysql_error() . "";

after your mysql_query calls for example.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php