Re: [PHP-DB] select substring_index

2001-04-11 Thread Paul Burney
ot;." ,2) FROM news' or $result = mysql_query("SELECT substring_index(body, '.' ,2) FROM news" Hope that helps, Paul Burney http://paulburney.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

Re: [PHP-DB] build drop-down pick from MYSQL table

2001-04-12 Thread Paul Burney
utorials. The format they use is very nice and easy to follow. Hope it helps, Paul Burney ++++++ Paul Burney Webmaster and Open Source Developer Educational Technology Unit Graduate School of Education and Information Studies University of Californ

Re: [PHP-DB] substring_index Part 2

2001-04-12 Thread Paul Burney
!'; } ? The above is untested but I think it will work. :) Hope that helps, Paul Burney ++ Paul Burney Webmaster and Open Source Developer Educational Technology Unit Graduate School of Education and Information Studies Univer

Re: [PHP-DB] HTTP1.0/404 Not found

2001-04-18 Thread Paul Burney
, you should really subscribe to the PHP General list to post non-php/database questions. You can do so here: http://php.net/support.php That page also has information about news groups and list archives. Sincerely, Paul Burney http://paulburney.com/ -- PHP Database Mailing List (http

Re: [PHP-DB] update problems

2001-04-26 Thread Paul Burney
a while loop to drop the values into a select field, i.e., echo 'option value=' , $row['fieldname'] , '' , $row['fieldname'] , '/option'; You may want to check out a small script I wrote: http://webdevel.burney.ws/code/id?14 Hope that helps, Paul Burney

Re: [PHP-DB] Creating/reading [TAGS]

2001-05-10 Thread Paul Burney
] etc. Since phpBB is open source, you could probably look through the source code and find it. I would guess some kind of preg_replace loop. http://www.phpbb.com/ Paul ++ Paul Burney Webmaster and Open Source Developer Educational

Re: [PHP-DB] Flash+PHP search error

2001-05-14 Thread Paul Burney
of what it sees. Try changing the file name to nav.php. HTH, Paul ++ Paul Burney Webmaster and Open Source Developer Educational Technology Unit Graduate School of Education and Information Studies University of California, Los Angeles

Re: [PHP-DB] user need password

2001-05-16 Thread Paul Burney
on 5/16/01 10:44 PM, andrie at [EMAIL PROTECTED] wrote: we know that every password in mysql was encryption using PASSWORD function. i have case that make me to send user password bymail. how can i get this user password ? You can't. It's a one way encryption. You'll need to log into MySQL

Re: [PHP-DB] MySQL connection: Change on syntaxis?

2001-06-22 Thread Paul Burney
use of the function mysql_num_rows? What are the error messages you get? The @ symbol suppresses warning messages being sent to the browser so it isn't fixing whatever the real problem is. Sincerely, Paul Burney ++ Paul Burney Webmaster

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Paul Burney
['ordertotal']; Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] submitbutton/imagebutton

2001-06-22 Thread Paul Burney
of checking for $submit, do something like: ... if (isset($submit_x)) { ... Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] Is MySQL in 4.0.6?

2001-06-26 Thread Paul Burney
with MySQL support. You still need to download and install MySQL on the machine. You can find packages and more information at: http://www.mysql.com/ Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA

Re: [PHP-DB] php/mysql horizontal listing query

2001-06-27 Thread Paul Burney
++; } // make sure you don't have a malformed table while ($c % $n != 0) { echo 'tdnbsp;/td'; $c++; } echo '/tr'; // end table code (omitted) ? Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread Paul Burney
suggestions??? It looks like you set your key column as a TINYINT type rather than say, an INT. Try ALTER'ing that column type to INT and see if it works. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS

[PHP-DB] PhpMyAdmin phpPgAdmin Security Issues

2001-07-02 Thread Paul Burney
, Paul Burney +-+-+ | Paul Burney | P: 310.825.8365 | | Webmaster Programmer | E: [EMAIL PROTECTED] | | UCLA - GSEIS - ETU | W: http://www.gseis.ucla.edu

