[PHP-DB] problems with require...

2001-02-13 Thread dave
Hi everyone; I have only started to program in php over the past month or so. but I'm some problems with this bit of code below. error message is: Fatal error: failed opening required "press.inc" (include_path=") in D:\Inetpub\paulberry\main.php on line 201 I'm passing the values of

[PHP-DB] exit code generation, php shell script/standalone

2001-05-10 Thread Dave
is specifically waiting for the exit code. really want to avoide writing a perl/dbi script to carry out this function. Appreciate any insight Dave -- 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] safe way to retrieve the record i just inserted

2002-11-24 Thread Dave
Hi everyone, I am new to the forum. I am using PHP and PostgreSQL. After I insert into a table Task who's primary key is a serial type (auto sequence number) I would like to immediately retrieve that generated sequence number to use for subsequent inserts into another table Points. So what is a

[PHP-DB] is innodb faster than MyISAM???

2002-11-27 Thread Dave
. 95 s. Is this true? For regular inserts that seems cool - obviously transactions would take a little more, but hey, why bother with MyISAM then? dave -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] SAP DB - you guys should check it out

2002-12-04 Thread Dave
hey, there's a full featured, open-source db, made available from SAP. since sap has software running on this database base that powers the ERP systems of the world's largest companies, it has a lot of powerful, advanced, reliable features. you can get free cd's of the database from there web

[PHP-DB] Re: Looking for a programmer

2002-12-04 Thread Dave
isn't it funny how all projects are simple till you do them! well, that is, unless they really are simple. i guess i never take those. Aaron Lagadyn [EMAIL PROTECTED] wrote in message 003c01c298b6$7a235180$[EMAIL PROTECTED]">news:003c01c298b6$7a235180$[EMAIL PROTECTED]... Hi: I'm looking

[PHP-DB] Re: query

2002-12-04 Thread Dave
echo the actual sql statement from runtime and post it. Natividad Castro [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi to all, I'm working in a system where users can post projects. Other users will verify those projects. What I'm trying to do is once a

RE: [PHP-DB] insert into mysql

2001-01-25 Thread Dave Fudge
try this: $db = mysql_connect(host,uid,pwd); if($act=="ADD"){ $sql="INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')"; $res = mysql_db_query($dbname,$sql,$db); if(!$res){ echo("Unable to add part."); mysql_close($db); exit(); } } you didn't specify $dbname -Original

[PHP-DB] oracle 8i client/ PHP 4.0.4pl1 breaks

2001-04-12 Thread Dave Thomas
. Should I suspect bad Oracle link libraries? Dave Thomas Chief Software Architect BCD Enterprises, Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

RE: [PHP-DB] exit code generation, php shell script/standalone

2001-05-10 Thread Dave VanAuken
. Dave -Original Message- From: Miles Thompsonclipped Dave, You can return a value from a function ... function dosomething( para1, para2 ) { code here which depending on success or failure sets $reflag to 0 or 1 return $retflag; } So now the question is Can we return

RE: [PHP-DB] exit code generation, php shell script/standalone

2001-05-10 Thread Dave VanAuken
to the calling program depending on the value returned. would like to do the same with the php script, but it returns the variable prior to exiting (ie printing it to the screen) rather than passing it back Dave -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Thursday

[PHP-DB] How do you make MySQL users so they can only view there database and not others while using php4

2001-05-11 Thread Dave Torres
I have some what of a security issue that I can't seem to solve. I run php4 and MySQL on a FreeBSD server with Apache 1.3 as the webserver and have users that I allow access to there personal database. (example: user johndoe uses database johndoe). I can configure johndoe so he can only have

RE: [PHP-DB] Now, I have new problem!!

2001-07-22 Thread Dave Watkinson
=9845Item description/option option value=9846Item description/option option value=9847Item description/option etc /select /form then in inventory.php you can retrieve the value of the variable $itemnumber to see which item was selected. Hope this helps! Dave -Original Message- From

[PHP-DB] Retrieving Rows - Can I Change The Order?

2001-07-26 Thread Dave Watkinson
column by name, but I'ds rather use a SELECT * fror this partucular instance. Any ideas? Or am I just being lazy (it's been a long night after all!)? TIA Dave -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

RE: [PHP-DB] Re: simple database question

