Re: 2 Questions... INSERT and searching records....
| From: | Todd Williamsen | Date: | Thu, 31 Jan 2002 18:45:35 +0000 |
| Subject: | Re: 2 Questions... INSERT and searching records.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16363@lists.php.net to get a copy of this message | ||
OOps... second question...
I wanted to do a search of text documents that are inserted into the
database.
1. What is the best data type for large amounts of text, like 2000
characters. I thought BLOB, but I could be wrong...
2. Within the above text, I wanted to search via keywords. How would I do
that?
"Todd Williamsen" <todd@williamsen.net> wrote in message
news:20020131184417.51706.qmail@pb1.pair.com...
> It seems that my insert statement doesn't want to cooperate.. I used the
> same format as in Julie Meloni's book. I know, sometimes, her code
doesn't
> always work either.
>
> here it is:
>
> $sql = "INSERT INTO Jobs (id, Industry, Other, JobTitle, Description,
> Location, Date)
> VALUES
> (\"\",
> \"$id\", \"$Industry\", \"$Other\", \"$JobTitle\",
> \"$Description\",
> \"$Location\", \"$Date\")";
> $result = @mysql_query($sql) or die("OOPS!! Couldn't Execute Query!");
> ?>
>
> its not the whole code block... it dies and executes the "OOPS!! Couldn't
> Execute Query!" statement.
> what is wrong... anybody? Bueller?
>
>