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 is
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 = mysql_fetch_array($catpermsquer
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) {
>
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]
Here's what I ended up doing that works:
(do all the db connection stuff - get your result, etc..)
Name
Company
Address
E-mail
Telephone
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');
mysql_
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
>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('Log
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:
***
But I get all the fields in one cell on each of these tries...
Thanks
>>> Gei
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','passwo
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: Galbreath
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 ."";
}
echo "";
}
Ryszard Hapka wrote:
Hi!
use foreach
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 = mysq
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
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");
header
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?
Mark
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 9:02 PM
To: matthew perry
Cc: [EMAIL PRO
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 se
18 matches
Mail list logo
