Mobile Wallpaper download

thx a lot for help here what i wanna do with mysql

//connect to db

//select pid,imagepath,imagename from cpg_pictures

$dbh=mysql_connect ("localhost", "dbname", "pass") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("dbname");
$sql = 'SELECT `pid` , `filepath` , `filename` '
        . ' FROM `cpg_pictures` '
        . ' WHERE pid =$id

imlink=imagepath+imagename

echo <a href="$imlink""> Download image </a>

can u help me

As I said, PHP isn't really my bag.  However, it looks like you are probably almost there.  Does your PHP return anything to the WAP browser yet or is it giving you errors?  Can you post the entire PHP code?

Note that in your "or die('..." line, you should be returning valid WML, ie. always put your text inside <p>...</p> tags.

... or die('<p>I cannot connect to the database because: ' .mysql_error() . '</p>');

Similarly, I would include the <p>...</p> around the download image link too:

echo "<p><a href=\"$imlink\">Download image</a></p>";

here is the code for my wml page
----------------------------------------------------------------------------------------------------------------
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
  <card id="card1" title="WAP Downloader">  
   <p>    
     Enter WAP ID :
    <br/>
  <input name="pid" type="text" id="image"></input>
    <do type="accept" name="next" label="Get File">
     <go href="download.php" method="post">
      <postfield name="pid" value="$(pid)"/>
     </go>
    </do>
   </p>
  </card>
</wml>
---------------------------------------------------------------------------------------------------------------

here the code or download.php
---------------------------------------------------------------------------------------------------------------
<?
header("Content-type: text/vnd.wap.wml");
echo "<?xml version=\"1.0\"?>";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\""." \"http://www.wapforum.org/DTD/wml_1.1.xml\">";
<wml>
<card id="card1" title="WAP Retriver">  

@MYSQL_CONNECT("localhost","user","pass");

@mysql_select_db("dbname");

$sql = 'SELECT `pid` , `filepath` , `filename` ' . ' FROM `cpg_pictures` '. ' WHERE pid =$pid

$filepath = @MYSQL_RESULT($result,0,"filepath");    

$filename = @MYSQL_RESULT($result,0,"filename");    

<p><a href="http://www.vk123.com/nuke/$filepath/$filename">Download File</a></p>
</card>
</wml>

---------------------------------------------------------------------------------------------------------------

<b>Parse error</b>:  parse error, unexpected '<' in <b>/home/vk123a1/public_html/nuke/download.php</b> on line <b>5

i got this error

Is that not working?  If not, what happens?

(Sorry, my last comment cross-posted with your error message)

Ah.  You need a closing ?> before the <wml>, then you need to re-open the PHP around the code.  I *think* the following should work:

<?php
header("Content-type: text/vnd.wap.wml");
echo "<?xml version=\"1.0\"?>";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\""." \"http://www.wapforum.org/DTD/wml_1.1.xml\">";
?>
<wml>
<card id="card1" title="WAP Retriver">  
<?php
@MYSQL_CONNECT("localhost","user","pass");

@mysql_select_db("dbname");

$sql = 'SELECT `pid` , `filepath` , `filename` ' . ' FROM `cpg_pictures` '. ' WHERE pid =$pid

$filepath = @MYSQL_RESULT($result,0,"filepath");    

$filename = @MYSQL_RESULT($result,0,"filename");    
?>
<p><a href="http://www.vk123.com/nuke/$filepath/$filename">Download File</a></p>
</card>
</wml>

how do retrieve the fields from mysql using php.

here id is the variable passed from wml page

but id on database is pid

how to equate them

and how to assign names

We're well off the topic of WAP here ;-)  Although it's quite interesting.  I hadn't done any PHP until I started started helping on this question.  I've installed PHP and even written my first little PHP script :-D.  However, I haven't done any database accessing yet.  Have a look here:

http://www.freewebmasterhelp.com/tutorials/phpmysql/4

This seems to show that you use your $sql like this:

$result = mysql_query($sql);

$result then contains everything that was returned from the database, so then you need to use other php functions to get to that data (probably within a loop), eg:

$numrows = mysql_numrows($result);
$i = 0;
while ($i < $numrows)
{
    $filepath = mysql_result($result, $i, "filepath");
    $filename = mysql_result($result, $i, "filename");
    echo "<p><a href=\"http://www.vk123.com/nuke/$filepath/$filename\">Download File</a></p>";
    ++$i;
}

great stuff,it works, but loop is infinite

Is it a problem with the "++$i;" ?

Have you included that?  Is it within the curly braces that surround the loop?  You haven't included the "$i = 0;" inside the loop have you? ;-)

i retreive only on row from the dbase.so i modified the code as per below

<?php
// send wml headers
header("Content-type: text/vnd.wap.wml");
echo "<?xml version=\"1.0\"?>";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\""
   . " \"http://www.wapforum.org/DTD/wml_1.1.xml\">";
?>

<wml>
    <card id="card1" title="WAP Download">
        <p>
        <?php
      // connect to mysql database
        $gallery = mysql_pconnect("localhost", "user","pass");
      // select database
        $db = mysql_select_db("db");
   
     $query = 'SELECT `pid` , `filepath` , `filename` '
        . ' FROM `cpg_pictures` '
        . ' WHERE `pid`=$pid ';
            
            $result = @mysql_query($query);
            //$numrows = mysql_numrows($result);
$i = $pid;
    $filepath = mysql_result($result, $i, "filepath");
    $filename = mysql_result($result, $i, "filename");
    echo "<p><a href=\"http://www.vk123.com/nuke/$filepath/$filename\">Download File</a></p>";
             ?>
        </p>
    </card>
</wml>

i want to get only one row from the db.i dont need to select pid from database. i need to pass the variable from wml page.(pid) how do i do it

and by the way this is not off topic. i want a WAP enabled phone to get a color wallpaper from the database.you have helped me get 90% success jimmack. thx a lot

thanks a lot. it worked. hats off to you.