[PHP-DB] Previous | Next (Again)

s the second etc. and know which the current one is if the id field has gaps in it. Not sure if that made any sense. Jeff Oien -- 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 administrato

[PHP-DB] Password Question

sword they use for other things I think it would be best for it to be encrypted. Jeff Oien -- 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]

RE: [PHP-DB] Password Question

I like the new password idea. How do I make sure it's them who's creating a new password so that someone else doesn't maliciously change their password? If someone knew someone's username and e-mail address I would think they could change it. Thanks. Jeff > This doesn'

RE: [PHP-DB] Previous | Next (Again)

sword stuff but this I'm just clueless. Jeff Oien > I would add the field "picnumber int" or something to your DB. > This is where the pic falls in the order of pics in the album. > > The the previous and next should be as simple as doing > select picnumber,picloc

RE: [PHP-DB] Previous | Next (Again)

ut them into an array? Thanks for the help. Jeff Oien > I don't know of a way to do the insert in a single query (anyone?!?) with > this... but > > assuming the fields in pic are > id int PRI > location varchar(30) > picnumber int > user varchar(20) > > $query = &

[PHP-DB] Parsing Error

{ $store=$row["store"]; $jobdesc=$row["jobdesc"]; $rowid=$row["rowid"]; echo " $store $jobdesc Modify/ Delete \n; } echo ""; mysql_free_result($result); ?> Return To Main Menu Add An I

[PHP-DB] Forms Question

stored in $store to automatically fill in on the drop down list. But, for some reason it is defaulting to the first option, and not using the value that is in the database. Can I use a drop down menu, or should I just go to radio buttons? Thanks, Jeff -- Jeff Grossman ([EMAIL PROTECT

[PHP-DB] Mail() function and the php.ini file

I'm attempting to setup the PHP module to allow the mail() function to work. As I understand, I need to edit the php.ini file? I can't locate the file to edit. Can someone point me in the right direction? I'm using OSX Server. Thanks, Jeff Panis [EMAIL PROTECTED] -- PHP Databa

[PHP-DB] Locating php.ini file

I can't seem to locate the php.ini file on my server. Phpinfo() shows it to be in /usr/local/lib but I can't seem to see it (logged as root). I'm on OSX Server 10.0.3 using PHP 4.0.6. Does anybody have have any clues where to locate this file? Thanks, Jeff Panis [EMAIL PROTECTED

[PHP-DB] Unwanted Column Updating

W() where id = '$id'"; However, time1 is being updated to be the same as time2 after the exit and I don't want it to be. Am I missing something? Jeff Oien -- 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] Please help asap

Hello I am trying make a script fatch my data form my mysql database. I use this script but when execute it is says Warning: printf(): too few arguments in /home/httpd/html/larken/database.php on line 47 any hints Thanks Jeff \n"; echo "Name of contactName of company Add

[PHP-DB] How to put data

Hello How do you Normal put you mysql data in to a php table. Jef -- 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]

Re: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

try : if (strlen($products) == 0) { echo "nothing entered in field"; } http://www.php.net/manual/en/function.strlen.php Jeff - Original Message - From: "Aaron Wolski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 0

Re: [PHP-DB] How to find the last ID?

("INSERT INTO agents (agent_name) >VALUES ('$agentname') > > but I need to find out the ID value it created, how can I do this easily? > > Thanks > > Chris --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problem with insert query

gt; > @ $db = mysql_connect("localhost"); > mysql_select_db("me2resh00"); > $query = "insert into recipients (recipient_name, recipient_email) values > ('"friend"', '".$mails[$i]."')"; > $result = mysql_query($query); > if ($result)

Re: [PHP-DB] MySQL, PHP, and XML

gt; To unsubscribe, visit: http://www.php.net/unsub.php --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Weird Segfaults with Oracle, PHP, Apache2

atement($stmt); OCILogoff($conn); echo 'here7'; ?> The server segfaults right after it gets to "here3". If you comment out everything after here3, the page works fine. Running the $stmt select works fine if you use sqlplus. I'm not sure why it's dying. Has an

RE: [PHP-DB] Weird Segfaults with Oracle, PHP, Apache2

-Original Message- From: Thies C. Arntzen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 5:33 AM To: Harris, Jeff Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] Weird Segfaults with Oracle, PHP, Apache2 On Tue, Jul 08, 2003 at 05:51:47PM -0500, Harris, Jeff wrote:

[PHP-DB] RE: Weird Segfaults with Oracle, PHP, Apache2

bpthread.so.0...done. Loaded symbols for /lib/libpthread.so.0 #0 0x407a5582 in sskgmstat () from /opt/oracle/OraHome1/lib/libclntsh.so.9.0 -Original Message- From: Harris, Jeff Sent: Tuesday, July 08, 2003 5:52 PM To: '[EMAIL PROTECTED]' Subject: Weird Segfaults with Oracle, P

[PHP-DB] Newbee: Array Field Separator: \035

gdbm file do I have to stick with dba_* calls or are there other function I can use to process the data? Thanks, Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Newbee: Array Field Separator: \035

I figured out the field seperation on my own. Thanks anyway, jeff Jeff Langley wrote: > Hi, > > I am reading an already created gdbm file with dba_fetch into an array. > > I am able to print out the array but not the individual > elements. The elements are separated with a

Re: [PHP-DB] Re: ./configure stupidity

ty in packages debian sure seems to beat the pants off of RedHat. But, sorry, that doesn't help your immediate problem. - Jeff On Thu, 2003-07-24 at 11:33, Nabil wrote: > please please would you help me to get > > mysql - gd - iodbc (odbc) - mssql - apache > > I need

Re: [PHP-DB] "Consider upgrading MySQL client" .... how do I do this?

ted was to use an ODBC driver to interface > between PHP and MySQL but indicated that this may be slower. > > My question, therefore, is - is there a way to upgrade the MySQL > client in PHP 4.3.3? If not, what are the alternatives (apart from > reverting back to MySQL 4.0.x

[PHP-DB] Best method to search mySQL with PHP?

e any experience with this? Jeff

Re: [PHP-DB] sql optimizing assistance

> table | type | possible_keys | key| key_len | ref| rows | > Extra | > +++---++-++++ >> Response| ALL| [NULL]| [NULL] | [NULL] | [NULL] | 126732 | > Using temporary| >

Re: [PHP-DB] how to select rows with repeated coloumns in one query????

p by grade having cnt>1 >> and then >> select * from studs where sno in ('result of previous query') >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] HELP With UPDATE Query in mySQL

ow can i update every row so that > all of the times for Booking_Start_Date are 09.00 and all of the times for > Booking_End_Date are 17.30, without affecting any of the dates? > > Thanks for your help --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Help With Another UPDATE Query Please!

to update Projects with one query? > > Thanks for your help --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Help With Another UPDATE Query Please!

as a work type associated with it, currently the Work Type > column of the Project table holds the work type name, however i have now > added a Work_Type_ID column to the Work_Type table and i would like Projects > to hold the Work_Type_ID as opposed to the Work Type Name. > > Thanks for

Re: [PHP-DB] Getting last insert id?

once it has done this, I need to get the id it has generated in > the DB and then update that record with the id it generate, so how > can I get the id from the above insert? > > Any help would be greatly appreciated :-) > > Regards > > Chris --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] crud forms

