RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Rich Gray
If you name the checkbox as name="system[]" then PHP will automatically create an array of the checkbox values which can be subsequently accessed via $_POST['system'][n] - be warned however that the '[]' can screw up any JavaScript code that refers to the checkbox object... HTH Rich -Original

RE: [PHP-DB] Select Last row

2002-11-21 Thread Rich Gray
Does 'select * from table order by id desc limit 1' do what you want? HTH Rich -Original Message- From: Afif [mailto:[EMAIL PROTECTED]] Sent: 21 November 2002 01:49 To: PHP DB Subject: [PHP-DB] Select Last row dear All, I have data and I want to get the last row of my table. how to selec

RE: [PHP-DB] Dynamic Table Front End

2002-12-10 Thread Rich Gray
You didn't mention it so did you check http://www.phpclasses.org - there's a lot of good stuff there - you will need to register however. HTH Rich -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 14:52 To: [EMAIL PROTECTED] Subject: [PHP-DB] Dyna

RE: [PHP-DB] MSSQL Text Length Restriction

2002-12-10 Thread Rich Gray
Adam IIRC this is a known problem with the native php SQL Server APIs which were built using the original TDS drivers based on v6.x of SQL Server which did not support NVARCHAR data types... if you can't change the datatype to TEXT then try a cast. Failing that does it work if you use ODBC inst

RE: [PHP-DB] MSSQL Text Length Restriction

2002-12-10 Thread Rich Gray
Adam IIRC this is a known problem with the native php SQL Server APIs which were built using the original TDS drivers based on v6.x of SQL Server which did not support NVARCHAR data types... if you can't change the datatype to TEXT then try a cast. Failing that does it work if you use ODBC inst

RE: [PHP-DB] Still having problems...?!

2002-12-10 Thread Rich Gray
Is PHP running as a module in Apache/IIS? If yes then you will need to bounce your web server to pick up the new ini settings... Rich -Original Message- From: Hartleigh Burton [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 14:01 To: [EMAIL PROTECTED] Subject: [PHP-DB] Still having probl

RE: [PHP-DB] Fatal error message

2003-01-16 Thread Rich Gray
Jon Based on your include path does the script exist in any of these locations on your server? => /var/www/html/addrbk/Connections/addrbk.php or => /php/includes/Connections/addrbk.php => /usr/share/pear/Connections/addrbk.php If not then that's your problem, else you need to start looking at fi

RE: [PHP-DB] Secure variable transport (newbie)

2003-01-23 Thread Rich Gray
Karina Use the superglobal $_SESSION[] array together with session_start(). $HTTP_SESSION_VARS[] is not a super global. Rich -Original Message- From: Karina S [mailto:[EMAIL PROTECTED]] Sent: 22 January 2003 23:30 To: [EMAIL PROTECTED] Subject: [PHP-DB] Secure variable transport (newbie)

RE: [PHP-DB] Data won't insert

2003-01-23 Thread Rich Gray
Jeffrey Most probably site 2 has register_globals set to Off whilst site 1 has them set to On... Try using $_POST['name'] for $name, $_POST['age'] for $age and $_SERVER['PHP_SELF'] for $PHP_SELF Cheers Rich -Original Message- From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]] Sent: 23

RE: [PHP-DB] Filling Fields

2003-01-25 Thread Rich Gray
have you tried str_repeat()? Rich -Original Message- From: Chezney [mailto:[EMAIL PROTECTED]] Sent: 19 January 2003 08:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] Filling Fields Hi Can some one please tell how I can fill and entire field with the same value. Maybe in a loop or is there a

RE: [PHP-DB] Sorting Arrays

2003-01-28 Thread Rich Gray
Mark Not exactly sure what you're after but will array_multisort() help? http://www.php.net/array_multisort Rich -Original Message- From: Mark @ Webbiz NZ [mailto:[EMAIL PROTECTED]] Sent: 28 January 2003 05:10 To: [EMAIL PROTECTED] Subject: [PHP-DB] Sorting Arrays Hello, I don't unde

RE: [PHP-DB] MySQL Error

