Hi Darrian
Have had similar problems. I got around it by
wrapping all posted variables with rawurlencode().
This replace any spaces or special characters with an nasi equiv
ie space with %20. IE will ignore it.
GL
Howard
-Original Message-
From: Darrian Walker [mailto:[EMAIL PROT
e a better way.
Howard
On Sat, 2002-08-17 at 15:44, Howard Picken wrote:
> What about setting all fields have a default value, say 0, that
> way you won't have a null but still a zero value.
>
> Howard
That would just make the graphs drop to zero for those dates, which
woul
Hi folks
Problem:
I'm trying to protect a heap of email addresses on lots of pages from
spammers. The pages are static pages on another site, (reason, they have to
be), but as some of them are generated on my site using PHP/MYSQL I thought
that the best way would be to redirect mail links to a p
Several things I've noticed.
One, you have not body tags in your code anywhere.
Just applying a style to the body doesn't (aas far as
I know doesn't declare it in your code.
Secondly, and I don't konw if you left it out
to protect the innocent, but you haven't supplied
a password for the databas
If you run an optimize or a repair on your datafile
it'll set the autoincrememtn back to next number
Howard
-Original Message-
From: Daniele Baroncelli [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 June 2002 11:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] auto increment
Hi guys,
The au
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
> -----Original Message-
> From: Howard Picken [mailto:[EMAIL PROTECTED
I'm looking for a way to do the following
I've created a php/mysql site for my wife for various
database lists she has.
She uses PHP locally on our on web server to add/manage
entries but a lot of the pages need to be static and uploaded
to a specific site (no PHP/MySQL).
So I've give her a li
Can I ask why you're not using "autoincrement" for your
id field? If you used this you would never have the problem
your having.
Everytime a record is added it will increment the id field
by one, so you don't have to use all the code your using.
Howard
-Original Message-
From: Leif K-Br
Hi Jon
Try using something like
$getlist = mysql_query("SELECT id FROM yourdb",$dbconnectetc);
$numrows = mysql_num_rows($getlist);
echo "$numrows\n";
This will give you the number of records in your db.
If you use autoincrement for the id field your will not have to
worry about your ++.
If
ample or a function to do this
but haven't seen one. Any Ideas?
TIA
regards
Howard Picken
[EMAIL PROTECTED]
Launceston, Tasmania, Australia
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To c
If you're running a web server on your Linux box
then simply download, install and use phpMyAdmin.
All your management is then down through web pages.
I use it all the time.
HP
-Original Message-
From: Jerry [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 16 January 2002 10:48 PM
To: [EMAIL
You could try returning the whole info with an alias
i.e.
select tbl_job.id AS jobno, tbl_job.name.id, tbl_job.job, tbl_name.* from
tbl_name, tbl_job where tbl_name.id = tbl_job.name_id;
You should then be able to refer to the tbl_job.id as jobno in any $row
function
i.e.
$jobnum=$row['jobno'
You've created the query but haven't actually run the query.
i.e.
$result = mysql_query($sql);
I'm new to this but I think that's what you're problem is.
Howard
-Original Message-
From: plague [mailto:[EMAIL PROTECTED]]
Sent: Friday, 24 August 2001 3:57 PM
To: [EMAIL PROTECTED]
Subj
Thanks Walter
Sorry. I should have thought about more details.
I'm using
echo "$member";
(within php4 code)
When I try this it just goes to the first letter (A) page
because I've used an Isset on $memltr in members.php setting it
to A if empty.
It seems to be having trouble parsing out the p
Hi
I'm trying to use the A NAME tag on a php4 generated page.
The pages being generated are alphabetically list
(e.g. Page just lists people with surname starting with A)
$member
It doesn't work of course. Anyone have any ideas?
Howard Picken
--
PHP Database Mailing
I'm a learner too.
But as I understand it, You make a connection to the database (or open it?).
Once it's open or connected to, you can access the different tables within
it.
I think the difference between "mysql_db_query" & "mysql_query" is that
later assumes that
you all ready connected to the
Have a look at how I would insert data in your case.
Howard
-Original Message-
From: sg [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 29 July 2001 8:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL newbie: inserting new entry to table?
Hi folks!
I'm new to PHP/mysql.
I created a db wit
in to select from it.
Howard Picken
(Server, SQL, Query, PHP, MySQl, Apache, Freebsd... etc)
[EMAIL PROTECTED]
--
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
;Q"=>"Q", "V"=>"V", "X"=>"X", "Z"=>"Z");
reset ($alphalist);
reset ($exemptlist);
while (list ($val) = each ($alphalist)) {
if ($currltr <> $val) {
$smlval = strtolower($val);
echo &quo
ages
When I get the record and open it for editing it automatically selects the
first option from the list.
I would like it to show the original value from the stored record.
Any ideas??....
Howard Picken
[EMAIL PROTECTED]
Launceston, Tasmania, Australia
--
PHP Database Mailing List (http:
Thanks for that. I've cleaned up things a bit for the time being.
I'm still getting an error though.
Parse error: parse error in c:\usr\local\www\pages/ships.php on line 30
Line 30 turns out to be $convict = $row["convict"]; so I'm assuming that
it's having trouble with the array. I've tried
ct"];
echo "$convict\n";
}
} Else {
echo "Sorry no records for that
letter\n";
}
}
?>
Obviously it doesn't work ("of course" or "how stupid" to some one out
there) but we all gott
22 matches
Mail list logo