What sort of tools are available for creating database CRUD forms(create,retreive,update,delete)? I am familiar with patForms and cake. What are the other leading contenders? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Table Output Question

I have a table, where each line is the output of a query from a MySQL database. I do not use borders, so the page is a little difficult to read sometimes. Is it possible, or how do I, alternate the background color of each row when I output it? My code is like this: while (query) {

[PHP-DB] Re: Table Output Question

t;blue"; >} else { >$color = "red"; >} >?> >.. > > } > > -Micah Great, thanks for the help and information. May I ask, how does PHP know to change the color? What do the "?&q

[PHP-DB] Re: Table Output Question

> > > bastien > > > ps: a class css definition would be better here Thanks for the help. After reading a couple of the responses, I couldn't believe that I did not think of this. I don't know a lot about CSS yet (just purchased a book). But, could you shar

[PHP-DB] Re: Table Output Question

> > echo "..."; > > } > > Its essentially the same thing, just neater and lets you concentrate on the > code for the table without the worry about the way the row looks > > Bastien > Thanks again for the information. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Creating checkbox list.

Good evening. I'm sure this is something easy so I'm hoping you can simply steer me to a good source. I simply need to create a Checkbox list using data from my "groups" table. I have a table with two fields: 1) groups_id 2) groups_name The data contained is simple: groups_id groups_name

[PHP-DB] Generate Report

tatement. Then I guess I would have to figure out the code for the echo. Am I at least in the ballpark??? Thank you and good night. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Where did my Hard Returns go?

umbled together. I checked within the MySQL database and noticed the Hard Returns show in the database (at least while using phpMyAdmin). Must have something to do with PHP? Where did I go wrong??? Thanks. --Jeff

Re: [PHP-DB] Where did my Hard Returns go?

the two color shades) and then displayed the 13 correct rows. Perhaps this was the proper placement of nl2br but there is something in the other code that screwed up the presentation??? Thanks. Jeff - Original Message - From: "Jeff Broomall" <[EMAIL PROTECTED]> To: S

[PHP-DB] Retricting Access to Menu Items

wasn't that helpful for this case. Can I setcookie('user_group', '3') and use that somehow??? Am I in the ballpark with this solution? Thanks. Jeff

[PHP-DB] dbx question - specifying a port for pgsql

variation of it could be used throughout dbx? Thank you, Jeff Van Campen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mcrypt: Is length of ciphertexts predictable?

he padding that was used? Thank you, Jeff Wiegley -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Is persistent connection + MySQL + Apache + insert_id === safe?

connection and insert. If that can happen, then do you get the right insert_id value back when person_page_1 resumes? Or do you get the most recent, which would be the insert from person_page_2? Thanks, Jeff Veit http://www.tanasity.com/ - Tanasity develops software and net applications - radical

<    1   2