Re: [PHP-DB] insert in mysql

2001-01-25 Thread Paul Burney
part.");mysql_close($db);exit();} > } Why the single quotes around $sql. It's a string so you shouldn't have to quote it at all. if (!mysql_query($sql)) {echo 'Unable to add part!'; } ++ Paul Burney Webmaster an

Re: [PHP-DB] AUTO_INCREMENT

2001-03-04 Thread Paul Burney
on 3/4/01 3:58 AM, Joris Kluivers at [EMAIL PROTECTED] wrote: > CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL > AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id); > with php. > But after some time i get the error: > ERROR 1062: Duplicate entry '127' for key 1 >

Re: [PHP-DB] How to redirect after a valid login

2004-03-15 Thread Paul Burney
h = $file_system_location . '/includes:' . $current_includes_path; ini_set('include_path',$new_include_path); Hope that helps. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] One or Many Databases?

2004-07-31 Thread Paul Burney
this question be any different if I were using PostgreSQL, MSSQL or DB2? Thank you in advance for any advice you can offer. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] DB Connections

2002-01-31 Thread Paul Burney
on 1/26/02 1:21 AM, jas at [EMAIL PROTECTED] appended the following bits to my mbox: > Ok, I am having a hard time coming up with a mysql connection class that > simply allows me to setup a require(db_connection.inc) at the top of my php > pages that allows a consistent connection to the mysql db

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_

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: m

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 P

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 probl

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 Me

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? Prob

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

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 P

Re: [PHP-DB] Dynamic Drop Down Box

2002-03-06 Thread Paul Burney
op-down menus. You can see the theory 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.co

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

2002-03-07 Thread Paul Burney
#x27;s better 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/ http://security.e-matte

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

2002-03-08 Thread Paul Burney
so take my advice with a grain of salt. Hope it helps. Sincerely, Paul Burney http://paulburney.com/ http://security.e-matters.de/advisories/012002.html> */ ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-03-15 Thread Paul Burney
out Marc Liyange's startup script for MySQL on OS X. <http://www.entropy.ch/software/macosx/mysql/> HTH. Sincerely, Paul Burney http://paulburney.com/ http://security.e-matters.de/advisories/012002.html> */ ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

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 shar

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

2002-03-29 Thread Paul Burney
to display the name CASTRO TRUCKING, the text field > only display the first word CASTRO. > > Just following up on what someone else said. If the Name field has a quote in it, such as <> that could also cause problems. To remedy, do this: HTH, Paul Burney http://burney.ws/

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

2002-03-30 Thread Paul Burney
ot;DELETE FROM $tablename WHERE id IN ('" . implode("','", addslashes($_POST['del'])) . "')"; That would produce something like: DELETE FROM table WHERE id IN ('3','4','123'); Hope that helps. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Updating Forms Values

2002-04-04 Thread Paul Burney
; , urlencode($username); HTH. Sincerely, Paul Burney <http://paulburney.com/> -- 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
nt then set a blank $thisoption="";} } // end option "if" statement } // end id "if" statement /* More code after this point */ } // end "while" if statement. === Hope that helps. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] selected problem

2002-04-26 Thread Paul Burney
the options into an array and then create the list by looping through the array, each time checking the value to see if it is the selected one using the code above. HTH. Sincerely, Paul Burney <http://paulburney.com/> -- 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
to delete your table's entire contents. Usually, with PHP and MySQL such a query would fail. If you use the above code, it would succeed. Just a word of warning. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-06-06 Thread Paul Burney
or an RPM for PHP that mentions MySQL as well. HTH. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] date format display

2002-06-10 Thread Paul Burney
ot;3"; Hope that helps. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] case

2002-06-11 Thread Paul Burney
al/en/function.preg-match.php> HTH. Sincerely, Paul Burney <http://paulburney.com/> -- 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
and it must be set to handle the FDF type. This may 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Header problem

2002-07-15 Thread Paul Burney
on php-general. FWIW, I believe 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

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

