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

On Saturday 08 June 2002 23:20, Garrett Nelson wrote: I have both the lines in httpd.conf. As I said, PHP is working fine, it's just an issue with MySQL support I believe. Sorry my mistake. Check in php.ini for this line: extension=mysql.so -- Jason Wong - Gremlins Associates

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

library './mysql.so' - ./mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0 Does that help at all in identifying what may be wrong? In php.ini check/add the line extension_dir = /path/to/directory/containing-mysql.so -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Fw: PHP amd MYSQL

dealing with result tables. Can anyone please tell me what the problem is. Basically as it stands, $result is a pointer to a set of results returned from the DB. To get at the actual results themselves you need to run mysql_fetch_array() (or similar, see manual). -- Jason Wong - Gremlins

Re: [PHP-DB] Unique SQL query?????????????

to create an index of all the different categories. SELECT DISTINCT category FROM products -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Ocean: A body of water occupying

Re: [PHP-DB] no subject

an AppleScript question, post on the AppleScript list (assuming there is one). -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* share, n.: To give in, endure

Re: [PHP-DB] Deleting old sess_... files from /tmp dir

. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* One seldom sees a monument to a committee. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Re: mysql_fetch_array pointer

a pointer. Is there a way to reset the pointer so I can reuse a query? Regards, Jeffrey Barendse WireITup -- Jason Morehouse ([EMAIL PROTECTED]) Netconcepts LTD - Auckland, New Zealand * Linux: Because rebooting is for adding hardware. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] random

number that will be generating randomly. I don't have any problem displaying the MM/DD and the three numbers, but I don't know how to get the first three characters. substr() -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting

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

to display stuff inside a textarea is: textareasome stuff here/textarea -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Second-sytem effect. */ -- PHP Database Mailing

[PHP-DB] permissions system

IN ('Approved', 'Pending'). Does this make sense? How are other people doing things? I've given a little bit of thought to it, but not enough. With all the applications out there everyone at some point has to come up with their own system. Ideas? Thanks, Jason = Just Another Fu@#in' Adventure http

Re: [PHP-DB] Insert images into blob field in MySQL

? Because i think the max size for a blob field is 16 Mb. Reading the manual is better than thinking. BLOB = 64K MEDIUMBLOB = 16MB LONGBLOB = 4GB -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] foreach

Kupernik [EMAIL PROTECTED] wrote: and I'm getting this: Warning: Invalid argument supplied for foreach() Why is that? are you sure $cart is an array ? Try: print $cart; // would show 'Array' if array Are you trying to use this in a function? If so have you declared it global? -- Ja

Re: [PHP-DB] new pair of eyes

[WHERE ...] thus there is no need for user_id, f_name etc. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* The number of licorice gumballs you get out of a gumball machine

Re: [PHP-DB] how to pull array out?

repeat, mysql_query() returns a resource-id which you need to feed into mysql_fetch_array() to get the actual record. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* The chief

Re: Re[2]: [PHP-DB] how to pull array out?

. You'll save yourself a lot of grief in the long run. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* You are deeply attached to your friends and acquaintances

Re: [PHP-DB] Arrays

everything in a single array then serialize() it and store (in a single field). -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* If he had only learnt a little less, how infinitely

Re: [PHP-DB] REGEX help.

out here.. but I'm struggling with SQL REGEX and there just aren't as many good examples out there as there are for PHP. The MySQL manual wasn't much help that's for sure. :-\ It doesn't seem possible. The MySQL REGEXP only returns a 1 or 0 to indicate a match or no match. -- Jason Wong

Re: [PHP-DB] Resource ID#2 ????

into my form boxes, all I get is a Resource ID #2. Not sure how I can over come this... $table = auth_users; $record = mysql_query(SELECT * FROM $table WHERE user_id = '$user_id',$dbh); Make liberal use of error checking (see manual) and mysql_error(). -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Resource ID#2 ????

) to actually retrieve records. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* 1: No code table for op: ++post */ -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Error? new set of eyes...

`T_VARIABLE' or `'$'' in /localhost/portfolio.php on line 169 Any help would be great!! Variable names cannot start with a digit. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] INSERT problem - please help!

. The one which isn't working would probably have register_globals set to Off. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Don't kid yourself. Little is relevant

Re: [PHP-DB] Re: how can i get field-informationof a table?

