Re: [PHP-DB] Sorting Multidimensional Array

2006-10-31 Thread Dave W
rpose is to retrieve the table data and manually add a record, then sort ASC by the startdate which is the forth field... Something like: $test = array_multisort($query, $key = '$query[4]'); Any help would be greatly appreciated. Thanks, Larentium -- Dave W

Re: [PHP-DB] mysql databases

2006-10-13 Thread Dave W
He means that he wants to use REPLACE and take out the old entry and update it with a new one. Although, you would probably use UPDATE instead. -- Dave W

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread Dave W
7;) Installing MySQL is not enough - you need to enable the mysql extension in your php.ini. -Stut -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Dave W

[PHP-DB] Re: Turning result into array from columns

2006-09-23 Thread Dave W
nothing to do with your problem, but why don't you just do the following? $q = 'SELECT id FROM content'; But here's your problem. Change > $realones = $row['id']; into $realones[] = $row['id']; And you get your desired result. Matthias -- Dave W

[PHP-DB] Turning result into array from columns

2006-09-22 Thread Dave W
If I just echo $row['id'], it will show both of them, just not put both of them into an array. -- Dave W

Re: [PHP-DB] Forms with letter verification

2006-07-29 Thread Dave W
e that shows how to create this feature. I have already created a set of graphical letters. Ron -- Dave W

Re: [PHP-DB] pulling numbers from a column and getting a total

2006-07-26 Thread Dave W
Thanks Natalie and Miles! The loop thing worked. What I had tried before was put the echo inside the loop and it wasn't working, but now it does, w00t! Thanks! On 7/26/06, Miles Thompson <[EMAIL PROTECTED]> wrote: At 10:27 AM 7/26/2006, Dave W wrote: >Hi, I was just wondering

[PHP-DB] pulling numbers from a column and getting a total

2006-07-26 Thread Dave W
Hi, I was just wondering on how I could get a whole column full of integers and added them up and display that total? I currently use a for loop to display the whole column in a table, but I wanted to add all those numbers up. Thanks. -- Dave W

[PHP-DB] Re: Subject: making an array from data in textfile

2006-07-24 Thread Dave W
Thanks for all the suggestions. On 7/24/06, Neil Smith [MVP, Digital media] <[EMAIL PROTECTED]> wrote: > >Message-ID: <[EMAIL PROTECTED]> >Date: Sat, 22 Jul 2006 21:31:35 -0400 >From: "Dave W" <[EMAIL PROTECTED]> >To: Php-Db >MIME-Ver

Re: [PHP-DB] Re: making an array from data in textfile

2006-07-23 Thread Dave W
7;; It works! On 7/23/06, Stut <[EMAIL PROTECTED]> wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave W wrote: > I figured it out before, but I didn't hit reply all. I used files() and > newlines to create it. Would using explode be a more reliable way? I assume yo

Re: [PHP-DB] Re: making an array from data in textfile

2006-07-23 Thread Dave W
I figured it out before, but I didn't hit reply all. I used files() and newlines to create it. Would using explode be a more reliable way? On 7/23/06, Stut <[EMAIL PROTECTED]> wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave W wrote: > Currently, here is my code

[PHP-DB] Re: making an array from data in textfile

2006-07-22 Thread Dave W
OK, well I did a debug and this is whats coming out: Array ( [0] => 127.0.0.1,127.0.0.1,127.0.0.1 ) Should I use fgets? On 7/22/06, Dave W <[EMAIL PROTECTED]> wrote: OK, so I have this text file that holds a list of ip addresses like this: 127.0.0.1,127.0.0.1,

[PHP-DB] making an array from data in textfile

2006-07-22 Thread Dave W
Data); Since it's a numeric array, I shouldn't need quotes around the ip octets. When I try to echo certain parts of the array like: echo $ips[0]; It's returning the whole array. The text file is exactly like an array so it shouldn't be a problem. -- Dave W

Re: [PHP-DB] Using MAX with COUNT?

2006-07-22 Thread Dave W
tp://www.php.net/unsub.php -- Dave W

Re: [PHP-DB] Discussion board integration

2006-07-19 Thread Dave W
1 W Broadway Butte, Montana 59701 406-782-2240 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Dave W

Re: [PHP-DB] Submitting form from

2006-07-17 Thread Dave W
Big Sky Penguin, LLC > 61 W Broadway > Butte, Montana 59701 > 406-782-2240 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Dave W

Re: [PHP-DB] detecting negative numbers

2006-07-16 Thread Dave W
, I'm just curious if there is a simpler way to do an already simple task. On 7/16/06, Stut <[EMAIL PROTECTED]> wrote: -BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dave W wrote: > Currently I have this: > > if($quant > $amount) {echo "You don't have that many!&quo

Re: [PHP-DB] detecting negative numbers

