Databases

Date calculation from MySql table
I want to calculate the registed users today Also total users this week Total users this month Total users this year The Mysql table has a row of INT(11) with time() value inserted. I did something like this $today = strtotime("+1 day") Then $sql = "SELECT COUNT(*) FROM table WHERE dateReg <= $today"; Sam... 12 Apr 2008 11:53

php-db Digest 9 Apr 2008 13:17:18 -0000 Issue 4019
The question is. Some nestled calculation. How did club freedom did the calculation, or how will the database structure looks like? *The example is -: * *Joseph* gave birth to *John*, *James,* and *Johnson* *John* gave birth to* Peter*, *Matter*, and *Potter* James gave birth to Juliana, Justin, and *Jane*... 9 Apr 2008 17:54

Nestling Array in PHP from MySql
Well i need a little ideal on nestling this php array. This what i want to do. Have you heard of online clubing? http://www.disneytreasures.biz/ This how it works, 1) (*Agent*) You bring 3 persons (first you as an agent or officer) 2) The 3 person you brought, brings 3 persons each 3) Again each perso... 9 Apr 2008 09:42

joins issues again
On Tue, Apr 8, 2008 at 7:28 AM, Steven Macintyre <steven(a)steven.macintyre.name> wrote: Hi all, I have the following SQL statement; SELECT count( salesID ) AS count, branch_name, company_name, branch.branchID FROM sales LEFT JOIN IGuser ON sales.IGuid = IGuser.IGuid LE... 8 Apr 2008 11:36

Fun with MySQL collation, HTML charset and PHP utf8_encode
How do I avoid having so much fun using utf8_encode throughout my document? I was thinking of using output buffering and then making 1 call to utf8_encode, but I think a better question is, how do I stop using utf8_encode completely? The docs say that utf8_encode "Encodes an ISO-8859-1 string to UTF-8". So if... 7 Apr 2008 16:45

mysqli_stmt_bind_param question
Hi Everyone, I have a MySQL database that I am accessing from PHP. The table in question has a auto increment field on it and I don't want to include that in my add/edit/update query's to the database... But I can't seem to figure out how to ignore it? Everything I have done seems to fail.. I am using pr... 4 Apr 2008 15:11

Dynamic Navigation with Limit
Hi, I'm trying to put limit of data fetch as well as dynamic navigation. Below is the try which I did but something is going wrong as $screen value is not increasing so when I click on NEXt button it refreshes the same page and Previous button does even show. Could you kindly have look on the coding and help me w... 3 Apr 2008 20:52

php4 to php5
I suppose I am behind the time in migrating from php4 to 5. That said, my main problem is getting variables recognised. I can see how to do it - you need to identify all the variables that could be sent from the page and then assign a name, as in $myvar=$_GET['myvar'] and ditto for POST variables if any. Is ... 3 Apr 2008 19:09

php + mysql + copy file
Hello I have the next code: -- archive_a_subir.php -- <form action="archivo_subir.php" method="post" enctype="multipart/form-data"> <input type="file" name="file"> <input type="submit" value="ADJUNTAR ARCHIVO"> </form> In archive_subir.php: <? $carpe... 4 Apr 2008 12:57

mssql_connect error only on command line
Hi, I have a problem with all my php scripts that use MS SQL Server, but only when I start them from the command line I'm using Apache 2.2.4 with PHP 5.2.5 on a server Win2k3 with SP2, and MS SQL Server 2000 on another Win2k3 server. If I run the same script using a webbrower as an internet page it works fine,... 2 Apr 2008 10:04