[RESOLVED] Jump to Recordset from another web page

[northstjarna]

Hi there,

I am fairly new to php so I am trying to get to grips with this.
I have a web page that show's video's. I built a custom player in Flash and the recordset variables are based on repeated regions from MySQL and load back into Flash

See - www.northstjarna.com/Media/Video

However my friend who owns Tequila Town wants to put some hyperlinks onto his page to jump to the recordset of the Video named "x"

This works but a) You have to guess that it's gonna be the correct video and b) If you change the recordsets in the DB the hyperlink would mess up

<a href="http://www.northstjarna.com/Media/Video/index.php?pageNum_Movies=1">A link to a Video where Recordset page=1</a>

I am trying to write a variable into my SQL statement which handles the QRY

So was trying this

$vidvar = $variable_from_hyperlink

mysql_select_db($database_northstjarna, $northstjarna);
$query_Movies = "SELECT MovieTitle, MovieDescription, MovieRL, MovieURLText, Year, Reference FROM Movies WHERE Movies.MovieTitle = '$vidvars'";

$Movies = mysql_query($query_Movies, $northstjarna) or die(mysql_error());
$row_Movies = mysql_fetch_assoc($Movies);
$totalRows_Movies = mysql_num_rows($Movies);

I have to tell it to filter rather than go to the page. So maybe the URL would be

<a href="http://www.northstjarna.com/Media/Video/index.php?MovieTitle=<?php echo $row_Movies['MovieTitle']; ?>'The Hawaiian Party'">A link to a Video where Title =The Hawaiian Party</a>

Or

<a href="http://www.northstjarna.com/Media/Video/index.php" Name="variable_from_hyperlink">A link to a Video where Title =The Hawaiian Party</a>

I am on the right track and is something so simple... but then again it's late and I am not thinking so straight.

Any help is much appreciated.

Thanks

Andi

[iNFERiON]

$vidvar = $variable_from_hyperlink

mysql_select_db($database_northstjarna, $northstjarna);
$query_Movies = "SELECT MovieTitle, MovieDescription, MovieRL, MovieURLText, `Year`, Reference FROM Movies WHERE Movies.MovieTitle = '$vidvars'";

You specify $vidvar and are trying to call $vidvars. 😉

[northstjarna]

Thanks for that - Ok Then. Done That.

So Now I have this on another page

<a href="VideoTest.php" UrlVariable='The Hawaiian Party'">Test Goto Brutal Me</a>

And then this is on the page I want to look up to:

$vidvars = $UrlVariable

mysql_select_db($database_northstjarna, $northstjarna);
$query_Movies = "SELECT MovieTitle, MovieDescription, MovieRL, MovieURLText, Year, Reference FROM Movies WHERE Movies.MovieTitle = '$vidvars'";

$Movies = mysql_query($query_Movies, $northstjarna) or die(mysql_error());
$row_Movies = mysql_fetch_assoc($Movies);
$totalRows_Movies = mysql_num_rows($Movies);

This is not working, I am getting a parse error.

Trying variations of $UrlVariable...

If you have any other info that might help. It's really the hyperlink that's got the problem. I can make $vidvars = 'anything' and it will filter to the correct video. It's getting the variable from a hyperlink on another page that's the issue.

Cheers

Andi

[mcready]

The link would be:

<a href="VideoTest.php?UrlVariable=The+Hawaiian+Party">Test Goto Brutal Me</a>

And the code:

<?php
$vidvar = $_GET['UrlVariable'];
?>

[northstjarna]

Perfect - Thank you Very Very Much.

The Part I was needing was Get. Now I can set up a new page and can give him a load of hyperlinks to the specific videos.

Thanks Again

Andi Lee Davis

[Rodney_H_]

northstjarna,

If the thread has been "resolved" your responsibility as the thread-owner is to mark it as such:

1) Go to "Thread Tools" (on the toolbar / top - right)

2) Select "Mark this thread as resolved"

3) Rejoice!

[northstjarna]

Ok Done

[Rodney_H_]

Thanks.