damnedgentleman

That'd do it in this instance. However, some of the long event descriptions also contain descriptive text, as well as a video. For example: 'Conquering Animal Sound provided one of our most memorable shows in late 2010. Wilfully angular Scottish boy/girl duo with their excellent L.P, affection for Toy Keyboards, and their other worldly sounds. This is highly recommended! <iframe width="425" height="349" src="http://www.youtube.com/embed/4D_iv0Dyg-k" frameborder="0" allowfullscreen=""></iframe>' How would I get the script to scan the entry, and locate the appropriate part to replace?

Ah! That value is just a youtube iframe. In this instance: <iframe width="425" height="349" src="http://www.youtube.com/embed/oSxWqfayU9E" frameborder="0" allowfullscreen></iframe> I'd like the code to be able to recognise any video iframe.

Sure. $eventDescLong, is basically the detailed description the an act playing at a live music venue. I'd like to give the venue the opportunity to incorporate embedded video as part of this. It's an underground venue, so we have a lot of acts no-one has heard of playing! The video is basically youtube footage of the acts from other venues, or music videos they have made. This actually works fine atm. It just look a bit ugly as it's out of sync with my page layout which is why I'd like to change the embedded footage size from its default values. However, I'll be honest. I've never really touched regular expressions before. So I don't have a clue! Here's the script that posts the form information to the database. It all seems to work, apart from the video dimension resizing script originally posted. <?php //combines variables $eventYear, $eventMonth & eventDay to variable '$eventDate'. $eventYear = $_POST['eventYear']; $eventMonth = $_POST['eventMonth']; $eventDay = $_POST['eventDay']; $eventDate = "$eventYear-$eventMonth-$eventDay"; //assigns contents of 'listing_artist' to variable '$listing_artist'. $eventName = $_POST['eventName']; //assigns contents of 'listing_desc' to variable '$listing desc'. $eventDescLong = $_POST['eventDescLong']; //assigns contents of 'eventEntryFee' to variable '$eventEntryFee'. $eventEntryFee = $_POST['eventEntryFee']; // Include script to search for video content and resize it. include ('resize_video.php'); // Include database connection code. include ('dbConnect.php'); $queryTable = "INSERT INTO eventsTable ( eventDate, eventName, eventDescLong, eventEntryFee ) VALUES ( '$eventDate', '$eventName', '$eventDescLong', '$eventEntryFee' )"; $result = mysql_query($queryTable, $connection) or die (mysql_error()); mysql_close ($connection); include ('redirectToEdit.php'); ?>

Sadly, that didn't seem to work either. Andy

Hi there. I'll be honest. I'm totally new to regular expressions and therefore slightly without a clue. I'm attempting to resize default embedded video dimensions so that the video looks better with the layout of my page. Can anyone explain what I'm doing wrong, please? <?php //resize embedded video $find = preg_match("/<iframe(.*)/iframe>/", $eventDescLong, $video); if ($find) { $video = preg_replace('/(width)=("[^"]*")/i', 'width="580"', $video); $video = preg_replace('/(height)=("[^"]*")/i', 'height="387"', $video); } Thanks, Andy

Ah! That seems to have helped somewhat. Thank you very much.

Hi everyone. I confess, I've been learning PHP now for a very short amount of time and really enjoy using it! However, I do seem to be having a spot of bother using it in conjunction with MySQL. So far all I've managed to do is get a couple of table creation scripts to work. I've spent today trying to get the following code to function but I'm not having much luck. Running the script returns the error message: "Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/blah/blah/php/displayEvents.php on line 19" Can anybody tell me where I've gone wrong? <?php //database connection information. include ("dbConnect.php"); //MySQL query assigned to variable. Selects data from the events table for //up and coming events. $queryTable = "SELECT eventDate, eventName, eventDescLong, eventEntryFee FROM eventsTable WHERE eventDate >= CURDATE() AND eventDate <= DATE_ADD(CURDATE(), INTERVAL 7 DAY) ORDER BY EventDate ASC"; $result = mysql_query($connection, $queryTable) or die (mysql_error()); //Pulls data from events table and assigns it to an array. while($row = mysql_fetch_array($result)) { //Assigns table fields from array to variables. $eventDate = $row ['eventDate']; $eventName = $row ['eventName']; $eventDescLong = $row ['eventDescLong']; $eventEntryFee = $row ['eventEntryFee']; //displays event information. echo "<h1>$eventArtists</h1>"; echo "<h2>$eventDate Tax: &pound$eventEntryFee</h2>"; echo "<p>$eventDescLong</p><br>"; } mysql_close ($connection); ?>

Hi there! My name is Andy. I'm relatively new to PHP. Despite this, my project (an events listings website for a live music venue) is coming along at a steady rate. However, I have become somewhat confused by the following: I have a MySQL table named 'events'. The table contains the following obvious fields 'eventID', 'eventDate', 'eventArtists', 'eventDesc', 'eventEntryFee'. It can be edited from a basic content management page. I would like the main page of the website to pull all the information out of the database, displaying the up and coming week's events starting with today's event. Further, I'd like a 'next' option, giving the site user the choice to scan further ahead should they choose. Does anybody have any ideas where I should start? Thanks for reading, Andy