problem is i cannot find a function which gives me an array of the fields of a table - fieldarray[$index] I guess this is for sure very simple - haves anyone the solution? i would -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * We

Re: [PHP-DB] php.ini Question

to disk until the whole file has been transferred. Thus you may find that you need to increase memory_limit as well. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Date

) ... The t_stellen_date field is a date field ! Ok, we can hear you loud and clear, no need for the exclamation marks :) -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Date

My guess is that you've a missing ')' or an extra '(' somewhere. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* It looks like blind screaming hedonism won out

Re: [PHP-DB] Problem with mysql_num_rows

If that is the start of your code then the obvious mistake is that there is no code to connect to mysql and initialise the connection etc. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] problems 'adding' to MySQL DBs

code as follows: submitform.php: html body ? php mysql_connect(localhost, test, testpw); mysql_select_db(testdb); msyql_query(insert into firsttab (first_name, last_name) values ('$first_name', '$last_name')); Add some error checking code and use mysql_error(). -- Jason Wong - Gremlins

Re: [PHP-DB] last 10

criteria can apply to? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* The data on your hard drive is out of balance. */ -- PHP Database Mailing List (http

Re: [PHP-DB] DROP tables with prefix match

the tables. If you're using MyISAM tables then each table is held in 3 files -- table.frm, table.MYD, table.MYI *** WARNING *** I've not tried this before. It may be a good idea to backup your data first :) *** WARNING *** -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source

[PHP-DB] Re: Easy one for you guru's :-)

are very much appreciated. Thank you fully in advance for any help you may give. Dave C -- .--- .- ... --- -. / -- --- .-. . --- ..- ... . Jason Morehouse [EMAIL PROTECTED] Netconcepts LTD Auckland, New Zealand - Linux: because rebooting is for adding hardware

Re: [PHP-DB] Client IP

??? If someone connects through a proxy then you might be able to use $HTTP_X_FORWARDED_FOR, but that depends on whether the proxy gives that info. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] Syncing two tables in mysql

On Sunday 12 May 2002 13:37, Thomas \omega\ Henning wrote: And how can i use it? I suppose the manual will have full details. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] problem with grant

. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Let me do my TRIBUTE to FISHNET STOCKINGS ... */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] problem with grant

On Saturday 11 May 2002 21:37, andy wrote: can you send me the link for the english mysql user group, please. I did search a while for this link on mysql.com but did not find any. I can't believe you have searched very hard :) google - mysql mailing list -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Syncing two tables in mysql

