Hi,
At 12:17 AM 2/7/2002 -0500, John George wrote:
I am a student a the University of Pittsburgh, and a new php developer. Is
it possible to have a mysql database that is made up of html documents that
can be accessed using php? This question may sound strange, but I'm not
sure of any other
See the set_time_limit() function in the php manual.
-Jason Garber
IonZoft.com
At 10:22 AM 2/4/2002 +0800, J-E-N wrote:
hello all,
i'm trying to make a script where i can do a mass insert to database
(4,000 entries) and then send confirmation email to each of the entry's
email address
if you have a date column 'birthdate'
SELECT (birthdate + INTERVAL 7 MONTH) as birthdate FROM yourtable WHERE ...
Look at the date and time functions in the MySQL manual.
-Jason Garber
IonZoft.com
At 02:28 PM 1/27/2002 +, DL Neil wrote:
Hello Sander,
I want to add a variable numer
I don't know much about javascript, but I would do the following:
1. Figure out what javascript data structure you are going to use to hold
the data.
2. Figure out exactly how it should be coded.
3. Simply write your PHP script to output your javascript as in 2.
The hard part of the matter
Hello,
You said that you are using MySQL. Create 2 columns like:
create_ts INT UNSIGNED NOT NULL,
last_login_ts INT UNSIGNED NOT NULL
Use the MySQL UNIX_TIMESTAMP() function, comparable to the PHP time()
function (number of seconds since 1-1-1970 12:00:00 AM).
UPDATE table SET
I just encountered the same problem...
I made a MySQL table with an email_id, email, and sentdate field.
while(true)
{
set_time_limit(10); //Give script 10 more seconds to run
SELECT email_id, email FROM thelist WHERE sentdate=0 LIMIT 1
if record not found, then break;
then I use
If you have a string that is the name of an input field, you can do one of
3 things:
Ex:
$sName = input.$i; //result = input1
$sName = input.$i; //result = input2
etc...
1: Variable Variables
$value = $$sName;
2: If you posted the form
$value = $HTTP_POST_VARS[$sName];
3: If you used GET
You read the mysql manual.
www.mysql.com
Look up alter table.
ALTER TABLE mytable ADD KEY keyname (keyfield1, keyfield2);
-Jason Garber
At 08:33 PM 10/23/2001 -0700, søren eriksen wrote:
How do I set up secondary keys in mysql?
--
PHP Database Mailing List (http://www.php.net/)
To
Matt,
Assuming that you have a variable number of records being displayed out of
the database:
As you write out the HTML, give each checkbox a name containing the ID# of
the record that is being written out. Ex:
input type=check name=chkAuthStatus_1203 checked
input type=check
the mysql_query function returns a Result Identifier. For every row in the
result (found by mysql_num_rows), you must call one of the the row
retrieval functions (mysql_fetch_array, mysql_fetch_object, etc...) These
functions automatically advance the row position in the Result.
Replace the
echo a href='$PHP_SELF?offset=$i*$step' target='_top'
Missing end quote and semicolon on this line may be the reason...
Try properly indenting and formatting your code. Also take advantage of
going in and out of php mode to seperate your code from your display of
content...
Ex:
instead of
Check out for MySQL mailing lists
http://www.mysql.com/documentation/lists.html
-JAson Garber
At 03:42 PM 9/20/2001 -0500, Christopher Raymond wrote:
NOTES: I know this is a PHP list, but I also know that many of you are
experienced MySQL admins. In addition, I was unable to find a MySQL
Just an idea...
You could do a str_replace(), replacing max with
span style=background-color: yellow max /span
You may need to use a reg-exp replace function to determine where actual
words are like max, vs. substrings like maximus.
see http://www.php.net/manual/en/function.str-replace.php
13 matches
Mail list logo