Re: [PHP-DB] vBulletin board

2002-06-15 Thread Neil Thomson

why dont u just use phpbb? 

it is opensource  free

http://phpbb.com/

Neil
- Original Message - 
From: Leif K-Brooks [EMAIL PROTECTED]
To: John StoneCold [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, June 16, 2002 8:30 AM
Subject: Re: [PHP-DB] vBulletin board


 That's illegal.
 
 John StoneCold wrote:
 
 Hi,
 
 Dose any one who has a copy of vBulletin board for sale?
 
 Thanks
 
 
 
   
 
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Re: PHP IDE

2002-02-23 Thread Neil Thomson

i use PHP CODER PR2 the newer version of it i think suks. so if u want it
ask. I like it tons.

Neil
- Original Message -
From: ACEAlex [EMAIL PROTECTED]
To: php-db [EMAIL PROTECTED]
Sent: Sunday, February 24, 2002 8:38 AM
Subject: Re: [PHP-DB] Re: PHP IDE


 I use homesite just to tag the functions in different colors

 - Original Message -
 From: robert janeczek [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Saturday, February 23, 2002 8:59 PM
 Subject: [PHP-DB] Re: PHP IDE


   After spending two frustrating hours tracking down a bug yesterday -
 only
  to
   discover it was a misplaced quote mark. I've had it.
  
   I am looking for suggestions out there for a good IDE for PHP
 development,
   preferably one that doesn't cost an arm and a leg. I tried PHP4EE
 studio,
   but it is buggy as hell and kept crashing on me.
 
  try zend studio - www.zend.com
 
  rash
 
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Protecting php scripts from source being downloaded

2002-01-09 Thread Neil Thomson

u can download a php page from a download manager ? i just tryed with
flashget...  it phrased the php page into html first.. ? ?

if you want to protect your say.. variables file from some1 trying in the
address of it. heres a simple way. in the variables file include
@header(status: error 404); (or how ever that code goes). then in the page u
want to include this. start the html tag first html then include this
page. the @ will make it not report errors. so u can inclue the page
perfectally..  when people try to look @ it, it will say it doesnt exist.

Neil

- Original Message -
From: Tom [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 09, 2002 8:00 AM
Subject: [PHP-DB] Protecting php scripts from source being downloaded


 Hi, im kinda new to this so be kind :)

 Im using mysql and php to create test databases (guestbook etc, basic
 stuff), but it doesnt seem so secure, people can just use a download
manager
 to download the php files and steal the mysql passwords. Is there anyway
to
 make it so they can see the php files through the brower but not download
my
 homecrafted php?

 Ive looked through many websites and the history of this, all I could find
 was one post which was to encript the files (this isnt really suitable for
 me as I edit bits and bobs as I go along). Is there anyway I can setup
 access as said in the above? Or just hid the password somehow? Im using
IIS
 5.1.

 thanks
 tom



 --
 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] mysql_num_rows

2002-01-08 Thread Neil Thomson

dont u need to add the $sql to the mysql_query... as in

mysql_query($sql,$db);

??
 i thourhgt u did ?

anyways.. might be wrong.

Neil

- Original Message -
From: Ford, Mike [LSS] [EMAIL PROTECTED]
To: 'Gurhan Ozen' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 08, 2002 6:07 AM
Subject: RE: [PHP-DB] mysql_num_rows


  -Original Message-
  From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
  Sent: 06 January 2002 20:10
 
  I am pretty sure that the query is correct. here is the actual query:
  $query=select  distinct(nodeid), nodename
  from books where
  bookid=$bookid;
  $result=mysql_query($query);
  $num_results=mysql_num_rows($result);
 
 snip
The funny thing is that if i write the same query without where
  bookid=$bookid then the mysql_num_rows works but with where
  statement it
  doesn't.

 Have you echoed $result to see what it contains?  My guess is that it
contains something unexpected which, when inserted into the query, causes it
to fail (or at least return no rows!).  Otherwise, I can see no reason for
the addition of the WHERE clause to cause this error.

 Cheers!

 Mike

 -
 Mike Ford,  Electronic Information Services Adviser,
 Learning Support Services, Learning  Information Services,
 JG125, James Graham Building, Leeds Metropolitan University,
 Beckett Park, LEEDS,  LS6 3QS,  United Kingdom
 Email: [EMAIL PROTECTED]
 Tel: +44 113 283 2600 extn 4730  Fax:  +44 113 283 3211

 --
 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] database/form help needed

2002-01-06 Thread Neil Thomson

