real media and php with mysql

adam_uk · 06-21-2003, 04:55 AM

yo

ive got a file called test.php and when the user opens it they are presented with some links which go to test.php?url=*REALMEDIANAME* for example test.php?url=foamo.rm

ive then got my embed code for the real media

PHP Code:

 
<embed src="<? echo $url; ?>" width="321" height="71" autostart="true"></embed></p>

and it should echo the ?url=foamo.rm, it echos it fine but it only echos the first audio in the database (it echos id 1)

below is my code anyone know why it doesnt work?

cheers

PHP Code:

 
<html>

<head>

<title>Untitled Document</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

 
<body>

 
<?php

 
$username = "adam123";

$pass = "adam123";

 
mysql_connect("localhost", "$username", "$pass");

mysql_select_db("salaciou_audio");

$select = "SELECT * FROM `audio`";

 
$result= mysql_query($select);

while($data = mysql_fetch_array($result)){

$url= $data["url"];

$title= $data["title"];

echo "

<a href='test.php?url=$url'>Play $title</a><br>

";

}

 
?>

<p>

  <embed src="<? echo $url; ?>" width="321" height="71" autostart="true"></embed></p>

</body>

</html>

deadserious · 06-21-2003, 03:19 PM

Wild guess here, but what happens if you change this:

$select = "SELECT * FROM `audio`";

to:

$select = "SELECT url FROM `audio`";

adam_uk · 06-22-2003, 03:24 AM

i thought i deleted this

thanks for the reply but ive sorted it now thanks

06-21-2003, 04:55 AM	#1 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	real media and php with mysql yo ive got a file called test.php and when the user opens it they are presented with some links which go to test.php?url=REALMEDIANAME for example test.php?url=foamo.rm ive then got my embed code for the real media PHP Code: `<embed src="<? echo $url; ?>" width="321" height="71" autostart="true"></embed></p>` and it should echo the ?url=foamo.rm, it echos it fine but it only echos the first audio in the database (it echos id 1) below is my code anyone know why it doesnt work? cheers PHP Code: <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php $username = "adam123"; $pass = "adam123"; mysql_connect("localhost", "$username", "$pass"); mysql_select_db("salaciou_audio"); $select = "SELECT * FROM `audio`"; $result= mysql_query($select); while($data = mysql_fetch_array($result)){ $url= $data["url"]; $title= $data["title"]; echo " <a href='test.php?url=$url'>Play $title</a><br> "; } ?> <p> <embed src="<? echo $url; ?>" width="321" height="71" autostart="true"></embed></p> </body> </html>

06-21-2003, 03:19 PM	#2 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,300 2.85 NP$ (Donate)	Wild guess here, but what happens if you change this: $select = "SELECT * FROM `audio`"; to: $select = "SELECT url FROM `audio`";

06-22-2003, 03:24 AM	#3 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	i thought i deleted this thanks for the reply but ive sorted it now thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)