pavelazad

hello, can you please write me a bit details how can i do it? i m bit new in php. thanks

Hello, I have a page (product.php) with image link which passing a value (catalog.php?cat=11987) to a page catalog.php. on catalog.php i am getting the value ($cat=$_GET['cat']. with this value I have used pagination on catalog.php. everything is fine one first page but when i clion on NEXT or page number 2 i get nothing. i understand why is happening. i think as catalog.php is getting the value from product.php and when i click page 2 or next page my query doesn't have this value. can anyone please help me to fix this. how can i hold this value for my pagination query. pls need help. thanks.

its working now. you guys are great. Thanks for your help.

when i open the file with editor i see: <br /> <b>Warning</b>: filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /downloads/songs/Bangla/Band/Aurthohin/Aushomapto 2/Alo R Adhar.mp3 in <b>/home/amarlon1/public_html/banglasong/download.php</b> on line <b>20</b><br /> <br /> <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/amarlon1/public_html/banglasong/download.php:20) in <b>/home/amarlon1/public_html/banglasong/download.php</b> on line <b>20</b><br /> <br /> <b>Warning</b>: readfile(/downloads/songs/Bangla/Band/Aurthohin/Aushomapto 2/Alo R Adhar.mp3) [<a href='function.readfile'>function.readfile</a>]: failed to open stream: No such file or directory in <b>/home/amarlon1/public_html/banglasong/download.php</b> on line <b>22</b><br /> i dont have any idea where is the problem. pls help.

Hello, I have the following code to force download mp3 file. the code is working fine but its only downloading 799 bytes. I am new in php and not able to figure out the problem. please help me to sort it out. thanks. <?php include "dbconnect.php"; $link=dbconnect(); $cat=$_GET['catagory']; $id=$_GET['id']; $query=("select *from $cat where id='$id'"); $result=mysql_query($query); $row=mysql_fetch_array($result); $file = $row["link"]; header ("Content-type: octet/stream"); header("Content-Disposition: attachment; filename=\"".basename($file)."\";" ); header("Content-Length: ".filesize($file)); readfile($file); exit; ?>

Hello, I have a php page from where anyone can download mp3 songs. my database table contain song title and the directory link of every song. the page retrieve song title with the link that people can click and download. but if u click the mp3 started to play on new window. if u right click and save as then it download. but I want that people click and it will start download or give a prompt to save the file in pc. I hv the following code please help me... thankx <?PHP $artist=$_GET['artist']; $album=$_GET['album']; $query=("select *from Band where artist='$artist' and album='$album'"); $result=mysql_query($query); while ($row=mysql_fetch_array($result)) { ?> <a href="<?php echo $row["link"];?>"><strong><?php echo $row["title"];?></strong></a> <?PHP } ?> How can I make that if I click on the title then it will start download. pls need help.

hi jasonc thanks for your reply. i am not sure how and where to use your code. can u pls help me a bit more if possible. thanks.

hello all, I am using the following code to retrieve mysql data and show on my page.. <?php include "dbconnect.php"; $link=dbconnect(); $result = mysql_query("SELECT * FROM playlist where date= '2011-09-06'") or die(mysql_error()); echo "<table width = 100% border = '0' cellspacing = '2' cellpadding = '0'>"; while ($friendList = mysql_fetch_array($result)) { echo "<tr>" . "<td><a href='memberindex.php?id = ".$friendList['id']."'><img src='".$friendList['image']."' title='".$friendList['artist']."' alt='".$friendList['album']."'/><br />".$friendList['album']."</a><br /></td> " . "</tr> "; } echo "</table> "; ?> this code retrieve image and album name from the table and display as below: id 1 image1 album1 id 2 image2 album2 id 3 image3 album3 but i want to display the info as below: id1-----------------id2---------------id3 image1------------image2-----------image3 album1------------album2-----------album3 i want image and album name of a product as column but other product as rows. I hope you understand. anyone can help me with this please?

hello, I need xml file as playlist.xml and i want to retrive data from my mysql table. I have the following code as i am trying to use php code inside playlist.xml file. <?xml version="1.0" encoding="utf-8"?> <xml> <?php $dbhost='localhost'; $dbuser='pavel'; $dbpass='pavel123'; mysql_connect($dbhost,$dbuser,$dbpass); mysql_select_db("amarmusic"); $sql=("select *from bband where artist='Meghdol' and album='Drohe Montre Valobasha';"); $res = mysql_query($sql); while ($result = mysql_fetch_array($res)){ ?> <track> <path> <? $result['link']?></path> <title><? $result['title']?></title> </track> <? } ?> </xml> but unfortunately its not working. any1 have any idea how to fix it? please help me.