Re: [PHP-DB] editing part of a field

through all the records and either use the MySQL function INSERT() or use some php code to replace what you need to replace, using UPDATE. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] editing part of a fiedl!

they are already in the database show up wrong. Is there a way to edit _part_ of the post. To fix the image url. Is there a mysql query I can use to edit where board/emotions with /emotions? Use an UPDATE query. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] pagination problem

=$prevbuscar=$buscar\Previous/anbsp;; NB you may want to urlencode() $buscar as well. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] download php headers?

I can go from there. How do I get http headers for somesite.com? I am doing the file method of getting the site currently. With some un*x system you can use: lynx -mime_header -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design

Re: [PHP-DB] Newbie file reading into MySQL

into something that can be read by fgetcsv() or parse_ini_file() would make things easier. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] php.ini

On Sunday 06 July 2003 00:13, frank wrote: i found that even i have not the php.ini in my SYSTEMROOT, php can still run ... why? For window XP, should it be placed in c:/WINDOWS? or any other ? If no php.ini is found then default values will be used. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Newbie file reading into MySQL

, a timestamp and a status (incomplete, pending, complete etc) [snip] Just one question: why are you storing text files containing DATA into a DB? Why not just store the data in the DB and do away with the text files? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

[PHP-DB] A complex query problem

of any school name starting with 'm' that has the highlights of 'Sports' and 'Graduation'. If you think you can help me, just email me at [EMAIL PROTECTED] If you need more information, let me know. Thank you, Jason Givhan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Re: A complex query problem

, school_name) 2. highlights (hID,highlight) 3. school_highlight_details (dID,sid,hid). Jason Givhan wrote: I have 3 tables: 1. school (sID, school_name) 2. highlights (hID,highlight) 3. school_highlight_details (dID,sid,hid). I have set up a search to allow the user to submit a school name

Re: [PHP-DB] hmmm

, then they would take more care of that message and may even actually read it for the useful info that it contains (like how to unsubscribe). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Getting data on last INSERTed row

the value of rows affected, i.e. 1 on any INSERT statement executed? Any ideas? Yeah, did it ever cross your mind to read the manual? mysql_insert_id() -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Rand() Emulation

... ORDER BY rand_col; I've not tried it myself so YMMV. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you

Re: [PHP-DB] md5 question!

get a 32 char hex string. Now how can a 32 byte string be converted back into a multi-gigabyte file (or whatever)? It is technically possible to create two different inputs which results in the same hash but the chances of that is very remote and hence why md5 is pretty secure. -- Jason Wong

Re: [PHP-DB] MySQL editor

to the mysql list where it belongs? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http

Re: [PHP-DB] Save mySQL data into a CSV file.

) or die(mysql_error()); Because $result_set is a resource id. Refer to the examples in the manual on how to get results from a db. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] re: PHP and MySQL

and php then install your own from source. That way you can mix and match your versions without having to rely on RH. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] PHP transfer variable question?????

confusion. Indeed ;-) -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http

Re: [PHP-DB] Select statement drops 10th digit during table lookup?

char(2) country_name varchar(50) Shouldn't you be using some INTEGER type instead of DOUBLE? An unsigned INT will just about handle it (2^32). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Execute a mySql sript file directly from PHP

script directly, without opening the file and go thru every line. You can try: upload file chmod so it is executable then exec() it from another php page May not work if your host has safe mode enabled. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] Way to update field thx Digital

which is of particular interest for people coming from an ASP background as the API is modelled on ADO. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Possible to store arrays in mySQL without explode()/implode()

be defined ? Any *TEXT field large enough to hold it. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you

Re: [PHP-DB] another redirecting question

' scripts to prevent any output. It is better to solve the problem at the places where you have control (at the server) rather than pass the problem onto places where you have no control (the user's browser). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] PHP/Mysql Script help.