Re: [PHP-DB] Authomatic Sorting

2001-07-04 Thread Paul Burney
to your query. That is, if you want to sort by reg_id, append ORDER BY reg_id. You can also add a DESC keyword to put them in reverse order. HTH. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310

Re: [PHP-DB] Counting Number of Instances in a One2ManyRelationships

2001-07-23 Thread Paul Burney
the database and return the publisherID and a count of the number of books. You can do a group by to get them all at once: SELECT COUNT(*) AS book_count, publisherID FROM bookDB GROUP BY publisherID; Then use your favorite mysql_fetch_*** and access them. Hope that helps. Sincerely, Paul Burney

Re: [PHP-DB] Problem with my first script

2001-07-24 Thread Paul Burney
an invisible control character between the mysql_fetch_ and the array part. Try deleting the line and retyping: $myrow = mysql_fetch_array($result); Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA

Re: [PHP-DB] mysql query problem

2001-07-26 Thread Paul Burney
='$ContactID'; echo 'SQL query is: ' , $sql, 'br'; $result = mysql_query($sql,$db); printf(%s\n, mysql_result($result,FirstName)); printf(%sbr\n, mysql_result($result,LastName)); ? Hope that helps. Sincerely, Paul Burney +-+-+ | Paul Burney

Re: [PHP-DB] Query on Oracle Views

2001-08-06 Thread Paul Burney
instance_name, host_name FROM v\$instance; HTH. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] mysql_fetch_array missing first record

2001-08-07 Thread Paul Burney
before this in your code, perhaps to see if there is a result? If so, that's the problem. Each call to mysql_fetch_array (mysql_fetch_row) increments the array pointer. If that isn't your problem, please post more of the code so that we can make a better diagnosis. Sincerely, Paul Burney

Re: [PHP-DB] Submit forms

2001-08-10 Thread Paul Burney
variable will be set to yes. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] MySQL Modules and multiple database

2001-08-13 Thread Paul Burney
sure that you select the db before each query otherwise a query will use the last selected database. Sincerely, Paul Burney +-+-+ | Paul Burney | P: 310.825.8365 | | Webmaster Programmer | E: [EMAIL PROTECTED

Re: [PHP-DB] mysql optional file - my.cnf

2001-08-17 Thread Paul Burney
this is a PHP / Database discussion list. See mysql.com for more information. Sincerely, Paul Burney +-+-+ | Paul Burney | P: 310.825.8365 | | Webmaster Programmer | E: [EMAIL PROTECTED] | | UCLA - GSEIS - ETU

Re: [PHP-DB] PHP/mySQL and INSERT statements

2001-08-28 Thread Paul Burney
() , ': ' , mysql_error() , 'BR'; HTH. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] MySQL UPDATE problem

2001-08-30 Thread Paul Burney
. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu/ ++ -- PHP Database Mailing List (http

Re: [PHP-DB] Random

2001-08-31 Thread Paul Burney
by rand() only working in 3.23.xx. If you're using 3.22.xx, it won't work. You could do something with mysql_data_seek() and the php mt_rand() function if that's the case. It would be klunky, but you could probably get it to work. Sincerely, Paul Burney

Re: [PHP-DB] How can you hide database login passwd in yourscript?

2001-09-05 Thread Paul Burney
databases regularly and hope you never really need to use them. Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] newbie needs to format time field

2001-09-05 Thread Paul Burney
, the value you're looking for is mydate, i.e., echo $myrow['mydate']; HTH. Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu

Re: [PHP-DB] mail() - Return-Path

2002-01-12 Thread Paul Burney
on 1/12/02 7:36 AM, Malcolm White at [EMAIL PROTECTED] appended the following bits to my mbox: 4. No error messages. An email constructed as above sends perfectly - but the return path defaults to the apache user (in my case www) not the supplied return path. I tested the header construction

Re: [PHP-DB] The New Guy