2002-07-30 Thread Paul Burney
to use the CURL functions: <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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-07-30 Thread Paul Burney
ly outputting strings, printf isn't really necessary so you can use the echo command instead. Also, though this probably isn't the reason, you should quote your key names. while ($myrow = mysql_fetch_array($result)) { echo '',$myrow['Name'],'';

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

2002-08-27 Thread Paul Burney
o run a version 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 Database Mailing List

Re: [PHP-DB] set_magic_quotes_runtime???

2002-09-18 Thread Paul Burney
orrectly, 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. Since

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

2002-09-20 Thread Paul Burney
r further information: <http://www.php.net/manual/en/function.ini-set.php> HTH. Sincerely, Paul Burney <http://paulburney.com/> -- 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
her MySQL commands, type a question mark or \h 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 (http://www.php.net/

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
t's a simple MySQL based calendar in PHP. DevShed is good place for other PHP tutorials as well. HTH. Paul Burney <http://paulburney.com/> -- 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
ange to DESC 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 Database Mailing List (http://www.php.net/) To uns

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

2002-10-25 Thread Paul Burney
rd = 'yes'; while (result = something) { if ($first_record == 'yes') { do_something(); $first_record == 'no'; } else { do_something_else(); } } HTH. Sincerely, Paul Burney <http://paulburney.com/> -- PHP D

Re: [PHP-DB] PHP4 to PHP3 problem

2001-04-10 Thread Paul Burney
on 4/10/01 1:49 PM, Rob Griffiths at [EMAIL PROTECTED] wrote: > **50** print "{$A["fname"]}" . You need to separate out the array reference: print "" . $A["fname"] . "" That should do it. Hope it helps, Paul Burney http://

Re: [PHP-DB] select substring_index

2001-04-11 Thread Paul Burney
ELECT substring_index(body, "." ,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 PROT

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

2001-04-12 Thread Paul Burney
p<->mysql tutorial is. I like devshed.com tutorials. 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 Educa

Re: [PHP-DB] substring_index Part 2

2001-04-12 Thread Paul Burney
assume that somewhere in the code you have the connection made and the database selected. Can you try this? 0) { while ($myrow = mysql_fetch_array($result)) printf("%s\n", $myrow['headline']); printf("%s\n", $myrow['body']

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

2001-04-18 Thread Paul Burney
gt; Pls help me Sorry, 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

Re: [PHP-DB] Sending e-mail thru PHP page (2nd part)

2001-04-19 Thread Paul Burney
net, zend.com, or the general list archives for more info. Hope that helps. Sincerely, Paul Burney http://paulburney.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 a

Re: [PHP-DB] extracting login name

2001-04-25 Thread Paul Burney
ly set if PHP is sending the authentication. If they don't work for you, you should be able to use the environment variable $REMOTE_USER. HTH, Paul Burney http://paulburney.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional co

Re: [PHP-DB] update problems

2001-04-26 Thread Paul Burney
d they run a while loop to drop the values into a select field, i.e., echo '' , $row['fieldname'] , ''; 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] Inserting correct value from database into formoption field

2001-04-28 Thread Paul Burney
add a " selected" keyword to the appropriate option tag. Typically in PHP, this is done with a series of if statements. For example, >One voyage only Hope that helps, Paul Burney http://paulburney.com/ http://webdevel.burney.ws/ -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread Paul Burney
u delete all rows from the table or something similar. Hope that helps, Paul ++++++ Paul Burney Webmaster and Open Source Developer Educational Technology Unit Graduate School of Education and Information Studies University of California, Los Angel

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

2001-05-10 Thread Paul Burney
> > [b]bold[/b] > 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 S

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

2001-05-14 Thread Paul Burney
is visible. IE is just trying to display what it can 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 Informat

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 MyS

Re: [PHP-DB] Filling a dropbox on form

2001-05-18 Thread Paul Burney
Other than that, you could have the user do a limiting search on the DB for the item first, and then make the drop box from that. HTH, Paul Burney http://paulburney.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: [PHP-DB] Deleting specific records from MySQL tables

2001-05-20 Thread Paul Burney
nnerID=' . $banresult[bannerID]; mysql_db_query("phpads", $this_query); If the bannerID field isn't numeric, you'll need to enclose it in quotes as someone else mentioned. HTH, Paul Burney http://paulburney.com/ http://webdevel.burney.ws/ -- PHP Database Mailing List

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

2001-06-22 Thread Paul Burney
m_rows($result); > > Is this a new 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 +++++

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

2001-06-22 Thread Paul Burney
do something with it. Call ifx_query or something.*/ } You could also just go through all the results in a similar fashion and set: $orderdate = $row['orderdate']; $ordertotal = $row['ordertotal']; Hope that helps. Sincerely, Paul Burney ++

Re: [PHP-DB] submitbutton/imagebutton

2001-06-22 Thread Paul Burney
f checking for $submit, do something like: ... if (isset($submit_x)) { ... Sincerely, Paul Burney ++++++ Paul Burney Webmaster && Open Source Developer UCLA -> GSE&

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

2001-06-26 Thread Paul Burney
t entails the necessary MySQL header files so that PHP can compile 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 +++

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

2001-06-27 Thread Paul Burney
ave a malformed table while ($c % $n != 0) { echo ' '; $c++; } echo ''; // end table code (omitted) ?> Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaste

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

2001-06-28 Thread Paul Burney
r, and it won't add them anymore. Any 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 Burn

[PHP-DB] PhpMyAdmin phpPgAdmin Security Issues

2001-07-02 Thread Paul Burney
ig etc. respond to this. Sincerely, Paul Burney +-+-----+ | Paul Burney | P: 310.825.8365 | | Webmaster && Programmer | E: <[EMAIL PROTECTED]> | | UCLA -

Re: [PHP-DB] Authomatic Sorting

2001-07-04 Thread Paul Burney
add an "ORDER BY" clause 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 Webma

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

2001-07-23 Thread Paul Burney
e mysql_fetch_*** and access them. Hope that helps. Sincerely, Paul Burney ++ Paul Burney Webmaster && Open Source Developer UCLA -> GSE&IS -> ETU (310) 825-8365 <[EMAIL PROTECTED]> <http://www.gseis.ucla.edu/&g

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

2001-07-24 Thread Paul Burney
you have 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 && O

Re: [PHP-DB] Retrieving Rows - Can I Change The Order?

2001-07-25 Thread Paul Burney
ay, you can do it as follows: 1. Create a new table with the columns in the right order. 2. Execute `INSERT INTO new_table SELECT fields-in-new_table-order FROM old_table'. 3. Drop or rename `old_table' 4. `ALTER TABLE new_table RENAME old_table' Hope it helps. Si

Re: [PHP-DB] mysql query problem

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

Re: [Fwd: [PHP-DB] How to LogOut?]Still no answer????

2001-07-26 Thread Paul Burney
on 7/26/01 6:25 PM, Ariunbold Gerelt-Od at [EMAIL PROTECTED] wrote: > Somebody give me a advice??? You probably should try your question on the PHP General list: <http://php.net/support.php> This list should be reserved for messages related to using databases with PHP. Sincerely, Pa

Re: [PHP-DB] Query on Oracle Views

2001-08-06 Thread Paul Burney
x27;; Or escape the $: $query = "SELECT instance_name, host_name FROM v\$instance"; HTH. Sincerely, Paul Burney ++++++ Paul Burney Webmaster && Open Source Developer UCLA -> GSE&IS -&

Re: [PHP-DB] mysql_fetch_array missing first record

2001-08-07 Thread Paul Burney
mysql_fetch_array 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 diagnos

Re: [PHP-DB] Submit forms

2001-08-10 Thread Paul Burney
cking isset($submit). Some browsers (Netscape on the Mac, for example) won't submit the name-value pair associated with the button. One solution is to do this instead: No matter how the form is submitted, the submit variable will

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

2001-08-13 Thread Paul Burney
($query, $connection_id) Just make 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 | | Webmas

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

2001-08-17 Thread Paul Burney
ist since 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]&g

Re: [PHP-DB] Photo Album Schema

2001-08-21 Thread Paul Burney
. $file_extension; You should also look at using the GetImageSize function to determine whether or not the file is really an image. Good luck. Sincerely, Paul Burney +-----+-+ | Paul Burney | P: 310.825.8365 | | We

Re: [PHP-DB] Error with in_use() from Beginning PHP4 book.

2001-08-25 Thread Paul Burney
ction exactly? If so, where is $dbuser set? If it's set outside the function, you need to make it a global global $user_tablename,$dbuser; > Does this have anything to do with updated MySQL parser? I am now using > MySQL version 3.23.36. Possibly if the version of P

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

2001-08-28 Thread Paul Burney
riptive than those from PHP. Another thing to try is instead of dying with "Problem!", try exiting with mysql_error and/or mysql_errno, that is: echo mysql_errno() , ': ' , mysql_error() , ''; HTH. Sincerely, Paul Burney

Re: [PHP-DB] MySQL UPDATE problem

2001-08-30 Thread Paul Burney
'" WHERE GID=' . $gid; HTH. Sincerely, Paul Burney ++++++ Paul Burney Webmaster && Open Source Developer UCLA -> GSE&IS -> ETU (310) 825-8365 <[EMAIL PROTECTED]> <http://www.gseis.ucla.edu/> +

Re: [PHP-DB] Random

2001-08-31 Thread Paul Burney
ion of MySQL are you using? I remember something about ordering 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 k

Re: [PHP-DB] MySql database data has html code in it

2001-09-01 Thread Paul Burney
specialchars() function. <http://php.net/manual/en/function.htmlspecialchars.php> Sincerely, Paul Burney ++++++ Paul Burney Webmaster && Open Source Developer UCLA -> GSE&IS -> ETU (310) 825-8365 <[EMAIL

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

2001-09-05 Thread Paul Burney
on shared servers. 5) Backup everything from databases regularly and hope you never really need to use them. Hope that helps. Sincerely, Paul Burney ++++++ Paul Burney Webmaster && Open Source Developer UCLA -> GSE&IS -> E

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

2001-09-05 Thread Paul Burney
es (what goes in the [" "]?) Using the above code, the value you're looking for is mydate, i.e., echo $myrow['mydate']; HTH. Sincerely, Paul Burney ++ Paul Burney Webmaster && Open Source Deve

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 constructio

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 Communiga

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 mysql_

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

2002-12-09 Thread Paul Burney
ng request page while waiting for the processing finished page to show up, which will take at least 10 seconds because 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

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

2002-12-18 Thread Paul Burney
tabase c) transfer the data 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. Since

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

2002-12-30 Thread Paul Burney
f not. Adding the select database command in the script solved it, of course. 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

Re: [PHP-DB] mysql time format

2003-01-07 Thread Paul Burney
n use PHP to parse the results to tell you which fields are time types, then use 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2003-01-07 Thread Paul Burney
t;\r\n","\n",$text); // windows to unix $text = str_replace("\r","\n",$text); // mac to unix $text = str_replace("\n","\r\n",$text); // all to windows HTH. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... ht

Re: [PHP-DB] Recursive SQL Expression?

2003-01-17 Thread Paul Burney
ree. See this site for details: <http://philip.greenspun.com/sql/trees.html> If you aren't tied to that database structure, you could investigate the must faster denormalized alternative nested set model that is often mentioned on this list: <http://searchdatabase.techtarget.com/

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

2003-01-17 Thread Paul Burney
" one that MySQL_fetch_array returns. Try using 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/> -

Re: [PHP-DB] Efficiency

2003-01-21 Thread Paul Burney
connection $q = 'SELECT COUNT(*) FROM tablename'; list($my_count) = 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 appl

Re: [PHP-DB] image in mysql?

2003-01-21 Thread Paul Burney
es on the list. 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

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

2003-01-21 Thread Paul Burney
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 admin interfaces to your MySQL web applications? A: Us

Re: [PHP-DB] Cookies problems

2003-01-22 Thread Paul Burney
#x27;t be seen until the next time you view the page. If your setcookie command and echo $cookie commands are in the same file, 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/func

Re: [PHP-DB] Array problems

2003-01-22 Thread Paul Burney
wGraph(); call inside your while loop. If not, let us know what 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. S

Re: [PHP-DB] file and https

2003-02-21 Thread Paul Burney
"file") If you don't want to recompile with CURL 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

Re: [PHP-DB] Calendar Question

2003-02-24 Thread Paul Burney
w a live demo and download the source 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 av

  1   2   >