[PHP-DB] magic_quotes_gpc?

Hello, New PHP (long time PERL user) here. I am using an Access database - yeah I know Access is crap, but I have no choice. Anyway, it seems that this magic backslash thing is unavoidable. As I understand it, I can shut it off at the .ini level, but I am running this app on a hosted s

[PHP-DB] set_magic_quotes_runtime???

So what does set_magic_quotes_runtime(0) do then??? Will it shut off the automatic backslashing of single quotes at run time or not? (it certainly doesn't seem to) Anyone? J

[PHP-DB] Still can't turn magic_quotes off!

quot;0") same for magic_quotes_sybase, which is what you really want, I think. You'll probably need it on both the form page and the processing page. If you have a config file that's included on every page, that'd be a good place for it. ---John Holmes... -Original Message-

RE: [PHP-DB] Still can't turn magic_quotes off!

And so it ends...(here is what the PGP bug people had to say about it...) ID: 19526 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: PHP options/info functions Operating System: Win2K PHP Version: 4.2.2 Ne

RE: [PHP-DB] Noob questions...

You should ask if your ISP has not already installed a phpMyAdmin that you can use - save you the bother. -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:57 AM To: 'Brett Lathrope'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Noob

RE: [PHP-DB] Why does this happen??

I would use JOIN syntax - then change your join type based on what you want to see in the results...(INNER JOIN, LEFT JOIN, RIGHT JOIN, LEFT OUTER etc.) SELECT updates.MODELCODE, SETNO, FRPICNO, TOPICNO, CPOSTDATE, MODELNAME, ZIPFILENAME, TOTPICS FROM updates LEFT JOIN models ON updates.MODELCODE

RE: [PHP-DB] Difference in time

yeah - the mktime function is returning unix style time (seconds since 1970) which is why only the last few numbers are changing. I would recommend letting the database decide who is able to submit... i.e. select * from database where lastSubmitDate > 'now()- 1 hour' and IP = '$ipaddress' if th

RE: [PHP-DB] Difference in time

dress']; $get_server_time2 = $row['server_time']; // close connection mysql_close($connection); mysql_free_result($result); if ($get_server_time2) {

RE: [PHP-DB] Pulling apart select list elements

There is another way -- I sometimes do this... you can have both the id and text in the value like so... Product 1 Another product etc... then parse through the value list and split it on "--" foreach ($listOfProducts as $prod){ if (!$prod){break;} list ($productID,$productNam

[PHP-DB] indexing on existing DB

(I know this is more of a mySQL question than PHP, but allow me this one if you would...) In MySQL, is there any difference between creating an index at table creation time, and creating an index on an existing table? Does an index created on an existing table re-index itself after each insert/up

RE: [PHP-DB] Difference between 2 dates.. thoughts?

You should be able to do this at the database level - of course you never said what database that is. Regardless, check your database documentation for the max() and min() functions - never used these on date but they might work - do you always want the first record and the last record in the data

RE: [PHP-DB] Difference between 2 dates.. thoughts?

those 2 records (how many days does this query span). Know what I am trying to say? Sorry if its not clear. Aaron -Original Message- From: Jason Vincent [mailto:jayv@;nortelnetworks.com] Sent: November 13, 2002 12:24 PM To: Aaron Wolski; [EMAIL PROTECTED] Subject: RE: [PHP-DB

RE: [PHP-DB] serious help with linking data together...

you haven't really said what the problem is - but this is what I can see... Functions like COUNT, MAX and MIN etc. are group functions (or aggregate functions). For example, select count(*) actually only returns 1 record - the total count. When you mix aggregate functions with regular selects (t

RE: [PHP-DB] Email Encryption?

Why email? If the Admin tool uses SSL, that is all you need. Regards, J -Original Message- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: Friday, November 15, 2002 11:39 AM To: 'Aaron Wolski'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Email Encryption? Just thinking here..

RE: [PHP-DB] Email Encryption?

ay no information is ever passed via email. Regards, Jason Vincent Voice Architecture, Nortel Networks (905) 863-7480 (ESN 333) [EMAIL PROTECTED] -Original Message- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: Friday, November 15, 2002 11:47 AM To: 'H

RE: [PHP-DB] phpmysqladmin

http://www.phpwizard.net/projects/phpMyAdmin/ yes it is - and it is a great tool J -Original Message- From: Matt Giddings [mailto:cen10761@;centurytel.net] Sent: Friday, November 15, 2002 12:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] phpmysqladmin Anybody have the url for phpmysq

RE: [PHP-DB] Email Encryption?

ckman@;purplecow.com] Sent: November 15, 2002 12:35 PM To: Aaron Wolski Cc: 'Jason Vincent'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Email Encryption? Why not encrypt the password in the DB? If they lose their password, it cannot be sent to them. They chose it, so it doesn't need to

RE: [PHP-DB] MySQL Problem

Still think we need to see the PHP code before determining that it is an SQL problem. Regards, J -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 11:55 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Problem On Friday 22 November 2

RE: [PHP-DB] Resource id #2

Try this... either... while ($row = mysql_fetch_array($result)) { $title = $row['Books.Title']; $author = $row['Books.Author']; ... print $title; } or... while ($row = mysql_fetch_array($result)) { print $row['Title']; ... } -Original Message--

RE: [PHP-DB] Single occurance of data

You really need to research join types for this. INNER JOIN, INNER LEFT, OUTER RIGHT etc. There are a plethora of examples and options on the web. Also, the DISTINCT keyword might help, as in "select DISTINCT department"; this would return only those departments in courses that have a correspond

RE: [PHP-DB] query

Ideally, you would have 3 tables like so... Projects(with one record per project) - projectID |ProjectName| etc... 1 my project 2 another project Users(with one record per user) --- userID| userName| etc... 123 Joe Blow 124