WebRadiance Guidelines

Welcome Guest ( Log In | Register )

Why register for free on WebRadiance?

Welcome to WebRadiance forums! WebRadiance is a place for discussion and help on a large range of web design and development related topics such as HTML, CSS, ASP & .NET, PHP and SEO. It is provided for free, without ads and is a friendly place for beginners and professionals alike. By joining us today you can take part in our rapidly growing community.

Registering enables you to:

have your say by posting new messages and taking part in topics and polls
keep up to date with the latest news and trends in the web design and development world
send private messages to other members
have your questions answered by our knowledgeable community
add a link to your website in our links area
receive emails when someone replies to your posts

Login Name (?)	Password (?)	Email (?)
Display Name (?)	Confirm Password (?)	Confirm Email (?)
Secruity Code (?)
I have read, understood and agree to these rules and conditions (View Terms)

Updated on 4th January 2008

We encourage you to participate in the WebRadiance Community, however as with all social circles, there are a few rules you must abide by in order to maintain your membership within these forums. We are trying to provide the highest quality community experience for our members and following these rules is the best way to maintain a quality environment for everyone.

If we find that you break any of these rules, your account may be disabled and your posting privileges removed.

Section A: Posting & Personal Messaging Rules

You will not post any messages, or links to content, that is obscene, vulgar, sexually-orientated, hateful, threatening, or otherwise violates of any laws
No double posting; keep your question in one section
Posts in a particular forum section and/or thread need to stay on topic
Never make a post simply to increase your post count
DO NOT POST IN ALL CAPS
Be respectful to other members
You will not recruit WebRadiance members for other forums
Individual sub-forums may have additional rules. These will be displayed at the top of each sub-forum

Section B: Spam

Users will not spam the forum through repetitive posting, or its members through the PM system

Section C: Usernames/Accounts

Your member name cannot contain profanity
Your member name cannot contain advertising or a company name that is not your own
Your member name cannot be an attempt to impersonate another member
If restricted/banned, you will not register a new account to obtain freedom to post

Section D: Signatures

One line of text only
In the one line of text, only one external link is allowed
No images are allowed

Section E: Avatars

Images must be suitable for all ages
Images may not be more than 15kb in size

Section F: Advertising

You cannot post with the intention of selling and/or promoting yourself, a product, or another web site
Your member name cannot be a blatant advertisement

Section G: Report Posts

You must not abuse the Report post feature. Blatant abuse will not be tolerated.

Section H: Site/code

Do not attempt to hack the site
Do not post compiled code, but source code is allowed.
Do not attempt to gain access to another member's account or any restricted areas of the web site

Section J: Administrators/Moderators

Members may never request to become an administrator or moderator
Any decision made by one administrator or moderator can be appealed
Any decision made by all of the Administrators is final

Section K: General:

Rules that are considered common sense or implied by the community also apply
These rules can be modified at any time by the administrators, so check back regularly

Webradiance > Web Development Forum > Databases

Combining CONSTANTS with MySQL queries

Combining CONSTANTS with MySQL queries,

Options

Beavis View Member Profile Find Member's Posts	Jul 30 2008, 10:15 PM Post #1
W.R. Corporal Group: Members Posts: 166 Joined: 24-March 08 Member No.: 883	This is another kind of newbie question that I hope someone can help with. The following query works fine. CODE $getDetails = "SELECT * FROM gallery_item LIMIT 0,6"; as does this CODE $getDetails = "SELECT * FROM gallery_item ORDER BY gallery_id DESC"; The idea is to later adapt the script to page through a set of results. I combined the two with this CODE $getDetails = "SELECT * FROM gallery_item ORDER BY gallery_id DESC LIMIT $startRow,$showmax"; where $startRow is dynamically generated and $showmax is derived from a PHP constant CODE define('SHOWMAX', 6); $showmax = SHOWMAX; but this last bit seems redundant so I was wondering how to insert a PHP constant directly into a MySQL query. I tried a few options but none seems to work. This post has been edited by Beavis: Jul 30 2008, 10:39 PM

Rob Kaper View Member Profile Find Member's Posts	Jul 31 2008, 02:26 AM Post #2
W.R. Corporal Group: Members Posts: 52 Joined: 19-July 08 From: Rotterdam, NLD Member No.: 1,069	CODE // concatenation $getDetails = "SELECT * FROM gallery_item ORDER BY gallery_id DESC LIMIT ". STARTROW. ",". SHOWMAX; // or sprintf? $getDetails = sprintf( "SELECT * FROM gallery_item ORDER BY gallery_id DESC LIMIT %d, %d", STARTROW, SHOWMAX ); (and many many more should work) -------------------- Rob Kaper - Rotterdam Capsi - Live music and concert community Personal website

TJSingleton View Member Profile Find Member's Posts	Jul 31 2008, 09:53 AM Post #3
Allegedly Legendary Group: Members Posts: 512 Joined: 31-July 06 From: Winder, GA Member No.: 11	or prepared statements: http://dev.mysql.com/tech-resources/articl...statements.html -------------------- Unique Web Design and Development

« Next Oldest · Databases · Next Newest »