2002-01-14 Thread Paul Burney
on 1/14/02 2:12 PM, Daniel Barton at [EMAIL PROTECTED] appended the following bits to my mbox: Well maybe I should just go out and join that perl list. I was going to respond to you but I didn't have a good answer. :) I don't know of any built in PHP functions that do what you are looking to

Re: [PHP-DB] mail() on Mac OS X

2002-01-15 Thread Paul Burney
on 1/15/02 7:38 AM, Adam Royle at [EMAIL PROTECTED] appended the following bits to my mbox: I have been trying for months now (on and off) to get mail() working in OS X. I - I am using PHP v4.0.6 on Mac OS X 10.1 (pre-compiled with cool options from entropy.ch) - I installed Communigate

Re: [PHP-DB] mysql_insert_id?

2002-01-15 Thread Paul Burney
on 1/15/02 4:08 PM, Wee Chua at [EMAIL PROTECTED] appended the following bits to my mbox: Is it possible that I would get the wrong ID (Not the ID I just inserted in Auto_Increment field) by using mysql_insert_id function if someone is also inserting record at the same time? How does

Re: [PHP-DB] Re: LEFT JOIN in UPDATE

2002-02-03 Thread Paul Burney
on 2/3/02 3:36 PM, Lutz Brückner at [EMAIL PROTECTED] appended the following bits to my mbox: Question is how to properly form a LEFT JOIN using UPDATE... I tried: UPDATE product_price LEFT JOIN temp SET product_price.product_price_vdate = 1 (del flag) ON product_price.product_id =

Re: [PHP-DB] MySQL connect

2002-02-04 Thread Paul Burney
on 2/4/02 12:54 PM, J Leonard at [EMAIL PROTECTED] appended the following bits to my mbox: mysql_connect($db[host],$db[user],$db[password],$db[database]) or The above function call only has three parameters. The database isn't specified in the connect call but selected later. Try:

Re: [PHP-DB] Exact String replace with eregi_replace()

2002-02-08 Thread Paul Burney
on 2/8/02 9:05 PM, Desikan at [EMAIL PROTECTED] appended the following bits to my mbox: Actually I want to replace is alone from the string and not all the words that contains is... I have tried with ^.$is.$ --- but yields nothing This kind of question really belongs on the PHP General

Re: [PHP-DB] Problem in programming PHP with WML

2002-02-25 Thread Paul Burney
on 2/25/02 11:32 AM, ªüYam at [EMAIL PROTECTED] appended the following bits to my mbox: I don't know why??That comes out a Err Msg about Unsupported type: text/html . I've never done any WML scripting, but the error message offers a big clue. PHP by default sends a Content-type

Re: [PHP-DB] Upgrading from php -4.0.3

2002-02-27 Thread Paul Burney
on 2/27/02 2:51 AM, Marco Coletta at [EMAIL PROTECTED] appended the following bits to my mbox: I would like to upgrade to newer version of php, ho can supply detailed instructions. You can start here: http://www.php.net/manual/en/installation.php And if you have difficulty, post your

Re: [PHP-DB] Question about setting up multiple relations

2002-02-28 Thread Paul Burney
on 2/28/02 2:21 AM, Monty at [EMAIL PROTECTED] appended the following bits to my mbox: I have an Image table in a MySQL database that will be used to store the location of all images used on my site. Some images will relate to an Article table (article.id) and some images may relate to a

Re: [PHP-DB] security

2002-03-03 Thread Paul Burney
on 3/3/02 7:39 PM, Ric Mañalac at [EMAIL PROTECTED] appended the following bits to my mbox: i personally think that the developer still has the control in making his php code secure. but how do you think will this news affect php as one of the most popular choice for web developers?

Re: [PHP-DB] addslashes needed for db security? Hack proving webapps

2002-03-05 Thread Paul Burney
on 3/5/02 5:35 AM, Andy at [EMAIL PROTECTED] appended the following bits to my mbox: No I was reading in a mysql book, that chars like ' are bad for db PHP provides the function addslashes. Is this the way to check for bad entries a user provides? What happens if a hacker tryes to delete my