2003-01-28 Thread Rich Gray
Hi Jordan Made any recent changes to your network configuration? Can you access other IP ports OK e.g. http port 80? Do you have any firewall protection on your PC? Can you access MySQL from the command line OK? Rich -Original Message- From: JordanW [mailto:[EMAIL PROTECTED]] Sent: 28 Jan

RE: [PHP-DB] Session variables when global variables switched off [Sorry, first message accidentally fired off to quickly ]

2003-02-18 Thread Rich Gray
Hi Jeff Don't use session_register() just use the $_SESSION superglobal as you would use any other array. So does this work? http://mysite/index.php'); exit(); } ?> HTH Rich > -Original Message- > From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]] > Sent: 18 February 2003 11

RE: [PHP-DB] Re: Storing images in MySQL table

2003-02-27 Thread Rich Gray
Pedro Er ... probably - I've not tested it personally. However, if you output the image directly from a database then your script is sending the http headers for content type etc and the browser has no choice but to render what you send. With HTML based stuff it'll try to pull the image from cac

[PHP-DB] RE: [PHP] Random not working?

2003-03-01 Thread Rich Gray
> Hi All, > > I'm trying to get a random record each time this script runs; > Only it's giving me everytime the first record back.. No random at all.. > > // generate and execute query > $query = "SELECT stedenid, naamstad, stadomschrijvk FROM steden > ORDER BY RAND() LIMIT 1"; > $result = mysql_qu

RE: [PHP-DB] Populate Array During Loop With in_array

2003-03-06 Thread Rich Gray
> Can somebody please tell me why the $displayThese variable in the code > snippet below only gets populated with the last value in the > $newsList array > even when $newsList has more than one row of data? > > while($newsList = mysql_fetch_array($result_getNews)){ >

RE: [PHP-DB] I'm almost there! Just a little more help

2003-03-07 Thread Rich Gray
> Below is all of my code. The first is my html page that calls my > php page. > I do not know php well enough to edit the code to make this work. I need > the image to go to a folder called "logos" on my C drive. The actual path > is: > C:\Program Files\Apache Group\Apache2\htdocs\logos > > Cou

RE: [PHP-DB] Output a few tupels of 493033 tupels

2003-03-11 Thread Rich Gray
> Hello, > > I have got a little problem with my datas. In one table I have > got 493033 tupels. A simple Output of all datas is to much for > the Browsers (and the intranet-connection) and to ask for all and > then only give out a few is also a big problem for the server. > > Is there any way only

RE: [PHP-DB] Real Killer App!

2003-03-12 Thread Rich Gray
> I'm having a heck of a time trying to write a little web crawler for my > intranet. I've got everything functionally working it seems like, but > there is a very strange problem I can't nail down. If I put in an entry > and start the crawler it goes great through the first loop. It gets the > url

RE: [PHP-DB] listbox not adding data to mySql?

2003-03-13 Thread Rich Gray
> Im having a problem getting listbox data to go into a mySql database. > > This may be a simple problem but Ive been searching with out any > result, and > thought I would ask on here. > > Here goes... > > > No > Yes > > > the name of the field in the database is server, all of the other i

RE: [PHP-DB] PHP script execution - display issue

2003-03-13 Thread Rich Gray
> Hello, > I have a display problem with one of my sites. > Because there is an big amount of information in the pages, which is > extracted from database, using IE browser I see only the background of > the site, and then, after a time, the whole page. > My client has recently requested to make s

RE: [PHP-DB] DB CODEING HELP!!!!!

2003-03-23 Thread Rich Gray
> this is bugging me. I have tried everything and I cant develop > the code without an error. Can someone plese write me simple code > that will go through a table and print 3 collums of that table? I > cant figure it out I don't know which database you're using but say for example it was MySQL he

RE: [PHP-DB] Can't Insert more than 1 record

2003-04-03 Thread Rich Gray
> Hello All, > > I am having a problem inserting records > into my Database. I am passing fields > from a FORM to my php program that adds > 1 record to my DB. It will create the > first attempt just fine, however any > attempt after the 1st fails. I have > to delete the existing row in order > to