Hi, im making a tab/lyric portal, and for viewing tabs i want to display the
time the lyric/tab was submitted. So I retrive it from a MySQL database (as
a timestamp) and format it using the date function. The problem is, that the
date: 19-01-2038 04:14:07 is allways returned, even though in the `d
Yeh, ive allready looked at that before, but where and when do i use
DATE_FORMAT() ? When im inserting the row or selecting it?
"Jome" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi, im making a tab/lyric portal, and for viewing tabs i want to display
> t
ou could store the dates as UNIX timestamps.
>
> That is what I do. It is then eaiser to do certian things(ie show stuff
> released in the last month)
>
>
> --
> JJ Harrison
> [EMAIL PROTECTED]
> www.tececo.com
>
> "Tony Harrison" <[EMAIL PROTECTED]>
Hi. I have a problem with my tab/lyric site, I need to create an artist
page, where users can view all lyrics/tabs by a certain artist.
Now because im likely to get guitar/drum/bass tabs / lyrics for the same
song, I want to have a table with links as follows (e.g):
Blink 182
-
Whats my
Instead of incrementing to find the next row to count them, you dont have to
set the ID if it is auto increment. MySQL will do it for you (and i think it
might fill the holes too). Also, to get the num. of rows just do this -
$get_rows = mysql_query("SELECT * FROM `table`");
$num_rows = mysql_num
If you write your own browser, who would use it? And without a back button -
nobody
"Petre" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> HI
> Is there a way I can disable the client's browser back button, forcing
> them to use the navigation I built into the
OK, im having some minor problems with my site.
In artist.php (http://members.lycos.co.uk/ajohnh/artist.php - Source at:
http://members.lycos.co.uk/ajohnh/source/artist.txt) If for example you view
lyrics by Weird Al Yankovic
(http://members.lycos.co.uk/ajohnh/artist.php?id=1) You'll see that the
; $g ++) {
> $color = 1;
> if ($color == 1) { $rowcolor = "#DFDFDF"; $color ++; } else { $rowcolor=
> "#FF"; $color --; }
> ...
> }
>
>
> "Tony Harrison" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL P
OK, the color works, but now I have 2 empty lines
"Tony Harrison" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Thanx, I havent tried the loop yet, but the color will work im sure .
>
> "Aaron Ott
Shouldnt there be some sort of MIME header for it?
"Philip Hallstrom" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> You can't (in the sense that there's an $attachment argument), but I've
> seen several classes that will let you do it. Check zend.com and
> p
Hi, I need to authenticate users on an included page on my website, but the
problem is, I cant get it to work.
view it included at http://members.lycos.co.uk/ajohnh/ (Source at
http://members.lycos.co.uk/ajohnh/source/index.txt)
the actual file:
http://members.lycos.co.uk/ajohnh/templates/twoShea/
Hi, I need to authenticate users on an included page on my website, but the
problem is, I cant get it to work.
view it included at http://members.lycos.co.uk/ajohnh/ (Source at
http://members.lycos.co.uk/ajohnh/source/index.txt)
the actual file:
http://members.lycos.co.uk/ajohnh/templates/twoShea/
How would I go about selecting rows from a MySQL table where the first
letter of a certain field is $letter ?
--
-
[EMAIL PROTECTED]
http://www.cool-palace.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.n
And do I need to use any other functions like mysql_fetch_row() ?
"Martín marqués" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> On Sáb 24 Ago 2002 11:19, Tony Harrison wrote:
> > How would I count the number of rows in a mysql table with a WHERE
If I insert a row's field's value using the PASSWORD() function, will I need
to use it or another function to find that row using the same field?
-
[EMAIL PROTECTED]
http://www.cool-palace.com
--
PHP General Mailing List (http://www.php.net/)
To uns
You need to give us the HTML for the form so we can comprehend the context
of it all
"Eriol" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I've got the following bit of code for an upload/feedback form.. Upload
isn't a
> required field, but name, email and me
Can anyone tell me why the following setcookie()s fail?
- Tabzilla.com
--
-
[EMAIL PROTECTED]
http://www.cool-palace.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
cheers
"Richard Lynch" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> >If I insert a row's field's value using the PASSWORD() function, will I
need
> >to use it or another function to find that row using the same field?
>
> You'll need to do this when somebody tries to log in la
Can anyone tell me why my emoticons arent appearing? Please?
Note: $message is a variable set by a web form. The field `pattern` is the
string to search for, like ":-)", and `url` is the relative url to the
emoticon. I just get the plain emoticon. Note: this bit is above the INSERT
statement in t
I asked a similar question the other day, I was told to use the password
function on the field name, not the value, i havent tested this and its a
weird way to do things, and why cant both work? (if any)
"Mike Tsapenko" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED
Can anyone tell me why my emoticons arent appearing? Please?
Note: $message is a variable set by a form. The field `pattern` is the
string to search for, like ":-)", and `url` is the relative url to the
emoticon. I just get the plain text, no replacement emoticon. Note: this bit
is above the INSE
What about multiple tables? Can that be done?
"Mark Charette" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> No, only one db at a time may be updated. The "where" clauses can contain
> multiple db.
>
> -Original Message-
> From: Sascha Braun [mailto:[
Hi, im wondering how in popular forum software, those 'BB codes' are done in
PHP, like, [B] and stuff. I just cant figure it out.
-
[EMAIL PROTECTED]
http://www.cool-palace.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.
Is it possible to specify more than 1 domain in a cookie?
-
[EMAIL PROTECTED]
http://www.cool-palace.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I realise its a longshot but is it possible to use PHP (or any other
web-based languages) to combine multiple ZIP files into a single ZIP file?
and any scripts i can download to do it.
Any help with this is most appreciated. ;-)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe
Hi, if you can find a web host that offers ALL these services, i will eat my
hat on my webcam to the whole club:
Usenet Newsgroup.
at least 200MB space
Perl/CGI support (optional)
PHP - note: must have GD library installed!
MySQL
SHOUTcast web radio
Reseller account option
at least 300MB per mont
ewsgroup for PHP discussion. This is not a PHP discussion, so
it
> is a spam mail. Please refrain from using it.
>
> "Tony Harrison" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi, if you can find a web host th
Hi. I please need some help with converting a MySQL timestamp into something
easily read. Any help at all is most appreciated, thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
28 matches
Mail list logo
