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  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);
> >
> 
> >   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);



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

$checkboxid="1";
// Start of the loop
echo "";
// 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] 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]




Re: [PHP-DB] hiding blank MySQL results?

2002-01-05 Thread Neil Thomson

ok i get your point.

how about
";
}
if ($discription !=""){
$discription1=$discription"";
}
if ($link !=""){
$link1=$link"";
}

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