Re: [PHP] Opera advice needed!

when the files are in my test server... -W "Frank Arensmeier" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] 7 feb 2007 kl. 09.50 skrev William Stokes: > If there's an opera expert around could you please check out the > following > link: > > htt

Re: [PHP] Opera advice needed!

ShitSHitSHIT!!! I had javascript disabled in Opera. The browsed just ignored it's own settings while brosing my server??? Feeling stopid. :O -W (Just costed me 3 hours) ""William Stokes"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > Tha

Re: [PHP] Opera advice needed!

If there's an opera expert around could you please check out the following link: http://www.fcviikingit.com/new/testimenu.php This script contacts a DB and prints out the results as javascript to the client browser. As I mentioned earlier It works ok with IE, FF, Netscape but not with Opera. H

[PHP] Opera advice needed!

Hello, I just noticed when I published a new menu system that it does NOT work in the ISP hosted server. However it works ok on my test server. Here's the test I have done all in same client machine (=unchanged browser settings): My test server: IE6 & 7->OK Opera 9.02 -> OK Firefox ->OK IS

[PHP] php & javascript interaction

Hello, I need some advice on how to learn Javascript and PHP interaction. Any good tutorials on the web would be most welcome. I particulary need to learn how to pass JS user input/choices to PHP. My current problem is how to ask user confirmation over his actions on a web form after POST. "Ar

[PHP] sortind arrays

