[PHP-DB] mysql -- php

2001-04-08 Thread Adam
mysql in a php script: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php3 on line 97 Error I'm sure that mysql server is running. Greets, Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

Re: [PHP-DB] Gathering data from a database

2003-03-22 Thread Adam -
Hi, $select = mysql_select_db ($database); like Mike said you don't need to have this in and no need for a var to be assigned... Then when you want to print out the data print_r( $row ); you can use $row['table_row_name']; :) Adam At 08:26 PM 3/22/2003 -0500, you wrote: I have been

Re: [PHP-DB] Returning a formated dat

2001-02-02 Thread Adam Younce
that the date is stored in. To get more info on the DATE_FORMAT function, check out the MySQL online manual. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Dat e_and_time_functions Regards, Adam Younce [EMAIL PROTECTED] - Original Message - From: "Ben C

[PHP-DB] Is MySQL in 4.0.6?

2001-06-25 Thread Adam Lundrigan
in PHPbut why doesn't the connect work if it is included? -Adam Lundrigan CEO, VPU http://www.vpu-virtual.com/ ICQ # 73617446 [EMAIL PROTECTED]

[PHP-DB] PHP on Linux and MS SQL

2001-07-30 Thread Adam Oliver
Anybody know of a good installation description for connection PHP on linux to MS SQL on a 2000 machine? I've been through about 3 so far and none of them have worked. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands

[PHP-DB] Can't connect to MS SQL

2001-07-30 Thread Adam Oliver
. What am I doing wrong? Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Random question selection in PHP w/ MySQL backend.

2001-07-31 Thread Adam Lundrigan
that the same question doesn't appear twice. The questions need to appear in a random order each time the script is loaded. It sounds simple enough, but i just can't seem to get it to work. Any suggestions?? Thanks in advance, -Adam Lundrigan CEO, VPU http://www.vpu-virtual.com/ ICQ # 73617446

[PHP-DB] REG_EMPTY

2001-08-01 Thread Adam Lundrigan
What exactly does the error 'REG_EMPTY' mean in PHP? -- -Adam Lundrigan CEO, VPU http://www.vpu-virtual.com/ ICQ # 73617446 [EMAIL PROTECTED]

[PHP-DB] MySQL Connection Lost....

2001-08-13 Thread Adam Douglas
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all that helped! The problem I'm now experiencing is when I try to interface with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly and through a MySQL GUI Client. I get the following error...

RE: [PHP-DB] Using A Query Results Multiple Times

2001-10-24 Thread Adam Douglas
Yes, I had the right code just was missing the mysql_data_seek. Thanks for the help. -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 1:09 PM To: 'Adam Douglas'; PHP-DB (mailing list) (E-mail) Subject: RE: [PHP-DB] Using A Query Results

RE: [PHP-DB] Using A Query Results Multiple Times

2001-10-24 Thread Adam Douglas
Thanks for the help. I had all the code right just had to add the mysql_data_seek. Wasn't aware it operated in this manner. -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 3:41 PM To: Adam Douglas; PHP-DB (mailing list) (E-mail); PHP

[PHP-DB] Using A Query Results Multiple Times

2001-10-23 Thread Adam Douglas
I have an instance where I have to query my MySQL database and then use the multiple row results to create multiple pull down menus on a web page. My problem is how can I take the results of the query and use them more the once to create pull down menus? I've always used a while look to

[PHP-DB] dates in db

2002-01-05 Thread Adam Jackson
i have a date in my mysql database in the format of 20011201 how do I output that to show for example 01 December 2001 or something similar? Cheers Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

[PHP-DB] 2D array into mySQL DB

2002-01-11 Thread Adam Royle
as expected mysql_query($sql); } Any help would be appreciated. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] mail() on Mac OS X

2002-01-15 Thread Adam Royle
PROTECTED] my sendmail_path is still the same as default... but I was just thinking that PHP would use my smtp server(ifunk.dyndns.org) Can someone slap me in the face if I'm misunderstanding something, or help me if you can. Thanks, Adam. -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] Automatic Listboxes

