[PHP-DB] MySQL and PHP?

Hello I hope this is a rumour but I heard that MySQL is now fully GPL which it wasn't earlier. I think the part used to communicate with the mysql server was lgpl. Does this mean that when using php with mysql your php scripts have to be licensed under the gpl as well if released? If this is the

Re: [PHP-DB] Unsubscribe me please

Me too Sent from my iPad On Sep 19, 2012, at 9:18 PM, Michel BUYSE m...@marvol.be wrote: Unsubscribe me too m...@marvol.be -Oorspronkelijk bericht- Van: Paul Clark [mailto:p...@leckytech.com] Verzonden: donderdag 20 september 2012 7:13 Aan: php-db@lists.php.net Onderwerp: Re:

Re: [PHP-DB] Code Security

Original Message Date: Thursday, February 05, 2015 13:10:51 + From: Richard Quadling rquadl...@gmail.com To: E Rosenberg erosenb...@hygeiabiomedical.com Cc: PHP Database List php-db@lists.php.net Subject: Re: [PHP-DB] Code Security On 5 February 2015 at 05:52

Re: [PHP-DB] Code Security

and database with minimal data loss Bastien On Thu Feb 05 2015 at 9:39:43 AM Omar Muhsin mrfroa...@gmail.com wrote: You forgot this one keep the box OFFLINE ... best security :-D On 05-02-15 14:10, Richard Quadling wrote: 1 - Don't allow terminal access to your box. 2 - Use a PHP byte

Re: [PHP-DB] Re: Code Security

to approach this, but it seems to need rather serious re-engineering -- with data privacy and security as the key element. - Richard Original Message Date: Wednesday, February 18, 2015 10:14:43 -0500 From: Mark Murphy jmarkmur...@gmail.com To: Taco Mathijs

Re: [PHP-DB] Waiting for localhost

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

Re: [PHP-DB] Waiting for localhost

Original Message Date: Wednesday, April 01, 2015 00:05:29 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: php-db@lists.php.net Richard - As we saw in the Apache list, the problem lies in PHP/MySQL To quote -- Date: Tuesday, March 31

Re: [PHP-DB] Waiting for localhost

Original Message Date: Friday, March 27, 2015 01:29:49 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com On 03/18/2015 07:51 AM, Richard wrote: Original Message Date: Wednesday, March 18, 2015 00:23:00 -0400 From: Ethan

Re: [PHP-DB] Waiting for localhost

http://designdrumm.com On Apr 1, 2015, at 10:35 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: snip Richard - Thanks. The problem is in the database connection. from MySQL mysql show tables; +-+ | Tables_in_Store

Re: [PHP-DB] Waiting for localhost

Original Message Date: Thursday, April 02, 2015 13:48:06 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: php-db@lists.php.net Subject: Re: [PHP-DB] Waiting for localhost On 04/02/2015 06:17 AM, Richard wrote: snip Here are some hints

Re: [PHP-DB] SQL injection

Date: Sunday, June 21, 2015 12:39:06 PM -0400 From: Aziz Saleh azizsa...@gmail.com On Sun, Jun 21, 2015 at 9:19 AM, Lester Caine les...@lsces.co.uk wrote: OK - this had no chance of success since publish_date_desc is processed using the _desc ( or _asc ) and any invalid data stripped

Re: [PHP-DB] Corn job anomaly

