[force a download file in flash player !]

I made a small force a download script, when I try the script here :

http://www.omgitsfamilyguy.com/get_video.php?id=2

 

it downloads the file fine, but when I try to play the file here :

http://www.omgitsfamilyguy.com/video_admin/player/flvplayer.php

 

it doesn't work !!

 

here's source code :

http://rafb.net/p/OW4juJ10.html

[[SOLVED] Showing data from 2 joine tables]

Thanks a alot, that learned me to make the fields name more unique next time.

thanks again

 

-Mahmoud

[[SOLVED] Showing data from 2 joine tables]

thanks a lot for ur fast reply, it works fine with numbers, but can't it be handled with names :$ !!

[[SOLVED] Showing data from 2 joine tables]

Hello,

 

I've 2 tables with the following structure :

 

Table 1 name : categories

Fields : id, code, name.

 

Table 2 name : Products

Fields : id, category_id, code, name

 

and here's MySQL query :

$query="SELECT *
FROM products
INNER JOIN categories
ON products.categpry_id = categories.id";

$result = mysql_query($query);

$row = mysql_fetch_array($result);

Now, I've the problem with "echo ()" !!

when I make :

 echo $row[name]; 

it shows the name of product, how can I show the category name ??

I tried

 echo $row[categories.name]; 

but I'm having errors !!

 

so how can I handle this ??

 

THANK YOU FOR YOUR TIME !