Re: [PHP-DB] adding a mysql query as text into a history table... ?

', date_modified = '-00-00 00:00:00', date_closed =' at line 6 You'll need to escape the string containing the query before you can insert it. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] Erroneous date and time

. But that was actually submitted at 11:24 AM, not PM. So, that's my code. Any suggestions?? Try gmdate() and see whether that gives the expected result. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] compile 4.3.6

update another machine with PHP 4.3.5 with GD / Fink and it work perfectly. Anyone have any ideas? It's only interesting if both machines have the exact same configuration. Otherwise find out what the difference is to figure out why one is working and the other not. -- Jason Wong - Gremlins

Re: [PHP-DB] Link to do query

like this: http://mydomain.com/profile.php?user=blah ... so just construct your links in a similar manner. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

[PHP-DB] Re: postgresql

if i remember correctly you have to do this su su postgres createuser your-user-id Adam Williams wrote: Hi, I know this isn't PHP related but I have a quick question about postgresql. I come from a mysql enviroment so I'm a little clueless, even after reading the postgresql docs. I

Re: [PHP-DB] mysql_escape_string()

by the w3c. If you are having a particular problem please elaborate. -- 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] PHP Confused: Using wrong Unix Socket

On Friday 09 April 2004 02:38, Noah Davis wrote: How can I get PHP to not get confused about which .sock file to use? php.ini Do I need to recompile PHP? No. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] Stumped with proper query and display

? What is the relation? And shouldn't the relation be reflected in your queries? And if so your second query should be inside your outer while-loop. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] Rounding

need one decimal place still.. multiply by 10 ceil() divide by 10 -- 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] Drop down menu with PHP

of the drop down box so that it displays 2 rows at a time then it is an HTML question and the anwser can be found in any decent HTML reference. Otherwise please elaborate. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] INSERT problem--Need help urgently

redirections or refreshing the page? -- 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] INSERT problem--Need help urgently

)) { // form was submitted } In addition you should always perform sanity checks on values of the individual form elements. Search the archives/web for 'sql injection' for more info. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] BLOB

to accidently see people's passwords why not just rot13 it (apparently some companies seems to think that is a secure enough form of encryption). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

RE: [PHP-DB] PHP - MSSQL connects, but can't query

I changed the mssql_select_db line as suggested by another person here but it didn't change a thing. I still get the exact same error message. Is there anyone else here connecting to a MS SQL server using TDS v8.0 ?? Thanks! Jason -Original Message- From: Jason Morrill [mailto:[EMAIL

[PHP-DB] PHP - MSSQL connects, but can't query

: - Connected to server. Warning: Sybase: Server message: Line 1: Incorrect syntax near 'e'. (severity 15, procedure N/A) in /home/www/sql-test.php on line 12 Can't connect to Northwind Can anyone help me figure this one out?! Thanks! Jason Morrill

Re: [PHP-DB] win32 Timestamp problem

to calculate age without using the timestamp? As you're asking on the PHP-DB list I would assume that your dates are stored in a database of some sort, in which case you could use your database's native functions to do your date calculations. -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] JPGRAPH, problem...

will obviously be the script that creates the graph and outputs the image. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] CREATE TABLE $phpVariable_for_tableName --- help please!

. Also, always use mysql_error(). -- 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] Forms and more forms?

() or var_dump() every significant variable. -- 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] No data being put into the DB

the connection. -- 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] No data being put into the DB

myself, of late, using the braces more... The braces syntax highlights fine on Quanta. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] MySQL query... count?

)bucount FROM $table_name But it doesn't work.. am I being dumb on this cold Monday morning? Don't use DISTINCT, use GROUP BY. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] User Authentication

to return true in the first script (login) it authenticates, but logs any one in. Not good. Does anyone have any ideas or suggestions? You aren't actually performing any queries -- you're missing a mysql_query(). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] User Authentication

On Friday 27 February 2004 22:42, Craig Hoffman wrote: Thanks - I can't believe I missed that. :( And I'm sure you'll want to stick in a mysql_error() as well. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] help w/ multidementional array in 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 http://marc.theaimsgroup.com/?l=php-db

Re: [PHP-DB] mail() and sendmail configuration

that creates a [snip] If anyone has suggestions or knows of helpful links or tutorials, I'd be deeply obliged. 0) Does the simplest mail() invocation work at all? 1) Check the php logs 2) Check the sendmail logs 3) Ask on the RedHat list 4) Ask on the sendmail list -- Jason Wong - Gremlins

Re: [PHP-DB] Multiple values for a column

is it better not to store multiple values in a single column, they should be moved into a separate table. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] apache/php/mysql - guarenteed DB transaction

' setting. -- 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] multiple fields all unique?