Re: [PHP-DB] security

2002-03-05 Thread Paul Burney
on 3/4/02 11:34 PM, jas at [EMAIL PROTECTED] appended the following bits to my mbox: how can you find out what the php.ini is looking like? is there a way to use php to get that info. i have used phpinfo() but i cannot see whether or not file_uploads is disabled It will only show up in PHP

Re: [PHP-DB] Dynamic Drop Down Box

2002-03-06 Thread Paul Burney
and tutorial here: http://webreference.com/dev/menus/ And they even have a script that'll generate the code for you here: http://webreference.com/js/tools/menus/ Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php If ($your_php_version 4.1.2) { upgrade_now(); // to avoid major

Re: [PHP-DB] Can I attach an image to a newsgroup post?

2002-03-07 Thread Paul Burney
to place it on a public web server somewhere and then use a link to it in your post, like this: http://example.com/somefolder/my_image.jpg Or http://example.com/somefolder/my_php_file.phps Sincerely, Paul Burney http://paulburney.com/ ?php If ($your_php_version 4.1.2) { upgrade_now

Re: [PHP-DB] Looking for a good MySQL db abstraction layer

2002-03-08 Thread Paul Burney
, Paul Burney http://paulburney.com/ ?php If ($your_php_version 4.1.2) { upgrade_now(); // to avoid major security problems /* Please see http://security.e-matters.de/advisories/012002.html */ ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] how to start and bring down mysql.server on OSX

2002-03-15 Thread Paul Burney
startup script for MySQL on OS X. http://www.entropy.ch/software/macosx/mysql/ HTH. Sincerely, Paul Burney http://paulburney.com/ ?php If ($your_php_version 4.1.2) { upgrade_now(); // to avoid major security problems /* Please see http://security.e-matters.de/advisories/012002.html

Re: [PHP-DB] https post using php

2002-03-28 Thread Paul Burney
on 3/27/02 11:45 PM, mailing list at [EMAIL PROTECTED] appended the following bits to my mbox: I am attempting to POST to a https://whatever.url.com server and return the result from the server into the script without the user knowing using a php script. I can not use CURL becuase the shared

Re: [PHP-DB] displaying info in a form

2002-03-29 Thread Paul Burney
=text value=?php echo htmlspecialchars($name); ? HTH, Paul Burney http://burney.ws/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] using multiple checkboxes to delete from db

2002-03-30 Thread Paul Burney
produce something like: DELETE FROM table WHERE id IN ('3','4','123'); Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Updating Forms Values

2002-04-04 Thread Paul Burney
. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Closing curly brackets?

2002-04-13 Thread Paul Burney
id if statement /* More code after this point */ } // end while if statement. === Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP

Re: [PHP-DB] selected problem

2002-04-26 Thread Paul Burney
. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] db sql issue from var

2002-05-27 Thread Paul Burney
the above code, it would succeed. Just a word of warning. Sincerely, Paul Burney http://paulburney.com/ ?php // the statement formerly known as prince if ($the_elevator == 'tries to bring you down') { go_crazy('punch a higher floor'); } ? -- PHP Database Mailing List (http

Re: [PHP-DB] MySQL problem on Yellow Dog Linux

2002-06-06 Thread Paul Burney
that mentions MySQL as well. HTH. Sincerely, Paul Burney http://paulburney.com/ ?php // the statement formerly known as prince if ($the_elevator == 'tries to bring you down') { go_crazy('punch a higher floor'); } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] case

2002-06-11 Thread Paul Burney
, Paul Burney http://paulburney.com/ ?php // the statement formerly known as prince if ($the_elevator == 'tries to bring you down') { go_crazy('punch a higher floor'); } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PDF/FDF Support

2002-07-03 Thread Paul Burney
be the default case in Windows, but I know from experience that it is a PITA on old Macs. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Header problem

2002-07-15 Thread Paul Burney
that the location needs to include the scheme and FQDN, i.e., http://example.com/file.php Some browsers (notably Lynx) complain or don't work with relative Location headers. It's also possible that the . is causing a problem. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self

