This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » SQL and Databases » Skip a Recordset

Skip a Recordset
Chris Trace Freaking Member Since: 14 Dec 2004 Posts: 142	Posted 26 Jul 2009 06:33:30 Hey there, How can i skip the first row of an sql query using mySQL? $query_enquiryofficelisting = "SELECT * FROM offices ORDER BY officename ASC SKIP (1)"; is one variation that doesn't work. Cheers Hey there, How can i skip the first row of an sql query using mySQL? $query_enquiryofficelisting = "SELECT * FROM offices ORDER BY officename ASC SKIP (1)"; is one variation that doesn't work. Cheers

Skip a Recordset

Chris Trace
Freaking Member

Since: 14 Dec 2004
Posts: 142

Posted 26 Jul 2009 06:33:30

Hey there,

How can i skip the first row of an sql query using mySQL?

$query_enquiryofficelisting = "SELECT * FROM offices ORDER BY officename ASC SKIP (1)";

is one variation that doesn't work.

Cheers

Hey there,

How can i skip the first row of an sql query using mySQL?

$query_enquiryofficelisting = "SELECT * FROM offices ORDER BY officename ASC SKIP (1)";

is one variation that doesn't work.

Cheers

Patrick Julicher Official Representative Since: 04 Feb 2002 Posts: 1,208	Replied 28 Jul 2009 11:04:27 Hi Chris, My guess is you are using PHP? Do you want to skip the first record when displaying this on a page? Kind regards, Patrick

eurish chavez Member Since: 22 Aug 2009 Posts: 2	Replied 23 Aug 2009 06:44:53 hi just want to ask if how can i display the records on my database to my html page or php

Patrick Julicher Official Representative Since: 04 Feb 2002 Posts: 1,208	Replied 23 Aug 2009 14:48:12 Hi Eurish, Before being able to answer your question, tell me if you have a connection to a webserver set up or if you are working locally with DW. It all comes down to this: * First you create a Connection to your Database (Window, Database) * Then you create a Recordset (Server Behaviors, +, Recordset) * Then from the Bindings tab, you click on what you want to display on the page and then click Insert * Finally select what you insert and apply a Repeat Region (Server Behaviors, +. Repeat Region) If you have now idea at all what this means, you might be better off following an online course on how to use DW. Kind regards, Patrick

	This reply was removed on 1/25/2012 9:07:58 AM. See the changelog

Reply to this topic

Message
Reply

Live Support

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Extensions Yearly Subscription

Tired of purchasing many extensions just to finish up your project. Now we have a solution for you. For a small fee you have access to over 70 high-quality (all DMXzone extensions) and growing Dreamweaver extensions for a year period!

Additionally, we're working on many new ones, which will be available for every subscription holder when released!

Forums

Skip a Recordset

Hey there,

How can i skip the first row of an sql query using mySQL?

$query_enquiryofficelisting = "SELECT * FROM offices ORDER BY officename ASC SKIP (1)";

is one variation that doesn't work.

Cheers