want an example of the first (and better) method, let me know. ---John Holmes... Yeah, I have never used a unique field for the database, and you are right it is a mysql db. Jas -- Jason Gerfen Student Computing Group Marriott Library University of Utah (801) 585-9810 [EMAIL PROTECTED] I'm

[PHP-DB] db2 as a module

? Thanks for any help you can provide. Jason Keltz [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] pop, php and mysql problem!

email address somewhere. Anyway, in your code the while-loop and for-loop is essentially looping over the same thing. I hope you're not running a spam factory. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

[PHP-DB] Access and PHP problem

Hi, I am trying to INSERT into a MSAccess database using PHP 4.3 - I have a problem when I enter a name like O'Donnell. In mysql I would normally just backslash the single quote but this doesn't work with MSAccess. is there a fix for this?? Thanks in adv. Jason -- PHP Database Mailing List (http

Re: [PHP-DB] Database abstraction

. There's the semi-official PEAR-DB, also ADODB and Metabase. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives

Re: [PHP-DB] Database abstraction

On Wednesday 14 January 2004 06:42, Martin Marques wrote: Why is it you say it's semi-official? I have always felt PEAR as much official. Well it's not in the PHP manual so I treat it as semi-official ;-) -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] Saving arrays to databases?

() -- 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] Re: Subject: grabbing text from a webpage and putting it in a query.

. If you're requesting a resend of a private mail from Neil, shouldn't you be making this request in private? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Undefined function mysql_connect

. That way everything can be updated without relying on RH. -- 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] Re: BINARY not recognized ??

On Tuesday 06 January 2004 03:51, Monty wrote: Anyone ??? www.mysql.com ??? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] file date upload

. Where can I query to get the timestamp of the upload? If it's uploaded into the filesystem then: manual Filesystem functions -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Shift_JIS Character Set

need to stripslashes. OK, if you *know* that the data has been through addslashes() (or equivalent eg magic_quotes_gpc) then doing a strip_slashes() should revert the data to its original form. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web

Re: [PHP-DB] More of a question rather than seeking code. :)

yourself a big favour and setup something using a real mailing-list software. Any decent mailing-list manager will handle bounces automatically. Sustained bounces from an email address will eventually lead it to being suspended or unsubscribed automatically. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Slashes

be much better off if you disable all magic_quotes_* and do manual quoting and escaping where necessary. That way you will know exactly what is being done to your data. then I get a MySQL error 1064 whenever my value has a single-quote in it. -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] Shift_JIS Character Set

a number of two-byte code charcters that contain the hex-value 0x5c (backslash) which will get stripped by this function thus garbling those characters. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Splitting a string by a ,

and the introductory paragraph. -- 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

Re: [PHP-DB] MySQL join with variable table?

On Tuesday 18 November 2003 10:00, Jason Godesky wrote: In a MySQL database, I have several tables, including one central table that essentially keeps track of the records in the other tables. TABLE1 +---+---+---+ | id| str

Re: [PHP-DB] Read file

to ask them to upload it to the server: manual Handling file uploads -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

[PHP-DB] MySQL join with variable table?

on the possibility entirely. -- Jason Godesky [EMAIL PROTECTED] http://www.tribaldawn.com/jason/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Read file

onto the server. But technically speaking, both of the above are still variations of 'uploading' the file onto the server. So another option is: 3) Install a webserver on the client and serve the files from there instead. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] CSV Import Question

,name) VALUES ('$data[$c]','$data[$c]') When I import, it puts all data in the EMail field, even the name field. What's $delim? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] CSV Import Question

; ? -- 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] Re: imagecreatetruecolor ?

? =) //_---pic part of function -- $tmp_img = imagecreatetruecolor($new_width, $new_height); imagecopyresized($tmp_img, $img, 0, 0, 0, 0, $new_width, You most likely want to use imagecopyresampled() instead. -- Jason

Re: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)

)); Are they what you expected them to be? -- 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

[PHP-DB] Re: Using PHP to print using LP on Linux

This is what i use: exec (lpr -P $PrinterName $PostscriptFile,$printOut , $printReturn); Paul Fitz wrote: Hi Guys, I suppose this isn't a database specific question, but it is the only PHP mailing list I am subscribed to. Trying to trigger a printer in the office hooked up to a Mandrake

Re: [PHP-DB] Form Variables

the beginning and state what exactly you're trying to do, pages involved, how you're getting from one page to another, etc. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Form Variables

work for you. -- 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

Re: [PHP-DB] Wrong Parament count

letters (non case-sensitive) 3) And nothing else I don't know what letters/symbols/characters constitute a valid IRC channel so you may have to season the above to taste. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] Wrong Parament count

