...or if everything else fail, do it the ugly-hack style and us a
frameset with an 1 px wide frame where you update the db... just target
the update to the "invisible" frame and only that gets updated...
_bobo www.bitbob.biz
Chris Payne wrote:
Hi there everyone,
I'm using PHP and MySQL in
Thanks, but DISTINCT doesn't work... But I managed to get it to work
anyway by including
"namn_1 NOT LIKE 'H%'"
in the second WHERE-clause...
Micah Stevens wrote:
use DISTINCT?
On Sunday 30 January 2005 12:51 pm, Bobo Wieland wrote:
Anyone that can help me with
Anyone that can help me with this one? I want this SQL-statement to
retrive only distinct values from the original table column named (not
the AS stuff)
(
SELECT * , namn_2 AS sec_namn, namn_1 AS one
FROM sortiment
WHERE namn_1 LIKE 'H%'
)
UNION (
SELECT * , UPPER( namn_2 ) AS sec_namn, namn_2 A
how can i force the SID variable in urls not to be &SID=, but &SID ?
_bobo wieland _ [EMAIL PROTECTED] _
winamp >> various artists | green velvet - the stalker (i'm losing my mind)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
n Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
-Original Message-
From: Bobo Wieland [mailto:[EMAIL PROTECTED]
Sent: Monday, November 29, 2004 3:31
ot;Bastien Koert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 29, 2004 9:51 PM
Subject: RE: [PHP-DB] & and sessions
you can't, not allowed
read here http://www.faqs.org/rfcs/rfc1738.html
bastien
From: "Bobo Wieland
how can i force the SID variable in urls not to be &SID=, but &SID ?
_ bobo wieland [EMAIL PROTECTED] __
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
To: <[EMAIL PROTECTED]>
Sent: Monday, November 01, 2004 11:14 AM
Subject: Re: [PHP-DB] Something wierd with time() and curdate()
On Sunday 31 October 2004 22:45, Bobo Wieland wrote:
There is something wierd going on over here...
I have a date field, datum, in mysql that I cast to a timestamp an
There is something wierd going on over here...
I have a date field, datum, in mysql that I cast to a timestamp and check against
time().
If the datum value is more than one day old the table finds a new random row and sets
the datum field to CURDATE().
Now, this has worked for two years now, but
this is some code i've written once that gets all supercategories from a
mysql db... Take it as it is... It prints out a html-string of links like
this:
Category : sub_cat1 : sub_cat2 : sub_cat3.
Maybe you can figure it out... it takes the current id (in your example
catId13) as a parameter and
How do you accualty stor jpegs in a mysql db? And what's the pros and cons
of storing the whole image in the db and not just the path to the file on
the server?
It feels to me that it can be a bit difficult to organize the images if
they're just placed in a directory on the server. It would be esi
Hi!
What is the best way to check if a record allready exists in a msql-db from
php in the case of when the same form is submited twice beacuse of the
"refresh"-button?
Should I allways check the db for the same entry, or is there some esier way
to prevent the user from submiting a form more then
$sql1 = "SELECT COUNT(*) as views FROM $table WHERE viewed = '1' AND email =
'$row[email]'";
$views = mysql_resutl(mysql_query($sql1,$connection),"views");
maybe?
.bobo
www.elstudion.com/bitbob/ <- not finished though...
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Daniel Cla
Hi! I'm new to this list. I usually try to get my answers at the php-win
mailing list...
But since this is a mysql question I thought it would be better to ask i t
here;
How do I get the best result from a simple search (just one input box and a
search button) from a mysql db with two tables cont
14 matches
Mail list logo
