Hey all,
If I use a query like: "SELECT * FROM mytable WHERE <condition> LIMIT 0,10"
What's the best method to determine if there more rows available?
Obviously if less than 10 rows are returned I know that there are no more. But if 10 are returned I can't tell if there are any more of if...
Hi!
We are looking for one or two programmers to help with programming and customizing our web based system.
The ideal candidate must have the following qualities:
- Is responsive and available to start immediately
- Be able to work fast yet diligently
- Team Player
- Must have strong...
Not sure if this fits in here, so feel free to move if needed.
Source: http://www.databasejournal.com/features/mysql/article.php/3865811/article.htm
Read further at the link above.
I have 2 tables, entity_A and entity_B.
entity_A has a field that links to one or more records in entityB.
entity_B has only a handful of records (say 20), while entity_A has a few thousand.
What is the best way to design for this? It doesn't seem to make sense to have entity_B have an...
Not sure if this is the right forum, feel free to correct me if not ;)
I'm looking for a Linux hosting provider for my website. I signed up with Axxess recently because they were the cheapest whilst offering MySQL, but I'm not at all impressed with the features and speed (I take it to be...
Hi guys,
Ok this is a n00b question:
:o
I have 2 tables:
a) Table_Seller
sellerID(PK)
sellerName
b) Table_Property
propertyID(PK)
property_address
sellerID(FK)
The problem I have is; When ever a seller registers, their details (name) is inserted into the...
Hi guys,
Ok, at the moment i have two sql database forms ( frmMember and frmBook ).
Now im following in the book on adding these two forms to a new project and the book says i must do the following:
Project | Add to project and select the unit ( which in this case is C15e02u ).
Now save the...