Re: [PHP-DB] How can you include an https?

2002-07-30 Thread Paul Burney
: http://php.us.themoes.org/manual/en/ref.curl.php I'd suggest looking for an RPM that has them included. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

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

2002-07-30 Thread Paul Burney
should quote your key names. while ($myrow = mysql_fetch_array($result)) { echo 'trtd',$myrow['Name'],'/td'; echo 'td',$myrow['txtSWDesc1'],'/td/tr'; } HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database

Re: [PHP-DB] Connecting to FileMaker Server?

2002-08-27 Thread Paul Burney
the FileMaker unlimited client connected to the FileMaker server. You can then use the native XML output from the Web Companion or one of the previously mentioned php scripts. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count

Re: [PHP-DB] set_magic_quotes_runtime???

2002-09-18 Thread Paul Burney
, that option is related to quoting for certain database queries. Specifically, it adds a ' to every ' character. If you are able to use .htaccess files to override settings on the server, you could try something like this: php_value magic_quotes_gpc 0 Hope that helps. Sincerely, Paul Burney http

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

2002-09-20 Thread Paul Burney
/manual/en/function.ini-set.php HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PhpHoo_create database phpHoo\p\g

2002-10-01 Thread Paul Burney
at the MySQL command prompt. mysql ? Hope that helps. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Obsession for Oil

2002-10-15 Thread Paul Burney
on 10/15/02 12:29 AM, CK Raju at [EMAIL PROTECTED] appended the following bits to my mbox: Reports of US annexing Iraq appears to be highly disturbing. The oil If (!preg_match('/php/',$message_body)) { redirect_message('/dev/null'); } -- PHP Database Mailing List

Re: [PHP-DB] Re: file upload and php (Not a begginer [sic]question!)

2002-10-15 Thread Paul Burney
on 10/15/02 4:11 PM, BAROILLER at [EMAIL PROTECTED] appended the following bits to my mbox: No one have an idea ? Maybe it's because this isn't really database related and you posted to the PHP-DB list instead of PHP-GENERAL? I don't want to use this because it's too long for users when you

Re: [PHP-DB] Calendar

2002-10-17 Thread Paul Burney
based calendar in PHP. DevShed is good place for other PHP tutorials as well. HTH. Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Log Application Formatting Issue...

2002-10-18 Thread Paul Burney
as suggested by someone else, but instead of directly outputting the result, store it into another array. Then reverse that array in php and display it. HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List

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

2002-10-25 Thread Paul Burney
'; while (result = something) { if ($first_record == 'yes') { do_something(); $first_record == 'no'; } else { do_something_else(); } } HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count

Re: [PHP-DB] Delay Confirmation....

2002-12-09 Thread Paul Burney
of the sleep(10) command. Why do you want to sleep instead of giving the results to the user as soon as they are ready? Is it a security issue so the server doesn't get flooded with automated requests? Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts

Re: [PHP-DB] How can I use PHP to duplicate a mysql templatedatabase? [hack] bug

2002-12-18 Thread Paul Burney
If the databases are on the same server, I think you can do (c) as the following: INSERT INTO $new_database.$tablename SELECT * FROM $old_database.$tablename; If it's a remote server, I think it would require you to do it in PHP (ouch). Hope that helps. Sincerely, Paul Burney http://paulburney.com

Re: [PHP-DB] The ability of accessing DB

2002-12-30 Thread Paul Burney
. Check phpinfo() to see if sybase persistent connections are allowed, and if you aren't using the default database, make sure you are calling the sybase_select_db() command before the queries. http://www.php.net/manual/en/function.sybase-select-db.php HTH. Sincerely, Paul Burney http

Re: [PHP-DB] mysql time format

2003-01-07 Thread Paul Burney
that result to build a query like that above. (You could also use one of the php mysql_field_* functions.) HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Re: Breaking up new lines for e-mail

2003-01-07 Thread Paul Burney
= str_replace(\n,\r\n,$text); // all to windows HTH. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Recursive SQL Expression?