2001-07-26 Thread Dave Watkinson
Oops sorry I keep assuming this is a MySQL/PHP list! D'oh! Dave -Original Message- From: Brian Weisenthal [mailto:[EMAIL PROTECTED]] Sent: 26 July 2001 15:08 To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: simple database question oh, using ms sql Brian Weisenthal [EMAIL

RE: [PHP-DB] replace string - case insensitive

2001-07-29 Thread Dave Watkinson
go to http://www.php.net/eregi_replace hth Dave -Original Message- From: J- E- N [mailto:[EMAIL PROTECTED]] Sent: 28 July 2001 15:41 To: [EMAIL PROTECTED] Subject: [PHP-DB] replace string - case insensitive hello str_replace is case sensitive, what function should i use

[PHP-DB] Finding NoMatches in MySQL

2001-07-29 Thread Dave Watkinson
jobs where jobs.id1 not in employers.uid ??? many thanks in advance! Dave -- 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]

RE: [PHP-DB] UPDATE Not Updating

2001-08-01 Thread Dave Watkinson
Isn't PHP/MySQL case sensitive? Are all the column names the correct case? You could also try changing your die bit to or die (mysql_error()); that will echo the MySQL error message. HTH! Dave -Original Message- From: Steve Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: 01 August

RE: [PHP-DB] Limit Select Field Characters?

2001-08-01 Thread Dave Watkinson
$fulldate = date(dmy); echo $fulldate; -Original Message- From: Jeff Oien [mailto:[EMAIL PROTECTED]] Sent: 01 August 2001 23:34 To: PHP-DB Subject: [PHP-DB] Limit Select Field Characters? I have a timestamp field that looks like this 0109011754 but I only want to

RE: [PHP-DB] PHP redirect?

2001-08-01 Thread Dave Watkinson
name of option_button and each has a value - one is 1 and the other is 2. HTH :-) Dave -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 04:45 To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP redirect? I have a form and based off of this form if my user

RE: [PHP-DB] PHP redirect?