> Date: Monday, September 19, 2016 03:26:54 -0500 > From: Karl DeSaulniers > > I am hoping someone can enlighten me on this issue I am having. > I am trying to set up a cron job to run a php file. > I am getting a strange error though. > > /home/(protected

Re: [PHP-DB] Corn job anomaly

> Date: Tuesday, September 20, 2016 03:26:39 -0500 > From: Karl DeSaulniers > >> On Sep 20, 2016, at 3:22 AM, Lester Caine >> wrote: >> >> On 20/09/16 09:14, Karl DeSaulniers wrote: >>> Pardon my ignorance, but what do you mean full path? >> Full path

Re: [PHP-DB] Corn job anomaly

> Date: Friday, September 23, 2016 03:28:47 -0500 > From: Karl DeSaulniers > > Ok, so I have run down all the possible things (that I know of) > that could be keeping this from working. I have checked with my > hosting service that: > > 1. MySQL is accessible with the

Re: [PHP-DB] Corn job anomaly

Original Message > Date: Tuesday, September 20, 2016 12:54:38 -0500 > From: Karl DeSaulniers <k...@designdrumm.com> > > On Sep 20, 2016, at 7:21 AM, Richard > <inbound-lists-...@listmail.innovate.net> wrote: >> >> >> &

Re: [PHP-DB] Corn job anomaly

> Date: Sunday, September 25, 2016 08:37:14 -0400 > From: Aziz Saleh <azizsa...@gmail.com> > Subject: Re: [PHP-DB] Corn job anomaly > > On Sun, Sep 25, 2016 at 4:59 AM, Karl DeSaulniers > <k...@designdrumm.com> wrote: > >> > On Sep 23, 2016, at

[PHP-DB]Question on select..for update

o check that the mode is OCI_DEFAULT) Debug: query = update psns set user_id = '' where part_nbr = 'XX' Regards, Richard Halford -- 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] MySQL and XML

Does MySQL 3 have XML support, or do I need to write (or find) a class to transform MySQL databases into XML documents? -- 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

[PHP-DB] Getting a date from MS SQL in the correct format.

n the mean time, I've had to use DATEPART to pull the three bits in separately and add a bit to the PHP templates to add them all together. Ideally I want just the value as CCYYMMDD. Regards, Richard Quadling. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] date_format for Oracle

This isn't strictly a PHP question, I suppose... but is anyone aware of a date_format function for Oracle comparable to MySQL's date_format() function? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Record Update Link

There's a good tutorial that covers the subject of creating a list of contacts with hyperlinks to edit, delete etc. at: http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html It was my first intro to PHP and was extremely helpful, although if I remember right a couple of

Re: [PHP-DB] mssql_connect() commandline problem

Sounds like you might be working with 2 different versions of php: Mod-php for Apache in the web environment, stand-alone php operating in the shell. You might want to start by ensuring that the stand alone version is compiled -with mssql. Try running phpinfo() in the shell? Richard Erik

Re: SV: [PHP-DB] mssql_connect() commandline problem

the Apache server and work within the shell environment. Richard Erik wrote: I wrote a script (? phpinfo(); ?) and executed it from the commandline (php script.php test.txt) turns out text.txt doesnt have sybase support listed at all - which the apache version of phpinfo has. could

[PHP-DB] Re: Sybase CT with/without Sybase ASE

When you compile php with sybase ct you specify where the libs are: $SYBASE/lib, in ASE12.0 and above maybe the path differs from 11.9.2, I have not checked yet, will tomorrow. //dbaBert Carlo Borreo wrote: Dear All, In the past I had installed an Apache server with PHP 4.0.6 and Sybase CT

Re: [PHP-DB] ADORecordset Equivalent in PHP?

I would suggest checking out the classes at http://phpclasses.upperdesign.com/browse.html I've used the mysql_recordset class that is part of the mysql_db package. It has the basic methods similar to ADO. I found it to be very functional if you're using mysql. There are other classes there as

[PHP-DB] php-mysql-and the elusive eval statement....

I'm having a php/mysql problem using the eval statement. what I'm done is created a template that is database driven ie. the document is setup so that all of the head, leftside, body, right and bottom are all text comming from database query returns. all database returns are valid tested code.

Re: [PHP-DB] Using variables within a SELECT statement

. Can anyone help. Thanks in advance Kevin -- 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] -- Sliante, Richard S. Crawford

Re: [PHP-DB] dynamic sql

-- Sliante, Richard S. Crawford mailto:[EMAIL PROTECTED] http://www.mossroot.com AIM: Buffalo2K ICQ: 11646404 Yahoo!: rscrawford MSN: [EMAIL PROTECTED] It is only with the heart that we see rightly; what is essential is invisible to the eye. --Antoine de Saint Exupery Push the button, Max

Re: [PHP-DB] Another dynamic sql.

