Re: Stupid Doubt but I am Stuck..help me out Guys..
| From: | Ignacio Vazquez-Abrams | Date: | Tue, 21 Nov 2000 19:13:43 +0000 |
| Subject: | Re: Stupid Doubt but I am Stuck..help me out Guys.. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-26495@lists.php.net to get a copy of this message | ||
On Tue, 21 Nov 2000, Dhaval Desai wrote:
> Hey Guys...
>
> I am trying to Load data from an external tab
> delimited file into mysql database table...::
> Below is my code but it always show error on line 4.
> Can anybody point me to my mistake...please.
> This is the only way I can load my data into the table
> coz I don't have access to mysql server directly from
> the command prompt.
>
> <?php
>
> $r = mysql_connect("localhost");
> $query "load data infile
> 'c:/mysql/bin/data/airlines.txt' into table airlines
> fields terminated by '\t'";
>
> $exec = mysql_db_query("dummy",$query);
>
> if($exec)
> {
> echo "Success";
> }
> else
> {
> echo "Could not complete your request master";
> }
>
>
> ?>
>
> Eagerly waiting for replies.....
>
> Thanx!
> Dhaval Desai
>
You caught the missing = right?
$query=...
--
Ignacio Vazquez-Abrams <ignacio@openservices.net>