2003-01-17 Thread Paul Burney
/1,289483,sid13_gci537290,00.html http://www.dbmsmag.com/9605d06.html http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm Hope that helps. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP Database Mailing List

Re: [PHP-DB] extract() expects first argument to be an array

2003-01-17 Thread Paul Burney
MySQL_fetch_assoc instead. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ Q: Tired of creating admin interfaces to your MySQL web applications? A: Use MySTRI instead. http://www.burney.ws/software/mystri/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Efficiency

2003-01-21 Thread Paul Burney
) = MySQL_fetch_row(MySQL_query($q,$dbh)); The $my_count variable now has your number of rows. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ Q: Tired of creating admin interfaces to your MySQL web applications? A: Use MySTRI instead. http://www.burney.ws/software/mystri/ -- PHP

Re: [PHP-DB] image in mysql?

2003-01-21 Thread Paul Burney
. Check the archives: http://marc.theaimsgroup.com/?l=php-db Also, a google search: http://www.google.com/search?q=mysql+php+image+blob Turns up a good tutorial as the first result: http://www.phpbuilder.com/columns/florian19991014.php3 Hope that helps. Sincerely, Paul Burney http

Re: [PHP-DB] session_destroy(); on submit?

2003-01-21 Thread Paul Burney
value=http://www.etc.com; thank you and best, addison No, it will not work. PHP is server side, JavaScript (onClick, etc.) is client side. Have the form submit to a PHP page that has the session functions at the top. HTH. Sincerely, Paul Burney http://paulburney.com/ Q: Tired of creating

Re: [PHP-DB] Cookies problems

2003-01-22 Thread Paul Burney
, you won't see the echo unless you reload. You may also wish to look at the documentation for the setcookie (not sendcookie) function: http://www.php.net/manual/en/function.setcookie.php HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count

Re: [PHP-DB] Array problems

2003-01-22 Thread Paul Burney
format it needs the data in and we'll help you figure out how to get it from the database into that format. If you can't figure out what format of data the class needs, you should let us see the graph class source. HTH. Sincerely, Paul Burney http://paulburney.com/ ?php if ($your_php_version

Re: [PHP-DB] file and https

2003-02-21 Thread Paul Burney
support, nor want to upgrade to PHP 4.3.x, you may be able to call a command line utility directly. For example, I've used this in the past: passthru('curl https://secure.example.com/some-file.html'); Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep

Re: [PHP-DB] Calendar Question

2003-02-24 Thread Paul Burney
at: http://www.burney.ws/software/library.php?id=20 Hope that helps. Sincerely, Paul Burney http://paulburney.com/ Q: Tired of creating admin interfaces to your MySQL web applications? A: Use MySTRI instead. Version 3.1 now available. http://mystri.sourceforge.net

Re: [PHP-DB] Screen size, browser on php

2003-02-28 Thread Paul Burney
?w=615h=420 - Have your php script output the correct Content-type header for the image and pass it through while logging the info you want. HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List

Re: [PHP-DB] Creating MySQL Entry Forms

2003-03-01 Thread Paul Burney
. PHPMyAdmin is just a collection of PHP pages that talk to MySQL. It doesn't require any special installation. See: http://phpmyadmin.sf.net for more information. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing

Re: [PHP-DB] undefined function: mysql_pconnect()

2003-03-01 Thread Paul Burney
(). Call to undefined function: mysql_pconnect() You need to install the php-MySQL RPM file from the Red Hat CD. The default install doesn't give you MySQL support. HTH. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP

Re: [PHP-DB] Making Join

2003-02-28 Thread Paul Burney
, username FROM photos LEFT JOIN users ON photos.userid=users.id GROUP BY userid You could add the file field in there as well, but it would only be returning one of the files (the first or last one for that user, but I don't know of a way for you to be specific). Hope that helps. Sincerely, Paul

Re: [PHP-DB] explode string variable

2003-03-08 Thread Paul Burney
an array that looks like this: $variable_array[0] should be Willy $variable_array[1] should be Brandt-Platz Wrong list since doesn't involve databases. Should be on PHP-General. That said, use strtok: http://www.php.net/manual/en/function.strtok.php Sincerely, Paul Burney http

Re: [PHP-DB] file save part 2

2003-03-08 Thread Paul Burney
); If that doesn't help, send an example of what you want the data to look like. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] receiving date elements from Access