? Best regards Raymond -- Sliante, Richard S. Crawford mailto:[EMAIL PROTECTED] http://www.mossroot.com AIM: Buffalo2K ICQ: 11646404 Yahoo!: rscrawford MSN: [EMAIL PROTECTED] It is only with the heart that we see rightly; what is essential is invisible to the eye

RE: [PHP-DB] MySQL

Easiest way is to download and install phpMyAdmin. http://phpmyadmin.sourceforge.net/ HTH Richy -Original Message- From: Morten Nielsen [SMTP:[EMAIL PROTECTED]] Sent: 04 February 2002 16:34 To: [EMAIL PROTECTED] Subject:[PHP-DB] MySQL Hi, Is there an easy way to see

[PHP-DB] odbc functions

in SQLPrimaryKeys I don't really know what the modifier and owner parameters should do, and suspect thats where the problem lies. I tried them as , % and . Running PHP 4.0.4 on NT 4.0 Workstation, with Access 97 Richy. == Richard Black Systems Programmer

RE: [PHP-DB] Access to Mysql

== Richard Black Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com Tel: 0141 435 3504 Email: [EMAIL PROTECTED] -Original Message- From: Alex Francis [SMTP:[EMAIL PROTECTED]] Sent: 13 February 2002 09:55 To: [EMAIL

RE: [PHP-DB] Tutorial?

this does nothing. Like I say, I'm 99.9% positive this is implemented using javascript, but have never investigated how it works... Richy == Richard Black Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com Tel: 0141 435 3504 Email: [EMAIL

RE: [PHP-DB] Tutorial?

How about mixing the 2??? :-) Richy -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: 04 March 2002 16:51 To: 'Richard Black'; 'Jennifer Downey'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Tutorial? Javascript will functionally solve the problem, but since

RE: [PHP-DB] need help guys

%26 So that it passes the correct value: http://localhost/auction/seller/additems.php?category=Antiques%20%26%20Arts HTH, Richy == Richard Black Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com Tel: 0141 435 3504 Email: [EMAIL

Re: [PHP-DB] results on multiple pages

Why don't you let mysql sort and limit the records for you? That's easy enough. Just keep track of where you are in the database and select only the records that you need. - Original Message - From: James Kupernik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002

Re: [PHP-DB] results on multiple pages