On Sunday 12 May 2002 01:34, Thomas \omega\ Henning wrote: Hey all, Is there a way i can sync two tables in mysql on two totaly different servers over the internet via php4 or mysql? I'm using php4.0.6 mysql has it's own replication mechanism. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Does mysql_connect() perform password encryption?

) -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Darth Vader! Only you would be so bold! -- Princess Leia Organa */ -- PHP Database Mailing List (http

Re: [PHP-DB] selecting records on a random basis with mysql function rand possible?

results and do the random thing with php, but this does take forever (doing it for a couple of times) Try (won't work on older versions of mysql) SELECT something, or_another FROM table ORDER BY RAND() LIMIT 1; -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software

Re: [PHP-DB] query error

', '$status'); mysql_query ($query, $conn); mysql_close($conn); ? why the argument isn't valid? how to solve this problem? Find out why by putting in some error checking code. See examples in manual and check out mysql_error(). -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open

Re: [PHP-DB] sorting tables

on every month column? Try incorporating a DISTINCT somewhere in your SELECT. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Question about Load Data to mysql through php

in response to your earlier post. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Cohen's Law: There is no bottom to worse. */ -- PHP Database Mailing List (http

Re: [PHP-DB] Question about Load Data to mysql through php

On Tuesday 30 April 2002 16:56, Jack wrote: Dear Jason Thx for the reply, but do you know where i should copy that file to in serverside? is it got to be the same directory of mysql? It doesn't matter where as long as it is readable by the process running PHP (ie the process running your

[PHP-DB] MySQL auto-increment problems

I have approx 160 rows in a table with an ID column set to auto increment. I have not changed anything suddenly one day the auto increment went from 162 to 2,145,694,203 I am running a Win 2000 box with IIS 5. any ideas? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

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

for the foreign key Hope this helps and let me know if you have any other questions. Jason J. Wharton [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I encountered something similar. Here is a snippet of code: $tdate=date(Y\\-m\\-d); $time=date(G\\:i\\:s);

Re: [PHP-DB] Changing from Windows to Linux

the performance of the application on the final /production/ server then I can't see how the /development/ OS will affect it. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Cynic

Re: [PHP-DB] Couldn't Unsubscribe

to be an apology for those who still don't read the messages that do have it, or don't bother to check php.net. What amazes me is that people have the intelligence to subscribe but seem to be lacking it somewhat when it comes to unsubscribing ;-) -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Getting data from a page which isn't a form

, or /make/ them a part of a form. That is, store your variables as hidden elements. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Honi soit qui mal y pense. [Evil

Re: [PHP-DB] conroling url variable when reading csv file

but it doesnot work propery as i expect *How* didn't it work properly? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* You have an unusual understanding of the problems of human

Re: [PHP-DB] selected problem

i do this?? Mark it as selected like above. OPTION selected value=Alexandria ... Look up a decent HTML reference. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Append into another table

On Friday 26 April 2002 09:14, Rosen Marinov wrote: Hi, how can I append from one table to another with same structure some selected records RTFM for the database you're using. If you still have problems, post to the database's list or to the php-db list. -- Jason Wong - Gremlins

Re: [PHP-DB] Couldn't Unsubscribe

the at the bottom of every post? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Confirmed bachelor: A man who goes through life without a hitch. */ -- PHP Database

Re: [PHP-DB] Update/Insert

else execute the update statement. I don't know if it is possible to do it in PHP. if ... else is certainly available in PHP. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Question about PHP Arrays syntax

to reference the fields using: $value_of_field_0 = $line[0]; Remember the manual is your friend. If you haven't already done so, download a copy (it's available in various formats) and make use of it! -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators

Re: [PHP-DB] Re: Retrieve information from mutiple tables

what it actually contains? If it looks valid try copy-paste that query into the mysql command-line to see what comes up. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Passing on an ID

to update the database. At this stage I would like to give tthe opportunity to email the comments back to the writer. I am having difficulty passing on the ID of the story to the feedback page. Can someone help please. What is the difficulty you're having? -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Re: Retrieve information from mutiple tables

...) (SELECT NickName FROM User WHERE...) Is it possible to combine those two statements? Try: SELECT Rights.UserID, User.NickName FROM Rights, User WHERE User.UserID = Rights.UserID -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web

Re: [PHP-DB] Connection error

the line: mysql_connect('server','name','pass') or die (Error) the sistem works. What's the problem ? Always check for errors. Use mysql_error() to see what the error is. Also try connecting to mysql from the shell/command-line. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Adding up the RESULT

products; i have also posted this question in mailing.database.mysql but the traffic in that group has been too light... and posted to alt.php.sql but i will take any suggestions from any group on this one... How about the MySQL mailing list? -- Jason Wong - Gremlins Associates

Re: [PHP-DB] PHP to Fax

On Wednesday 17 April 2002 00:36, Jonathan Hilgeman wrote: #2 Does anyone know about fax servers or how to obtain one? If using *nix then www.hylafax.org. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet

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

, better to use underscores -- How_Are_You. 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(). I second this! -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Delete from mysql table is there a way to....

fragmenting the db? No. If you do a lot of deletes then you can optimize the table now and again to ensure maximum performance. See MySQL for details. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Advice for dataupload

with phpmyadmin? Have you actually installed it yet? It's pretty straightforward and self-explanatory. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Your best consolation is the hope

Re: [PHP-DB] help! i don't know anything!

words, what is the best way to display a specific field value in php? are there specific functions? anyone have a good coded example they can just shoot my way? Links section on PHP website. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web

Re: [PHP-DB] undefined function

On Wednesday 10 April 2002 00:12, Nick wrote: Hi: thank you for you e mail I am using redhat7.2 I am new to php and linux , do not know how to configure mysql into php Install: php-mysql-4.0.6-7.i386.rpm it's on the second disc. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Re: executing cgi

could, but I'll just point you to the manual and the Program Execution functions. For being OT. Mind turning word wrap on, please? And if you want further info, this was discussed at some length on the php-general list just last week. Search the archives. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] If statement for sql statement

; else $sql = UPDATE $table_name SET image01_t = \$files\; Am I missing something? Psuedo-code: if ($file_name != '--') { $sql = UPDATE ; $result = $mysql_query($sql); etc; etc; } else { don't even need an else! } -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Re: htaccess quick ?

On Monday 08 April 2002 18:55, David Robley wrote: This is rather out of the scope of php_db, no? But you need something like Unfortunately people take advantage of the good-natured people on this list who answer off-topic questions such as this. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Regular Expressions

this code but it's not working. I couldn't find what the problem is. I'll be glad if anybody help me. 1) What is your regex supposed to do? 2) HOW doesn't it work? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] Advice for dataupload

name_of_database | mysql --compress -h remote.mysql.host name_of_database 2) Dump from local mysql and compress to file: mysqldump --opt name_of_db | gzip name_of_db.gz Then ftp to remote, decompress and import. 3) Install phpMyAdmin on both machines. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] oracle php abstraction layer