2003-03-09 Thread Paul Burney
) The field Datumsfeld is a date field with the syntax DD.MM. (German way) Maybe you should try the date in the syntax the database uses, i.e., 12.12.2002? Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing

Re: [PHP-DB] Real Killer App!

2003-03-13 Thread Paul Burney
just sees a really long query_string starting with /examples. I'm sure that isn't your problem, but I've been bit by it a few times. END OF ASIDE Hope some of that ramble helps. Please try to see if it is dieing on a particular URL so we can be of further assistance. Sincerely, Paul Burney

Re: [PHP-DB] Real Killer App!

2003-03-16 Thread Paul Burney
the connections? If so, you could try sleeping for a second every 10 times through the loop, etc, to slow down the process and maybe keep it from dying. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php if ($your_php_version 4.1.2) { upgrade_now(); // to avoid major

Re: [PHP-DB] Re: deleting records using a checkbox

2003-03-20 Thread Paul Burney
for JavaScript / DOM interaction and reserve the name elements for php. That should work on any modern browser (sorry, no Netscape 4.x). HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http

Re: [PHP-DB] Gathering data from a database

2003-03-22 Thread Paul Burney
on 3/22/03 8:26 PM, Mike Delorme at [EMAIL PROTECTED] appended the following bits to my mbox: $select = mysql_select_db ($database); Remove the quotes around this. Actually, there is no reason to do the variable assignment either. Sincerely, Paul Burney http://paulburney.com/ ?php while

Re: [PHP-DB] Generating view of tree?

2003-03-27 Thread Paul Burney
://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html http://www.dbmsmag.com/9605d06.html http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm Hope that helps. Sincerely, Paul Burney http://paulburney.com/ Q: Tired of creating admin interfaces to your MySQL web

Re: [PHP-DB] PHP for apache logging to mysql

2003-03-27 Thread Paul Burney
that shows up in things like this: ERROR 1030: Got error 127 from table handler You could also add indexes for that table to speed up queries and setup a script to automatically migrate from one table to the other, etc. Hope that helps. YMMV. TMTOWTDI. Sincerely, Paul Burney http://paulburney.com

Re: [PHP-DB] PHP for apache logging to mysql

2003-03-28 Thread Paul Burney
. Sincerely, Paul Burney http://paulburney.com/ ?php // the statement formerly known as prince if ($the_elevator == 'tries to bring you down') { go_crazy('punch a higher floor'); } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] naming conventions

2003-03-30 Thread Paul Burney
object. Hope that helps. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep) { $sheep_count++; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Modify php.ini setting in code

2003-05-27 Thread Paul Burney
to be different. If your web host allows you to use .htaccess files and gives you override permissions, you can put this in the .htaccess file at the top level of your server. php_value include_path '/whatever/path/you/need/here:.' Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp

Re: [PHP-DB] Optimize following Mysql-Query

2003-05-31 Thread Paul Burney
INNER JOIN Master ON Firmennamen.ID=Master.FN INNER JOIN Personen ON Master.NN=Personen.ID WHERE Personen.NAME LIKE '%$name%'; Also make sure that you are indexing the fields that you are performing the joins on. HTH. Sincerely, Paul Burney http://paulburney.com/ ?php while ($self != asleep

Re: [PHP-DB] File input from form not detected

2003-05-31 Thread Paul Burney
probably be looking at the $_FILES array. - You must add an encoding type to the form - enctype=multipart/form-data HTH. Sincerely, Paul Burney http://paulburney.com/ ?php // the statement formerly known as prince if ($the_elevator == 'tries to bring you down') { go_crazy('punch a higher floor

  1   2   >