Hello, How can I sort an array like this so that it would be ASC ordered by the [1] key in subarrays? I need to maintain only the subarray key - value pairs. (Do I make sense?) Array ( [0] => Array ( [0] => Logo [1] => NameC [2] => Home

Re: [PHP] regular expression help!

Hello Roman, Could you specify the functionality of your script a bit please. (How it works) I forgot to mention that this part: ', is not always the same. The image properties can vary. Thanks -Will "Roman Neuhauser" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] ># [EMAIL PR

[PHP] regular expression help!

Hello, Can someone here give me a glue how to do the following. I guess I need to use regular expressions here. I have absolutely zero experience with regular expressions. (if there's another way to do this I don't mind. I jus need to get this done somehow :) I need to strip all characters fro

Re: [PHP] web form data to arrays?

I got it working like this: $counter = 0; foreach ($arr as $value) { //make the form ... print "\n"; $counter++; } Now I have array $ArrUpdate which contains sub-arrays with the update data. This can now be processed with another foreach loop -Will "Jochem Maas" <[EMAIL PROTECTED]> kirj

Re: [PHP] web form data to arrays?

tti viestissä:[EMAIL PROTECTED] > On sze, 2007-01-17 at 15:23 +0200, William Stokes wrote: >> Hello, >> >> I have a script which retrieves rows from DB and prints them to a user >> editable form to a web page. I don't know how to print the form objects >> so >

[PHP] web form data to arrays?

Hello, I have a script which retrieves rows from DB and prints them to a user editable form to a web page. I don't know how to print the form objects so that all editable fields are put to arrays for updating them to DB. I have tried to create arrays sarjanID[] etc. but havent got it to work...

[PHP] Arrays?

Hello, How to print out the following array $test so that the print order is by the fourth[4] key? I need to print out all arrays in $test so that the data is ordered by the fourth key in ascending order. $test =Array ( [0] => Array ( [0] => 5 [1] => 2 [2] => sika [3] => sika.php [4]

Re: [PHP] Access array data in foreach?

Uh. (Embarrassed) Thanks anyway!! -W ""Casey Chu"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > $value holds the value of the current array element. > > On 1/6/07, William Stokes <[EMAIL PROTECTED]> wrote: >> Hello, >> >

[PHP] Access array data in foreach?

Hello, I Have an array $toplevel containing arrays: Array ( [0] => Array ( [0] => 1 [1] => 1 [2] => eka [3] => eka.php ) [1] => Array ( [0] => 2 [1] => 1 [2] => toka [3] => toka.php ) [2] => Array (

[PHP] Arrays help

Hello, I'm making a menu script that uses mysql, php and javascript to build a "on mouse over" dropdown menu to a page. I ran into some problems and would need help to get this working. (This is just the top level of the menusystem) 1. Get the toplevel links from DB, create array and put values

[PHP] reading MS Excel?

Is it possible to read Excel files and store the info to DB? If so how? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Paste variable from popup to previous page?

Hello, How can I pass a variable from popup window back to the page that originally opened the popup? Or can I? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Paste variable from popup to previous page?

Hello, How can I pass a variable from popup window back to the page that originally opened the popup? Or can I? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Cookies & page refresh

Thanks. It seems that I tested the right things but in a wrong order... -Will "Chris" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: >> Hello, >> >> I have a page that uses session cookies for deciding what content to s

[PHP] Cookies & page refresh

Hello, I have a page that uses session cookies for deciding what content to show to a visitor. User also has 2 form objecks to apply filters to the content SQL queries. So at the beginning of the script I set 2 cookies based on user selections(or defaults) and after that make DB query based on

[PHP] $POST Q

Hello, Can someone tell me what wrong or to how to manage this? //default $limitorig = 10; echo ""; echo "$limitorig"; echo "10"; echo "20"; echo "30"; echo "; When the form is first printed the selected default (10) value is shown OK and if something is selected everything is fine. If I just

[PHP] file uploads Q?

Hello, I have somehow managed to write a scipt that is able to upload and resize images to a server :))) Sad part is that now the user can upload only one image at a time.(user has a browse button for browsing images in his local disk and can pick only one at a time). Is it possible to allow

Re: [PHP] calendar Q

-Will ""Richard Lynch"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > On Thu, August 10, 2006 12:14 pm, William Stokes wrote: >> I have a calendar script that displays a simple mini calendar view one >> month >> at a time. User can click

[PHP] calendar Q

Hello, I have a calendar script that displays a simple mini calendar view one month at a time. User can click any date and the calendar opens another page that displays that date's events. I would like to highlight to the mini calendar view dates that have an event in database. So what would be

[PHP] Passing variables.

Hello, I've used like 3 hours to get this done but I can't figure this out. Hope someone here can help. I have a form that a user can use to edit www pages. Page content is stored in DB as a HTML code. First user has to select, from menu, which page to edit. Then the selected page content ht

[PHP] popup window from php page

Hello, How do I open a popup window from php code when a web page is loaded? Does it require javascript usage? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Cannot read variables

Yess! Wrong ini file... There seems to be 3 of them on the same PC for some reason? -W "David Otton" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > On Tue, 6 Jun 2006 10:36:12 +0300, you wrote: > >>I just set up a test box for PHP/MySQL on a WinXP box and now I'm having >>trouble

[PHP] Cannot read variables

Hello, I just set up a test box for PHP/MySQL on a WinXP box and now I'm having trouble with variables passed to browser from a link. For example I have a link that outputs this: http://localhost/index.php?team=CF10b. Now the CF10b cannot be user in the code like it should. I turned to Regis

Re: [PHP] User confirmation questions?

OK ""Rabin Vincent"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] On 5/5/06, William Stokes <[EMAIL PROTECTED]> wrote: > In PHP is it possible to generate "windows style" question boxes and get > the > users choice back? Or do I

[PHP] User confirmation questions?

Hello, In PHP is it possible to generate "windows style" question boxes and get the users choice back? Or do I need javascript or something else for that? For example if a user hits a button in form I could ask for his confirmation for the action. Like "Do you Really wan't to drop the whole dat

Re: [PHP] SQL query to array?

27;ve just done it! Here's another way of doing it that will utilize mysql_fetch_assoc() to allow your query to dictate the elements of the array. Keep in mind, I haven't tested this, but since I'm not entirely sure what you are asking the list, I'll offer it anyway ;-) On

Re: [PHP] Re: Serveral forms in a page.

it was just a question "?" "Stut" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: >> Mulkku? > > 'Cause insulting us is the way to convince this list to answer your > irrelevant questions? Seriously tho, if I

[PHP] SQL query to array?

Hello, Can someone please help me to put the results of a query to an array. Never done this before: $sql = "SELECT sortteri,jouk_id,jouk_nimi FROM x_table ORDER BY sortteri ASC"; $result = mysql_query($sql); $num = mysql_num_rows($result); $cur = 1; //create empty array that contains an array

[PHP] Re: Serveral forms in a page.

Mulkku? "Barry" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: >> Hello, >> >> This "might be" more HTML stuff but anyway... > Yeah, anyway who cares if it belongs in here or not. > >> I have

[PHP] Serveral forms in a page.

Hello, This "might be" more HTML stuff but anyway... I have several forms in a page which is ok otherwise but the reset buttons doesn't clear anything that is queried from DB and printed to the text fields. Any idea how to create Reset buttons that clear the fields even when the data is not fr

Re: [PHP] sorting troubles

PROTECTED] > On Sat, April 22, 2006 4:49 am, William Stokes wrote: >> I have a column in DB that contains this kind of data, >> A20,B16,B17C14,C15,D13,D12 etc. >> >> I would like to print this data to a page and sort it ascending by the >> letter an descending by

[PHP] sorting troubles

Hello, Any idea how to sort this? I have a column in DB that contains this kind of data, A20,B16,B17C14,C15,D13,D12 etc. I would like to print this data to a page and sort it ascending by the letter an descending by the number. Can this be done? Like A20 B17 B16 C15 C14 D13 D12 Thanks -Will

[PHP] Re: Export data with PHPMyAdmin

Forgot to say that the scandic fonts are ok in the tables... ""William Stokes"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > Hello, > > I'm using PhpMyadmin 2.6.3 on operators server for DB management. I would > from time to time like t

[PHP] Export data with PHPMyAdmin

Hello, I'm using PhpMyadmin 2.6.3 on operators server for DB management. I would from time to time like to export the whole DB to text file and move the DB to my own test server. Problem is that when I dump the whole DB to a file all scandic fonts are incorrect. If I dump the data to screen the

[PHP] forms and variables?

Hello, Probably a stupid one but anyway... In PHP. Is it possible to point to a variable with the HTML form name by which it was posted from? Example: //point to the variable with something like or somenthing??? $AddNew.SomeVar $SomeVar = "Add"; $SomeVar = "Del"; Or do I just have name

Re: [PHP] POST arrays?

So. If large amount of variables are needed to be preserved in arrays or otherwise is "session" the (normal)way to go? -W "Stut" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: > >>You're right. >> > > I

Re: [PHP] POST arrays?

True. I'm not famiar with sessions. I have always used $POST to transmit variables. -W "Stut" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: > >>You're right. >> > > I'm also shocked, but only mildly. &g

Re: [PHP] POST arrays?

You're right. BTW, can sessions and $POST be mixed? If yes is there any reason what so ever to do that? -W "Stut" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: > >>From here: >>$arr_siirto = array((serialize('

Re: [PHP] POST arrays?

>From here: $arr_siirto = array((serialize('1','2','3')); after removing the single quotes it started to work. -W "Stut" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: > >>Is it bad just to rem

Re: [PHP] POST arrays?

Is it bad just to remove the single quotes [ ' ] ? "Stut" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: > >>OK. Must try that. >> >>BTW theres something odd about my serialize. I got it return something but >&

Re: [PHP] POST arrays?

OK. Must try that. BTW theres something odd about my serialize. I got it return something but not quite what was expected :) Here's the result "a:3:{i:0;s:1:" -W "Stut" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: > &g

Re: [PHP] POST arrays?

"Why do you want to post it to itself? Why not use a session instead? " -I dont know. Never tried "session" "It's a lot more efficient." -OK. Is it more complicated to write? -Will "Stut" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECT

Re: [PHP] POST arrays?

; <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: >> No other way? >> >> > > Over sessions or saving as file and loading it in the following page. > > -- > Smileys rule (cX.x)C --o(^_^o) > Dance for me! ^(^_^)o (o^_

Re: [PHP] POST arrays?

No other way? "Stut" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: > >>How to post an array with associated values? >> >>This works ok >> >>>$arr_siirto = array(1,2,3); >>print_r($arr_siirto); >&g

[PHP] POST arrays?

Hello, How to post an array with associated values? This works ok But if I post it to another form with this: "> And print there with: print_r($arr_siirt_jouk); prints: Array So how can post the values forward? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscr

[PHP] preventing duplicate rows?

Hello, I'm updating a table with following SQL statement $sql = "INSERT INTO x_ikaluokat (ryhma, ikaluokka) VALUES ('$ryhma','$ikaluokka')"; What would be the best way to test that similar rows doesn't get created to the table? I can't make both columns unique. Thanks -Will -- PHP Gener

Re: [PHP] var_dump($POST)

oooppps :) sorry about that one... "Albert Padley" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > > On Apr 13, 2006, at 12:16 AM, William Stokes wrote: > >> Hello, >> var_dump($POST) returns now always NULL. > > Try var_dump($_POST); >

[PHP] var_dump($POST)

Hello, var_dump($POST) returns now always NULL. Before it returned the POST variables and their values like it should, right? Is there something that the operator could have done in the server that causes this? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visi

[PHP] Hiding text?

Hello, How can I hide error message when user enters to POST action form for first time? I have a form for collecting and saving user data. In the code below you can see that there are text messages for user info stored in $teksti variables. At the end the $teksti is passed to function that di

[PHP] Re: Date question

Yep. Nevermind... (and back to sleep) ""William Stokes"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > Hello, > > I have a datetime column in MySQL DB. How can I match to that column from > php code if I only have the date information avail

[PHP] Date question

Hello, I have a datetime column in MySQL DB. How can I match to that column from php code if I only have the date information available. 2006-02-24 12:00:00 against2006-02-24 This might be more SQL question sorry about that. Thanks -Will -- PHP General Mailing List (http://www.php.net/)

Re: [PHP] loop Q

Cheers! "Jochem Maas" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: >> What does this do in a for loop? >> >> $counter+=1 >> > > it's shorthand for $counter = $counter + 1; > which in this case (because

[PHP] loop Q

What does this do in a for loop? $counter+=1 Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: menu Q

e you got confused as well? William Stokes wrote: > I have a menu on a header bar on my page. The header bar is 20px > high. The menu, code and style below, works ok on Opera but not in Ie6 or > Firefox. In these browsers the menu 'streches' the bar height so that the >

Re: [PHP] menu Q

"http://www.css-discuss.org/ :-)" I tried that also :) Had to put this to stylesheet to get it 'fire' select.menu {} But it didn't solve the problem... thanks for the effort anyway. -Will "Kim Christensen" <[EMAIL PROTECTED]> kirjoitti viesti

[PHP] menu Q

Hello, This might not be a PHP related issue. I don't know. But this one is really bothering me. I have a menu on a header bar on my page. The header bar is 20px high. The menu, code and style below, works ok on Opera but not in Ie6 or Firefox. In these browsers the menu 'streches' the bar he

[PHP] CSS Groups?

Anybody know any good CSS groups? I don't want to post here non PHP related stuff Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] target?

I mean. If I open popup named page2.htm from page1.htm with target="_blank" can I go back to page1.htm with target="_parent"? -W "Jay Blanchard" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > [snip] > Is target="_parent" opposite to target="_blank"? > [/snip] > > Opposite? no. N

[PHP] target?

Hello Is target="_parent" opposite to target="_blank"? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] LIMIT?

Hello I have a news page which is getting quite long now and I would like to split the news to two pages. Now I have one SQL query for all the rows and I think I could use LIMIT to limit the results but how to limit the results for example to 15 rows for page one and from 16 to the last on seco

Re: [PHP] string lenght?

Cheers! "Richard Davey" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > > On 6 Feb 2006, at 12:18, William Stokes wrote: > >> How can I test whether a string is 1 or 2 digits long? > > Cast it to an int (or float if required) and strlen()

[PHP] string lenght?

Hello, How can I test whether a string is 1 or 2 digits long? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PHP vars to JS?

Hello, How can I get my PHP variable values to a javascript? Here's the code:

Re: [PHP] image uploads

there are atleast 5Megapixels in the camera :( ""Albert"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: >> I somehow got it back working with Opera. Don't know how :) One question >> still remains. How to make

[PHP] Wysiwyg editors?

Hello, Once again no PHP question... If I want to allow users to design and create their own static pages and store them to a server as a part of larger site what ways I have to do this? I once tested htmlarea (http://www.htmlarea.com/) and I think thats something I'm looking for. I don't ha

Re: [PHP] image uploads

OK. I was a bit vague at the first posting... To DB a put the filepath to the two images i create. And some additional info like upload date, width, height etc. I like storing my files in filesystem... "You mean isset($image), right?..." Right ! "ENCTYPE="multipart/form-data" " It's there.

Re: [PHP] HTML Question?

"Those aren't tables" Doesn't matter... (to me:) ""Richard Lynch"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > On Thu, January 26, 2006 11:35 am, William Stokes wrote: >> This is totally HTML question but I had

[PHP] image uploads

Hello, Is there something special about php and images that nobody told me... I'm writing a image gallery but I have run to serious trouble with it. I have one page with form in it. Form's action is $PHP_SELF. In the form there is just one file field called "image". I test if there's users im

Re: [PHP] HTML Question?

Jawohl :) "David Grant" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William, > > William Stokes wrote: >> How to print tables to a page so that they are placed side by side >> horizontally as long as there is screen width left and then con

[PHP] HTML Question?

Hello, This is totally HTML question but I had to post cause I can't get this one to work myself How to print tables to a page so that they are placed side by side horizontally as long as there is screen width left and then continue to second row below? Like in many image galleries where t

[PHP] absolute vs relative path?

Hello, I Have a web site on one server and a test site on another. How can I build the hyperlinks so that they work on both servers without modification. For example build this link dynamically: "http://www.domain.com/www/test.php In test server the same should be: "http://internalserver/www/te

Re: [PHP] phpmyadmin import

Thanks. Got that one changed to 8Mb. I ran into another issue though. I'm tryin to import a 2,5 Mb table. PhpMyAdmin import ends with fatal error while importing. Here's the error message. "Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 2247907 bytes) in /srv/ww

[PHP] phpmyadmin import

Hello, When importing data from file with phpmyadmin the file max size is 2 048kb. Can this be changed to accept larger files? It would be more convenient to import data to my test DB if this could be done via single file export/import. Thanks -Will -- PHP General Mailing List (http://www.ph

[PHP] reading variables?

Hello, The code below is from a document library I'm building. With this user can upload a file to server and the uploaded files are printed as links to same page. For each printed document there's a check box "Delete" for marking that document for deletion. The document info from DB is printed

[PHP] Image handling advice needed

Hello, I need to build an image 'library'. The library will consist mostly of images taken with digital cameras. Since unedited digicam pics will most likely be too big for web usage they need to be edited automatically so that they can be put to a web page. I'am trying to deside between two o

[PHP] input validation?

Hello, I need to check that user input text is less than 300 characters long. How? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Image size?

Cheers! :) ""Albert"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > William Stokes wrote: >> Can I get pixel sizes from a uploaded web applicable image with PHP? I >> mean width and height as pixels. If so How? > > http://www.php.

[PHP] Image size?

Hello, Can I get pixel sizes from a uploaded web applicable image with PHP? I mean width and height as pixels. If so How? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] test variable value?

Hello What is the best way to determine if a variable has no value? if ($var== '') or if ($var== 'null') Can 'null' be used here? Thanks -Willa -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] test variable value?

Hello What is the best way to determine if a variable has no value? if ($var= '') or if ($var= 'null') Can 'null' be used here? Thanks -Willa -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Image editing?

Hello, I might have to start doing some automated image editing or rezising with PHP. I've never done anything like this before so I would need some guidelines to get started. Basically what sections of the manual to read and what tools need to be installed to the server side to get things like

Re: [PHP] MySQL update killed my login...

Thanks! -W "M" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > It seems the upgrade was from Mysql 4.0. PASSWORD() function changed > between 4.0 and 4.1, it uses longer hashes now. You can still use > OLD_PASSWORD() function instead. > > William S

[PHP] MySQL update killed my login...

Hello, My ISP updated their MySQL DB to 5.0.18 and that killed my login procedure which was OK yesterday. Any ideas how to start to debug this? The login updates 2 fields in users table row where username and password macthes. This is the code: if (!$query = mysql_query("update tbl_users set

[PHP] SELECT?

Hello, I have one MySQL table with about 500 rows. I need to read the table one row at a time, make some changes to data in one field and then store the changed data to another table. I'm using PHP to change the data but I have no idea how to select one row at a time from the DB table. There's o

[PHP] Varchar "date" to real date?

Hello, This is propably a more of a MySQL question but here we go anyway... I have a DB that has dates stored in a table. The date field type is Varchar (don't ask why... :( The dates are stored using european date format DD.MM.. I need somehow convert the dates to the format MySQL uses (Y

Re: [PHP] Database problem?

"You should not generally code with a dependence on register_globals" OK. I have to consider that. Apparently the, ISP's production server has this setting "on". Don't know why... -Will "Jim Moseby" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] >> >> Damn! It Worked. Thanks :) >>

Re: [PHP] Database problem?

Damn! It Worked. Thanks :) "Jay Blanchard" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > [snip] > OK. Where can I change the register_globals setting? > [/snip] > > In the php.ini -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.ph

Re: [PHP] Database problem?

OK. Where can I change the register_globals setting? Thanks for the fast replies. -Will "Jay Blanchard" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > [snip] > http://localhost/index.php?team=F10a > > I have this in my page and it doesn't work: > $sql = "select jouk_nimi from x_jun

[PHP] Database problem?

Hello, This page works on a operator hosted production server but not my own test server. I have no idea what's causing this and I REALLY need some help or ideas what to check. This is the browsers address line: http://localhost/index.php?team=F10a I have this in my page and it doesn't work: $

[PHP] stupid (HTML) question

Embarrassed to ask but how to vertically align a table to a middle of a page? Forgot... ...didn't even find it with even Dreamweaver... :-0 -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Quidelines for Site visitor counter

Hello, I would like to add a visitor counter to my site. I know that there are plenty of free and nice applications/scripts for this avalable but I would like to write my own. I'm at the moment thinking either to make graphical or text based user interface for this statistics counter. So I'm as

Re: [PHP] sort by date

Thanks Richard. That did the trick. Now to the DB fixing business... -Will "Richard Lynch" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > On Thu, May 5, 2005 10:42 pm, William Stokes said: >> I made a mistake and stored date information to DB as varchar va

Re: [PHP] sort by date

OK. I found that out from MySQL manual. I just don't know how to insert the date formatting function to the query: I quessI need to put STR_TO_DATE() in to the following SQL query: SELECT event_id,name,date,time,place,type,info FROM test_table WHERE (group = '$group') AND (type = 'Game' OR type

[PHP] Re: sort by date

work cause it's a varchar field in the DB. Any idea how to put STR_TO_DATE() in to the following SQL query: SELECT event_id,name,date,time,place,type,info FROM test_table WHERE (group = '$group') AND (type = 'Game' OR type = 'training') ORDER BY date ASC Thanks a

[PHP] sort by date

Hello, I made a mistake and stored date information to DB as varchar values (dd.mm.yyy). When I read the DB is it still possible to sort the data by date with SQL query (ORDER BY date ASC)? Or is it nessessary to have the date information to be stored as a date in the DB? Will it work or is the

  1   2   >