[PHP-DB] Re: checkboxes names & values in mySQL (newbie)

Here's a nifty trick. Name your check boxes like this. Then when it posts back to php, you will have a nice array. Lets say that they tick all but value2, then you will have: $myarray == array("value1", "value3", "value4"); I guess the order in which they appear is arbitrary, but that ma

Re: [PHP-DB] checkboxes names & values in mySQL (newbie)

Hello, John. You wrote 10 îêòÿáðÿ 2002 ã., 23:40:10: J> 2 questions: J> Should I have a unique form name for each checkbox, and store it's J> boolean value in the database, OR (is it more streamlined) .. J> To create an array=myarray[$i]> with the same name but different value

[PHP-DB] Re: easier way to do this? (time interval)

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Hello, > > Curious if there is an easier way to do this (using just SQL and not PHP). > SQL seems powerful enough to do this but can't think of the synatx. Note, I > am using MySQL so no sub-selects (or other useful items). Basically

[PHP-DB] easier way to do this? (time interval)

Hello, Curious if there is an easier way to do this (using just SQL and not PHP). SQL seems powerful enough to do this but can't think of the synatx. Note, I am using MySQL so no sub-selects (or other useful items). Basically trying to pull all records for a 24 hour period but instead of ->

Re: [PHP-DB] sessions tutorial

This is a very good tutorial about authentication using PHP and MySQL. If you don't use database, you may still learn some thing about sessions from there: http://phpcomplete.com/content.php?id=72 Ruth - Original Message - From: "Edward Peloke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

[PHP-DB] Re: Multi-Dimensional Arrays

Perfect, thank you very much Owen!! "Owen Prime" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Sounds like what your trying to do is: > > $cartArray[] = array("ItemNumber" => $itemnumber, > "Brand" => $brand, >

RE: [PHP-DB] Selecting PASSWORD() value in MySQL

> I'm trying to retrieve data from a MySQL table which contains data > encrypted with the MySQL "PASSWORD()" function from a PHP script but I > can't seem to get it to work. Below is the query I'm trying: > > SELECT * FROM user_data WHERE username = 'thaak' AND password = > PASSWORD('thaak'); >

RE: [PHP-DB] update and join?

> Quick questionis it possible to do an update query w/ a join yet? If > not, what is your preferred method? Would you take care of it on the PHP > side? Probably depends on your database, but MySQL doesn't support it. I think MySQL 4.0 might. > I need to update a table w/ data from another

Re: [PHP-DB] update and join?

Cory Hicks [mailto:[EMAIL PROTECTED]] wrote: > Hello to all! > > Quick questionis it possible to do an update query w/ a > join yet? If not, what is your preferred method? Would you > take care of it on the PHP side? No, it's not possible, at least not with MySQL 3.x. MySQL 4.1, currently i

RE: [PHP-DB] space in query

nevermind, stupid me, I got it working... -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 5:04 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] space in query forgive the basic question but how do I add a space in my query $result=mysql_

[PHP-DB] space in query

forgive the basic question but how do I add a space in my query $result=mysql_query("SELECT * from ".$dbname.".grades WHERE user_id=".$uid. " and subject=".$subject,$db); I need to force a space between $uid and 'and' and I don't think simply pressing the space bar does it. Thanks, Eddie

[PHP-DB] update and join?

Hello to all! Quick questionis it possible to do an update query w/ a join yet? If not, what is your preferred method? Would you take care of it on the PHP side? I need to update a table w/ data from another table if certain conditions are true, i.e the fields in the table to be joined are

[PHP-DB] Selecting PASSWORD() value in MySQL

Hello, I'm trying to retrieve data from a MySQL table which contains data encrypted with the MySQL "PASSWORD()" function from a PHP script but I can't seem to get it to work. Below is the query I'm trying: SELECT * FROM user_data WHERE username = 'thaak' AND password = PASSWORD('thaak'); I t

[PHP-DB] checkboxes names & values in mySQL (newbie)

I'm new at using PHP and mySQL, so please forgive my potentially naive question. I have a series of checkboxes with different values. The user can select any number of checkboxes, and I need to store this information in a mySQL table. 2 questions: Should I have a unique form name for each chec

[PHP-DB] sessions tutorial

Sorry, Michael, I meant to send this to the list, not just to you. I apologize. Hello all, I am a php newbie and am currently developing my first php page. My page will allow several people to log in at the same time sharing access to the mysql db. SO, I need to use sessions. Does anyone

