Re: [PHP-DB] Sessions ???
Thanks Steve; I now have this in a session file in my tmp dir topicID|s:1:8; Now how do i get the link to read http://localhost/forums/view.php?topicID=8 i think its along the lines of http://localhost/forums/view.php3?PHPSESSIONID?topicID I am banging away, the 4 books i have on Php are useless when it comes to session and there usage. Thanks for the help Dave C Steve Brett [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... try session_register(topidID); without the $ Steve -Original Message- From: DC [mailto:[EMAIL PROTECTED]] Sent: 02 May 2001 13:54 To: [EMAIL PROTECTED] Subject: [PHP-DB] Sessions ??? Hi All I have a ? about setting a session. I have a functions.inc file and at the top have put my session statment that looks like this. ? session_start(); session_register($topidID); ? $topicID comes from my mysql db. What i am trying to do is set the $topicID of my message board so that when a sucessful post has been made the visitor can click on a link that show the right board by topicID. so the link will look like this... http://localhost/forums/view.php?topicID=3 I am banging away trying to make this work Any help in the meantime is as always appreciated Thank You In Advance dave C -- 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-mail: [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-mail: [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-mail: [EMAIL PROTECTED]
[PHP-DB] Sending the user their forgotten password via emal??
Hi all I would like to offer my users the chance to have their username and password sent to them via the email address stored. As i see it i have two issues (1) how do i do the verify email thing where the script send a click here to confirm email address on registration application (2) how do i then send their details (username / password) to the confirmed stored email address. I have looked around but cqnt find the answer. 5 books on the shelf give no clue either Any help is most apreciated Thanks in Advance Dave C -- 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-mail: [EMAIL PROTECTED]
[PHP-DB] How to stop blank entries
Hi All Firstly thanks to the people who have helped in the past with my questions... My issue: I have a registration script which allows new users of a site to become a member. All works very well BUT if a new user just hit enter on the blank form then a new account is created with all fields except the id field blank allowing anyone just to hit enter a gain access. I have search the MySql docs, Php.net docs, this and other NG's but i can't find the solution to this. And how can i carry forward the username to be shown on all pages after sucessful login. I thank you in advance Dave C To email me remove the NOSPAM bit of my return email address -- 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-mail: [EMAIL PROTECTED]
Re: [PHP-DB] count function?
Ok i think i need to expand my help request... my fault I have a db that uses ids for topics in a message board ie each topic has messages of various numbers in them. From my select a topic page i hope to put the number of messages in the topic, so it visually looks like this sort of... topic 1 bb (5 posts) topic 2 ff (2 posts and so on. The only constant i can see in the tables is my posts table which specifies the topic id number. So i think i am asking how can i count the number of the same topic id numbers and show that next to the relevant topic. Thanks Again Dave C "Andrei Skorokhod" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... if you just need the number SELECT COUNT(*) FROM table where At 06:34 PM 3/30/2001 +0100, DC wrote: Hi All I cant quite work out how to count the number of rows in my mysql db that match a certain critieria and the show that number numericaly in my pages. Checked books, php.net etc. Any help is appreciated Yours Dave C -- 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-mail: [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-mail: [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-mail: [EMAIL PROTECTED]
Re: [PHP-DB] count function?
Ok i will get the books out and see if i can construct something. Thanks for the tip... Dave C ""Larry Rivera"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I think you have to run multiple queries, ie run some loop after finding out what topics you wil count from e== run a select distinct to get the topics run a while or for loop then run queries again like count(*) where topic='$topic' etc then echo the result to each line -Original Message- From: DC [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 9:53 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] count function? Ok i think i need to expand my help request... my fault I have a db that uses ids for topics in a message board ie each topic has messages of various numbers in them. From my select a topic page i hope to put the number of messages in the topic, so it visually looks like this sort of... topic 1 bb (5 posts) topic 2 ff (2 posts and so on. The only constant i can see in the tables is my posts table which specifies the topic id number. So i think i am asking how can i count the number of the same topic id numbers and show that next to the relevant topic. Thanks Again Dave C "Andrei Skorokhod" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... if you just need the number SELECT COUNT(*) FROM table where .... At 06:34 PM 3/30/2001 +0100, DC wrote: Hi All I cant quite work out how to count the number of rows in my mysql db that match a certain critieria and the show that number numericaly in my pages. Checked books, php.net etc. Any help is appreciated Yours Dave C -- 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-mail: [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-mail: [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-mail: [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-mail: [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-mail: [EMAIL PROTECTED]
Re: [PHP-DB] count function?
Cheers Brian
Thats sounds more like i am looking for
Although i have put the other code examples offered for this prob in my code
folder for later cause you never now when you'll need them.
Cheers
Dave C
""Brian S. Dunworth"" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
At 10:06 AM 3/30/01 -0800, Larry Rivera wrote:
I think you have to run multiple queries, ie run some loop after finding
out
what topics you wil count from e==
run a select distinct to get the topics
run a while or for loop then run queries again like count(*) where
topic='$topic'
Better yet (and less db-intensive), run a
SELECT TOPIC,COUNT(*) FROM table_name
WHERE condition
GROUP BY TOPIC
ORDER BY COUNT(*);
That'll return:
TOPICCOUNT(*)
Topic A 8
Topic B 3
Topic C 1
Topic D 0
Topic E 0
-
Brian S. Dunworth
Sr. Software Development Engineer
Oracle Database Administrator
The Printing House, Ltd.
(850) 875-1500 x225
[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-mail: [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-mail: [EMAIL PROTECTED]
[PHP-DB] PHP / MYSQL message board ?
Hi all I would like to find some documentation about how to create my own Php / Mysql driven message board. This is purly for my own educational interests. Any pointers and help appreciated Email: [EMAIL PROTECTED] kill the NOSPAM to send emial Thank you in advance Dave C -- 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-mail: [EMAIL PROTECTED]