On Wednesday 22 October 2003 16:15, Jason Wong wrote: $input_string = #ircchannel; if (preg_match(/^#[a-zA-Z]+/, $input_string) { echo Looks like an irc channel; } else { echo Go check your input; } Sorry that regex should look like: if (preg_match(/^#[a-zA-Z

Re: [PHP-DB] Re: textarea with multiple rows and mysql insert

= These are comments that I am writing in the textar, cat_id = 1 Jay --- Viorel Dragomir [EMAIL PROTECTED] wrote: mysql_escape_string? [try to print what kind of values do you receive in post vars] vio- - Original Message - From: Jason End [EMAIL PROTECTED] To: George Patterson [EMAIL

Re: [PHP-DB] Re: textarea with multiple rows and mysql insert

The type was already set to text. The problem isn't at the mysql level but at the form/php level. The insert statement that is formed extracting the values from the form is only giving that part of the url or comments. Jay --- Dan Brunner [EMAIL PROTECTED] wrote: What is your field length???

Re: [PHP-DB] Re: textarea with multiple rows and mysql insert

2003 23:31:55 -0700 (PDT) Jason End [EMAIL PROTECTED] wrote: The type was already set to text. The problem isn't at the mysql level but at the form/php level. The insert statement that is formed extracting the values from the form is only giving that part of the url or comments

Re: [PHP-DB] Re: textarea with multiple rows and mysql insert

writing in the textar, cat_id = 1 Jay --- Viorel Dragomir [EMAIL PROTECTED] wrote: mysql_escape_string? [try to print what kind of values do you receive in post vars] vio- - Original Message - From: Jason End [EMAIL PROTECTED] To: George Patterson [EMAIL PROTECTED]; [EMAIL

[PHP-DB] textarea with multiple rows and mysql insert

I have a form that includes two text areas that span multiple rows. The first textarea (rows=2, cols=50) is used to insert a pretty long url, while the second (rows=5, cols=50) is used for inserting free text (comments). When I process the form to create the mysql insert statement, the values

Re: [PHP-DB] pathinformation from file-field

. This is for security reasons. -- 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

Re: [PHP-DB] Trouble with uploading a file via ftp_put

to itself isn't very useful. In other words you need an ftp server on (A). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] Trouble with uploading a file via ftp_put

really is 'html/html/' -- 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

Re: [PHP-DB] Confused

it right. Specifically, I need the user to CONNECT, SELECT, INSERT, UPDATE, DELETE and that's all for privileges. Any help is appreciated. This has *nothing* to do with PHP, try asking on the MySQL list. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] Trouble with uploading a file via ftp_put

: , ftp_pwd($conn_id), \n; //ftp_chdir($conn_id,html); echo Current directory is now : , ftp_pwd($conn_id), \n; echo brBilddatei ; echo $bild; $upload=ftp_put($conn_id,'html'+$bild,$bild,FTP_BINARY); ? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] SoS

Your if statement will only be TRUE if $id is set to FALSE, NULL or zero (0)--I think you're looking for if the variable is set. That would be: if (isset($id)) -- Jason Godesky [EMAIL PROTECTED] http://www.tribaldawn.com/jason/ I'm a beginner of PHP. While trying the code from a tutorial, I

Re: [PHP-DB] SoS

query strings, and the case of any possible includes. -- Jason Godesky [EMAIL PROTECTED] http://www.tribaldawn.com/jason/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SoS

the integrity of any input that you receive from the user. For example, in this case you should verify that $_GET['id'] is indeed an integer and nothing else. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] fopen : Supplied argument is not a valid File-Handle resource

in manual. -- 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] Replacing + with question

= urlencode($AddressLine1); $AddressLine1 = str_replace( , +, $AddressLine1); -- 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] HELP-PHP install

the apache error log to see whether that gives any clues. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before

Re: [PHP-DB] Excel file into MySQL

list for those two applications you mentioned? And asking on *their* mailing lists? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] fopen : Supplied argument is not a valid File-Handle resource

: Supplied argument is not a valid File-Handle resource in /home/sites/site1/web/whoisnew.php on line 584 [snip] How about putting in some error checking code as per example in manual? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] How to post code and avoid spam filter in Yahoo?

fine. Could the List Moderator chuck this guy, [EMAIL PROTECTED], off the list? Or at least ask him to configure his mail system properly. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] mysql, finding the last record

On Saturday 27 September 2003 01:04, John Ryan wrote: is there any quick way of selecting the 'last' row in a mysql table?? i could write some messy code but id prefer an elegant solution. mysql_num_rows() mysql_data_seek() -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] fgetcsv() only returns half of the rows