2001-08-02 Thread Dave Watkinson
with this... (top of some_page_or_other.php) $user_selected_value = getenv(QUERY_STRING); (top of some_other_page_you_choose.php) $user_selected_value = getenv(QUERY_STRING); Cheers Dave -Original Message- From: CrossWalkCentral.Net (Webmaster) [mailto:[EMAIL

RE: [PHP-DB] Trouble with PHP/MYSQL/APACHE

2001-08-02 Thread Dave Watkinson
looks like your include path and/or file don't exist. Double check that colon before /usr - surely that's incorrect? The undefined function is probably because the include file can't be found. Dave -Original Message- From: Al Moote [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 20:06

RE: [PHP-DB] Transforming doc files into html

2001-08-04 Thread Dave Watkinson
project, and then you can open a document and make it perform a Save As HTML, add the link to the database as a URL and you then have a clickable link to the converted file. This is all done with a combination of Visual Basic, PHP and MySQL. Hope this helps you out :-) Dave -Original

[PHP-DB] counting and displaying a how many figure

2001-08-04 Thread Dave Carrera
something like the count() function but I haven't used this yet Thanks for any help or guidance in this matter. Dave C ;-) -- 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

[PHP-DB] Error checking and escaping before running a query (MySQL)

2001-08-08 Thread Dave Watkinson
\dev\code\can_search_quick.php on line 22 there's a parse error if I don't escape the , so what can I do? I know how to do it in VB! I searched PHP.net, but could only find an old bug report that advised escaping special characters! Help! Thanks in advance Dave

RE: [PHP-DB] Error checking and escaping before running a query (MySQL)

2001-08-08 Thread Dave Watkinson
Wicked! Thanks Beau - it's not quite there but it's better than errors and timeouts all over the place! I'll keep playing with it - thanks again! Dave -Original Message- From: Beau Lebens [mailto:[EMAIL PROTECTED]] Sent: 08 August 2001 08:28 To: Dave Watkinson; PHP-DB List (E-mail

RE: [PHP-DB] order by date

2001-08-09 Thread Dave Watkinson
you can use order by date DESC for descending or order by date for ascending nice to see a PHP-Database question in here ;-) Dave -Original Message- From: Scott Chapman [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 10:50 To: [EMAIL PROTECTED] Subject: [PHP-DB] order by date

RE: [PHP-DB] blinking background

2001-08-09 Thread Dave Watkinson
I guess it's either a timer thing, and change the td bgcolor= or a timer thing and change the img src= from an animated to a non-animated GIF surely there's a better way? bgcolor and background images for tables are not enitrely cross-browser compliant - why not use JavaScript and send an Alert?

[PHP-DB] Another SELECTING problem :-(

2001-08-09 Thread Dave Watkinson
= contacts.uid and count(empid) 1; and get all kinds of invalid grouping messages many TIA Dave

RE: [PHP-DB] Another SELECTING problem :-(

2001-08-09 Thread Dave Watkinson
PS This is for a web page, so it's PHP related!!! :-) -Original Message- From: Dave Watkinson Sent: 09 August 2001 12:51 To: PHP-DB List (E-mail) Subject: [PHP-DB] Another SELECTING problem :-( I've a feeling I've asked this before, but checked my old messages and couldn't see

RE: [PHP-DB] Another SELECTING problem :-(

2001-08-09 Thread Dave Watkinson
, since you didn't tell the database which table to take empid from. A working statement would look like [Dave Watkinson] yeah, but empid inly exists in one of the tables in the FROM argument, so there's no error there SELECT empid, COUNT(empid) FROM emp_cont or SELECT emp_cont.empid

RE: [PHP-DB] how can save image in mysql

2001-08-16 Thread Dave Watkinson
:-) Dave -Original Message- From: Mad Nas [mailto:[EMAIL PROTECTED]] Sent: 16 August 2001 10:11 To: [EMAIL PROTECTED] Subject: [PHP-DB] how can save image in mysql Hi all How can save a image in a field of mysql table with use php language ? thanks for answer Mad Nas -- PHP

RE: [PHP-DB] query question

2001-08-28 Thread Dave Watkinson
instead of SELECT all_records WHERE some_condition, and then DELETE certain_rows, couldn't you just do a DELETE FROM WHERE? -Original Message- From: L Melville [mailto:[EMAIL PROTECTED]] Sent: 28 August 2001 14:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] query question Hi, If I

RE: [PHP-DB] Re: Database Transactions and HTTP statelessness

2001-08-29 Thread Dave Watkinson
to edit the row, set the value to 1. If someone chooses to edit a row and the value is 1 tell them it's locked elsewhere (maybe even tell them who's got it). Then when they update their changes reset the 1 to a 0. Just a coupla ideas :-) Dave -Original Message- From: Bopolissimus Platypus

RE: [PHP-DB] Simple database error (SPACE)

2001-08-30 Thread Dave Watkinson
try urlencode in the PHP manual ... I believe that'll do the trick! Cheers Dave -Original Message- From: Nagasea [mailto:[EMAIL PROTECTED]] Sent: 30 August 2001 23:02 To: [EMAIL PROTECTED] Subject: [PHP-DB] Simple database error (SPACE) //-- Anybody can help me with this problem (I

RE: [PHP-DB] Simple database error (SPACE)

2001-08-30 Thread Dave Watkinson
OK, try this $db = mysql_connect(localhost, ,pass); mysql_select_db(mydatabase_com,$db); $result = mysql_query(SELECT * FROM big_member WHERE position='Squads' ORDER by first LIMIT 0,300,$db); while ($myrow = mysql_fetch_row($result)) { $link_string = urlencode($myrow[3]);

RE: [PHP-DB] PHP / MySql / catalogs / carts

2001-08-31 Thread Dave Watkinson
php.net has loads of such links - don't be so lazy! ;-) -Original Message- From: Larry RedCobra Linthicum [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 20:57 To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP / MySql / catalogs / carts I bet there are some shopping carts and or catalogs

[PHP-DB] Weird Problem In mysql_connect();

2001-08-31 Thread Dave Watkinson
', which is kinda weird cos I'm actually specifying a (different) IP address in the host argument. I know it wasn't broken, but I decided to try and fix it anyways!!! TIA! Dave

RE: [PHP-DB] Weird Problem In mysql_connect();

2001-08-31 Thread Dave Watkinson
(!), and it's working, but the original problem has still got me confused!!! Dave -Original Message- From: Brunner, Daniel [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 21:32 To: Dave Watkinson Subject: RE: [PHP-DB] Weird Problem In mysql_connect(); Hello!! Have your tried to echo

RE: [PHP-DB] Weird Problem In mysql_connect();

2001-08-31 Thread Dave Watkinson
at the top of the file and it still wouldn't work. I think Dan's on the case with the IP Address thing ... I'll see what I can do about users and stuff. I'm running Win2K here :-( Cheers Dave -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 21:55

[PHP-DB] A timed refresh ?

2001-09-02 Thread Dave Carrera
on a 5 second timed interval. So: I have a list of images i.e..: image_1.gif image_2.gif image_3.gif Which I want to refresh every 5 seconds As always I Thank you for any help in advance. Yours Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

RE: [PHP-DB] Warning: Page has Expired

2001-09-03 Thread Dave Watkinson
look in php.ini (or whatever the Linux equivalent is) for session.cache_limiter and set it to session.cache_limiter = nocache HTH 8^D Dave -Original Message- From: olinux o [mailto:[EMAIL PROTECTED]] Sent: 03 September 2001 19:34 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Warning

[PHP-DB] Step through an array

2001-09-09 Thread Dave Carrera
ideas or pointers would of grate help Thanks in advance Dave C -- 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] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Dave Watkinson
remembering that I'll be searching TWO columns in the table every time. Are there perhaps any functions I can get for this? Or is there a really easy way I can do it that's escaped (scuse the pun!) me? Many thanks in advance Dave

RE: [PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Dave Watkinson
Cheers Rick ... I think I nailed it. I've copied my little function below for anyone else interested. Am keen on the saving milliseconds bit, though (will add it to the function below before making it live). Any more tips? Dave function parse($what) { $what

RE: [PHP-DB] Re: php and WAP?

2001-09-19 Thread Dave Watkinson
(Content-type: text/vnd.wap.wml); Looky here http://www.phpbuilder.com/columns/mike20010118.php3 Cheers Dave -Original Message- From: Nael Mohammad [mailto:[EMAIL PROTECTED]] Sent: 20 September 2001 00:32 To: 'Andreas D. Landmark'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: php and WAP

RE: [PHP-DB] sessions in PHP

2001-09-24 Thread Dave Watkinson
http://www.php.net/session -Original Message- From: nirat [mailto:[EMAIL PROTECTED]] Sent: 25 September 2001 06:46 To: [EMAIL PROTECTED] Subject: [PHP-DB] sessions in PHP can anyone guide me to using sessions in PHP i've tried it a lot of times but its not working. any help tutorials

RE: [PHP-DB] i know i caused u a headache:)

2001-09-26 Thread Dave Watkinson
you need to do ?brand=? echo $something; ? -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: 26 September 2001 14:11 To: [EMAIL PROTECTED] Subject: [PHP-DB] i know i caused u a headache:) here is my situation: i select a category on store.php(from a form) then in the

RE: [PHP-DB] mysql_fetch_array() doesn't work

2001-09-26 Thread Dave Watkinson
that's not a mysql_fetch_array() error it's a coding error -Original Message- From: Web user [mailto:[EMAIL PROTECTED]] Sent: 27 September 2001 05:48 To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql_fetch_array() doesn't work System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 +

[PHP-DB] (poss OT) mail() function

2001-09-27 Thread Dave Watkinson
to send the email (copied below) and sometimes (more often than not) the email is fine (I get a copy), but other times it's all plain text and the formatting isn't there. Does anyone know why this would happen? Cheers in advance Dave // start copy of function function send_email

RE: [PHP-DB] Script

2001-09-30 Thread Dave Watkinson
Alternatively if you're using Windows you can write a batch file and use AT to set it to run as often as you like. Just include the path to PHP.exe and the path to the PHP file in the batch file, like this... D:\PHP\PHP.exe D:\Scripts\email_sender.php HTH! Dave -Original Message

RE: [PHP-DB] Check Boxes/UPDATE

2001-10-02 Thread Dave Watkinson
Hiya Matt you have to set the value of the checkbox to 1, and give it a unique name. if the user has checked the box when they submit the form then the checkbox' name will have a value of 1. if they didn't check it it won't have a value at all. Hope this helps! Dave -Original Message

RE: [PHP-DB] date

2001-10-18 Thread Dave Watkinson
mysql date format is -MM-DD including the hyphens) I usually use substr() to convert it from a user's entry to the format reqd for the database hth Dave -Original Message- From: ax [mailto:[EMAIL PROTECTED]] Sent: 18 October 2001 10:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] date

