l the returned data.
Is there an option I'm missing to assign a field as the output array index from
a PHP based query?
Thanks,
--
Richard Scotford
Mysql 8 is already the stable version and has been for a while. I for
development use it on windows and its v8
-Original Message-
From: Ruprecht Helms
Sent: 08 September 2021 16:02
To: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQLnd support for ed25519
Hi Dimi,
I think mysql 8
I have made multiple attempts to get PDO-OCI to work in PHP 7. Sometimes it
fails to compile at all, other times appears to compile correctly, but I
can't connect to any Oracle databases. Thus far, this has kept me stuck on
PHP 5.x.
The relevant part of my configure statement is:
./conf
Hi! This is the ezmlm program. I'm managing the
php-db@lists.php.net mailing list.
I'm working for my owner, who can be reached
at php-db-ow...@lists.php.net.
To confirm that you would like
arch...@mail-archive.com
added to the php-db mailing list, please send
an empty reply to th
;
>
> Best,
> Karl
Wow, working code! Thanks. I did try it:
0){
for($i=0; $i<$num_rows; $i++){
$c = mysql_result($result,$i,"contract");
echo sprintf( "|%13d |%7d |\n", $c, $i );
}
}
?>
But it does the same thing:
PHP Fatal error: Allow
ow['contract'];
>// do what ever you'd do with the new contract
> }
> }
>
> assuming you are ordering by contract as in the example select.
Thanks for that suggestion, also.
Something more fundamental is going on.
Here is simpler code which still reproduces
etty trivial,
and was surprised to find that the routine ran out of memory.
This simple counting exercise is merely a test of the loop
algorithm so that I can do a 'cmp' or 'diff' comparison of the
output of the PHP versus the output of the SQL to verify that in
fact the PHP a
Running PHP 5.3.5 on FreeBSD 8.2 connecting to a MySQL 5.1.55
server.
Why does this code (below) run out of memory? It queries
test_table for all rows, all fields and sorts them by the numeric
'contract' field. It then iterates through the rows, and tallies
the number of rows pe
n the wamp icon
again, move to Apache, then Service, and then click on "Test port 80", then
you should get something like
--
Your port 80 is actually used by :
Server: Apache/2.2.11 (Win32) PHP/5.2.8
IL PROTECTED]
> SELECT MIN(id), MAX(id) FROM mytable
As an aside, is you are using associative arrays, be sure to use the
following keys:
$array['MIN(id)'] and $array['MAX(id)']
Just something I figured out recently :)
Matt
--
PHP Database Mailing List (http://www.ph
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
re's one small piece of data I left out. I'm working with
php/mssql, no mysql. I'll move to mysql when I get everything else
built. Mssql 2000 doesn't seem to like the = sign in the order by
clause. It looks like both of you so far have come up with the same
syntax thoug
I'd like to find a way to combine these 2 statements. I want to list out
all the products, ordered by title but listing out all the Cats products
first. Any way to do that without having separate statements?
Thanks...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: htt
s, etc.
I've looked around and haven't been able to find a way to search only for
complete words within a block of text. Any help?
Thanks in advance,
Zeth
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Assuming you're using MySQL, try MONTH(). As in:
SELECT MONTH(SomeDateField) FROM SomeTable
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
If this isn't a database question, but a general PHP question, try this:
// For numeric month without leading zero, us
Try this as your SQL. It should give you all the results, then you can use PHP
to sort it all out.
SELECT * FROM egw_cal WHERE cal_category='501' and cal_id in (SELECT cal_id
FROM egw_cal_dates where cal_start > $tstamp)
-TG
= = = Original message = = =
Hello Everyone
x27; and bring back the value
for contact_value
query WHERE contact_name='PrevSys' and bring back the value
for contact_value
Which are all different rows in the second table
with the same ID field
thats how they are linked to the first table
than
ow[PrepSys] $myrow[name]
I have tried alot of stuff to get this done, but i think i was very off task.
Some help/guide is needed I'm new
Thanks...
Matt
___
Sent by ePrompter, the premier email notification software.
Free dow
t;]);
while ($myrow = mysql_fetch_array($master));
echo "\n";
echo "\n";
else
echo "Sorry, no records were found!";
?>
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
"I would normally just pass the offset through the get var."
I understand what you are saying in concept ... but what would a sample
command be like?
http://www.host.com/script.php?next=21";>Next Link
http://www.host.com/script.php?previous=1";>Previous Link
Ron
I am wondering what the mySQL commands are to display the next 10
records / previous 10 records.
I am wondering how you pass a variable through a PHP script so the
script knows which next or previous 10 entries to display. (Especially
since this is all variable driven) Would you do something
hopname
";
$i++;
?> index.htm < Back to search
The search criteria you entered did not generate any
result, index.htm please try again .
~";
?>
~
.
--
View this message in context:
http://www.nabble.com/search-result-error-message-tf2867391.html#a8014
e the following connection string:
php:
--
$connection = mssql_connect <http://php.net/mssql_connect>('server','user',
'password') or die ('server connection failed');
$database = mssql_select_db <http://php.net/mssql_select_db
t does the rest as well. I could also do 2 queries where
> it calls it once in order WHERE !='', and then do another query to
> get the empty ones, but that seems a bit cumbersome.
>
> --
> Kevin Murphy
> Webmaster: Information and Marketing Services
> Western Nevada Comm
Community College
www.wncc.edu
775-445-3326
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
___
Sent by ePrompter, the premier email notification software.
Free
Community College
www.wncc.edu
775-445-3326
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
___
Sent by ePrompter, the premier email notification software.
Free
Is it possible to do an ORDER BY column_a column_b ASC ? IE Can you
specify two columns to cause the output to be displayed in a specific
order? Ron
If I give this command through PHP to mySQL
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "UPDATE `table` SET `last_activity_field` = '$current_date'
WHERE `reference` = '$account_reference&
I have completely missed it and need to try again.
Is there a slick and easy way to convert January to 01 ? (and February
to 02, etc) Ron
In one of my scripts I have
where
$saved_message_title is 1 Peter 5:7 "Cast all your cares on Him for He
cares about you"
--- note the "
When this is displayed on the screen it reads
1 Peter 5:7
I am assuming the " closes the value=
How may I echo this to the screen and have the full text
The way my web hosting server was configured is that files uploaded
through a web form to be processed by PHP are owned by 'www'. I am
wondering if I am able to change the owner of the file to my ftp user
name before I use the move_uploaded_file command to the directory I need
the file
I am wondering if someone would help me write a SELECT date query ...
Weekly mailings go out every Wednesday. I am setting up an
administration function and table to store the mailing name, PDF to be
contained within the mailing and the date for it to be used.
The SELECT query I want to create i
If I have the sentences
Check one two three four. You did well to count to four.
how do I put each word into an array (so there would be 12 components in
the array) as well as remove the period and make the C in Check and the
Y in You lower case
Ron
I have used both index.html and index.php in the various directories.
Is there a way to tell which was loaded if a user visited:
www.domain.com/directory/
?
Ron
Where '$eachLine' is a line of HTML code the following command
echo str_replace("http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html";>here.
I want to get rid of everything including and following the "
What do I do next?
I have been playing tonight for a few minutes.
The following code:
Produces me output like:
137
http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html";>here.
What I want to do now is to remove the
http://www.actsministrieschristia
out redundant data
> and in a MySQL database.
>
> ___
> Shaun Riches
> Computer Science Student
>
>
>
> -Original Message-
> From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]
> Sent: Thu 28/09/2006 03:44
> To: PHP DB
> Subject:
Has anyone wrote a search engine for the web site? I am wondering if
someone has the time to help me walk through doing this. Ron
Is there a predefined variable that will tell me the resolution of the
browser that is looking at my site?
EXAMPLE 1024 X 768 OR 800 X 600
Ron
r and then have
the javascript open the result page after the update is complete. I do this on
several of my webpages and it works great.
>Tamkhane, Pravin wrote:
>> Hi All,
>> I am a PHP newbie. I am using HTTP POST request to send some data to
>> Apache and then us
I realized this is off topic; I am not sure where I would look online.
Today I purchased a VX724 LCD monitor for my computer. I am running
Fedora Core (Linux). I am not sure where I would find a driver for my
monitor. ViewSonic's tech support told me they don't support the
monitor directly an
If $file_name includes the path
/path/to/file/file_name.pdf
is there anyway of searching from the right hand side to the left and
getting the file name out the $file_name variable? The file name starts
the character following the last /
Ron
I am creating a submit button on the fly. The purpose of this is to
open up a new browser window and then display the contents of a PDF
file.
The code for this button reads:
The window name is prayer_ministry_document_viewer
I am trying to access document_reference 1 which is in a mySQL table
You know forms which have a security field where the user reads back the
letters that are displayed? I am wondering if someone has the time to
coach me in writing this --- or if you know of a web page that shows how
to create this feature. I have already created a set of graphical
letters. Ron
You may get duplicate messages sometimes when someone responds directly to you
as well as copying the message to the main mailing list. Like in this ccase,
my To: field is the PHP DB list, and my CC: field is your personal email
address.
If that's not the issue, then try what Dave sugg
cron or Windows Task Manager would work if you want to check the status of the
data periodically, but I believe you can also use Access to hit a web address
(it doesn't have to display anything) so you could, at time of insert, have
Access activate a PHP script on your web server that doe
Here are some thoughts on the couple of methods shown:
1.
SELECT count(*) as MyCount FROM aTable # Fast query done on server size
SELECT * FROM aTable LIMIT 5 # Fast limited data return query done server side
2.
SELECT * FROM aTable # Potentially slow query, lots of data stored in PHP
n'
The 'unlink' command works within the context of a php script when
activated by a user on the web site.
Is there another file deletion command within PHP other than unlink?
Here is the error message I am e-mailed by the cron when it doesn't
successfully delete a session
Every now and then the following command fails --- the FTP connection is
refused by the server:
$conn_id = ftp_connect($ftp_server);
Is there a way to delete a file within PHP without having to FTP to the
server?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
Thank you for the thought, however, I don't have a shell that I can run in,
hence, I have to rely on help from others.
""JupiterHost.Net"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
> Grae Wolfe - PHP wrote:
>> Sorry I h
rst_name' AND last_name='$last_name'";
"Jeffrey" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Perhaps I have misunderstood something here. But it seems to me that
> anyone who just happens to put John Smith's name in could alter Mr.
esone"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Why don't you try populating the fields the user intends to modify
> with the information you already have?
>
> Alex T
>
> On 6/17/06, Grae Wolfe - PHP <[EMAIL PROTECTED]> wrote:
>>
one2',
email_address='$email_address',
farmers_barn='$farmers_barn',
wrhs_tour='$wrhs_tour',
crystal_rose='$crystal_rose',
registration_comments='$registration_comments',
date_registered='$today'
WHERE first_name='$first_name' AND last_name='$last_name'";
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
way to join the letters together
instead of having 6 different images displayed.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
s an example of how to do it in MySQL:
http://dev.mysql.com/tech-resources/articles/wizard/index.html
But again, not what the original poster was looking for.
-TG
= = = Original message = = =
google 'cross tab queries'...there is a php/mysql example (sorry travelling
and don't
tomers order by cus_name asc
While row is not empty do
echo"costomer name";
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
both this list, and the mysql list as I'm not sure
whether this is something that I'd need to do with the php or mysql.
Basically, I am making an add-on to my small website which is a mini online
game. Every user will have gold, and every 30mins I'd like their amount of
gold to go up
Again, my many thanks - I didn't know about the 'explode' function - that
may be a huge help.
Hopefully, I am on the right track now... thanks!
"Brad Bonkoski" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
> Grae Wolfe - PHP wrote:
back to making the DB create an auto-incrementing ID
number. Hmmm...
Thanks!!
"Brad Bonkoski" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
> Grae Wolfe - PHP wrote:
>
>>Good Day!
>> I am trying to use my limited knowledge to
row['first_name'];
$fname = $row['first_name'];
$lname = $row['last_name'];
$option_block .= "$lname, $fname";
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ick your code here replacing references to the
$suggested_category_1 var with $val
}
Incidentally, I do hope that code was simplified for brevity. There
should be extensive use of mysql_real_escape_string in there.
-Stut
--
PHP Database Mailing List (http://www.php.net/)
To unsubs
#x27;$variable' ,
'$reference_number', '$suggested_category_1')";
mysql_query($query);
mysql_close();
}
Is there any way to create a loop to check all three instead of me
repeating this code twice more changing $suggested_category_1 to _2 and
_3 ?
Ron
--
PHP Database Mailing Li
atever
}
}
There are other ways to handle this.. this might be one of the easier ones (if
I'm understanding your problem correctly).
-TG
= = = Original message = = =
Hello, all. I don't know if this is a php-mysql question or just a
mysql, but here goes:
I have a list of DVDs that
ly use single quotes for SQL statements.. in this case, it would
simplify your PHP SQL statement by removing the necessity to escape all the
double quotes \"
If you echo the SQL and it looks ok, try running it manually through mysql's
command line or via a program like WinSQL Lite on Window
_last_name, guest_name, street_address1,
street_address2, city, state, zip, phone1, phone2, email_address,
number_attending, payment, registration_comments, date_registered)
VALUES
(\"$first_name\", \"$last_name\", \"$hs_last_name\", \"$guest_name\",
\"
figure out how they do it (if at all) but I'm guessing
it's not going to really be feasible for you to do this... not easily at least.
-TG
= = = Original message = = =
Hi all,
I am developing the site using php and mysql. I have to add the url at
google site through php code.
If any
sage . $file_attachment_header . $data . $footer;
#file attachments and the file attachment headers are
#really part of the e-mail message
Then you issue the command
mail($email_address, $email_subject, $message, $headers);
Ron
On Thu, 2006-05-11 at 18:33 -0400, Ron Piggott (PHP) wrote:
>
Does any one know how to send a file attachment using PHP?
I have been using the mail() command to send e-mail in various scripts,
but have spotted a file attachment syntax to use on the php web page.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
I am using mySQL
On Mon, 2006-05-01 at 13:21 +, replies-lists-
[EMAIL PROTECTED] wrote:
>
> Original Message
> > Date: Monday, May 01, 2006 09:14:36 AM -0400
> > From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]>
> > Subject: [
How do I change the auto_increment / auto_index value? Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- containing the
component reference number from the component table (described above)
and also the member reference number.
Essentially if you are logged in your reference number is in a session
variable and using PHP & mySQL the script is checking to see which
components to allow you acces
Is there a command in PHP that is equal to the search & replace function
in a word processor?
If I want to search for 'this' and replace it with 'that' what would the
syntax be?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-0500, Ron Piggott (PHP) wrote:
> I am wondering if
>
>
> causes the
>
> session_id();
>
> to change or be reset.
>
> Some how my $_SESSION[''] variables are "dumping" when I use the POST
> command above.
>
> More importantly I am
I am wondering if
http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The other response is half correct.. I havn't seen anything to read data from
Excel with PHP (although it's technically possible, just kind of complicated)
so the easiest solution is to use Excel and just have it load the file and save
it in CSV format.
The part that's not e
Is there a way to unescape a string once the command
mysql_real_escape_string($variable);
has been used on it? (This is to display it to the screen, instead of
sending it to the database.)
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
Is there a way to re-name a table once you have created it? Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
operly. Here's the procedure i went through:
PHP Version: 5.1.2
Apache Version: 2.0.55
MySQL Version: 5.0.18
Windows XP Pro
1. launch the go-pear batch file
2. select system-wide installation
3. use default install directories: (Seems fine to me since PHP is installed
into C:\PHP)
Instal
essarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of
> its control, controlled, affiliates and subsidiaries companies. No part of
> this message or attachments may be used or reproduced in any manner
> whatsoever.
___
S
ail notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I wonder if someone would tell me the command in PHP that allows me to
write to a file --- for example "test.txt" Just for this example I
would like the word "apple" to be the contents of "test.txt"
Now if I want to re-create "test.txt" --- erasing all t
I did some searching and found the function on the PHP web site. Ron
"minus twelve thousand forty-five"
* Handles negative and positive integers
* on range -Long.MAX_VALUE .. Long.MAX_VALUE;
* It cannot handle Long.MIN_VALUE;
*/
function num2words( $num ){
$ZERO = "zero"
Is there a command within PHP that would convert numbers to words:
echo "1";
# 1 appears on screen
echo command('1');
# one appears on screen --- what would the command be?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Or you can have a page which detects resolution by javascript and redirects
to another PHP page with the resolution data
On 2/4/06, Bastien Koert <[EMAIL PROTECTED]> wrote:
>
>
> As the other poster mentioned you need JS to detect the screen
> widththe
> usual approach i
did you turn on display_errors and set error reporting to E_ALL in php.ini?
if not you should
On 1/20/06, Allen Schultz <[EMAIL PROTECTED]> wrote:
>
> Sorry, I was in a rush to work guys.
>
> All these were downloaded pre-compliled for Win32.
> Apache 2.0.55
> PHP 5.1.1 w/
ult($result,$i,"reference");
>
> to determine what numeric value was assigned.
>
> Is there a way I may find out what value was assigned to the
> $auto_increment_variable when the INSERT INTO query is issued?
>
> Thanks.
>
> Ron
>
>
> ___
to the
$auto_increment_variable when the INSERT INTO query is issued?
Thanks.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is there a way I may find out how many characters
$variable
is long after it has been submitted through a web form?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
able SET AmtOwed = '10.74'
Bye,
Balazs
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ly
works :)
(I am writing a SESSION function for my web site using mySQL and a cron.
The select statement I quoted above is part of the cron.)
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
en just a straight UPDATE was performed. I remember doing it
manually, not even through PHP, using absolutely no math functions, just a
totally straight:
UPDATE SomeTable SET AmtOwed = 10.74
Someone made a recommendation of "never use SOMETYPE for money.. you should use
SOMEOTHERTYPE instead
= Original message = = =
bastien
>From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: PHP DB
>Subject: [PHP-DB] Date & Time 90 minutes ago
>Date: Thu, 19 Jan 2006 16:57:33 -0500
>
>Would someone be able to help me with the DATE com
earlier is a day before. Thanks. Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am wondering if I may delete a file by FTPing within PHP.
I found the followed on the PHP web site:
fopen("ftp://user:[EMAIL PROTECTED]/somefile.txt", "w");
Is there a way for me to delete somefile.txt ?
The FTP program on my computer gives the command
DELE /path/some
want to have the code or a
similar one without the need to re-write it.
The code does not require the page refreshing at all, just loops in a script
and outputs. I might have to do some web surfing on it, pity I can't remeber
where it is.
If anyone could help that would be
n a script
and outputs. I might have to do some web surfing on it, pity I can't remeber
where it is.
If anyone could help that would be great.
It's for a PHP site using MySQL. I am considering having the slogans in a
database this time rather than just a text file.
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
= =
Could you not just add:
ORDER BY ApptDate, ApptTime
To the end of your SQL - this will order the set by date then time. You can
also add ASC or DESC for Ascending or Dscending as desired.
N.B. the ORDER BY statement must be the last part of you query!
-Original Message-----
From: [
Forgive me that this isn't really PHP related, but solely MySQL.. but the MySQL
mailing lists drive me nuts and figured someone here would have a quick answer.
I'm trying to sort by a date and time field(s) (two separate fields). It's a
dumb system but until we do the next revis
1 - 100 of 198 matches
Mail list logo