Forums

This topic is locked

Skip a Recordset

Posted 26 Jul 2009 06:33:30
1
has voted
26 Jul 2009 06:33:30 Chris Trace posted:
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

Replies

Replied 28 Jul 2009 11:04:27
28 Jul 2009 11:04:27 Patrick Julicher replied:
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
Replied 23 Aug 2009 06:44:53
23 Aug 2009 06:44:53 eurish chavez replied:
hi just want to ask if how can i display the records on my database to my html page or php
Replied 23 Aug 2009 14:48:12
23 Aug 2009 14:48:12 Patrick Julicher replied:
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
This reply was removed on 3/21/2012 12:58:24 PM.
See the changelog
This reply was removed on 5/15/2012 10:05:22 AM.
See the changelog
Replied 27 Sep 2012 01:01:45
27 Sep 2012 01:01:45 Rachel Moore replied:
I am trying to insert a record from a C++ system using ADO connection to selected fields in an SQL database Table.



bigg boss 6
Replied 01 Dec 2012 00:59:34
01 Dec 2012 00:59:34 Stellaheresa Veronica replied:
Okay firstly I realise it will probably be quite hard for you to get your head around the situation but thanks for trying...
click for info

Reply to this topic