RE: [PHP-DB] wildcard in mysql search with php

2001-10-18 Thread Dave Watkinson
select columnlist from tablename where columnname like '%searchword%' RTFM!!! -Original Message- From: Thomas omega Henning [mailto:[EMAIL PROTECTED]] Sent: 18 October 2001 14:58 To: [EMAIL PROTECTED] Subject: [PHP-DB] wildcard in mysql search with php Hello all, Is there a way to

[PHP-DB] import error into mySQL

2001-10-25 Thread Dave Pollak
? Dave Pollak -- 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] How do i search my database...

2001-11-10 Thread Dave Carrera
Hi All, I have a database with only three fields FIELD 1 FIELD 2 FIELD 3 I want the user to input into FIELD 3, and then my script to go of to my database and see if it finds a match or something like the input and display it to the screen. Please help as i can't seem to get my brain around

[PHP-DB] product selection from url ?

2001-12-30 Thread Dave Carrera
see that specific product. Any help is apprieciated Keep happy and well Dave C The two rules for success are: 1. Never tell them everything you know. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

[PHP-DB] I think i saw this somewhere....

2002-01-06 Thread Dave Carrera
, it had a mysql db in the background. Is this kind of thing available or did i dream it. As always any pointers of advice is welcome Dave C The two rules for success are: 1. Never tell them everything you know. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] adding $ to my file