/ADODB Or look in: http://www.phpclasses.com -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* A Smith Wesson beats four aces. */ -- PHP Database Mailing List (http

Re: [PHP-DB] Session problem?

); } } -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* I remember when legal used to mean lawful, now it means some kind of loophole. -- Leo Kessler */ -- PHP

Re: [PHP-DB] PHP Logon Script Help....

message. Can anyone help? Which bit are you stuck on? To redirect to a different page use the header() function. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Lisp, Lisp

Re: [PHP-DB] PHP Logon Script Help....

but the manual suggests using OCIResult(). Read and 'try' the examples in the manual. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Schizophrenia beats being alone

Re: [PHP-DB] Cosmetics

: $TIMER_END = explode( , microtime()); $TIMER_END = $TIMER_END[1] + $TIMER_END[0]; echo br, $TIMER_END - $TIMER_START, secs; -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Wouldn't this be a great world if being insecure and desperate were a turn-on? -- Broadcast News

[PHP-DB] New to PHP Need Help

I am trying to define variables through an anchor tag to retrive data from MySQL, When the script runs it displays Array. I am running WIN2K and IIS 5 echo a href=location.php?location=2Camp Street Cafe/a; Here is the script that is called. ?php $db = mysql_connect(localhost, , ) or die

Re: [PHP-DB] Forms and mysql

in the archives: http://marc.theaimsgroup.com/?l=php-db -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* If Love Were Oil, I'd Be About A Quart Low -- Book title by Lewis Grizzard */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] viewing records

really. Without knowing what your authentication scheme is we can't really comment on how secure it is. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* I'd love to go out with you, but the last time I went out, I never came back. */ -- PHP Database Mailing List (http

Re: [PHP-DB] Forms and mysql

. $return[quantity] was holding a quantity when in your form, now it's being assigned a query ?? $result=mysql_query($db[quantity]); Is $db[quantity] meant to be $return[quantity] ? Or vice-versa? Or is it a typo? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Why must you tell me

Re: [PHP-DB] Pop up are you sure...

On Tuesday 02 April 2002 01:30, Jonathan Hilgeman wrote: You're so negative, Jason. :) No, my answer was just short and to the point ;-) Long answer, Dave, it wouldn't be wise to do this via Javascript. My long answer was going to be: it's possible to do it in PHP, but then it would

Re: [PHP-DB] thanks

On Sunday 31 March 2002 23:05, Matthew Crouch wrote: i think i got this solved; sorry about the non-php question but there isn't a mysql newsgroup that i know of. www.mysql.com ?? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* I don't want people to love me. It makes

Re: [PHP-DB] Re - Direct a User after a completed Form

a form which loads data to my data table. Works great. Is there a way to allow the user to go to a thank you after the form is completed. Where could I find this is the manual. Tried Location() with little success. I can't find a function called Location(). Try header(). -- Jason Wong

Re: [PHP-DB] How to lock the entire db?

. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* The magic of our first love is our ignorance that it can ever end. -- Benjamin Disraeli */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Probably a stupid Array question

point of using arrays is to simplify the handling of multiple 'related' variables. In the above example you would simply refer to the first word as $words[0], the second as $words[1] etc. If you really want to do $word1, $word2 ..., then read about: Variable Variables foreach -- Jason Wong

Re: [PHP-DB] Images on MySQL

On Thursday 28 March 2002 19:35, Clever wrote: Hi, I'm designing a site and I have to store a lot of images. Which is the best for speed? 1) Store all images on a MySQL table? 2) Save them on disk like normal files and only have pointers to them on the database? 2) -- Jason Wong

Re: [PHP-DB] Problem with PHP connectivity with mySQL (RedHat package)

. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* The only difference in the game of love over the last few thousand years is that they've changed trumps from clubs to diamonds. -- The Indianapolis Star */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Uploading a file

name=action value=Upload! /form -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* I don't want people to love me. It makes for obligations. -- Jean Anouilh */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL/PHP Update

the update only for sku equally with the string '$prod'... I'm afraid that is incorrect. Try it for yourself: ? $doo = 'dah'; echo Doo is '$doo'; ? His problem lies elsewhere. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Nature abhors a virgin -- a frozen asset

RE: [PHP-DB] MySQL/PHP Update

Actually... this turned out to be something totally unrelated. Thanks for all the interest tho. Missing little things like variable spelling is why you shouldn't code for 18 hours straight. Jason Cathcart Check Out My Site: http://www.biohazardous.org -Original Message- From: Rick

[PHP-DB] MySQL/PHP Update

I'm trying to update my MySQL database, but it doesn't seem to be taking. my code is: mysql_query(update prod_list set prod_manu=$prod_man where sku='$prod'); where prod_manu is an int $prod_man is an int sku is a varchar $prod is text mysql_query() comes back successful, and

Re: [PHP-DB] include() statement hell!

o change the httpd.conf file then just use ini_set() at the beginning of all your php files to specify an include path. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Support wildlife -- vote for an orgy. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, vis

Re: [PHP-DB] storing PDF in a database

You'd want to use a BLOB field to store it. It would be stored as raw data in the db. For an example, go find a tutorial on how to store images in the database. It would work the same way. Jason Cox - Original Message - From: Alain DESEINE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

[PHP-DB] Need Help with returning new id's

to get the desired results but have been unsuccessful. Any help would be greatly appreciated. Thanks, Jason -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] textarea and mysql query

