[limit] Forum Topics

i have two mysql tables.A java application is working there which picks data and insert into second table.what i want is if there are less than 60 rows in targeted table then java application should stop when there is less than 60 entries only then it should insert data in …

Hi, Can any body provide me some code reference regarding,how to limit execution of a function to a registered user everyday for n number of times.Like user can only send 20 mails everday.so allowing execution of mail function for only 20 time everday and resetting the counter the next day …

hello, I need to display contents with their tags, and in same page all the tags of the page contents the problem is having a limit on contents doesn't work if join tags on them (the number of tags change the number of select contents) [B]THE TABLES ========== [/B] I …

Hi, How do you set a text input field to have a character limit? Say for example, the user had to enter a postal code of 4 characters, how would you limit the text field to only allow 4 characters? Thanks, Ashton.

Hey all, I have several cron jobs running but some of them take a lot of time to complete, since it requires fetching data from an external website and then updates my site's database. My hosting provider has a 120 second time limit for PHP scripts, which is too low …

Does anyone know why the following subquery is using filesort and scanning all rows in the table according to EXPLAIN? I am trying to get the total of the top ten scores and the result is fine. [CODE]EXPLAIN SELECT SUM( score ) AS top10_total FROM ( SELECT score FROM answers …

Right, so I installed a 512mb module, but it is only showing 64mb? Im sure its compatible, it is pc133-333-542, just like the 128mb that came with the computer. I upgraded my bios yet still no luck :( Thanks in advance

[B]Hi, im new to this forum, and as far as I know. this hasn't been posted. What I am trying to create is a log in system, and in one of my forms I want to limit the date entered into a form. For example a user cannot enter a …

I have a table and I want to start the select with the 20th row. How do I do this? Does conditionals work on "limit"

I was trying out a 2-dimensional integer array on a UNIX box. I hit up a 'Segmentation Fault' on trying to run it. [CODE]#include <iostream> #include <cstdlib> using namespace std; int main() { int matrix[2000][2000]; int i, j; srand ( 1 ); for (i=0; i<2000; i++) { for (j=0; j<2000; …

Hi, I have a bit of a strange problem where I am unable to "echo" results from a database - I will show you the code then explaine what im trying to do [code] <?php include_once "connect_to_mysql.php"; $sql = mysql_query("SELECT * FROM table ORDER BY RAND(), LIMIT 1"); while($row = …

Hi all, I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g. [code=sql]SELECT [ID] FROM dbo.Users WHERE Status = 1[/code] -- and then some code to get let's say fifth record …

Hi dear all I have 2 question to be asked 1. everything is working fine but I couldnot understand [ICODE]$page = $_GET['page'];[/ICODE] what function is performing in the script? 2. when I change limit greater then 2 its not echo any record but for limit=1 or limit=2 its working perfectly. …

I can't seem to limit the result to a desired number. I have this code: [code]//GET THE TOTAL OF LEVEL 2 $result = mysql_query("SELECT COUNT(*) FROM agents WHERE (sponsor = '1' or sponsor = '2' or sponsor = '3') LIMIT 0,1")or die(mysql_error()); while($row = mysql_fetch_array( $result )) { $lvl2parent = …

I was wondering if there was a way to only allow myself to access certain pages on my website? Is there a way to do this by using my ip address? And if someone with a different ip try's to access the page they are denyed or forwarded back to …

Hi guys , I am new here. I am facing some error in ma vbulletin forum. my php memmory limit is set to 32MB . while trying to upload a file to forum(URL UPLOAD) i am getting a error Fatal error :out of memmory(tryied to allocate 123334bytes of 682111 byts) …

This is possibly going to be very badly timed. A lot of users are going to get very confused. Essentially in the UK we have a lot of free or very cheap Internet services. We also have a lot of people - Apple, the BBC, many media providers - offering …