2002-01-08 Thread Dave Carrera
Hi All I am trying to add this to a file on my system $var = $string_submited_by_form All i get when i run the script is an input to my file like this = string_submited_by_form whithou the $var at the beging Can anyone please help. Thanks in Advance Dave C The two rules for success

[PHP-DB] Create Table from a file in php

2002-01-11 Thread Dave Carrera
Hi All I want to create a table from a file that contains the sql to create the table. I have checked Mysql.com and have seen how to do it from telnet, but i want to do it from a php script. Can anyone please help. Thanks in Advance Dave C The two rules for success are: 1. Never tell them

[PHP-DB] A local file copy question

2002-01-15 Thread Dave Carrera
I can not fix the scripts path as i dont know where people un zip the script to on thier local system. Any help or guidence as aways, is most appreiciated. Yours Dave C The two rules for success are: 1. Never tell them everything you know. -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Reading and Writing ?

2002-01-17 Thread Dave Carrera
Hi All How can I read the contents of 1 file then Write those contents to a newfile? This is baffling me. I Know about fopen,fread,fwrite but cant seem to get the logical steps clear in my head. As always any help or pointers given are most appreciated. Yours Dave C -- PHP Database

[PHP-DB] Recalculation ?

2002-01-18 Thread Dave Carrera
); session_register($qty); calc stuff here } And have tried other ways but to no avail. Can someone throw any light on this. As always any help is appreciated. Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [PHP-DB] MySQL Connection Class

2002-01-30 Thread Dave Richardson
A number of connection classes and abstraction toolkits already exist. Your PHP 4.x install probably came with PEAR's DB.php abstraction layer. Save yourself the trouble perhaps? jas said: So all I would need to do is create a file named db_connection.php3 and put in the functions

[PHP-DB] Selct show certain num records ?