formatted code that php doesn't even attempt to run. Check that each open , ', [, (, { has a corresponding closing counterpart and each of your php statements (~lines) are terminated with a semi-colon (;). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

[PHP-DB] PHP CLasses and DB Access

to use a dbconnect.php include in both classes to minimize administration. Unfortunately I cannot seem to get the include to work and I am wondering where to go from here. If any one has any suggestions I would be very appreciative. Thanks for the help, Jason -- PHP Database Mailing List (http

Re: [PHP-DB] Offering alternatives in typing mistakes

solution, like taking the middle? I've already put some thought in it, but I see no reason to reinvent the wheel again. Has anybody any better ideas? I'm open to solutions. If you're going to be running on some *nix platform then have a look at the chapter on pspell. -- Jason Wong - Gremlins

Re: [PHP-DB] Re-ordering items

to create a linked list. The fields will hold the previous and next records in the list I'll leave you to work out the implementation details. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

[PHP-DB] Re: sending a form feed to a printer

form feeds don't work in html. It is interpreted as a space. Arthur Chevalier wrote: Hello, I am having problems getting the \f (form feed) expression to work. After a certain amount of lines print I want to start printing the next line on a new sheet of paper. Any ideas of what I could be

[PHP-DB] LDAP using login form

Could someone point me to an example script using ldap authentication but where logins are entered through a form rather than an http pop-up challenge. I can only find exmaples of the latter, and I'm not sure how to keep the user logged in with the former. thanks, J

Re: [PHP-DB] Php Thumbnail Gallery

a bundled GD library there may not be much incentive for people write one. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

Re: [PHP-DB] MySql, PHP, and Dates

On Sunday 30 March 2003 11:11, Bruce Feist wrote: I wonder why the PHP/MySql interface doesn't simply return dates as dates instead of strings. *frowns* How do you mean? PHP doesn't have a date type. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] PHP and MySQL 4

On Monday 31 March 2003 04:46, Benjamin Higgins wrote: Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP with --with-mysql, is that sufficient to get MySQL 4 support? Yes. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators

Re: [PHP-DB] An interesting Apache Log to MySql ?

On Saturday 29 March 2003 22:25, Dave Carrera wrote: I have been trying to find a way to write Apache Log data to a MySql db via a pipe log directive. Search the archives, a solution was presented in the past few days. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] Setting up arrays from queries

, UPDATE, DELETE queries 3) If you want an associated array use mysql_fetch_assoc() -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] mail() function

webserver) then leave it as 'localhost'. Otherwise do what I originally suggested and use an upstream SMTP server (probably provided by your ISP). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] mail() function

sadflkjaflkasdj; } 1) Check that php.ini is correctly configured 2) Check the php error log 3) Check your mailserver log -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] mail() function

in sending mail :) If you're running on some Windows system you can try specifying the SMTP server provided by your ISP. Otherwise google is your friend. If you're running some *nix system then they usually come with the ubiquitous sendmail. -- Jason Wong - Gremlins Associates

[PHP-DB] Interlacing two separate mysql queries

I'm trying to interlace the results from a left-join query with a regular select result. I have two tables: Aplications and States (state as in: the states of Florida and California). Each aplication in the Aplications table contains a state_id, which matches an id of a state in the States table.

Re: [PHP-DB] transfer files that doesent exists

know how to do that ?? If i did'nt explain right please let me know You can have tar _extract_ an archive onto stdout. But I don't think you can _create_ an archive and have it go to stdout. So you would _have_ to create a temporary file and delete it when you're finished with it. -- Jason

RE: [PHP-DB] Problem with passing variables in PHP

I am sure someone else will beat me to this but here is an example update.php --- ?php echo html\n; echo body\n; //add this to assign POST to a variable you can use on this page $sname=$_POST[sname] //that will give you an idea of what to do if (isset($sname)) {

RE: [PHP-DB] newsletter optimization help needed

Jason -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 11:41 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] newsletter optimization help needed Hi there Everyone, Below is some code I use to send a newsletter to clients subscribed on my mailing

Re: [PHP-DB] newsletter optimization help needed

. but for the life of me I can't think straight right now :-( The easiest method is to stick them all into an array then implode them using a comma as the delimiter. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

RE: [PHP-DB] newsletter optimization help needed

of 1 or 2 to email it to a few test email accounts (hotmail or whatever) and see if it all works. I stress this as I may have accidently at one time in the past tried a test similar to yours with live data. Needless to say our exchange admin was a bit unhappy. Jason -Original Message- From

