what does the code that displays the results look like?
jim
----- Original Message -----
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Mark Sweeney" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 3:20 PM
Subject: Re: [PHP-WIN] Search Engine Problem
> I am using this piece of code to display news articles based on the
variables inputted by a user. However, it will only
> display one article, never more, even if more are within the terms of the
"WHERE" clause. What am I doing wrong?
>
> $search = mysql_query("SELECT news.ID, newstitle, newsdescription,
newsdate, author, email FROM news, authors WHERE
> $name LIKE '%$value%' AND authors.ID=AID ORDER BY news.ID DESC");
> if (!search) {
> echo("<p>Sorry, there are no matches for what you are looking for. Please
try again</p>");
> exit();
> }
>
>
>
> Mark,
> This piece of code interrogates MySQL and responds with a "result
identifier resource" or ResourceSet or ResultSet or
> RecordSet, depending upon your terminology. How do you thereafter 'unpack'
the rows from the resource set - using for eg
> mysql_fetch_assoc()? (else see manual)
> Have you tried copying that SELECT statement (substituting values
appropriately) and running it under native SQL or in a
> 'management tool', to be sure it actually works (regardless of PHP)?
> Regards,
> =dn
>
>
> --
> PHP Windows 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 Windows 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]
