nooooobie needs help

[ste2me]

I have been working on a website using PHP and MySQL and although I have knowledge in both these fields, my knowledge is quite limited and I have come across a problem I need help with.
I am creating a videos page and I would like the videos to be displayed (using PHP) in a format similar to what is found here:

http://www.hiphopdx.com/index/videos?nav

I would like the videos to display the date headline (the date being when the videos were posted) then the thumbnails of the videos to be displayed in 4 columns. I already have the videos page set up with the pagination, mysql connection and video details. I am currently displaying the videos in a single column as I dont know how to display PHP results in multiple columns.

So basically I am looking for the videos page to display the results like this (example):

Thursday, August 27, 2009
Video 1 | Video 2 | Video 3 | Video 4
Video 5 | Video 6 | Video 7 | Video 8

here is the search script. many thanks

Code:

Search Error

Please enter a search…

” ;
}
// check for a search parameter
if (!isset($var)){
$resultmsg = “

Search Error

We don’t seem to have a search parameter!

” ;
}
// Build SQL Query for each keyword entered
foreach ($trimmed_array as $trimm){

// EDIT HERE and specify your table and field names for the SQL query
$query = “SELECT * FROM data WHERE id LIKE “%$trimm%” OR thumb LIKE “%$trimm%” OR titel LIKE “%$trimm%” OR code LIKE “%$trimm%”ORDER BY id DESC” ;
// Execute the query to get number of rows that contain search kewords
$numresults=mysql_query ($query);
$row_num_links_main =mysql_num_rows ($numresults);
// next determine if ‘s’ has been passed to script, if not use 0.
// ‘s’ is a variable that gets set as we navigate the search result pages.
if (empty($s)) {
$s=0;
}
// now let’s get results.
$query .= ” LIMIT $s,$limit” ;
$numresults = mysql_query ($query) or die ( “Couldn’t execute query” );
$row= mysql_fetch_array ($numresults);

//store record id of every item that contains the keyword in the array we need to do this to avoid display of duplicate search result.
do{
//EDIT HERE and specify your field name that is primary key
$adid_array[] = $row[ ‘id’ ];
}while( $row= mysql_fetch_array($numresults));
} //end foreach

if($row_num_links_main == 0 && $row_set_num == 0){
$resultmsg = “” . $trimmed .”

Sorry, your search returned zero results

” ;
}
//delete duplicate record id’s from the array. To do this we will use array_unique function
$tmparr = array_unique($adid_array);
$i % 5 == 0;
foreach ($tmparr as $v) {
$newarr[$i] = $v;
$i++;
}
// now you can display the results returned. But first we will display the search form on the top of the page
?>

Search results for : $var

” ;
}

foreach($newarr as $value){

// EDIT HERE and specify your table and field names for the SQL query
$query_value = “SELECT * FROM data WHERE id = ‘$value'”;
$num_value=mysql_query ($query_value);
$row_linkcat= mysql_fetch_array ($num_value);
$row_num_links= mysql_num_rows ($num_value);

//now let’s make the keywords bold. To do that we will use preg_replace function.
//EDIT parts of the lines below that have fields names like $row_linkcat[ ‘field1’ ]
//This script assumes you are searching only 3 fields. If you are searching more fileds make sure that add appropriate line.
$titlehigh = preg_replace ( “‘($var)’si” , “\1” , $row_linkcat[ ‘id’ ] );
$linkhigh = preg_replace ( “‘($var)’si” , “\1” , $row_linkcat[ ‘titel’ ] );
$linkthumb = preg_replace ( “‘($var)’si” , “\1” , $row_linkcat[ ‘thumb’ ] );
$datum = preg_replace ( “‘($var)’si” , “\1” , $row_linkcat[ ‘datum’ ] );
$code = preg_replace ( “‘($var)’si” , “\1” , $row_linkcat[ ‘code’ ] );

foreach($trimmed_array as $trimm){
if($trimm != ‘b’ ){
//IF you added more fields to search make sure to add them below as well.
$titlehigh = preg_replace( “‘($trimm)’si” , “\1” , $titlehigh);
$linkhigh = preg_replace( “‘($trimm)’si” , “\1” , $linkhigh);
$linkdesc = preg_replace( “‘($trimm)’si” , “\1” , $datum);
$linkthumb = preg_replace( “‘($trimm)’si” , “\1” , $thumb);
$linkcode = preg_replace( “‘($trimm)’si” , “\1” , $code);
}
//end highlight
?>

“>

#64888

bmdsherman

Member

If I where you I would use css to put the videos in rows.

#65563

ste2me

Member

use css? any ideas

#65578

TheDoc

Member

Each of the items on the example page you gave have their own div that is floated to the left.

[bmdsherman]

If I where you I would use css to put the videos in rows.

[ste2me]

use css? any ideas

[TheDoc]

Each of the items on the example page you gave have their own div that is floated to the left.

[Author]

Posts