Re: AW: [PHP-DB] OT...where do I go for this......?

This is what I have in my config file: # The following is for PHP4 (conficts with PHP/FI, below): # AddType application/x-httpd-php .php4 .php3 .phtml .php AddType application/x-httpd-php-source .phps # # The following is for PHP3: # AddType application/x-httpd-php3 .php3 AddType applica

AW: [PHP-DB] OT...where do I go for this......?

Have you checked apache's config file for: AddType application/x-httpd-php .php AddType application/x-httpd-php .php4 AddType application/x-httpd-php-source .phps ? IIRC Apache denies POST to file types not registered for... Also it may be possible that your OS upgrade has overwritten your (ol

RE: [PHP-DB] OT...where do I go for this......?

I just checked and register_globals are on in php.ini. I have also previously been in the httpd.conf in my previous attempts to fix this problem. I have googled my fingers off and all fixes have mentioned the conf file for apache. I have played with "options ExecCGI" as well as other opt

[PHP-DB] Problem after upgrading to PHP 4.2.3

I recently upgrade to PHP 4.2.3 and started having problems with one of my applications. I have a PHP application that interfaces to a MySQL DB (version 3.23) all running on an Apache web server (1.3) under Linux 7. Up until doing the upgrade, everything had been working fine. Now on a daily ba

RE: [PHP-DB] OT...where do I go for this......?

That would be an Apache configuration issue. Somewhere in http.conf, I think, you can choose whether or not to allow GET/POST operations. ---John Holmes... > -Original Message- > From: Michael Cortes [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 10:25 AM > To: [EMAIL PROT

[PHP-DB] OT...where do I go for this......?

I realize this is off topic, not php db interfacing. However, it is php and I am hoping someone can point me to a mailing list that would cover this question. So here goes I am working on a simple inventory program and am running into the following messageMethod Not Allowed Th

RE: [PHP-DB] Re: Multi-Table Insert and gettin' data from auto-inc coloumn in one to the other

No, you have to use two queries to do two inserts into different tables... ---John Holmes... > -Original Message- > From: Noodle Snacks [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 7:07 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: Multi-Table Insert and gettin' dat

RE: [PHP-DB] Error query : mysql_result

This usually means your query failed. Check for errors using mysql_error(). ---John Holmes... > -Original Message- > From: Burgess [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 5:14 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Error query : mysql_result > > Hi > > I h

[PHP-DB] Re: Multi-Table Insert and gettin' data from auto-inc coloumn in one to the other

I can get the previous insert auto-increment id via mysql_insert_id(). it will solve my problem. but if you know a soloution that will work in one query please share it with me/everyone! -- JJ Harrison [EMAIL PROTECTED] "Noodle Snacks" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">new

[PHP-DB] Multi-Table Insert and gettin' data from auto-inc coloumn in one to the other

I have table A with an auto increment coloumn called tid. during the same query I need to get that value and stick it in a related record in anouther table. I have two doubts. A: What is the way to do a multitable insert? guess is: INSERT INTO table(fields) VALUES (fields), table1(fields) VALUES

Re: [PHP-DB] Error query : mysql_result

Burgess [mailto:[EMAIL PROTECTED]] wrote: > Hi > > I have used the mysql_result function to return some specific > information > from database. The information is returned as it should but > I keep getting > this error message: > > Warning: Unable to jump to row 0 on MySQL result index 4 in

RE: [PHP-DB] Error query : mysql_result

would be nice if you would tell which line is 140 -Original Message- From: Burgess [mailto:[EMAIL PROTECTED]] Sent: donderdag 10 oktober 2002 11:14 To: [EMAIL PROTECTED] Subject: [PHP-DB] Error query : mysql_result Hi I have used the mysql_result function to return some specific info

[PHP-DB] Error query : mysql_result

Hi I have used the mysql_result function to return some specific information from database. The information is returned as it should but I keep getting this error message: Warning: Unable to jump to row 0 on MySQL result index 4 in /u1.bath/s31/eh842/public_html/SCR/register/process.php on line

Re: [PHP-DB] MySQL REGEXP functionality... any way to make this easier?

Hi, unfortunately i can't help you much, but listen you can make your pattern more readable if you delete "[]" there's no need for classes in your pattern SELECT * FROM ospd WHERE word REGEXP '^a?p?e?$|^a?e?p?$|^p?e?a?$|^p?a?e?$|^e?a?p?$|^e?p?a?$'; ? = one or none but if you need each letter th