Hello Daniel,
you said you change all the max_limit stuff in PHP/Apache, but did you
change it on mysql ?
by default the mysql_allowed_package is set to 1M, you have to add a line in
your my.ini file (in my case this is in the windows directory, if you are
using linux search google :))
In the
Do you set the content-type in the response header like in JSP and servlets?
I've been reading the PHP Manual; where do you find stuff like this?
Mark
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 9:02 PM
To: matthew perry
Cc: [EMAIL
Good stuff to know! Thx, Geir!
Mark
-Original Message-
From: Geir Pedersen - Activio AS [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 9:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: exporting data to excel
Matthew,
I am looking for the easiest way to export data to
Do you set the content-type in the response header like in JSP and
servlets?
I've been reading the PHP Manual; where do you find stuff like this?
take a look at the header function
http://php.net/header
an example...ymmv
header(Content-type: application/vnd.ms-excel);
way cool - thanks for the clues!
Mark
It's better to TEACH a man how to fish than to GIVE him a fish!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 7:46 AM
take a look at the header function
http://php.net/header
an example...ymmv
Hi!
use foreach (www.php.net/foreach).
Ryszard
W. D. wrote:
Hi Folks,
I am trying to display a list of retrieved records, but can't seem
to figure out how to do this properly. Here is what I am aiming
for:
?
$result = mysql_query($SQLqry);
$NumRows = mysql_num_rows($result);
$NumFields =
not only foreach ;)
$r = mysql_query(select * from table);
while($t = mysql_fetch_assoc($r)) { // or while ($t =
mysql_fetch_array($r)) -- you will see difrends
foreach($t as $key = $value) {
echo [.$key.] .$value .br /;
}
echo hr /;
}
Ryszard Hapka wrote:
Hi!
use foreach
heh heh - last week I attempted to print the Manual...didn't realize the
sucker is 2500 pages long until the printer ran out of paper...and the
buffer overflowed.
Mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 7:54 AM
To:
Title: Strange problem with mySQL
I am trying to update a database that I use to store user names and the hashed values of passwords. The database name is Login, the table is users.
I have the following commands in my php file.
@ $db=mysql_pconnect('localhost','apache','password');
Hello all
I am also needing to do this - I got the xcel ss to generate but it wont tab to the
next cell in xcel...
Here's what I've tried so far:
?php
while ($row = mysql_fetch_assoc($res)) {
echo $row[first] . \t . $row[last] . \n;
// echo
I am trying to update a database that I use to store user names and the
hashed values of passwords. The database name is Login, the table is
users.
I have the following commands in my php file.
@ $db=mysql_pconnect('localhost','apache','password');
mysql_select_db('Login');
You just need to export to csv using phpMyAdmin or create the csv file on
the fly and send an excel or text/csv header before sending the csv data.
Couldn't be easier ;-)
At 01:30 25/03/2004 +, you wrote:
Message-ID: [EMAIL PROTECTED]
Date: Wed, 24 Mar 2004 19:30:09 -0600
From: matthew
Brown, Craig wrote:
I am trying to update a database that I use to store user names and the
hashed values of passwords. The database name is Login, the table is
users.
I have the following commands in my php file.
@ $db=mysql_pconnect('localhost','apache','password');
Here's what I ended up doing that works:
(do all the db connection stuff - get your result, etc..)
table width=100% border=1
tr
td div align=centerstrongName/strong/div/td
td div align=centerstrongCompany /strong/div/td
td div
Strange problem with mySQLTry to put backslashes before each single quote:
$query=UPDATE users set pw=\'$hash\' WHERE id=\'$user\';
Remember to put them whenever you need to introduce special characters.
Daniel
Craig Brown [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED]
I
Thanks! mysql_fetch_assoc did the trick.
At 07:08 3/25/2004, Ryszard Hapka wrote:
not only foreach ;)
$r = mysql_query(select * from table);
while($t = mysql_fetch_assoc($r)) { // or while ($t =
mysql_fetch_array($r)) -- you will see difrends
foreach($t as $key = $value) {
echo
Hi gang
I ran into a minor, but weird problem yesterday ...
Query one:
$catpermsquery = mysql_query(SELECT cat_view FROM hf_category_perms
WHERE `catID`='$catID' AND `levelID`='$levelID' LIMIT 1) or die('Could not
get cat perms'.mysql_error());
$catperms =
I am running the following query:
SELECT
...stuff...
FROM
properties LEFT JOIN property_photos ON
property_photos.property_id=properties.id,
states
WHERE
states.code='fl' AND
properties.state_id=states.id
LIMIT 0, 10
(not sure if the JOIN
18 matches
Mail list logo