Search db display results in sets of 5 with next/prev ...

[luckyblackcat]

Hi

I need to write an application which searches a MySQL db and dispays the results much like a search engine.

I have a number of fields to output in a 3x2 table

1st row ... A ref no, title

2nd Row A thumnail jpg (blob), main description

3rd Row Tel:, e-mail

I would like to control the number of results per page
and have |<< < > >>| or better navigation at the head and foot.

Anyone know of any library scripts/examples I could use.
This has to be widely used but I'm on a steep learning curve here and have limited time available (No time to read up ....I need to cheat)

Thanks for reading this

luckyblackcat

 

[alsoknownas]

Dreamweaver does that for you

--------------------------------------------------------------------------------
​

 

[luckyblackcat]

Thanks, I guess it does ... cheers for the help

luckyblackcat

 

[ChrisHirst]

maybe Dreamweaver does, but you won't learn anything and will probably be unable to debug it.

http://www.asp101.com/samples/db_paged_search.asp

Chris.

Indifference will be the downfall of mankind, but who cares?

 

[lebisol]

http://www.basic-ultradev.com/extensions/

> need more info?
:: don't click HERE ::

 

[luckyblackcat]

Hi,

I've tried the Trio motors PHP tutorial. I have MySQL PHP IIS set up and tested as working as the tutorial says but when I get to add the repeated region and test live data I get errors.

The repeated are misses the 1st coin the row and I get errors on the page.

I have given up on the tutorial and I am going to have to work it out myself.

Dreamweaver seems to add code that I'm not sure about, if the design mode worked it would be OK but if I'm left to code it myself .. why use dreamweaver except for site/file management & ftp.

I have a few days to sort this out. Your time and help is much appreciated thank you.

luckyblackcat

 

[lebisol]

&quot;Dreamweaver seems to add code that I'm not sure about&quot;
-->....then add the code that ur sure about!

&quot;I have a few days to sort this out. &quot;
--> wait, if ur doing a &quot;tutorial&quot; why are in a rush....do it until u learn

http://www.basic-ultradev.com/extensions/

will give u extentions that generate &quot;user friendlier&quot; code than MM_code....perhaps decoding &quot;Navigational Suite&quot; extention will be easier....

&quot;why use dreamweaver except for site/file management & ftp&quot;
--> well....some people like it some don't...but in reality...u can not expect to be a super-user of DW if u just started...don't be fooled that &quot;ease of use = knowledge of use&quot;....take your time...look at the code as it is being generated.....start with simple designs and text...note your Database/pages errors and then look up those errors and read upon them......it is not all click+dragg process...nothing in life is!
All the best!

> need more info?
:: don't click HERE ::

 

[luckyblackcat]

Hi,

I did the DW tutorial as it seemed similar to the website I need to do.

I am in a hurry as I am moving house/country and will have to use a mobile phone to connect until a landline is connected and ISP sorted.

OK?

luckyblackcat

 

[lebisol]

then I suggest you start you project and decoding it as it all can be accomplished. IMHO why not post questions that you can benifit from right away....
anyhow
&quot;No time to read up ....I need to cheat)&quot;
-- then look at the extentions

&quot;I would like to control the number of results per page
and have |<< < > >>| or better navigation at the head and foot.&quot;
--DW will allow u to edit and use imags or text as a navigation.....&quot;double nav&quot; has to be done in code view...copy+paste
Good Luck!

> need more info?
:: don't click HERE ::