try using the rand function..
eg...
$rand=rand(1,10);
input type='text' name='id$rand'


but that migth get a same number more then once... my suggestion is this

$checkboxid=1;
// Start of the loop
echo input type='text' name='id$checkboxid';
// end of loop
$checkboxid = $checkboxid + 1;

that should work i think

havent tested that code. but thats my idea.

Neil


- Original Message -
From: Chris Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 05, 2002 10:59 PM
Subject: [PHP-DB] database/form help needed


Hi there everyone,

I have a loop which goes through my MySQL database and some PHP code which
grabs results 9 at a time, and that works great.  Now, I also have a
checkbox called ID for each of the 9 entries and here is my problem.

How can I dynamically assign a unique ID for my checkboxes?  I am getting my
checkboxes through a loop, and because of that the ID is called id - for all
of my entries, so I can't select multiple as only one entry comes out on the
results page.  How can I dynamically create checkboxes with a unique id
(Such as id1, id2 etc ...) so that I can make multiple selections from my
DB?

Thank you all so much - Happy New Year.

Regards

Chris Payne
www.planetoxygene.com



-- 
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] hiding blank MySQL results?

2002-01-05 Thread Neil Thomson

ok i get your point.

how about
?
while($myrow=MySQL_fetch_array($result))
{
$title=$myrow[title];
$discription=$myrow[discription];
$link=$myrow[link];

if ($title !=){
$title1=$titlebr;
}
if ($discription !=){
$discription1=$discriptionbr;
}
if ($link !=){
$link1=$linkbr;
}

echo $title1 $discription1 $link1;
?
the != means if does not equal.

so basically that should i think do. if the title does not equal nothing
then add a br to the end of it. (putting the return in html). So if it
does equal nothing. then it will be nothing.

does this make sense ?
i wasnt sure on how to add br to the end... i had a shot @ it. this code
may not work just an idea.

Neil

- Original Message -
From: Nathon Jones [EMAIL PROTECTED]
To: 'Shooter' [EMAIL PROTECTED]
Sent: Saturday, January 05, 2002 4:01 AM
Subject: RE: [PHP-DB] hiding blank MySQL results?


 Thanks Neil.

 Does this produce a message saying Sorry no Result if the field is
 empty?

 What I am after is for it to just remain blank without inserting a blank
 line where the field should be and without inserting an error message.

 Lets say my results are as follows:

 Blues Magazine  -- Title
 Best Blues Magazine in the world.  -- Description
 www.bluesmagazine.com  -- Link

 If one of my database records doesn't have a Description, how do I stop
 the PHP page inserting a blank line where the description SHOULD have
 been?  Do you get my drift?  Like, for certain records it might display:

 Blues Magazine
 blank line
 www.bluesmagazines.com

 ...where there is no description for this record.  Can't get my head
 around it!

 Thanks for your help Neil. Much appreciated.
 Regards
 Nathon Jones

 -Original Message-
 From: Shooter [mailto:[EMAIL PROTECTED]]
 Sent: 05 January 2002 05:25
 To: Nathon Jones; [EMAIL PROTECTED]
 Subject: Re: [PHP-DB] hiding blank MySQL results?

 i would suggest in your while you do someting like this

 while($myrow=MySQL_fetch_array($result))
 {
 $time=$myrow[time];

 if ($time ==)
 {$time =Sorry No Result;
 }
 echo $time;

 if u get my drift ? ?

 Nei;l


 - Original Message -
 From: Nathon Jones [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 5:12 PM
 Subject: [PHP-DB] hiding blank MySQL results?


  Hi.
 
  I have a PHP page calling a set of results from a MySQL database.
 They
  appear in the following format on the results page:
 
  Title
  Description
  Link
 
  Problem I'm having.  When a db record has an empty field (for example,
 no
  description), the results page leaves a gap where the description
 should
 be.
 
  How do I do a hide if empty thang to stop the gaps appearing?
 
  Really appreciate the help.
  Regards
  nathon
  [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] Building a user preference site

2002-01-05 Thread Neil Thomson

use either sessions or cookies. ur choice.

look @ the manual on both.

Neil

- Original Message -
From: Danny Kelly [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 05, 2002 6:42 PM
Subject: [PHP-DB] Building a user preference site


 Hello,
 I am trying to figure out how to setup a user preference system. When the
 user successfully
 logs in they will go to a page that will display their preferences. I have
a
 Mysql database that contains all the user info. How do I START developing
a
 site like this. Thanks, Dan


 --
 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]