Mysql fetch specific data from row (id)

[roadrunner]

Ok so im not very good with all this mysql stuff but im having a go.

I have built a script that inserts into my DB the following:

Video Link (playable mp4,avi etc etc)
Video Title
Video download link

I now have my output done BUT im using the echo command to pull the media link from my DB into the media player

Example:

<OBJECT ID="MediaPlayer" WIDTH="192" HEIGHT="190" CLASSID="CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95"
STANDBY="Loading Windows Media Player components..." TYPE="application/x-oleobject">
<PARAM NAME="FileName" VALUE="<?php echo("$vid_source"); ?>">
<PARAM name="autostart" VALUE="false">
<PARAM name="ShowControls" VALUE="true">
<param name="ShowStatusBar" value="false">
<PARAM name="ShowDisplay" VALUE="false">
<EMBED TYPE="application/x-mplayer2" SRC="<?php echo("$vid_source"); ?>" NAME="MediaPlayer"
WIDTH="192" HEIGHT="190" ShowControls="1" ShowStatusBar="0" ShowDisplay="0" autostart="0"> </EMBED>
</OBJECT>

Now this works fine and plays the video BUT all the movie players play the same video so i need to use something like

<?php echo("$vid_source from $id1"); ?>

Now of coarse this dosn't work and i didnt expect it to......so what do i put in there so it pulls the links from the diferent rows/id's from my DB.


Thanks
RR

roadrunner Reviewed by roadrunner on 22nd Aug 2011. Mysql fetch specific data from row (id) Ok so im not very good with all this mysql stuff but im having a go. I have built a script that inserts into my DB the following: Video Link (playable mp4,avi etc etc) Video Title Video download link I now have my output done BUT im using the echo command to pull the media link from my DB into the media player Rating: 5

[cgworld]

first of all you have to get the id of the video using $_GET from the user.
You can do something like this:

$id = $_GET['videoid'];
$sql = "SELECT * FROM table WHERE id={$id}";
$query = mysql_query($sql);
while($result = mysql_fetch_array($query)){
echo $result['id'] . $result['videolink'] . $result['videotitle']
}

[soft2050]

Give an example link to your website

Get the data by input get in a variable

Then connect to the mysql database and use "MySQL Select" to select the row and then fetch the variable from that row

About MYSQL Select:

http://dev.mysql.com/doc/refman/5.0/en/select.html
http://www.w3schools.com/PHP/php_mysql_select.asp

[roadrunner]

Thanks for the quick response.

Take a look here ( ignore the cosmetic side at the moment please):

http://userporn.co.uk/new_site/out2.php

You will see from the text output there are 2 diferent MP4 links

But the media players only play the last one....

Here is my DB :



So i need to make this :

<?php echo("$vid_source"); ?>

echo the diferent links from the diferent ID's

Cheers
RR

[Lock Down]

Try this:

<?PHP
$user_name = "DbUserName";
 $password = "DbPassword";
 $database = "DbName";
 $server = "localhost";

$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);

if ($db_found) {

$SQL = "SELECT vid_source FROM DbTableName";
$result = mysql_query($SQL);

while ($db_field = mysql_fetch_assoc($result)) {
echo $db_field['vid_source']."<br>";
}

 mysql_close($db_handle);

}
else {
echo "Database NOT Found ";
mysql_close($db_handle);
}

?>

[roadrunner]

Tryed that, it printed/echo'ed the 2 links but the media players stopped playing

[roadrunner]

Perhaps its not possible to pull a specific bit of info from a specific row of a table ?

[cgworld]

ofc it is possible, when you use mysql_fetch_array(); those info are placed inside the array, e.g.

array['vid_source']

[roadrunner]

Thanks all
Have now got it sorted as you will see here:

http://userporn.co.uk/new_site/

Cheers
RR

[Lock Down]

You are welcome.