then you're missing the important step of connecting to the mysql server and selecting a database. Have a look at the examples in the manual. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Most people don't need a great deal of love nearly so much as they need a steady supply

Re: [PHP-DB] textarea and mysql query

On Monday 18 March 2002 15:09, jas wrote: Sorry, the connection is established already so that part works just fine. It is getting the results of said connection \ query to appear in a textarea vs. a text line. Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED

Re: [PHP-DB] passing array through $PHP_SELF

then pass it along in a hidden form element. Or you can use cookies (sessions). -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Why must you tell me all your secrets when it's hard enough to love you knowing nothing? -- Lloyd Cole and the Commotions */ -- PHP

Re: [PHP-DB] SQL statement - PHP/mySQL - brain fart

thinking that I'm just looking at the the wrong way.] SELECT sc.* FROM site_category sc WHERE sc.category_id = $category_id_1 AND sc.category_id = $category_id_2 Or am I missing something? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Let's just be friends and make

Re: [PHP-DB] increase date()

On Sunday 17 March 2002 14:28, its me wrote: i have: $nowdate=date(Y-m-d); and i want to increase it by 6 months,how can i do that?? Look at the examples in the manual for date(). -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* True happiness will be found only in true love

Re: [PHP-DB] Date Returns

/2002 3/15/2002 and so on and so forth. The field actually requests a dd/mm/yy format, but you know how people follow instructions. checkdate() -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Absence in love is like water upon fire; a little quickens, but much extinguishes

Re: [PHP-DB] Creating an array of mySQL results with PHP

parent_id = \$parent_id\ AND student_id = \$student_id\ AND week_no = \$week_no\ ; # end create sql query You can use: classroom = '$classroom', homework = '$homework', to make the code more readable. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* All the passions make us

Re: Re(2): Re(2): Re(2): [PHP-DB] Fatal Error using mysql_connect()

reason why you want to use the headers and libs that come with mysql, then I suggest you just use the ones that come with PHP. Thus: --with-mysql would (should) work. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Falling in love is a lot like dying. You never get to do

Re: Re(2): [PHP-DB] Fatal Error using mysql_connect()

/lib/mysql Try: -with-mysql=/usr -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Absence diminishes mediocre passions and increases great ones, as the wind blows out candles and fans fires. -- La Rochefoucauld */ -- PHP Database Mailing List (http

<    2   3   4   5   6   7   8   9   >