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

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

hi just want to ask if how can i display the records on my database to my html page or php

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

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

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