it's result set.
Well, I typically do loop over the result set but typically don't loop
over the fields in each record, so I don't know that I can agree with the
weight you put on that. But at least I see why I could care :-)
%
% Chris
Thanks HAND
:-D
--
David T-G
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP
for. If
Hmmm... You mean like taking results
1 a
2 b
3 c
4 d
and changing it to
1 2 3 4
a b c d
or such? I'm certainly confused.
TIA HAND
:-D
--
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage
John, et al --
...and then CPT John W. Holmes said...
%
% From: David T-G [EMAIL PROTECTED]
%
% can't think of a practical example for which I would loop over $row...
% Care to help me out?]
%
% How about a dynamic query where you do not know the number of columns
Hmmm... I suppose so
us once a
month or so -- or for you to bug him and then YOU update us once a month
or so.
Thanks again to all, including John, HTH HAND
:-D
--
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work
domain? And others can ask
% for it to be installed for their accounts.
You should be keeping all of the domains' mail separate anyway, so that's
no big deal.
%
% All help mostly appreciated.
I wonder how 'mostly' this input will strike you :-)
%
% Thanks!
HTH HAND
:-D
--
David T-G
Beckman Internet Guy
% [EMAIL PROTECTED] http://www.purplecow.com/
% ---
HTH HAND
:-D
--
David T-G * There is too much animal
Peter, et al --
...and then Peter Beckman said...
%
% On Wed, 27 Aug 2003, David T-G wrote:
%
% Looks like it, though I admit that the manual doesn't adequately explain
% your results. Check out section 6.2.2.4 for details.
%
% I did; see my previous (moments ago) email on my read
14000 in a varchar field).
HTH HAND
:-D
--
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur
you mean :-) Spend a *lot* of time with the manual!
HTH HAND
:-D
--
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org
looking
for a all_in_one solution.
Thanks for your help!
Aaron
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:07 PM
To: Aaron Wolski
Subject: Re: [PHP-DB] alphabetical sorting... limiting and paginating
onnext set of letter group
function($char_begin, $char_end)
{
$q_begin = strtolower($char_begin);
$q_end = chr(ord(strtolower($char_begin))+1);
make that
$q_end = chr(ord(strtolower($char_end))+1);
sorry.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
To make it little more clear, always write session_start() on the top of the
page. Because if you output some thing to the browser without starting a
session will show you these kind of error.
-Sourabh
From: Ford, Mike [LSS] [EMAIL PROTECTED]
To: 'Ahmed Abdelaliem' [EMAIL
Hi,
Session problem.
I am getting a weird session problem in my site.
Background of the Problem:
--
My site use sessions for user authentication. Site has a Admin Panel where
admin can search users and then through a link
(which has login and password appended) login as
do a var_dump($result_set) to see what $result_set contains (if it's
actually and array.
(did you implement the code given as is? if not AND you have put line-11
in a function and $result_set as a global variable then you need to
define $result_set as a global inside the function.)
ramil
On
a simple way would be to :
$pass = $allowable_characters[mt_rand(0,$ps_len-5)]
for($i = 0; $i ($length -2); $i++) {
$pass .= $allowable_characters[mt_rand(0,$ps_len-1)];
}
$pass .= $allowable_characters[mt_rand(0,$ps_len-5)]
// This variable contains the list of
On Wed, 2003-06-18 at 08:16, [EMAIL PROTECTED] wrote:
Hello,
Would be grateful if someone couldkindly point me in the right direction.
Whenever I try to connect to mysql server, I get these messsage back
1.
mysql GRANT ALL PRIVILEGES ON *.* TO moses@% IDENTIFIED BY cludiana;
ERROR
On Tue, 2003-06-17 at 03:08, Nathan wrote:
# ./bin/mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
030616 12:04:24 mysqld ended
I'm running the command as root so I don't think it's a permission issue. Does
anyone know anything about the PHP install that would
pg_last_oid returns the last object id (an id used in the system
catalogs) and not the ID/index of the row.
if you need to get the last ID, you need to execute another select or
write a pl/sql function.
On Tue, 2003-06-17 at 10:13, Norma Ramirez - TECNOSOFT wrote:
Hi all,
Im starting with
I hope this is something easy I am overlooking but here goes:
I have a table called: country which has the following fields:
FieldType
ip_from double(11,0)
ip_todouble(11,0)
country_code char(2)
country_name varchar(50)
IP_FROM
. If you want to
show how you've used php to create an anti-war site, then that's great.
If you want to ask for help in your php project praising GWBush, then do
so. If you want to talk/evangelize/whine about war, however, then go and
do it elsewhere. It is NOT welcome here.
TIA
:-D
--
David T-G
Craig --
...and then Craig Kohtz said...
%
...
% The script I've included works for a table named structure with the
% following fields:
Sounds interesting. Care to actually post the script? ;-)
I'd like to see it.
TIA HAND
:-D
--
David T-G * There is too much animal
of the awesome depth of
functionality available through CPAN, a collection of modules and tools
for perl that already do, and generally quite well, anything most people
are likely to want to do :-)
HTH HAND
:-D
--
David T-G * There is too much animal courage in
(play) [EMAIL
obviously haven't found the beginners, beginners-cgi, and db
lists at perl.org yet :-)
% for my Perl scripting. (This last may sound like sucking up, but it's the
% honest truth.)
Hey, these *are* awesome lists :-)
HTH HAND
:-D
--
David T-G * There is too much animal
spit out the leading javascript and then
passthru the actual file.
Note that those of us who have javascript turned off can use the right
mouse button all we want :-) It may not be worth your effort.
HTH HAND
:-D
--
David T-G * There is too much animal courage in
(play
can ODBC it, and use ms access and it's report writer.
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
echo 4year; //would return 00
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi I was wonder if any knows how 2 display sound clips held in a mysql
database using a php page ? I have stored the urls of the clips in
mysql database and I belive I need some like to (below) to display them
but its not quite working.
while ($row= mysql_fetch_row($result)) //retrieve a row
Thanks got it working
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
please don't send password over the internet.
better you ask the user if they click the link
below your email. then the user get a formular
and there you can ask him for his password.
then you can make sure the emails wasn't read
by other user. this is a secure method.
--
Leo G. Divinagracia III
rather than relying on img... tags to simply point
to them.
HTH HAND
:-D
--
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
; this comes up at least twice a
month.
After that you could take a look at the Fine Manual and read the Fine
Example and try it out.
That's all there is to it!
%
% Thanks in advance,
%
% Gabriel,
HTH HAND
:-D
--
David T-G * There is too much animal courage
invite you to surf over to
http://www.unicom.com/pw/reply-to-harmful.html
and have a read on why this is such a bad idea.
%
% -- Mitch
Now back to our regularly schedule discussions...
HTH HAND
:-D
--
David T-G * There is too much animal courage in
(play) [EMAIL
... lol...
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
z
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
, shell, whatever) to do the dump and
then just call it from your web click or, better yet, from a crontab.
%
% Any examples would be really appreciated :-)
Answers first, grasshopper :-)
%
% Thank you.
%
% Regards
%
% Chris
HTH HAND
:-D
--
David T-G * There is too
and 6.0
% Mozilla 1.1
No lynx?
bash-2.05a$ lynx --version
Lynx Version 2.8.4rel.1 (17 Jul 2001)
Built on freebsd4.5 Jan 23 2002 07:28:38
I'm crushed! ;-)
HAND
:-D
--
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient
for (filmID - fd_date)
loop
select sd_starttime from session_data where fd_id = sd_fd_id
print sd_starttime
end loop
next fd_date
next movie
film_detail has a 1 to many to film_date
film_date has a 1 to many to session_data
--
---
Leo G. Divinagracia
if you try to access
your data, the system would not let you in.
this is common.
--
---
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
How can I query this characters 'áéíóúÁÉÍÓÚñÑ' from a MSSQL DB with PHP???
Actually I obtain this: ' '¡¢£µÖà餥'!!!
Thanks
Fernando Bernain
Senior A
Business Process Outsourcing
KPMG Argentina
Tel: 54 11 4316 5754
Fax: 54 11 4316 5734
[EMAIL PROTECTED]
Email Disclaimer
The
:10 PM
To: Bernain, Fernando G.; 'Peter Beckman'; Hutchins, Richard
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Users on line
Hi
My bank uses two processes. If a user is inactive for more than about 5
minutes it forces you to log in again. This is done server side and just
does not allow you
I dont know if its the best solution, but I made a function that cut the
date:
function sqldate($fecha) {
$dia=substr($fecha,0,2);
$mes=substr($fecha,3,2);
$anio=substr($fecha,6,4);
$fechasql=$anio./.$mes./.$dia;
return $fechasql;
I'm working with MSSQL7.0 Apache 1.3.19 and PHP4.2.3
When I select a table with this kind of characters: ó The output is ¢...
I have the same problem with the others vocals (á-é-í-ú)
What can I do??? Forgot the spanish???
Fernando Bernain
Senior A
Business Process Outsourcing
KPMG
[EMAIL PROTECTED]
-Original Message-
From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 2:30 PM
To: Bernain, Fernando G.; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Special characters
Fernando,
try to store you data in unicode (utf8) for example.
You iconv
time, it nearly killed my programming machine...).
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
z
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm working in an app that requires to know who are on line. When the user
login the app, I use session in order to storage de name and login. Its
posible to do this???
Thanks!
Fernando Bernain
Senior A
Business Process Outsourcing
KPMG Argentina
Tel: 54 11 4316 5754
Fax: 54 11 4316 5734
: Peter Beckman [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 4:49 PM
To: Hutchins, Richard
Cc: Bernain, Fernando G.; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Users on line
I agree; it'd be nice if there was some sort of code that'd be executed
when someone closed their browser
This is from de books online (MSSQL).
@@IDENTITY (T-SQL)
Returns the last-inserted identity value.
Syntax
@@IDENTITY
Return Types
numeric
Remarks
After an INSERT, SELECT INTO, or bulk copy statement completes, @@IDENTITY
contains the last identity value generated by the statement. If the
Message-
From: Bernain, Fernando G. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 10:09 AM
To: Ryan Jameson (USA)
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: NewB: Return New Record ID...
This is from de books online (MSSQL).
@@IDENTITY (T-SQL)
Returns the last-inserted identity
to be an easy way to do this. Now my sql server is saying this:
Connection is busy with results for another hstmt, SQL state S1000
. it looks like I'll have to take my chances with select max()
Ryan
-Original Message-
From: Bernain, Fernando G. [mailto:[EMAIL PROTECTED]]
Sent: Thursday
Michael, why do you need to link de manufacturer table with de product
table? I think that you have to clarify the design of your db and your
business rules first... for instance, if you have to reuse the IDs (the
barcode and de manufa cturer ID), then you will create new tables in order
to
There is a utility called MyAcess it is like MyODBC and I have used it to do
this exact thing. It works very well. I believe you can find it on
Freshmeat.
Thomas G. Knight
[EMAIL PROTECTED]
http://www.slaponline.com
-Original Message-
From: David Eisenhart [mailto:[EMAIL PROTECTED]]
Sent
I'm working in a migration of an application from MSSQL7-VB6.0-Crystal
Reports to MSSQL7-winApache-PHP4.
I'm having problems with the reporting, because I cant find an user
friendly solution for the creation of reports with PHP (I need something
similar in functionality and look and fell to the
--
.: B i g D o g :.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
this. I installed oracle 9i on SUSE linux 8.0.
Best Regards
Maizar
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
.: B i g D o g :.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
is being duplicated on a multiple
select but not on a single select?
Sorry if this sounds confusing :(
Aaron
--
.: B i g D o g :.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
:(
Sorry again all.
Aaron
--
.: B i g D o g :.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
://www.php.net/unsub.php
--
.: B i g D o g :.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Morgan
Admin Computing Section
University of Brighton
Tel: +44 (0) 1273 64 3930
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
.: B i g D o g :.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
be appreciated
Ray
P.S. if any one also knows how to get it to display a 2 or 3 months at a
time or even a year this would also be a bonus as I have tried to do this as
well.
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net
translation. handy site to keep around...
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
...They have autoindexing built into the Apache server.
just add an .htaccess file in that directory saying no one but LOCALHOST
has access to it...
http://www.javascriptkit.com/howto/htaccess5.shtml
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http
is that it's limited to 255 bytes...
good news is that it's N+1 byte size.
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
for the other tasks? or a single
user that does everything including the INSERTS?
and where are you storing the username and password? in the code itself or call it
via the INCLUDE statement?
thanks...
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http
= microphones;
so it didn't help.
Can anyone offer a hint?
Thanks,
russ
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
,
russ
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.
With best I mean the most data efficient way and in the same time the best
for fast searching later on the table to find all which are false, or true.
I think I did read something about a way to do this with ENUM, but cant
remember where and how, all tryes did not succeeed so far.
--
Leo G
RIGHT
JOIN KeyWords ON Emails.ID = KeyWords.EmailsID) LIMIT 250
I am getting an error, and I am quite certain that it is my syntax
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
;
}
Regards,
Manoj
'I have miles to go before I sleep, and promises to keep'
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net
sara
12 1michael
12don
92beth
42bob
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Any ideas how to generate a unique serial number that you can check that
it's valid..
Thanks...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Ma
this?
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
MySQL has xml support...have you looked at the docs at mysql.com for
anything that might help you input the data directly...
B i g D o g
- Original Message -
From: Peter Lovatt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 3:03 PM
Subject
I had to reinstall PHP SQL, now whenever I run a PHP script I get the
following error, can someone please help.
Thanks
CGI Error
The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are:
--
PHP Database Mailing List
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
Hi olinux,
If I understand what you are saying...I would use mcrypt and encrypt the
stored info, keeping the KEY and IV in a separate location for when you need
it. Chances that anybody will break the triple des encryption without the
KEY and IV are slim to none. That way, you don't have to
Hi olinux,
This is what I ended up doing. This will work if you have a PHP that was
compiled with mcrypt as it is, just pass the info to your encrypt and
decrypt functions. The key I used is 123 but you can use something
different. The Initialization Vector is hard coded, but there is a function
Hi All,
I'm just new to this list and I'm hoping somebody might have information leading to a
PHP that can access an MS Excel Spreadsheet. FreeBSD 4.2, PHP 3.0.18 (for gif GD),
Apache1.3.12.
I have had no luck getting any of the ODBC functions to work with this OS
(odbc_connect, php compiled
emphasize!) Also, any ODBC driver you would recommend?
-Paul
- Original Message -
From: Andrew Hill [EMAIL PROTECTED]
To: Paul G [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 2:37 PM
Subject: RE: [PHP-DB] FreeBSD 4.2 and ODBC
Paul,
You can simply download
Hello,
My boss is going through the mysql.com tutorials starting at ...
http://www.mysql.com/articles/ddws/12.html
... and currently stuck at ...
http://www.mysql.com/articles/ddws/13.html
The boss is using phpMyAdmin to access the database, and everything
has been working just
How about
LOAD DATA INFILE 'filename.txt'
INTO TABLE Table
FIELDS TERMINATED BY ',' comma delimited for tabs use '\t'
LINES TERMINATED BY '\n' *nix line terminator, for Dos/Win use
'\r\n'
IGNORE 1 LINES use if the first line of the file has col.
hdrs.
Not sure but if line 358 is...
358nobr
.. as it says below, then the before the no needs
a beginnnig to it somehow. It's like a html-tag that's
only half baked.
--
__ _Tyler Nally
/ /__ _(_)___ _
Luke M. said:
Find the DIRECTORYINDEX attribute in httpd.conf and add 'index.php' to
the list:
DIRECTORYINDEX index.html index.php index.wml homepage.html
index.shtml
homepage.shtml index.cgi homepage.cgi index.htm \ Index.html
Homepage.html Index.shtml Homepage.shtml Index.cgi
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
Hmm it's not PHP functionality that makes
html ugly as shown at validator.w3.org. It's the person's
html/php coding ability to avoid coding mistakes.
Basically, PHP gives functionality. A part of that functionality
is for the php programmer to make correct HTML as output so
the
okay, you consultants...
i'm gonna venture at work to do some side jobs here for some online
dynamic web pages. but what would be a good starting pay rate?
or would you contract for the entire job? what about a per PAGE/SCRIPT
basis?
thanks...
--
Leo G. Divinagracia III
[EMAIL PROTECTED
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
From: Thomas omega Henning [mailto:[EMAIL PROTECTED]]
Subject: [PHP-DB] wildcard in mysql search with php
Is there a way to use wildcards in search in a mySQL db?
e.g. I have a dbase of over 24000 records and i can only search exact
matches is there a way to search something like this :
The manual says...
Remember that the header() function must be called before any actual
output
is sent, either by normal HTML tags blank lines in a file, or from PHP.
It is a
very common error to read code with include(), or require(), functions,
or another
file access function, and
[*NOTE* - I sent this yesterday. Since I didn't receive a copy
back from the listprocessor, I assumed that it was lost somewhere
along the way. --TGN ]
Hmm I'd first put a or die clause onto
the clause...
$updated =
. i inserted few dates in the above format and asked
mysql to list them by date and it does not seem to work.
any suggestions?? please :)
ax
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
Hello,
I'm trying to store HTML (that is cut-n-paste from source)
into a textarea field on a web page. As it's submitted to
the php page that processes it, the database column that
it ends up with strips the and out of the html
so that it doesn't end up in the source.
Example I can
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
101 - 200 of 223 matches
Mail list logo