2002-01-15 Thread Adam Royle
!-- function start(){ var something = new Array(); ?php for ($i=0;$icount($array);$i++){ echo javascript array stuff -- $array[$i]; } ? // now the other javascript code (additional lists etc) } and then thats it! (well, sorta, but you get the jist) Adam

[PHP-DB] Authentication

2002-01-16 Thread Adam Royle
is what makes it work. For better definition of what these things do, look in the php manual (Chapter 3. Configuration). Hope this helps, Adam. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

[PHP-DB] RE: Recalculation ?

2002-01-20 Thread Adam Royle
an existing session variable. Also, in logic (I haven't tested though), your condition for your 'if' statement ($qty == $qty) will always evaluate to true. Adam -Original Message- From: Dave Carrera [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 19, 2002 3:17 AM To: php List Subject

[PHP-DB] RE: MySQL Update help needed

2002-01-21 Thread Adam Royle
A few things to check: 1. You have a connection to the database (I'm assuming you do). 2. mysql_query() is a php function so you should not put a dollar sign before it (indicating it is a variable. If you want mysql_query() to return a variable, do something like this: $result =

[PHP-DB] RE: ensuring unique field value in MySQL using PHP

2002-01-28 Thread Adam Royle
command to make sure there are no duplicates. Look in the mySQL documentation (www.mysql.com) to find the correct command. Adam -Original Message- From: Janet Valade [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:24 PM To: [EMAIL PROTECTED] Subject: ensuring unique field value

[PHP-DB] RE: FIle Uploading to database

2002-02-03 Thread Adam Royle
You missed the SET parameter in your query... example is below... $query = INSERT INTO Canidate SET (FirstName, LastName, Indus... Adam -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 11:06 AM To: [EMAIL PROTECTED] Subject: Re: FIle

[PHP-DB] Re: Counting db generate links

2002-02-06 Thread Adam Royle
, etc. this is would be good if you were storing addresses (like downloadable things, eg PDFs or scripts, etc) cause then it really is a link MANAGEMENT system, and not just a link stat counter Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: option in forms

2002-02-09 Thread Adam Royle
I think this is what you're getting at: select name=artistID option value=?= $row[ID] ??= $row[ArtistName] ?/option /select or something like that so it would look like (in HTML) select name=artistID option value=23Artist's Name First in list/option option value=44Artist's Name second in

[PHP-DB] RE: Outputing Distinct rows

2002-02-10 Thread Adam Royle
= posts.topic_id ORDER BY posts.lastUpdated DESC LIMIT 10; Also, this would allow for extra things in the future, such as a page showing all updates in a certain day, or within last 3 days, or something like that. Hope this helps. Adam -Original Message- From: KingZeus [mailto:[EMAIL

Re: [PHP-DB] Session confusion :-(

2002-02-18 Thread Adam Royle
variables with the same name. See if that works, and if it doesn't have a look at this... http://www.php.net/manual/en/language.variables.predefined.php Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Special Insertion Into MySQL - at a loss!

2002-02-21 Thread Adam Royle
worried about... any questions about the code?? just ask... Adam I have a special set of information retrieved from a while loop that I would like a person to be able to edit and send back into a MySQL table. I know all of the basic MySQL commands for doing such, but the PHP side to get the input

[PHP-DB] Question about advanced SQL

2002-02-27 Thread Adam Royle
to be an easier way. Adam. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: login

2002-03-10 Thread Adam Royle
If the variable $SCRIPT_NAME does not suit your needs, try the other environment variables here: http://www.php.net/manual/en/language.variables.predefined.php Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Output of curl to an array.

2002-03-21 Thread Adam Royle
: ) Adam You can use it like so... PHP Script (of course, you must either have the function on the same page or include() it like so): ?php include('extractPairs.php'); header(Content-Type: text/plain); $strText = Name1=Value1 \n Name2 = Value 2\nName 3 =Value 3; $arrPairs = extractPairs

[PHP-DB] Re: insert into javascript php

2002-03-22 Thread Adam Royle
PHP cannot recognise javascript variables because javascript is interpreted via the browser, and not the server (which php is). for php to use javascript variables, you must post the variable to another page using either a form or querystring. Adam script c=document.forms[0

Re: [PHP-DB] marking DB entries...

2002-03-22 Thread Adam Royle
of the person logged in, you can allow/disallow what they can edit depending on the ID. If you need further help, contact me directly. Adam. Im making an address book using PHP and mySQL. I want each user to have access only to his/hers adressinputs. Now Im wondering how I gonna solve this, ofcourse

[PHP-DB] Re: urgent guys

2002-03-22 Thread Adam Royle
?; /script javascript - php: script language=JavaScript // this is probably wrong javascript syntax, but you get the idea location.href = thing.php?q=first+onep=second+one; /script Adam i know it has nothing to do with php but i'm stuck:) i have this url: http://localhost/auction/seller

[PHP-DB] Re: If else Question

2002-03-26 Thread Adam Royle
and if they are allowed to insert the record. Adam. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: PHP/Access problem

2002-03-26 Thread Adam Royle
not hae single quotes around it... adam

[PHP-DB] Re: Checking for 2 unique row contents

2002-03-27 Thread Adam Royle
Simple do these checks and you'll be sweet as a nut Adam ?php $sql = SELECT nickname FROM tblUsers WHERE nickname = '$nickname''; $result = mysql_query($sql); $sql = SELECT email FROM tblUsers WHERE email = '$email'; $result2 = mysql_query($sql); if (mysql_num_rows($result

[PHP-DB] Advice to PHP beginners

2002-03-27 Thread Adam Royle
there... Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-04-01 Thread Adam Royle
to use both (its not that hard) and it will make life a lot easier (and more interesting). Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mail()

2002-04-02 Thread Adam Voigt
without the variables to make sure it works just even with straight static values? Adam Voigt [EMAIL PROTECTED] On Tue, 2 Apr 2002 10:55:20 -0500, James Kupernik [EMAIL PROTECTED] wrote: I'm trying to run a mail function .. the program is running, but I'm not getting the email. Here is the code

Re: RE: [PHP-DB] mail()

2002-04-02 Thread Adam Voigt
as coming from [EMAIL PROTECTED], while when they clicked the reply button, it would go to [EMAIL PROTECTED], the most useful situation for these is when your server appends a nastry from address like apache@localhost or whatever from the webserver daemon. Adam Voigt [EMAIL PROTECTED] On Tue, 2 Apr

Re: [PHP-DB] New PostgreSQL functions

2002-04-08 Thread Adam Voigt
ways to do certain things, and so few ways to do other things. =) Just Curious, Adam Voigt [EMAIL PROTECTED] On Mon, 08 Apr 2002 13:41:46 +0900, Yasuo Ohgaki [EMAIL PROTECTED] wrote: Hi, I've added new PostgreSQL functions to CVS

Re: Re: [PHP-DB] New PostgreSQL functions

2002-04-08 Thread Adam Voigt
language, and I certainly don't want you to think me a ASP zealot because I don't program in ASP or iHTML for that matter, I'm a pure PHP evangelist from top to bottom. Adam Voigt [EMAIL PROTECTED] On Mon, 08 Apr 2002 23:04:25 +0900, Yasuo Ohgaki [EMAIL PROTECTED] wrote: Adam Voigt wrote: think it's

Re: [PHP-DB] Finding highest number in auto increment

2002-04-09 Thread Adam Voigt
SELECT * FROM whatever ORDER BY id DESC; Ofcourse if you want Ascending order, it would be ASC instead of DESC Adam Voigt [EMAIL PROTECTED] On Tue, 09 Apr 2002 15:48:45 +0200, Lisi [EMAIL PROTECTED] wrote: Each record in my table has a unique ID number generated by auto increment each time

Re: [PHP-DB] Finding highest number in auto increment

2002-04-09 Thread Adam Voigt
Oh, forget to include that if you only want that one record, use the LIMIT 1 keyword as well. Adam Voigt [EMAIL PROTECTED] P.S.: All of this is in the MySQL manual. On Tue, 09 Apr 2002 15:48:45 +0200, Lisi [EMAIL PROTECTED] wrote: Each record in my table has a unique ID number generated

[PHP-DB] PHP tips to make your life easier

2002-04-24 Thread Adam Royle
as much. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Adding totals

2002-05-20 Thread Adam Royle
This should be it (if I am understanding you correctly). Adam $strSQL = SELECT SUM(columnName) as sum FROM tblName; $result = mysql_query($strSQL); while ($row = mysql_fetch_array($result)){ $total = $row[sum]; } Hi all, Is there a way for me in PHP4

Re: [PHP-DB] new pair of eyes

2002-05-31 Thread Adam Royle
add and delete things inside the functions for your own setup. Adam / DEFINE CONSTANTS / // Connecting to a database define( DB_SERVER , localhost ); // used for dbConnect() define( DB_USERNAME , username ); // used for dbConnect() define( DB_PASSWORD

[PHP-DB] sql and week starting ending numbers (dates)

2002-06-01 Thread Adam Royle
is my table schema for the above query Adam CREATE TABLE tblCashflow ( ID bigint(20) NOT NULL auto_increment, purchaseDate date default NULL, categoryID_FK tinyint(4) default NULL, itemName text, itemPrice float default '0', isEssential tinyint(4) default '0

[PHP-DB] Re: SQL Troubles with JOIN, GROUP BY and MAX???

2002-06-04 Thread Adam Royle
I think this is something like you would want... Adam SELECT users.id, username, MAX(stamp) as stamp, filename FROM users, files WHERE users.id = userid GROUP BY username -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Having trouble understanding how to manage arrays

2002-06-10 Thread Adam Royle
. Adam ?php /* Connecting, selecting database */ $link = mysql_connect(192.168.0.112, root, ) or die(Could not connect); print Connected successfully; mysql_select_db(dgdrivers) or die(Could not select database); /* Performing SQL query */ $query = SELECT type

Re: [PHP-DB] MySQL Clustering, redundancy

2002-06-18 Thread Adam Voigt
must take account of this in your code interacting with the server, but the data will be sync'd). Adam Voigt [EMAIL PROTECTED] On Tue, 2002-06-18 at 08:47, Matt Babineau wrote: Hi All: I quickly skimmed the MySQL manual and didn't see any information on clustering. Does MySQL have any support

RE: [PHP-DB] MySQL Clustering, redundancy

2002-06-18 Thread Adam Voigt
could think of would be an application gateway of some sort which will load balance properly to different IP's while in your code you only point to one. Adam Voigt [EMAIL PROTECTED] On Tue, 2002-06-18 at 09:12, Matt Babineau wrote: Thanks for your response Adam! Do you know if there is any

RE: [PHP-DB] Converting values from text to numerical

2002-06-21 Thread Adam Royle
Hi Matt, I think this might be the answer to your problem. It basically checks if the string is an integer. I generally love the PHP automatic type conversion, but sometimes it can trick ya :) if (intval($val) == $val){ // integer stuff } else { // string stuff } Adam

[PHP-DB] Re: Populating multi-select list from mysql

2002-06-21 Thread Adam Royle
(category_list_array[],categories,,multiple size=10); And voila... all is done... Need any help... ask Oh yeah, btw everyone else, I have emailed the lib.php file to Bob - if you want a copy, email me. Adam lib.php.zip Description: Zip archive -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: getting the value of a javascript variable

2002-06-22 Thread Adam Royle
the contents of the second drop-down box. There are a few examples around on the net - Google is your friend. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Form not working...

2002-06-26 Thread Adam Royle
What you said (Mike) is mostly correct, although the GetSQLValueString() function in Scott's code automatically puts the quotes around the values if the datatype definition of text is passed to the function. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Re: remove from db renumbering

2002-06-30 Thread Adam Royle
() LIMIT 1 2. Get all of the ID numbers into an array and pick a random value, then retrieve the rest of the details using the row ID you picked from the array. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: delete multiple records with one query

2002-07-02 Thread Adam Royle
. this will make a comma-delimited string of all your selected ID numbers, and will be available in $name_array your choice adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Refresh after DB Query

2002-07-03 Thread Adam Royle
Sorry if you are a newbie.. but if might help if you delete the records before you select them to display in html ie: put the delete query at the top of the page, just after this line: require (templates/db_connect.php); adam

[PHP-DB] Re: Urent please

2002-07-08 Thread Adam Royle
?var2=?= var2 ?,theWindow,width=200,height=300); adam maybe this is more a javescripy problem...but its related to my php code: how can i open a new window with javacript and pass to it php variables?? thanks guys alot. Rehab M.Shouman -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] A Simple Question

2002-07-09 Thread Adam Alkins
. Good reading: http://www.php.net/manual/en/language.variables.predefined.php -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] catch warnings?

2002-07-10 Thread Adam Alkins
in PHP? I believe mssql_get_last_message() is what you want. -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] A Simple Question

2002-07-10 Thread Adam Royle
[3] = third ) You can also have multidimensional arrays, but not associative arrays. But you do have the 255 character limitation (can be a bummer). Adam Also, as far as limitations go, the following are considerations; 1. You can't pass an array using the querystring 2. Multiline

Re: [PHP-DB] PHP Security and Code Design

2002-07-10 Thread Adam Alkins
clear this up? Yes. URL passed variables are access via the GET method. So page.php?foo=bar is accessed by $_GET['foo'] -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: HELP NEEDED!

2002-07-13 Thread Adam Alkins
(); } -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: HELP NEEDED

2002-07-13 Thread Adam Royle
= false, 1 = true; { echo Name was found in the database; } else { echo Name was NOT found in the database; } Hope that helps.. Adam Hi there I am having a problem querrying to my database. I wish to check to see if a username is listed in the database so that I can

Re: [PHP-DB] extract data from database into an array

2002-07-13 Thread Adam Alkins
if selecting multiple rows, use a loop while($data = mysql_fetch_array())... -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Select a subset?

2002-07-14 Thread Adam Alkins
selected 10 rows, it will return 10. If you want to count all the rows in the table, its best to use the COUNT() function SELECT COUNT(*) FROM table -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] extract data from database into an array

2002-07-15 Thread Adam Voigt
$query = mysql_query(SELECT whatever FROM whatever;); while($row = mysql_fetch_array($query)) $construct[] = $row[whatever]; That will give you an array (construct) with position 0 being the first row, position 1 being the second row, and so on. Adam Voigt [EMAIL PROTECTED] On Mon

Re: [PHP-DB] Keeps prompting to download php page???

2002-07-16 Thread Adam Alkins
Wrong list. This is for Databases. Try the php-install list. -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Construct, Q+E, QBE

2002-07-17 Thread Adam Royle
to help. Adam

[PHP-DB] To Bo

2002-07-21 Thread Adam Royle
Study these two parts in the manual, and you will know how to do everything you've mentioned (and more). http://www.php.net/manual/en/ref.strings.php http://www.php.net/manual/en/ref.array.php Adam

[PHP-DB] Re: php and javascript?

2002-07-22 Thread Adam Royle
; } } //-- /SCRIPT !-- and your html will be like this (obviously change your var names as per your script -- A HREF=javascript:deleteRecord('?= $recordName ?','?= $recordID ?');?= $recordName ?/A HTH, Adam. Hi, Here is what I wanted to achieve, I want to get a confirmation box pop

Re: [PHP-DB] has anyone used php to connect to access ?

2002-07-24 Thread Adam Alkins
/en/ref.odbc.php -- Adam Alkins http://www.rasadam.com -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP4 MSSQL Error handling

2002-07-25 Thread Adam Voigt
$result = mssql_query($query) or die(mssql_get_last_message()); Adam Voigt [EMAIL PROTECTED] On Wed, 2002-07-24 at 19:48, Salve Tinkerworth wrote: Does anyone have any good tips for error handling? I've tried different methods to retrieve good error information from mssql_query but nothing

Re: [PHP-DB] mssql datetime field

2002-07-25 Thread Adam Voigt
Could you give an example of what you are sending in as the date value in an Insert/Update? Adam Voigt [EMAIL PROTECTED] On Thu, 2002-07-25 at 08:45, [EMAIL PROTECTED] wrote: has anyone had any expierence with the datetime field coming back from MSSQL as someting along the lines of February

[PHP-DB] Re: Pulling a data from array of checkboxes

2002-07-28 Thread Adam Royle
This is friendlier, cleaner and faster way to return the results. $chk = implode(, , $chk); $sql = SELECT field1, field2 FROM tblName WHERE ID IN ($chk) ORDER BY ID; this should bring back all the records within one resultset, which is easier to manage Adam -- PHP Database Mailing List

[PHP-DB] Re: Auto Increment Problems....

2002-07-29 Thread Adam Royle
it right. If you want to use numbering for your records, create it dynamically when you display the data. Adam --- Original Message --- rite, my primary key column (id) is set to auto_increment as usual which is very handy. But when I delete a row, the auto_increment just keeps incrementing

[PHP-DB] Benefits of assigning query to variable

2002-07-31 Thread Adam Royle
', field3 = 'something3', field4 = 'something4'; $result = mysql_query($sql); Hope that answers your question. Adam

[PHP-DB] Re: Multiple select ?

2002-08-01 Thread Adam Royle
Try using parentheses inside your sql: Select * from table_name where (col1=1 OR col2=1) and col3=0 Select * from table_name where col1=1 OR (col2=1 and col3=0) They make a big difference, also helps to indentify what you're selecting when you come back to the sql later. Adam

Re: [PHP-DB] Need Advice on Installing PHP MySQL on Mac OSX

2002-08-11 Thread Adam Royle
info on their ste http://developer.apple.com/internet/macosx/php.html Adam

Re: [PHP-DB] Upgrading PHP

2002-08-14 Thread Adam Williams
I'd uninstall php first...I believe its rpm -e mod_php (or you can do rpm -e `rpm -qa|grep php` and then I'd upgrade apache and PHP on your box for security reasons. Read the installation section in the php manual at www.php.net for details. Adam On Wed, 14 Aug 2002

Re: [PHP-DB] Upgrading PHP

2002-08-14 Thread Adam Williams
/access_log and error_log Adam On Wed, 14 Aug 2002, Julio Cuz, Jr. wrote: Hi-- I'm currently running 4.0.4pl1 on RedHat 7.0 and I want to upgrade to PHP 4.2.2is there anything special I have to do BEFORE or AFTER the install? Or is it just a straight re-install of PHP

Re: [PHP-DB] PHP File for adding to database

2002-08-15 Thread Adam Williams
what is the structure of the table that this info will be going into? Paste me the CREATE TABLE command you used to create it. Adam On Thu, 15 Aug 2002, Shoulder to Shoulder Farm wrote: Hi all, How can I make a PHP4 page that will add information to a MySQL database

Re: [PHP-DB] Connecting Linux (PHP) to MS Access database

2002-08-15 Thread Adam Williams
See if this message posted earlier helps you out: http://marc.theaimsgroup.com/?l=php-dbm=102938139730405w=2 Adam On 16 Aug 2002, Osman Omar wrote: Hi, Can I connect/access MS access database from linux ? if can, what software/driver that I need? Now I'm using

Re: [PHP-DB] Return Results in Categories - like CNET

2002-08-16 Thread Adam Williams
If your articles are in an SQL database uses the LIMIT clause on your SQL statement. Adam On Fri, 16 Aug 2002, olinux wrote: I would like to allow articles to be searched and returned in grouped categories - similar to cnet.com See example here: http

Re: [PHP-DB] default value for date.

2002-08-19 Thread Adam Williams
set a default value that isn't possible (like -99-99 99:99:99) and then have an if statement saying if ( $row[date] == '-99-99 99:99:99' ) { $row[date] = '';} Adam On Mon, 19 Aug 2002, Smita Manohar wrote: i'm using php with mysql. some tables in database have

[PHP-DB] Re: Date Subtraction

2002-08-21 Thread Adam Royle
Use getdate() with mktime() and this is your solution. http://www.php.net/manual/en/function.getdate.php http://www.php.net/manual/en/function.mktime.php Adam

Re: [PHP-DB] full text search and how to underline keyword in results

2002-08-25 Thread Adam Royle
$keywords[$i], although you could figure out a proper regex if you don't want partial words higlighted. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] is the following query legal?

2002-08-26 Thread Adam Williams
and insert the array $statement[$counter]? I am at a loss as to what is happening, because if I change the form to submit one variable instead of an array, it works fine. Any idea as to what is happening? Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] is the following query legal?

2002-08-26 Thread Adam Williams
I got it to work. I have to put the statement in ifx_prepare right before I call it in the loop. I think its because when I define the statement at the start of the code, $statement[$counter] has not been asigned yet so it sets its value to nothing. Adam -- PHP

Re: [PHP-DB] How do I submit data AND send user to other page?

2002-08-26 Thread Adam Williams
use an HTML form. Adam On Mon, 26 Aug 2002, Gerd Ulrich wrote: Hello, I want to build a questionaire where the user is guided through five pages of questions. How can I program PHP that the user gets to the second page after pushing the Submit-Button? My solution

Re: [PHP-DB] AUTO_INCREMENT problemos

2002-08-27 Thread Adam Williams
Thats how its supposed to work. It won't reuse old numbers even after you delete the entire row. Adam On Tue, 27 Aug 2002, simon wrote: Hi Wondering if anybody can help with this: My table has an INT column named 'member_id' which is set to AUTO_INCREMENT

Re: [PHP-DB] Create database

2002-08-27 Thread Adam Williams
the same error, try connecting to mysql from the console with mysql -u user -ppasswd Adam On Tue, 5 Aug 2003, Russell Griechen wrote: Newbie here, With PhpMyAdmin, What is the syntax for create database? I have: $link = mysql_pconnect(hostname, username, password

Re: [PHP-DB] login won't work for Internet Explorer

2002-08-27 Thread Adam Williams
View the source in mozilla, it might just be suppressing the output for whatever reason. Adam On Wed, 28 Aug 2002 [EMAIL PROTECTED] wrote: Hi there, I am experiencing a peculiar problem. I have recently moved a PHP / MySQL driven website I have been developing

Re: [PHP-DB] connectivity problem

2002-08-27 Thread Adam Williams
look at http://www.php.net/manual/en/function.pg-connect.php do you have postgresql starting with the -i paramater so that it is listening on a TCP port? PHP needs this to be able to connect to postgresql. Adam On Tue, 27 Aug 2002, Brian Noecker wrote: Hey everyone

Re: [PHP-DB] connectivity problem

2002-08-27 Thread Adam Williams
In your connect statement, you aren't selecting a password and TCP port to connect to. You made need to specify those. Adam On Tue, 27 Aug 2002, Brian Noecker wrote: Hey everyone, got a problem here. I'm using php4.2.1, postgres 7.2. I'm trying to do a simple

Re: [PHP-DB] Script to control mysql users?

2002-08-29 Thread Adam Williams
read mysql.com's documentation on the GRANT command. Or install phpmyadmin and use that. Adam On Thu, 29 Aug 2002, Leif K-Brooks wrote: I need to add mysql users to some databases, but my dumb control panel (ensim) doesn't seem to have a feature to do that, and I'm

Re: [PHP-DB] This is driving me insane!

2002-08-29 Thread Adam Williams
restart apache Adam On Thu, 29 Aug 2002, James Hatridge wrote: HI all... I'm at my end, would some kind soul please help? I'm working on a database using SuSE 8.0, mysql, and PHP. All the standard installs. I need to use exec, unlink, etc. BUT the durn PHP

Re: [PHP-DB] how to hide source code??

2002-08-29 Thread Adam Williams
set you to owner of the script and then chmod 700 it Adam On Thu, 29 Aug 2002, Smita Manohar wrote: hii im using php script with mysql. i want to hide the script from the admin or from the person who has privileges to access all the data. bcos i use ftp to upload

RE: [PHP-DB] how to hide source code??

2002-08-29 Thread Adam Williams
oh yeah duh me, set it 701 Adam On Thu, 29 Aug 2002, Ryan Jameson (USA) wrote: Wouldn't that make php unable to read it as well? Then it is useless as well. Ryan -Original Message- From: Adam Williams [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29

  1   2   3   >