Re: Fwd: Re: [PHP-DB] need help with foreach()

. } $query = SELECT * FROM Rota WHERE date = $start and date = ($start + INTERVAL 6 DAY) ; $result = mysql_query($query); while ($row = mysql_fetch_array($result)){ $date = $row[Date]; Again, see above comments. -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] PHP to mysql to email

that the email bounced email matches? Search archives (php-general) for mail bounce or mailing list bounce or similar. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] need help with foreach()

you're at it do a var_dump($tips) as well. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post

[PHP-DB] mysql delete loop

displayexpt.php?softID=$softID displays a checkbox list of experts for a given piece of software. The admin needs to select each user he wants to delete. This is then posted to deleteexpt.php?softID=$softID, which must delete users from the apliexpert table with a statement like this: DELETE FROM

RE: [PHP-DB] mysql delete loop (SOLVED)

to print it into the loop so try first: echo $sql2br; and you'll see that there is a mistake somewhere i guess... did you check hhow often he goes trhough the loop? -Original Message- From: Jason End [mailto:[EMAIL PROTECTED] Sent: vrijdag 7 maart 2003 11:53 To: [EMAIL

[PHP-DB] mysql statement: two tables, two comparisons

I'm looking for a mysql select statement that does the following: - Check if the value of each expert.id on the table experts matches a value expt.id in the table apliexpert. - For those values where this is true check whether the softID value for that row matches the variable $softId. - return

Re: [PHP-DB] data insert in textfile

On Friday 07 March 2003 13:59, Ramesh PAtel wrote: I am working on PHP and PostgreSQL. I want to insert output of my Query in textfile. so how to open file and insert data one by one in textfile. fwrite(), see manual for details and example. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] php and local printing

file which on server I can print using lp filename. Similar thing but without any print dialogue box at the client end. Exactly, this is a client-side problem (Javascript, ActiveX/script, etc). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web

Re: [PHP-DB] A-Z Listings

On Tuesday 18 February 2003 05:46, Andy wrote: Hi There., I have a script that lists directorys then how many files are in each. although it won't list in an A-Z format, would anyone know how i would do this? Read all the filenames into an array then use asort(). -- Jason Wong - Gremlins

[PHP-DB] Using results from one mysql query to make another

I have a table that includes the ids of software aplications and experts (apliexperts). My page is loaded with the variable of the software id (softid), which it uses to match the experts for that software. But instead of returning just the expert id (expid), to use that expid to get the full row

Re: [PHP-DB] Update errors

near 'WHERE cat_id = 2 ' at line 4 Db : mysql -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post

Re: [PHP-DB] Multiple select box using mysql

rather than an array, and you could remove the [] from the SELECT form element for the software. Please check all code, as it's off the top of my head, and not verified at all. --- Jason End [EMAIL PROTECTED] wrote: But how do I populate the array with (for e.g.) 2 fields from a mysql

Re: [PHP-DB] Array key problem

in the array named something the code will print the key 0 PHP is doing automatic type conversion for you. Use: if ($key === something { ... } instead. See manual for details. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Multiple select box using mysql

the Mutli select box a name as an array. eg: SELECT NAME=experts[] MULTIPLE SIZE=5 OPTION VALUE=key1val1/OPTION /SELECT then in PHP, you can access $experts as an array. while (list ($key, $val) = each($experts)) { print $key = $valBR\n; } Jason End wrote: I writing a software

Re: [PHP-DB] Checkboxes to gather rows to delete

the space or has extremely high turnover of deleted records, this makes sesne. Better still, setup parallel tables and move deleted records over. That way you'll save cluttering up the main tables. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web

Re: [PHP-DB] problem in PHP with ADODB connection, Microsoft JET Database

. - The error is quite explicit: Syntax error in FROM clause So unless the Jet Engine is lying or is buggy then you have an incorrectly formed query. can anyone help me? Nobody can help you unless you post your query. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software

Re: [PHP-DB] Submitted information not being displayed

]); $Array[id_num] = trim ($Array[id_num]); $Array[Email] = trim ($Array[Email]); Use print_r($_POST) to show all the values POSTed from your form. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Auto Generation of HTML Forms + SQL Code to update My/Postgre SQL Database