2002-01-30 Thread Dave Carrera
Hi All I know this has been covered here before but can someone please remind me how to selct just the 5 latest records in my db and show them in list form. Just like phpbuilder.com dose I thank you in advance for repeating this information. Dave C :-) -- PHP Database Mailing List (http

[PHP-DB] Counting db generate links

2002-02-05 Thread Dave Carrera
Hi All How do I count how many time a certain link generated in part from my db has been click so that I can show this number to my visitors as some kind of hit list, top 10 etc: I thank you in advance for any help Dave Carrera Website Designer http://www.davecarrera.com -- PHP Database

[PHP-DB] Select rows where ?

2002-02-12 Thread Dave Carrera
Hi All How do I select the rows that DO NOT contain a certain character. I.e. : select * from tablename where field dose not contain A Any pointers as always appreciated. davec Dave Carrera Website Designer http://www.davecarrera.com -- PHP Database Mailing List (http://www.php.net

[PHP-DB] A while loop prob ?

2002-02-13 Thread Dave Carrera
Hi All What have I done wrong here. 3 yes 3 hours I have been plaing with this loop. All it shows is the last record in my db. It should show and record containing any string in the search. Error works Please help I beg you... As always thank you for any help Dave C - My Code

[PHP-DB] Deleting from a select list ? :-(

2002-02-14 Thread Dave Carrera
light on this. As always thanks for past and future help Dave C :-) --MY CODE STARTS HERE --- $deloptions_sql = select * from $tbn2; $delresult = mysql_query($deloptions_sql, $con) or die(error: .mysql_error()); $delrows = mysql_num_rows($delresult

[PHP-DB] Session confusion :-(

2002-02-16 Thread Dave Carrera
on this please. As Always I am grateful for any pointers or exampled help :-) Dave Carrera Php / MySql Development Web Design Site Marketing http://www.davecarrera.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] I cant get the logic for this...

2002-02-18 Thread Dave Carrera
. As Always your help and or guidance in this matter is appreciated. Dave Carrera Php / MySql Development Web Design Site Marketing http://www.davecarrera.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: I cant get the logic for this...

2002-02-18 Thread Dave Carrera
Dave C CODE HERE-- if(ISSET($category)){ $viewsql = select * from $tbn2 where catid = \$category\ ; $viewres = @mysql_query($viewsql, $con) or die (Cant get details. Please report this to the website administrator); $num_rows = mysql_num_rows($viewres); while( $v1rows

[PHP-DB] How do I add multiple var to a if clause ?

2002-02-21 Thread Dave Carrera
Hi All If($var == 1,2,3){ } This is wrong so what is the right way. I am try to find out a if var equals either 1 2 or 3 do something type thing but cant find answers anywhere Thanks in Advance Dave Carrera Php / MySql Development Web Design Site Marketing http://www.davecarrera.com

[PHP-DB] Shopping Cart ?

2002-02-24 Thread Dave Carrera
( I think...). Is there some kind of code example for this. As Always thank you in advance for any snippets of wisdom. Dave Carrera Php / MySql Development Web Design Site Marketing http://www.davecarrera.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] I have a in my db ?

2002-03-06 Thread Dave carrera
which is 15 lcd Monitor. How do I get past this issue The php manual has no usage examples relevant to my needs. Please help Dave c

[PHP-DB] How to add 2 years to todays date ?

2002-03-17 Thread Dave Carrera
Hi All I think the subject line says it all. How to add 2 years to today's date ? Any helps as always most appreciated. Dave Carrera Php Developer http://davecarrera.freelancers.net http://www.davecarrera.com

[PHP-DB] A text file include ?

2002-03-25 Thread Dave Carrera
Hi All, I know how to include the contents of a test file into my app. But at the moment I have to type in p/p tags to make in render properly. Is there a way of reading the contents and dynamically creating paragraph breaks or line breaks? Dave Carrera Php Developer http

[PHP-DB] 2 related ?'s email users

2002-03-25 Thread Dave Carrera
someone can help with this. As always I thank you in advance of any help, code samples or pointers. Dave Carrera Php Developer http://davecarrera.freelancers.net http://www.davecarrera.com

[PHP-DB] Very wierd problem ;-(

2002-03-27 Thread Dave Carrera
the message and cant reply. Got me foxed. What could I be doing wrong? Any ideas as always appreciated. Dave Carrera Php Developer http://davecarrera.freelancers.net http://www.davecarrera.com

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

2002-04-01 Thread Dave Carrera
Hi All How do you do this? On click of button to delete a record make a popup yes / no box appear. On yes then do it else stop. Is it possible to do with out using JS? Thanks for any pointers or code in advance. Dave Carrera Php Developer http://davecarrera.freelancers.net

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

2002-04-01 Thread Dave Carrera
you to do this. I have come across various probs with JS on client systems so I shy away from it. Again thank you all for your advice. Dave Carrera Php Developer http://davecarrera.freelancers.net http://www.davecarrera.com

[PHP-DB] Please help count ?

2002-04-04 Thread Dave Carrera
. It is returned in the format shown, so my question might be how I read only the first bit before the space. I fully appreciate any kind of help with this and as always thank you in advance for any help. Dave Carrera Php Developer http://davecarrera.freelancers.net http

[PHP-DB] saving details problem (big)

2002-04-04 Thread Dave Carrera
all fine and dandy when I added the extra info after postcode lookup but customer insisted he wants it this way round. Customers... (cant live with them, cant live without them...) Dave Carrera Php Developer http://davecarrera.freelancers.net http://www.davecarrera.com

[PHP-DB] Keep state of a selected field?

2002-04-06 Thread Dave Carrera
for displaying the way I am trying at the moment. Keep happy Dave Carrera Php Developer http://davecarrera.freelancers.net http://www.davecarrera.com

[PHP-DB] htaccess quick ?

2002-04-08 Thread Dave Carrera
. P.S got the restrict by ip number sorted I think.. Dave Carrera Php Developer http://davecarrera.freelancers.net http://www.davecarrera.com

[PHP-DB] Apology for htaccess post

2002-04-08 Thread Dave Carrera
user of this list. P.S found the answer to this issue. Dave Carrera Php Developer http://davecarrera.freelancers.net http://www.davecarrera.com

[PHP-DB] Count and group ?

2002-05-01 Thread Dave Carrera
3 2 1 1 Then the result I would like to display is this.. Admin (1) = 3 posts Admin (2) = 4 posts Admin (3) = 5 posts Basically displaying the total post each admin has made Any help or guidance is very appreciated and thank you in advance Dave Carrera Php Developer http

[PHP-DB] Re: php-db Digest 1 May 2002 19:24:34 -0000 Issue 1181

2002-05-02 Thread Dave Carrera
and will need changing to your suit your needs. -- End My Code Snippet - Once again Thank you Frank Flynn [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi Dave, The easiest, most direct, ANSI - SQL way to do what you ask is: SELE

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

2002-05-11 Thread Dave Carrera
fully in advance for any help you may give. Dave C

[PHP-DB] setcookie warning?

2002-05-23 Thread Dave Carrera
I get this warning with setcookie Warning: setcookie() expects parameter 3 to be long, string given But the cookie works ok this is the line setting the cookie setcookie(selarea,$gotarea,/ ); any ideas i am using php 4.2 Thanks in advance Dave C -- PHP Database Mailing

[PHP-DB] refreshing an array

2002-05-23 Thread Dave Carrera
. All help and guidence is most appreciated Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] sql statement via var

2002-05-26 Thread Dave Carrera
Hi All I am trying to load a mysql statement which i have tested and know to work from a var in my script. It is a create table statement. I have a good connection as a table list shows tables. I tried to echo my var but no joy Any ideas? Thanks in Advance Dave C -- PHP

[PHP-DB] Sql from file

2002-05-26 Thread Dave Carrera
a good db connection of which a can echo what i want. Thank you for any help in advance Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] db sql issue from var

2002-05-26 Thread Dave Carrera
pointer and or code example would be most appreiciated. Thank You Dave C ---Original Message--- From: Rasmus Lerdorf Date: Sunday, May 26, 2002 16:20:39 To: Dave Carrera Cc: php List Subject: Re: [PHP-DB

[PHP-DB] Array_rand issue...

2002-05-31 Thread Dave Carrera
can make it work but some guidence in this matter would be very much appreciated. Thank you in advance Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] making sub dirs ?

2002-06-16 Thread Dave Carrera
and then transfer thier uploaded image to thier newly created directory. I am using php4.2 apache 1.3+ I thank you in advance for any help. Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE:using rand() in multiple insert ?

2002-07-06 Thread Dave Carrera
Hi All I worked it out. If you would make use of this kind of thing email me and I will gladly give the code example. Thanks Anyway Dave C

[PHP-DB] Header problem

2002-07-15 Thread Dave Carrera
. Is there anything new with header location that I haven't heard of? Any help is most appreciated. Dave C

[PHP-DB] Multiple select ?

2002-08-01 Thread Dave Carrera
is all rows whether or not col3 is 0 or 1. I am confused ☹ Any help or guidance is very much appreciated. Thanks in advance Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Select * from t1.id where not equal to t2.id ???

2002-08-03 Thread Dave Carrera
High all I cant seem to get this sql working. I am trying to pull everything from table 1 (t1) where t1.id is not equal to table 2 (t2) id I cant find examples anywhere. Any help or guidance with this as always is very much appreciated. Thanks in Advance Dave C

  1   2   >