of the WHILE-loop reads in 600 chars from the file. Is that your real intention? $buffer = fgets($handle,300); $buffer = str_replace(\,,$buffer); print $buffer.br; } //end of while loop fclose ($handle); -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software

Re: [PHP-DB] fgetcsv() only returns half of the rows

(\,,$buffer); print $buffer.br; -- 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] Need some MySQL Optimization suggestions - uber slow queries

negligible. Does anyone have any suggestions for speeding up the query process...a lot? Try asking on the mysql list? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Re: Email Application

would say there is something wrong with your code. -- 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] Reference to SQL qyery result ????????

the problem ? Case-sensitivity issue? Did you try *any* debugging at all? Eg print_r($rangee)? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] set password on a page

On Monday 22 September 2003 00:17, SAGERAT wrote: How do I set up password on a page so that only restricted people can open it? google php user authentication tutorial -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Passing variables between html forms and updating sql table

having is updating the values. Here is my attempt [snip] And can you describe what this problem is? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Re: Why varying functionality across php db apis for db metadata?

you have to thank for the current inconsistencies. I think some move is being made to make the commands consistent across the different DBs. Eg the names of the postgresql functions are being changed to match those of the mysql functions. -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] Passing variables between html forms and updating sql table

kick-in? Does the php error logs show anything? etc -- 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] Passing variables between html forms and updating sql table

= mysql_field_name($result, $i); $fieldname2 = $.$fieldname; mysql_query(UPDATE $table_name SET $fieldname=$fieldname2 WHERE id =$id); echo $fieldname.br.$fieldname2.br; ... does the above echo display what you expected it to? -- Jason Wong - Gremlins Associates

[PHP-DB] how many rows updated

When updating or deleting a table is there anyway to find out how many rows where affected using php?? I am using Postgresql 7.2 and php 4.2 using pgsql from the the command line I enter this query update teststock set item_num ='something' where item_num ='something'; and it returns UPDATE

Re: [PHP-DB] how many rows updated

Thanks, i could not find that function in the book i was using. sorry for the inconvenience. John W. Holmes wrote: Jason S Motes wrote: When updating or deleting a table is there anyway to find out how many rows where affected using php?? I don't even use PG, but it took me 5 seconds to find

Re: [PHP-DB] date function

in MySQL mysql manual Tutorial Introduction Date Calculations -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives

Re: [PHP-DB] MySQL Returns Error

On Wednesday 06 August 2003 01:14, Jeff wrote: Well I did what you said, and now I get Parse error: parse error, unexpected T_ECHO in C:\FoxServ\www\encana_db.php on line 44 Try: $result = mysql_query($query, $link_id) OR die(mysql_error()); -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Configuring PHP with Firebird

installation is on a remote machine. Ie, the machine where PHP is running *does not* have Firebird installed. As Firebird is based on Interbase, I believe you can use PHP's Interbase interface: manual InterBase functions, for installation instructions. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Database Design Issue

reference. Also, I'm just designing the website I will have no part in the everyday maintenance of the website -- except when the maintainer gets stuck. :) Jason CPT John W. Holmes wrote: From: "Jason Lange" [EMAIL PROTECTED] Here's my question. I'm creating a website for a we

[PHP-DB] Database Design Issue

of the songs in a single table with a field denoting what show they're from, or should I create a separate table for each weeks show and just request that entire table? I'm looking at this from both a long-term performance and *maintenance* issue. TIA, Jason -- PHP Database Mailing List (http

Re: [PHP-DB] MySQL

, *how* doesn't it work. If you're new to all this, you might want to start by reading some of the numerous tutorials available (google for them) and follow through a few of them. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] not a valid MySQL result

jobs. Try using another variable to help it out. -- 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] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

if my work was right .. how can i link the driver (FreeTDS and then the DSN..) Have you configured /etc/odbc.ini /etc/odbcinst.ini correctly? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

On Monday 28 July 2003 18:13, Nabil wrote: Please Jason help me to do this The sql server is on 192.168.0.101 IP address. Please give me a sample of how can i config these files : /etc/odbc.ini /etc/odbcinst.ini As an example my /etc/odbc.ini contains: [MySQL-test] Description

Re: [PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

On Monday 28 July 2003 19:46, Nabil wrote: these are not working because i need to connect ro Micro$oft SQL server 7 NOT to mysql nor postgresql *sigh* They were meant to be examples of what *I* have. That's why you have to read the docs and see what needs to be done to use MSSQL. -- Jason

Re: [PHP-DB] Hackers?

account. As with all break-ins or suspected break-ins, to be on the safe side you should recover any data that you can (making sure that they haven't been tainted) then format the hard-disk (or better still, put in a new hard-disk, keeping the old one for analysis) and re-install. -- Jason Wong

<    1   2   3   4   5   6   7   8   9   >