products etc... I'm trying to quicken my development cycle. freshmeat.net and search for mysql forms -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

[PHP-DB] Multiple select box using mysql

I writing a software catalog that features experts, who a people especially skilled in a piece of software. My db, has a software table and an experts table. I need to have a page that generates 2 multiple select boxes, each on with the data from each table. From there one will be able to choose

Re: [PHP-DB] [Import text file]

the question. Real email clients gives you multiple response methods -- reply to sender; reply to list; reply to all; bounce; redirect etc -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] crypt help

On Thursday 13 February 2003 04:33, Zach Davis wrote: However, I've noticed that if anything past the 8th character in the password is irrelevant. That is clearly explained in the manual. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web

Re: [PHP-DB] Using CURDATE, DATE_SUB and DATE_ADD

you expect them to contain. And also you could consider using BETWEEN instead of the less-than and greater-than comparisons. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Is my Hosting service full of it?

run a monitor while testing your code locally, you'll be able to pinpoint precisely what causes the recources to be chewed up. There is something called mysqltop. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] access mysql db with DW

hp?email=.HTTP_POST_VARS[email].; should be $insertGoTo = booking_details.php?email=$HTTP_POST_VARS[email].; For people wondering _why_ it works like a charm the correct statement should in fact be: $insertGoTo = booking_details.php?email=.$HTTP_POST_VARS[email].; -- Jason Wong - Gremlins As

Re: [PHP-DB] foreach problem

foreach database query.); } $event_date is an array with several dates separated by commas. (2003-10-02, 2003-10-03). The code above successfuly inserts the first dae in the array, but none of the others... am I missing something? Any error messages? If so what does mysql_error() say? -- Jason

Re: [PHP-DB] foreach problem

is an array with several dates separated by commas. (2003-10-02, 2003-10-03). The code above successfuly inserts the first Could you explain what exactly $event_date contains? The output of print_r($event_date) would suffice. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] Getting array values into a query

the values I want in the session through a query on the previous script and call it directly to the function I want to use? Please post your code. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] vaiable from one page to another

of the variable in another php program. butit is not getting. one our friend told to put like echo $_post(fname) but it is also not working. now getting the error about post array. so what to do. manual A simple tutorial manual Variables Variables from outside PHP -- Jason Wong - Gremlins

Re: [PHP-DB] Argh ! array help required :(

)) { $prod_search .= ,; } } $prod_search .= ); Can anyone see where I am going wrong? $doo = array('dah', 'dee', 'dib'); $doo = in (' . implode(', ', $doo) . '); echo $doo; -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] Storing iterated results into various variables

with HTMLs (kind of template) and by means of Php tags I can echo these variables where needed. What exactly are you having problems with? What is your code so far? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] How activate the support for MySQL?

for Call to undefined function mysql_connect will probably cover all the common cases. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

RE: [PHP-DB] matching data from one table with another and displaying results?

Seek out LEFT JOIN on mysql web site, thats what you want. Cheers Jason -Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 10:43 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] matching data from one table with another and displaying results

Re: [PHP-DB] UPDATE doesn't work

-- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db

Re: [PHP-DB] inserting datas through table