I don't understand what you're saying - Original Message - From: James M Kupernik [EMAIL PROTECTED] To: 'Richard Emery' [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 4:05 PM Subject: RE: [PHP-DB] results on multiple pages Because if I limit the record sort, then if the record I

Re: [PHP-DB] Inserting a String Variable into mysql_query() returns Query was empty error

Are you trying to create a table named How Are You? If so, can't do it. It MUST be a one-word name. You would have discovered this yourself had you typed your CREATE statement into the mysql command line. Second ALWAYS include an or die(Error: .mysql_error()) part after your mysql_query().

Fw: [PHP-DB] Problem

mysql permissions? you gave us no info...we can give you no answer - Original Message - From: Thomas omega Henning [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:25 AM Subject: [PHP-DB] Problem Ok i have a problem big one. I'm using php 4.0.6 and mysql 3.23

Fw: [PHP-DB] determine the primary key after adding a row to a table (mysql)

$lastid = mysql_last_id(); returns auto_increment from inserted record - Original Message - From: CJ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 4:19 PM Subject: [PHP-DB] determine the primary key after adding a row to a table (mysql) is there any way to

Re: [PHP-DB] selected problem

How is your option list created? Did you pull the names and values from a database? Or is the list hard-coded? - Original Message - From: its me [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 26, 2002 3:39 AM Subject: [PHP-DB] selected problem i have the file:

Fw: [PHP-DB] select and sort question

Why don't you sort in your SELECT statement? SELECT * FROM newsitems where ID='1' ORDER BY newsdate DESC - Original Message - From: Kirk Babb [EMAIL PROTECTED] To: Sent: Saturday, April 27, 2002 3:56 PM Subject: [PHP-DB] select and sort question I have a db table which holds news in

Re: [PHP-DB] Re: [PHP] Database Duplication

TEMPORARY tables would require that he create and fill ALL the tables each time. Too much work for what he needs. mysqldump is your friend here - Original Message - From: Eugene Mah [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 10:08 AM Subject: [PHP-DB] Re:

Re: [PHP-DB] Recommendation needed: a php/mySQL program to batch e-mail announcements

majordomo and ezmlm would provide more power and cause more headaches than he needs. What he describes is very basic and can be done in less than 5 hours. - 1 hour to create sign-up screen with db update, including test - 30 minutes to create un-register screen with db update, including testing

[PHP-DB] Can you SUM(IF) from two different tables at the same time?

number of threads and messages posted to the two respective boards (boardid1 and 2). All I am wondering is if this can be combined into a single query or does the very nature of using the SUM(IF) not allow this to happen? Regards, Richard -- Fatal Design http://www.fatal-design.com Atari / DarkBASIC

[PHP-DB] Re: Can you SUM(IF) from two different tables at the same time?

stitutes a good database design and lots and lots of query examples/tutorials. Cheers, Richard -- Fatal Design http://www.fatal-design.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] problem with login script

I haven't been following your whole thread on this issue, but I did notice that the syntax for your include statement is incorrect. Try this: ? include(functions.php); ? I've been working with includes recently and that's the standard syntax. Furthermore, if you put the functions.php

RE: [PHP-DB] Last ID from database?

Chris, $insertID = mysql_insert_id(); Check http://www.php.net/manual/en/function.mysql-insert-id.php for additional info. Rich -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:57 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Last

RE: [PHP-DB] storing content data outside the application

Without knowing what you really are trying to accomplish... I've had very good results with the following bit of code: //scan the directory and load its contents into an array $handle=opendir($dir); while (false !== ($file = readdir($handle)))

[PHP-DB] Refresh after DB Query

OK, loosely related to the database topic on this list. I have a page that displays the contents of a contact list in an HTML table. The contents are pulled from a MySQL db with a standard PHP query. Nothing special happening there. In this table, I put Edit and Delete links to maintain each

[PHP-DB] RE: Refresh after DB Query - Solved

Ugh! Thanks, Adam. I knew it would be something stupid. Although I am kind of new (less than 6 months) to PHP, I'm really not that bad with it (IMHO). I really thought I had tried putting the DELETE stuff where you said to put it and it didn't work. However, new day, fresh eyes, your advice...it

RE: [PHP-DB] passing variables from one page to another

Matthew, have you tried running your query from the command line in MySQL? If you can do that successfully, that'll prove that the query is functioning properly and the problem can be tracked elsewhere. -Original Message- From: Matthew K. Gold [mailto:[EMAIL PROTECTED]] Sent: Monday,

[PHP-DB] php problem passing variables

hi, i've tryed to install php 4.2.1 with apache 1.3.24 php works, but i can't pass any variables. is it in php.ini that i have to change something ? or is the installation of php not correct ??.. thanks in advance, Richard Pijnenburg The netherlands -- PHP Database Mailing List (http

[PHP-DB] PHP Security and Code Design

OK, so I was really bored today and started reading through some PHP security stuff starting with the php.ini-recommended and found the register globals off stuff. So you don't have to find it yourself, here's a direct lift from the file: ; This is the recommended, PHP 4-style version of the

RE: [PHP-DB] PHP Security and Code Design

Thanks, Adam. All clear now. Rich -Original Message- From: Adam Alkins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 4:28 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP Security and Code Design I understand that this applies to data put into a form to be submitted to

RE: [PHP-DB] ID numbers not sorting Properly

Would using sort($result); solve the problem? I believe the default sort order is ascending. Try using sort($result) before your while($myrow = mysql_fetch_array($result)) statement and see if that fixes things. I also noticed that you don't use an ORDER BY clause in your sql statement, but if

RE: [PHP-DB] mysql_fetch_array limit? - more details

One thing I haven't seen yet is a cut-n-paste of your db tables. Could you post that to this list? Maybe there's something you're overlooking there? Maybe seomebody will find something amiss there. I know it sounds simple and you might think you have it all down right, but how many times have

RE: [PHP-DB] adding a space in mysql

I haven't set up any text-based searches before, but when you say: snip If the user types 'Wash' I don't want any matches for 'Washington', 'Washing', etc. snip Aren't you, in essence, saying that you want to search for Wash? Meaning that your query could just say WHERE name = '$var' (where $var

RE: [PHP-DB] PHP and XML

A question better suited for the php-general list, but check out: http://www.php.net/manual/en/function.htmlspecialchars.php and/or http://www.php.net/manual/en/function.htmlentities.php hth, Rich -Original Message- From: Bernard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13,

RE: [PHP-DB] SELECT statement problem

Can you echo out the sql going in and any errors you're getting when the query doesn't work then post that info to this list? It'll help both you and us diagnose what might be going wrong. In addition, what datatype are the columns named start and end in your database? (Assuming database is

RE: [PHP-DB] Date Subtraction

Manoj, Just a couple of thoughts: First, I know this particular topic has been discussed here recently, so you might want to search the archives for more exhaustive information. Second, if you're using MySQL, check out the functions DATE_ADD() and MOD(). They're MySQL functions, so you'll have

RE: [PHP-DB] Date Subtraction

Oh, in MySQL, there's also DATE_SUB(). Forgot to mention that one. Rich -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 2:40 PM To: 'Manoj Japher'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Date Subtraction Manoj, Just a couple

RE: [PHP-DB] how to hide source code??

Forgive me for sticking my nose in the middle of this, but stupid question here: This sounds like more of an architectural thing. A further abstracted view of the information you're dealing with. You (Smita) stated that the admin needs to see all of the data and you're concerned about him (or

RE: [PHP-DB] Indepth Tutorial... need help.

Just one more to throw on the fire: Pretty basic tutorial that covers a lot of topics. If you buy the book, there's a little more depth. On my first day working with PHP/MySQL, I had basic pages up and running. http://www.webmasterbase.com/article/228 Incidentally, this same question was asked

RE: [PHP-DB] Form question.......

Another option would be to break your one form into two separate forms where the first form asks for this number, checks the database, then transfers to user to the next logical page (rest of form or re-enter data) based on the results of that query to the db. I'm not saying it's anywhere near

RE: [PHP-DB] data by link

You have to append the data to the href then access the variable and its value on a resulting page. In general, it would look like this (I'm sure the list will point out any syntax errors I have made): To send the data to another page: a href=foo.php?variable1=value1variable2=value2Click here/a

RE: [PHP-DB] php - checkboxes - mysql

Also check the archives for the php-db list. Questions very similar to this get asked just about every week and you might be able to find more information there. Rich -Original Message- From: nikos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 7:51 AM To: PHP-mailist

RE: [PHP-DB] I need some information!!!

Rodrigo, Check the PHP-DB archives from yesterday and the day before. Lots of comments about this very subject. Happy hunting. Rich -Original Message- From: Rodrigo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 2:32 PM To: PHP Subject: [PHP-DB] I need some

RE: [PHP-DB] Current row of query

Not sure here, but you might also run into a problem if you start your if statement with $i=0. If PHP does not treat the value 0 as even or odd, your first row is most likely going to be purple along with your second row. I know it's nitpicky, but I could see myself spending half an hour trying

RE: [PHP-DB] Need help urgent!!

What's you register_globals set to? -Original Message- From: Thomas omega Henning [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 12:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help urgent!! I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't

[PHP-DB] Return Array from Function

Can somebody tell me what I might be doing wrong in the code below? I'm trying to use a function to perform an often-used db query and return the resulting resource to the calling script. I keep getting this error though: Parse error: parse error, unexpected T_LNUMBER, expecting T_VARIABLE or

RE: [PHP-DB] Return Array from Function

Sorry, line 51 is the one that reads: $1contentID=$row[1contentID]; -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 4:19 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Return Array from Function Can somebody

RE: [PHP-DB] Return Array from Function - SOLVED

save you some. ;) Thanks for the help. -Original Message- From: Dave Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 4:31 PM To: Hutchins, Richard Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Return Array from Function Try single-quotes instead of double

RE: [PHP-DB] variable names

Without more detail about your code, my first guess would be your register_globals setting in php.ini. In PHP 4.2.x it's set to OFF which means you have to refer to your variables like this example: $_POST[varname]; -Original Message- From: Brendan Flynn [mailto:[EMAIL PROTECTED]]

RE: [PHP-DB] Multiple select

rename your select lists with array brackets at the end 'listbox1[]' all of your values will be passed to the next page as an array -Original Message- From: Wilmar Perez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:47 PM To: php-db mailing list Subject: [PHP-DB]

RE: [PHP-DB] Sending E-Mail

FYI... Not sure what your intentions are, but you can also send the form data from ANY form by putting the mailto:[EMAIL PROTECTED] statement in the action property of the form and using the POST method (I don't think it'll work with GET). You'll generate an e-mail with an attachment that

[PHP-DB] Pulling apart select list elements

OK, so this probably is a bit off topic, but the results of these actions will be placed into a MySQL database. Close enough? I have a select multiple/select object named list[] that is passing its selected contents to an array. That part works fine. I can use a for loop to grab all of the

RE: [PHP-DB] Advanced search scripts

John (and list), Do you know if MySQL 4.0.x and PHP 4.2.x are fully compatible? I'm interested in the topics you have been discussing in this thread and don't really want to pursue upgrading MySQL if the support is only experimental at this stage (i.e. Apache 2.0). Thanks, Rich -Original

RE: [PHP-DB] images

This has been asked many times before, but unless you have a really good reason for storing the image in the database, don't. Instead, upload the image file to a directory on the server and store the URL to the image in the database. Fewer db resources are consumed. -Original

[PHP-DB] Re: PHP and databases? ...without MySQL and such

You can use the Microsoft ODBC Text driver to access flat files and perform SQL Queries on it - can be REALLY slow on big files though (no indexes) :( Alternatively - write a script that pulls the flat file into a proper database table :) Hope this helps -- Richard Allsebrook Applications

RE: [PHP-DB] MySql Statement inside a function?

Dave, I'd agree with Rob especially about returning the results. Plus it's always a good idea to add error checking to your SQL statement. Try replacing your existing line of code with this to make sure you query is actually returning valid results before trying to operate on them. $gnlistres =

[PHP-DB] Re: Re:Re: [PHP-DB] Print data

This isn't a PHP problem - its you browser. ie has an option in its print dialog (option tab) to print framed sites out properly - don't know how the other browsers manage it... [EMAIL PROTECTED] wrote in message news:E184aOC-0002vK-00;mail.idilis.net... hy, i'm having a problem with printing

RE: [PHP-DB] DB Print Columns and Rows

Something like this should also work for you. table ?php while($row=mysql_fetch_array($sqlResult){ $var1=$row[col1]; $var2=$row[col2]; //etc., etc. echo(trtd.$var1./tdtd.$var2./td/tr; } ? /table -Original Message- From: [EMAIL PROTECTED]

RE: [PHP-DB] DB Print Columns and Rows

Sorry, fixed a syntax error in my original post. -Original Message- From: Hutchins, Richard [mailto:Richard.Hutchins;GetingeCastle.com] Sent: Thursday, October 24, 2002 10:59 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] DB Print Columns and Rows Something

RE: [PHP-DB] Inserting checkbox data

In addition to what Mihail had to say, I saw a couple of minor things as well. I'm not sure if they're the cause of or solution to the problem you're experiencing. First, I'm pretty sure that a value of value=\Y\ is not valid HTML. I don't know what it does to your name/value pair when you POST

RE: [PHP-DB] URGET HELP : Logic Help - for first record do_this for each record after do_that

What about wrapping your logic in a counter? Set $count=1, if($count=1){do_this; then $count++;} else{do_that}. Wouldn't really add any overhead to your script since the counter only gets incremented once when the if() statement is true then stays at 2 and executes the else{} stuff after that.

[PHP-DB] Re: persistant database connections

There's a whole world of difference between 'rendered' and 'processed - the page is processed top to bottom (baring any branching in your php) - and generally rendered from top to bottom - some parts being rendered after as the missing components (images etc) are loaded. - in short - yes you can

RE: [PHP-DB] sort by date

Just to weigh in on the tail end here, a FAQ of the top N items would be nice. But I have to say, I use the archives a lot before I post to the list. The archives contain the answers to most questions out there. If subscribers to this list checked the archives to see if their answer is there, then

RE: [PHP-DB] sort by date

] Sent: Wednesday, November 06, 2002 10:42 AM To: Hutchins, Richard; [EMAIL PROTECTED] Subject: Re: [PHP-DB] sort by date What archive and how do I access it? -Original Message- From: Hutchins, Richard [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday

RE: [PHP-DB] Variables

It would seem that your IF statement, as it is written below, evaluates to true every time because I'm guessing that the hexadecimal value of the string timeb is larger than the hexadecimal value of timea. Like I said, just a guess. I'm also guessing that you actually want to compare two values

RE: [PHP-DB] payperiods

I don't know what your application or requirements are, but here's something to think about... If each pay period will ALWAYS be in two week increments from the date you hard code, then you're fine just hard coding the first one and incrementing automatically after that. However, if you're in one

RE: [PHP-DB] Displaying a single picture...

The link for your image: a href=displaypage.php?image=imagename.jpg target=_blankClick Here/a The code for displaypage.php HTML head blah... /head body ?php echo img src=\.$_GET[image].\ ? /body /HTML Something like this should be all you'll need. A little

RE: [PHP-DB] Multiply Auto_Increments

Sounds like a looping problem in your code. Can you supply the code around your INSERT statement so we can see what's going on? The only times I've experienced anything Roswell about MySQL is when I've written bad code. Rich -Original Message- From: Toby Parkins

RE: [PHP-DB] Multiply Auto_Increments

specific the first time. Rich -Original Message- From: Toby Parkins [mailto:toby;uknetweb.com] Sent: Wednesday, November 13, 2002 2:16 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Multiply Auto_Increments Richard, Here is the code $sql = INSERT INTO $table

Re: [PHP-DB] can i create an Access table or mdb with PHP?

()...) and populate the copy. Send the copy to your user You will end up with copies littering your site, so at the start of the population phase, run some 'tidy up code' which deletes any old databases (older than a day say). Hope this helps. -- Richard Allsebrook Applications and Web

RE: [PHP-DB] checking for 0 results?

Aaron was right initially: $sql = select * from ietsfuckingfriday; $result = mysql_query($sql); $num_rows=mysql_num_rows($result); Somewhere along the line, things got convoluted, but that's how you check for 0 rows returned from a query. -Original Message- From: Snijders, Mark

RE: [PHP-DB] Email Encryption?

Can you explain how e-mail fits into the Admin solution? What is the e-mail used for? Setting up the accounts/passwords or sending the account/password to the user? -Original Message- From: Aaron Wolski [mailto:aaronjw;martekbiz.com] Sent: Friday, November 15, 2002 11:39 AM To: 'Aaron

RE: [PHP-DB] Email Encryption?

it used in various places. -Original Message- From: Aaron Wolski [mailto:aaronjw;martekbiz.com] Sent: Friday, November 15, 2002 11:47 AM To: 'Hutchins, Richard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Email Encryption? The user account is setup via the Admin util. The details

[PHP-DB] Query Executes in MySQL Command Line, Not From PHP.

I'm having problems with a query. The query as it reads in my code is: $sql_element_low = UPDATE $table SET medialow=NULL WHERE .$_POST[tbl].contentID=.$_POST[id].; All of the varibles get passed as expected. I know this because if I echo the SQL out to the page, I get: UPDATE levelone SET

RE: [PHP-DB] Query Executes in MySQL Command Line, Not From PHP.

frustrating. -Original Message- From: Marco Tabini [mailto:marcot;inicode.com] Sent: Friday, November 15, 2002 4:14 PM To: Hutchins, Richard Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Query Executes in MySQL Command Line, Not From PHP. Uhm... are you sure it's not working? It's

  1   2   3   4   5   6   >