Re: [ross] Installing Back Button on thumbnail expanded images

Mon, 27 Apr 2009 16:15:40 -0700

hiya mate, in that case maybe integrating something like highslide might be a lot better. (Link is http://highslide.com/)

That way the presentation of th pic looks so much cooler, and the whole need for back buttons, etc are void!

I know its javascript, but its pretty versatile, and passing the image url to it, through php i dont think will be that hard...

Just a suggestion...

Re: [ross] Help with Search. Very Urgent, please help!

Mon, 27 Apr 2009 16:11:14 -0700

MAte everything right on track... Wroking like a charm... Dave's code definitely gave me the direction... The information on the fourm has been invaluable in me being able to continue... Thanks to all the contributors!

Re: [Dave] Help with Search. Very Urgent, please help!

Sun, 26 Apr 2009 09:55:07 -0700

H Dave,

thanks so much for the quick response (and that too over the weekend! [cool])

The reason I cant use the inbuilt search is, that I have my own if condirtions that need to be met, like dates between, wut quick option was chosen etc...)

Cheers again mate...

Re: [RaisyRoo] Installing Back Button on thumbnail expanded images

Sat, 25 Apr 2009 19:45:22 -0700

I'm not a 100% sure, but if Ross says the browser's back button works, then try:

Back

Javascript that does pretty much the same thing i reckon...
Like i said, i cant be sure, but trying it wont hurt i guess :))

Help with Search. Very Urgent, please help!

Sat, 25 Apr 2009 18:45:37 -0700

Ok I guess this is pretty straight forward problem.

In my list viewer page I use php get to get some values into some variables like so:
$quick_option = $_GET['varQuickOption'];
$start_date = $_GET['varStartdate'];
$end_date = $_GET['varEnddate'];
$match_type = $_GET['varType'];
$team_type = $_GET['varTeam'];

the problem I have is I want to be able to use these variables in the list viewers 'where' clause like so:

list($fixturesRecords, $fixturesMetaData) = getRecords(array(
'tableName' => 'fixtures',
'where' => 'match_type = $match_type',
'perPage' => '15',
));

However I am having no luck. This gave me the error:
getRecords(fixtures) MySQL Error: Unknown column '$match_type' in 'where clause'

I have tried putting it like this: "$match_type", this '$match_type' and even this echo($match_type) but nothing works!

Could anyone provide me with a solution please? Any help would be VERY VERY much appreciated.

Cheers

Re: [zaba] Help with TABLE LAYOUT PLEASE

Mon, 20 Apr 2009 07:51:34 -0700

mte thank you so very much! it was a great help! :)

Help with TABLE LAYOUT PLEASE

Mon, 20 Apr 2009 04:41:09 -0700

Hi guys,

Sorry to bother you but I was wondering if you would be kind enough to help me with this... I am pretty sure it a lot less complicated than i think it is... As always any help would be very much appreciated.

Ok basically this is what my page looks like (current.jpg).

I need it to look like (required.jpg)....

The only thing I want to know is how to get my layout to look like that (complete with the column headings [not really fussed bout color, etc right now])

Here is my code ( I only put the display part of it coz I figure thats all thats required yes? Also dont worry bout anything I've set to variables, jus something I'm trying out):

Fixtures

Results page '' not found, start over >>.

No records were found!

Need to use 2 advanced filters

Fri, 17 Apr 2009 05:15:21 -0700

Any help with this issue would be very very much appreciated.

Ok this is what I have;
2 sections: Fixtures & Tournament Info

Tournament Info has the field names:
team
tournament
tournament_name

Fixtures has a few other fields, but the ones essential to my query are:
team
match_type
tournament_name

Ok basically what happens is I fill the Tournament_Info section with information.

Now to my question.

Ok in fixtures:

my team field is populated by using the "Get options from db". The results are gotten from the team field in the tournament_info database.

the match_type field is populated using the "Get options from MySQL query". The query is dependent on the value chosen for the team option above, using the Advanced filter option. Here is the code for it just for information purposes.

SELECT DISTINCT tournament, tournament FROM cms_tournament_info WHERE team = ''

ok now to my problem, for the tournament_name field, i want a pulldown box that is dependent on the value of team & the match_type field. That is I want to use 2 escaped value options. Is there anyway to get this done? So in short, I want to have a MySQL query that will look something like this:

SELECT DISTINCT tournament_name, tournament_name FROM cms_tournament_info WHERE tournament = '' & team = how to assign this value????????????

Once again any help would be very very very much appreciated!

Cheers....