Posted by Howard on 02/14/06 23:04

The script runs but there is no data. I get blank page.

I copied the info for making a config.php file.
So I guess I want to try using an include statment to call those files and
see if
that works.
The scripts were copied right from the CD-ROM so I don't know why the
echo statements don't seem to be doing anything.

I put a require ('config.php') in the script. Still nothing shows up and no
errors in
the apache log.

I have a feeling that it has to do with a configuration file with php or
mysql.

Thanks So far

Howard


"David Haynes" <david.haynes2@sympatico.ca> wrote in message
news:LXnIf.23728$Hj6.11243@fe29.usenetserver.com...
> Dave Mennenoh wrote:
>>>> $query = select * from books where ".$searchtype." like
>>>> '%".$searchterm."%'" ;
>>
>> Besides missing the leading quotation mark, you might like to know that
>> you don't need to do concatenation like this using PHP - so you can
>> simply do this:
>>
>> $query = select * from books where $searchtype like '%$searchterm%'" ;
>>
>> weird huh!
>>
>
> You also might like to use a format like:
>
> $query = <<<EOQ
> SELECT *
> FROM books
> WHERE {$searchtype} LIKE '%{$searchterm}%'
> EOQ;
>
> Which make the whole query a lot clearer to those used to SQL CLI
> environments.
>
> -david-
>

[Back to original message]