2006-07-16 Thread Dave W
They are both positive numbers. I want to see if, when subtract, do they equal a negative number? On 7/16/06, Peter Beckman <[EMAIL PROTECTED]> wrote: On Sun, 16 Jul 2006, Dave W wrote: > Currently I have this: > > if($quant > $amount) {echo "You don't have that

[PHP-DB] detecting negative numbers

2006-07-16 Thread Dave W
Currently I have this: if($quant > $amount) {echo "You don't have that many!"; } $quant is the user inputted amount and $amount is the amount that they actually have. Is there any way of checking if the result is negative rather than doing what I have above? -- Dave W

Re: [PHP-DB] Problem with list#2

2006-07-07 Thread Dave W
t advise to In forums. Off list I can for sure if any one wants To see what's going on. Karl James ("TheSaint") <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] www.theufl.com -- Dave W

Re: [PHP-DB] Re: posting information from a textarea

2006-07-07 Thread Dave W
t for some reason, I had to convert the textarea to a utf encoding before I entered it into the database! That was annoying. On 7/6/06, Dave W <[EMAIL PROTECTED]> wrote: I think I might have found the problem, but I'm not sure how to fix it. I'm just going to rebuild the form and it

Re: [PHP-DB] Re: posting information from a textarea

2006-07-06 Thread Dave W
just make a new one. On 7/6/06, Dave W <[EMAIL PROTECTED]> wrote: hmm..interesting. Neither the motto or desc is showing up in the array. I made a simple form and the echo 'post vars: ' . print_r($_POST, true) . ''; works fine. I'm just perplexed on why the motto

Re: [PHP-DB] Re: posting information from a textarea

2006-07-06 Thread Dave W
g a fieldset, but then why wouldn't just one not work? On 7/6/06, Chris <[EMAIL PROTECTED]> wrote: Dave W wrote: > I'll show you all the steps it passes through. > Here's the form: > > > > Motto: > v

Re: [PHP-DB] Re: posting information from a textarea

2006-07-06 Thread Dave W
wrong since it's posting the motto (which is just a text-type input) and not the description (which is a textarea). I echo'd out the mysql queries and excuted them myself from what echo'd out and it's selecting the desc column just fine. On 7/6/06, Chris <[EMAIL PROTECTE

Re: [PHP-DB] posting information from a textarea

2006-07-06 Thread Dave W
uery to the page before you even excute the insert, to verify the query, and that you are getting the proper information from the form. -B Dave W wrote: > I seem to be having a problem posting text from a text area. I have a > form > that posts data into a database and there are input

[PHP-DB] Re: posting information from a textarea

2006-07-06 Thread Dave W
I saw this bug: http://bugs.php.net/bug.php?id=22427. Could this be related to problem I'm having? On 7/6/06, Dave W <[EMAIL PROTECTED]> wrote: O, I also tried to change it to a $_FILES array, but that didn't work either. On 7/6/06, Dave W <[EMAIL PROTECTED] > wrote: >

[PHP-DB] posting information from a textarea

2006-07-06 Thread Dave W
o is a longtext type with fulltext. -- Dave W

[PHP-DB] Re: posting information from a textarea

2006-07-06 Thread Dave W
O, I also tried to change it to a $_FILES array, but that didn't work either. On 7/6/06, Dave W <[EMAIL PROTECTED]> wrote: I seem to be having a problem posting text from a text area. I have a form that posts data into a database and there are input fields which seem to post the d

[PHP-DB] splitting string from database

2006-07-03 Thread Dave W
ther to work...It just kept saying Array in the cell. I also tried strtok. -- Dave W

Re: [PHP-DB] Cron & unlink

2006-07-02 Thread Dave W
oops. yea, chris is right. I thought you were trying to delete files. On 7/2/06, Dave W <[EMAIL PROTECTED]> wrote: You have to use the absolute (or server, whatever you want to call it) path. So like/home/www/sessions/files/ or whatever it is. On 7/2/06, Ron Piggott (PHP) &

Re: [PHP-DB] Cron & unlink

2006-07-02 Thread Dave W
on/calls/script.php on line 47 Any suggestions? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Dave W

Re: [PHP-DB] ftp_connect($ftp_server);

2006-07-01 Thread Dave W
to delete a file within PHP without having to FTP to the server? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Dave W

Re: [PHP-DB] 時間の価値

2006-06-12 Thread Dave W
の価値を知るには 事故で生き残った人に 聞いてみなさい 千分の1秒の価値を知るには オリンピックで銀メダルを獲った人に 聞いてみなさい 時間は待ってくれません あなたの持っている全ての時間を大切にしなさい そしてここで全てを発散しなさい http://vqlh.com/?jy111 拒否 [EMAIL PROTECTED] -- Dave W

[PHP-DB] Restricting What's Retreived

2005-12-08 Thread Dave W
Does anyone know when you get info from a DB, can you restrict how many characters it gets from it? say you had a paragraph 1,000 letters but you only wont it to get 100 how would you do that?