= "horror";
$array[1][4][9] = "IT";
etc, so I could pull them out into a select dropdown list nicely sorted.
I am not sure how to write an array function with an unlimited number of
levels. If someone could help out it would be greatly appreciated.
Thanks
Stephen
--
PHP D
I am having most of my problems because I am trying to do this walking
through the data a single time, with the assumption any records parentID
has an ID less than the child and therefore would already be populated in
the array...
On Sun, 21 Jan 2001, Stephen wrote:
> Date: Sun, 21 Jan 2001
,
>
> Maybe it would be better not to use a multidimentionnal array in a db.
> You should create to additionnal columns that stores the ParentID
> of the row.
>
> It's the easiest way to do it.
>
> Also you can create another table that would translate from
> n
SELECT * FROM table LIMIT 0, 20
LIMIT 20, 20
LIMIT 40, 20
etc
thats doing it with mysql anyways
- Original Message -
From: "Vipin Chandran" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 05, 2000 9:46 PM
Subject: [PHP-DB] Database Paging
> Hello,
> I am presently dev
When i use the alter statement in the PHP function mysql_db_query( ) I get a
permission error. I can CREATE tables, DROP them etc so there are no
permission problems as far as I know. Can anyone help ?
Steve
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://
Use this: ($dateInYourForm gives the date in three months time in the form
you gave below.
$threeMonths = mktime(0,0,0,date("m")+3,date("d"),date("Y"));
$dateInYourForm = date("d/m/Y",$threeMonths);
Cheers
Steve
"Manuel" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTEC
When you write the SQL statement write it as:
select count(user) AS count from log_request where date='$date' and
status = 'open'
(note i have added 'AS count' in there so it stores the value in
'count')
Now when you output the result write it as $line->count
Cheers
Steve
"Chris
Forget my last email. Similar but before I told you how to do it from todays
date. You need to parse the $effdate. Below would only work for 1 number
months. (i.e not Oct,Nov,Dec)
Find where / occurs in the string and you will be laughing. Once you have
those numbers in $day,$month,$year you will
use the function mysql_list_fields in url
http://www.php.net/manual/en/function.mysql-list-fields.php
Cheers
Steve
"Hermann Otteneder" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> hi,
> i'm using a mssql-database. now i want update a record with the
informa
You could have if statements for every option.
May be better if you have a for loop for some of the options -- SEE BELOW.
e.g
:
%s",$i);
}
printf(" 1916");
printf(" volta");
printf(" scatt11");
?>
Cheers
Steve
"Walid Dib" <[EMAIL PROTECTED]
Hi
I am wanting to use the value in a variable as a variable name. I know it is
possible but do not remember how to do it - what function to call.
Example
$section1 = "SECTION 1";
$section2 = "SECTION 2";
// I want to have a for loop that will call these variables.
eg for ($i=1;$i<3;$
Hello,
I was wondering how you make these markers. They're like what's on phpBB
that shows that a topic has new posts in it or something along those lines.
Thanks,
Stephen Craton
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://w
HELLO - this is probably a simple problem !!
Wanting to use in a html form and pass multiple value
into a php variable but does
not work. I only get a single value. Can you tell me what I am doing wrong
?
Does the multiple value get passed correctly in php
if ($task=="check")
{
pr
Cheers - query Answered
"Stephen Rhodes" <[EMAIL PROTECTED]> wrote in message
news:20021112162930.65021.qmail@;pb1.pair.com...
> HELLO - this is probably a simple problem !!
>
> Wanting to use in a html form and pass multiple
value
> into a php variable but d
reply with the output of this. Please reply to
[EMAIL PROTECTED]
Best regards,
--
Stephen Schadt
Technical Support Consultant
OpenLink Software
http://www.openlinksw.com
"Joachim Schade" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
&g
hello?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Try something like:
date_format(news_date, '%d %M %Y @ %H:%I:%S')
Go to http://www.mysql.com/doc/D/a/Date_and_time_functions.html and look for
date_format to determine what parameters to use in order to format the date
as you want it. Note that this method will actually format the date retur
It sound like you have Oracle installed on one machine and are attempting to
connect to it from another machine. If this is the case you may need to
install the client libraries on the machine that does not have oracle
installed. I recently did some development for a client in Windows and
rece
Hello from North Central University in Minneapolis.
I have two forms. Both relate to required student ministry involvement
(students must be involved in four semesters of Christian ministry to
graduate).
The first is a "credit registration" form which students fill out before
starting a ministry.
Hello from North Central University in Minneapolis.
I have two forms. Both relate to required student ministry involvement
(students must be involved in four semesters of Christian ministry to
graduate).
The first is a "credit registration" form which students fill out before
starting a ministry.
If all else fails, split on the &.
$url = split("&", $_SERVER["REQUEST_URI"]);
$args = $url[0];
Cheers,
~Steve
Steve B. wrote:
I have an online tutorial build into a web page.
It has button next step.
If you are on page index.php?abc=123 for instance
the code is smart enough to make it index.php?
Does the ip address of where you are trying to access the mysql database
from (client), change?If you have a dynamic ip address
your ISP should have a grant something to the effect of:
grant all on database.* to [EMAIL PROTECTED] identified by 'password';
This would allow your client to be a
What I would recommend is using PEAR's HTML_TreeMenu package for this.
http://pear.php.net/package-info.php?package=HTML_TreeMenu
I use it quite a bit in applications .. .download the souce (make sure you
have PEAR configured), and it even comes with an example.
Cheers,
~Steve
> What you're lo
Anybody have code that WORKS (hehe) for executing a MS-SQL stored
proceedure through PHP?
exec viewFacilities()
Thanks in advance!
~Steve
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
uot;;
$RES = mysql_query($SQL);
may have to prefix with exec like you mentioned...
change sp_runthis to your procedure name... probably still works the
same..
On Wed, 16 Jul 2003, Stephen March wrote:
Anybody have code that WORKS (hehe) for executing a MS-SQL stored
proceedure through PHP?
exec view
Norma,
I have found the best strategy is to setup an ODBC link to an
alternative to the database. As an example, I had a mysql database
"intranet", and I created an ODBC link to, with the MySQL ODBC drivers
(from the mysql.com site), and then opened up Microsoft Access.Went
file => ge
I'll bite.First of all, if Netscape / Opera browsers are running,
you can be guarenteed that it is a problem with IE, especially since you
just SP'd it. The URL for the fix you described is located at:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin
Have you considered using the console-tool, "mysqldump " ?
You could write a quick script ... say
mysqldump -u adminuser -p adminpass --all-databases > backup.sql
tar -zcvf backup.tar.gz backup.sql
mv backup.sql /somepath/backup.sql
if you're on Winders, a batch file:
mysqldump -u adminuser -
Any database that supports nested queries (unfortunatly this excludes
MySQL) ... you can do
select pic_id from pictures where pic_id not in (select pic_id from
album_pictures)
Otherwise you might have a harder time with MySQL ... something like set
difference if it supports it (I'm not s
I know that true randomness only exists in nature. However, the
randomization in PHP is fairly good. I have only used it on fairly small
scales (i.e. Randomizing 200 quotes to give a random quote when people log
onto a page.)
For passwords I have always gone an easier route.
$password = time();
Did I miss the actual insert statement?
Can you please show me your insert statement?
http://www.thelonecoder.com
[EMAIL PROTECTED]
562.924.4454 (office)
562.924.4075 (fax)
continuing the struggle against bad code
*/
?>
> From: sultan Ibraheem <[EMAIL PROTECTED]>
> Date: Wed, 9 Mar 2005 1
Do you receive any errors or anything that might indicate a problem other
then the date not appearing the db ?
Be wordy -- hold nothing back -- give me as much as you can.
http://www.thelonecoder.com
[EMAIL PROTECTED]
562.924.4454 (office)
562.924.4075 (fax)
continuing the struggle against
This may not necessarily be the problem. But I am not sure that you should
be capitalizing the first character of your variable.
That is a special type of PHP variable - which I do not use normally - so I
can not remember what it is called.
However, put all your variables to lower case except th
Did you compile php or did you install from a binary?
If you compiled -- did you configure the PHP module --with-pgsql?
I have not installed a binary in the past so I am not sure how you activate
the pgsql module in that regard.
The problem though is that the version of PHP you are running is no
not workign through PHP only.
Any pointers would be very helpful.
--
Warm Regards
Vinayak
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
*
Stephen Johnson
[EMAIL PROTECTED]
http://www.thelonecoder.com
--continuing the s
more characters in a string
(ideally binary).
-Stephen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
$realones = $row['id'];
This line needs to be
$realones[] = $row['id'];
...then you will be filling an array instead of just overwriting the same
variable repeatedly!
-Stephen
- Original Message -
From: "Dave W" <[EMAIL PROTECTED]>
To:
My first thought is that your values in your insert statement are not in
quotes..
>
> $insert = 'INSERT INTO domains ( picture, thumbnail ) values(
> $picture, $thumbnail )';
Should be
$insert = 'INSERT INTO domains ( picture, thumbnail ) values( "$picture",
"$thumbnail")';
Hope that
; thumbnail ) values( "$picture", "$thumbnail" )
>>
>> excatly like that. Shouldn't the values echo as what should be inserted
>> into the database?
>>
>> - Original Message -
>> From: "Stephen Johnson" <[EMAIL PROTE
OK guys, here is my delima, which is probably very easy to solve, but I can't
seem to find it. I am trying to get form fields to accept apostrophes within
the input and stop crashing on me. I'm writing forms into a mysql database and
everything works great unless the user enters a word like "w
I'm getting the above NOTICE with the following statement:
Echo date('d/m/y',$CTS);
Where $CTS = 2007-09-22 10:09:31
And 31/12/69 is being echoed.
PHP 5.2.1
MYSQL 5.0.37-community-nt via tcp/ip
Thanks in advance for any insight.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscri
hould be a unix timestamp value, so $CTS should contain
an integer value.
You can also find ways to convert the time value you have to unix
timestamp, in the manual.
-Original Message-
From: Stephen Sunderlin [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 7:48 PM
To: '
e it, of course, if you may be
presenting the datetime value in different ways, or if you want the
flexibility, then use php.
I hope this helps somewhat.
-Original Message-
From: Stephen Sunderlin [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 9:24 PM
To: 'Naintara'
Naintara,
That worked!
I must have made a syntax error.
Thank you!
-Original Message-
From: Naintara [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 1:34 PM
To: 'Stephen Sunderlin'
Cc: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well
Neil,
Have you had success with triggers. I couldn't get one to work and then saw
discussion on the board here that MYSQL triggers were not so reliable and
still somewhat problematic so I archive through the application.
Just curious.
-Original Message-
From: Neil Smith [MVP, Digital
When I put his line outside of the php tags I get the correct size:
When I put this line inside the php tags the size comes out about 2 rows by
10 columns regardless of the value of rows and cols.
Any ideas on how to format this would be greatly appreciated. The mySQL db
column TYPE I am cal
It seems to be ccing each email to everyone and I'd like it to only include
one email address with each email. I've tested in on three of my personal
emails and I see to get six messages in my inbox.
I'm also sending about 4000 emails and would like some pointers to avoid
time out errors.
Finall
calculations on the formatted variable since it now considered a string.
Hope this helps
--
Stephen Johnson c | eh
The Lone Coder
http://www.thelonecoder.com
continuing the struggle against bad code
http://www.thumbnailresume.com
--
> From: Ron Piggott <[EMAIL PROTECTED]>
> Organi
prompt security warnings
that will bug your users.
--
Stephen Johnson c | eh
The Lone Coder
http://www.thelonecoder.com
continuing the struggle against bad code
http://www.thumbnailresume.com
--
> From: Hiep Nguyen <[EMAIL PROTECTED]>
> Date: Mon, 17 Dec 2007 15:13:45 -0500
>
$query = mysql_query("SELECT * from gig WHERE gigName='$gig_name' or
gig_fdate='$sdate'");
You can not use more then one WHERE in your sql statement... And SQL accepts
OR and AND..
--
Stephen Johnson c | eh
The Lone Coder
http://www.thelonecoder.com
continuing
at your
database design to see if it can be normalised or something...
Stephen Wellington
On Mon, Sep 15, 2008 at 4:06 PM, Mike Sullivan <[EMAIL PROTECTED]> wrote:
> Hello all. I'm using PHP to build a query for a database that consists of
> multiple tables, all with identical at
I'm emailing an html file through phpmailer and the sql look up is getting
the html from a table and setting it into a variable. Within the html from
the table are also variables that are also being called by the same sql that
is looking up the html variable. However the variable in the html are
Hello there, yeah I'm new to this list and I'm no professional, but I'm
sure something can be done to help you. And welcome to the world of PHP
and MySQL... bring paracetamol :)
Okay when you say you've installed WAMP, you are installing Windows,
Apache, MySQL and PHP on your web server (be it lo
I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box trying to
loop through a while statement to send about 3000 email using
phpmailer. It's worked well in the past but after an upgrade it seems
to be timing out now after 200-300 emails over 1 minute or two. I've
added set_time_limi
Antonio M?rmol Albert ([EMAIL PROTECTED]) wrote:
> With index in the third table, How would it be ?
It depends on the dynamics of the application.
1) If you have to ask "what cateogories does the editor edit?", you
create an index on editor.
2) If you have toa sk "what editors does this categor
Sharmad Naik ([EMAIL PROTECTED]) wrote:
> I know that this mail is not to be posted on this list
So, then why'd you post it?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list admini
I am currently running on a Windows Box the OS is ME
I have installed apache 2.0.44 and I have downloaded the newest PHP download
for windows.
I have read the configuration manual repeatedly for getting the php into the
apache httpd.conf doc file. but I still cannot get php to be recognized.
Can a
code
below. Can someone please look and help me so that I can upload the image
to that folder.
Thank you!
In Kindness
Stephen K Knight
\n";
// echo "newname = '" . $newname . "';\n";
// echo "\n";
}
--
PHP Database Mailing List (http://
?>
If someone could fix this I would greatly greatly apreciate it!
In Kindness
Stephen K Knight
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is there a way to pass a value from on html page to another on a different
server through a URL and have that value input into a form.
The value trying to be passed is a record id from a database.
In Kindness
Stephen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
doc
in the html doc but it didn't work.
Any ideas?
In kindness,
Stephen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
61 matches
Mail list logo