On Wednesday 05 February 2003 15:03, kumar wrote: (B (B I have created reservation table i need to store all the values in (B database when i click the submit button (B but it couldn`t working. (B (BCould you give a detailed description of HOW it isn't working? (B (BWhat did you

Re: [PHP-DB] Help!

for the function in question to see which configure option/switch you need to compile that function into PHP. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] variable conversion

that value i did like: ?php echo($fname); ? where fname is the text box name of the previos page. but it is not coming. what should i do. help me.. Have you tried reading the manual? The chapter A simple tutorial? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] - Update help

with 4.0.6 you really should be using a newer version. If you really do need 4.0.6 then check the archives on how to use the patch. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] Is there a Php MySql Scripting Tool or Gui ??

on this project. http://freshmeat.net search for mysql forms -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you

Re: [PHP-DB] check box help

trying for hours. You mentioned printing out Globals or something. I am relatively new to this, so I don't really know how to do that. I would really appreciate more help. Thanks. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design

RE: [PHP-DB] login script

try: http://www.hotscripts.com/PHP/Scripts_and_Programs/User_Authentication/ there are loads of pre done scripts you can reference. Cheers Jason -Original Message- From: Matt [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 11:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] login

Re: [PHP-DB] SQL: Limit 1 usage?

- Original Message - From: jason wesley upton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 9:42 PM Subject: [PHP-DB] SQL: Limit 1 usage? Currently I have a script that contains this piece of code: $sql = SELECT MIN(network

Re: [PHP-DB] check box help

That should be: ... name='CheckBox[$counter]' ... -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* 1 1 was a race-horse, 2 2 was 1 2. When 1 1 1 1 race, 2 2 1 1 2. */ -- PHP

Re: [PHP-DB] upload time out

files then things will fly Remember HTTP uploads doesn't allow you to resume transfer. Thus if a file was 99% uploaded and an error occurs you have a very unhappy user ;-) -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] really stumped!

someone else's code. There are plenty of classes at www.phpclasses.org which builds and verifies forms for you. Also searching freshmeat.net for mysql forms should be rewarding. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

inspection so that whatever port was used to initiate the connection with mysql should be allowed through. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* We're all

RE: [PHP-DB] Help with converting data type from Database in PHP

I think I remember something about pack and unpack working with aunti endian, uncle endian and all the little endians. Jason -Original Message- From: Robert Trembath [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 9:02 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP

Re: [PHP-DB] empty query

of a button and Submit Your Ad is it's value? As it is part of the form and you're programmatically (or indiscriminately) extracting everything from $_POST (or equivalent) then that is why you end up with it. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] dates and updates recommendation?

date functions). If your date stuff will mostly be done in PHP then use unix timestamps. On the whole I would stick to a DBMS native date format because: - it's human readable - built-in date functions - not limited to post epoch dates -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] empty query

the contents of $formdata into your database. If that code is properly written then the presence (or otherwise) of next_ should not affect its operation. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] empty query

$formdata is empty?? If it is, where are you getting $formdata from? [snip] $result = mysql_query($query) or die (Couldn't execute query.); Don't use die(), use: $result = mysql_query($query) or echo Couldn't execute query. . mysql_error(); -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Array trouble

. Considering all of the columns exist, I think the problem just has to do with how I am pulling the array values out and placing them into their column. Any help would be appreciated. Thanks in advance, Please post your code and DB schema. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] While + Function

) { do_insert_row; } while ($row = mysql_fetch_array($result)) { insert_results($row); } -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Joe's sister puts spaghetti

Re: [PHP-DB] posting field_DATE variables

to do this. One is: $date = explode('-', '10-01-2003'); $newdate = $date[2] . $date[0] . $date[1]; -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* To err is humor

Re: [PHP-DB] Array Issue help please

describe in more detail how your code doesn't behave the way you expected it to behave? So do you see anything at all? What exactly does it do? Error messages? Have you checked the logs? Have you tried echo() on the important variables to see what they contain? -- Jason Wong - Gremlins

Re: [PHP-DB] Getting all rows of a certain column when grouping?

that smileys associated with the same image are displayed on the same row. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* I'm not the person your mother warned you about... her

Re: [PHP-DB] [NB] Mail() question

); if ($result) echo mail sent; } It always print mail sent, but I never got the email. So I was wondering if Mail() request any send mail program to work. Is it a windows server that you're using? SMTP only works for windows. Anything else uses sendmail or equivalent. -- Jason Wong

Re: [PHP-DB] Date math functions...

. Any more ideas? Which probably means your $StopDate is 0. What does it actually contain? You really should assign your query to some variable ($query) THEN plug it into your query function. If and you have any problems you can echo $query to see what you're passing to mysql. -- Jason Wong

Re: [PHP-DB] Slashed being added..

options in php.ini. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Don't SANFORIZE me!! */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

<    1   2   3   4   5   6   7   8   9   >