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.

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] Thanks, I got the html sorter and the page

Re: [PHP] Opera advice needed!

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: http://www.fcviikingit.com/new/testimenu.php

[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 ISP

[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.

[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

[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

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: img width=99 height=120 border=0 src=%s /', is not always the same. The image properties can vary. Thanks -Will Roman Neuhauser [EMAIL PROTECTED] kirjoitti

[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

Re: [PHP] web form data to arrays?

, 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 that all editable fields are put to arrays for updating them to DB. I have tried

Re: [PHP] web form data to arrays?

I got it working like this: $counter = 0; foreach ($arr as $value) { //make the form ... print input type=\text\ name=\ArrUpdate[$counter][]\ value =\$value[0]\\n; $counter++; } Now I have array $ArrUpdate which contains sub-arrays with the update data. This can now be processed with

[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] = 1

[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 (

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, I Have an array $toplevel containing arrays: Array ( [0] = 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] $POST Q

Hello, Can someone tell me what wrong or to how to manage this? //default $limitorig = 10; echo select name=\USRlimitorig\; echo option selected value=$limitorig/option; echo option10/option; echo option20/option; echo option30/option; echo input type=\submit\ name=\resetlimit\ value=\GO\;

[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

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 show to a visitor. User also has 2 form objecks

[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

[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

[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

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 any date and the calendar opens another page that displays

[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

[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 select menu, which page to edit. Then the selected page

[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

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 with

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 need javascript or something else for that? For example

[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

[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

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 may, go join an HTML/Javascript list for these questions

Re: [PHP] SQL query to array?

row while(list($key, $val) = each($tmp)) $Team[$key][$i] = $val; } // display the contents of the $Team array print_r($Team); ? On 4/26/06, William Stokes [EMAIL PROTECTED] wrote: Hello, Can someone please help me to put the results of a query to an array. Never done

Re: [PHP] sorting troubles

, 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 the number. Can this be done? Like A20 B17 B16 C15 C14 D13 D12 I

[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

[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 several forms in a page which is ok otherwise but the reset buttons doesn't clear

[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] 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 form name=AddNew method=post action=? $PHP_SELF ? $SomeVar =

[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

[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 to export the whole DB to text file and move the DB

[PHP] POST arrays?

Hello, How to post an array with associated values? This works ok ?php $arr_siirto = array(1,2,3); print_r($arr_siirto); $arse = $arr_siirto; print_r($arse); ? But if I post it to another form with this: input type=hidden name=arr_siirt_jouk value=?php echo $arse;? And print there with:

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 ?php $arr_siirto = array(1,2,3); print_r($arr_siirto); $arse = $arr_siirto; print_r($arse); ? But if I post it to another form

Re: [PHP] POST arrays?

value=?php echo $arr_siirto;? ? Which, to my great surprice, didn't work :) Thanks -Will Barry [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

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 PROTECTED] William Stokes wrote: Can someone help me to get

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: Why do you want to post it to itself? Why not use

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 not quite what was expected :) Here's the result a:3:{i:0;s:1

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 remove the single quotes [ ' ] ? From what? In fact, yes, almost certainly

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('1','2','3')); after removing the single quotes it started

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. BTW, can sessions and $POST be mixed? If yes is there any reason

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'm also shocked, but only mildly. BTW, can sessions and $POST be mixed

[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,

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); Note the underline between $ and P. Al Padley -- PHP

[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

[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

[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

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 1 is being added) can also be written as: $counter

[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

[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 available. 2006-02-24 12:00:00 against2006-02-24

[PHP] Re: menu Q

? William Stokes wrote: I have a select 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 bg image starts repeating itself. (looks nasty) It's

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 viestissä:[EMAIL PROTECTED] On 2/17/06, William Stokes

[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

[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 select 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

[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

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. Not alike? yes.

[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

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() it. Cheers, Rich -- http://www.corephp.co.uk Zend

[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

Re: [PHP] image uploads

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 100% sure that the image isn't re-loaded to server if user hits refresh? And he will cause

[PHP] PHP vars to JS?

Hello, How can I get my PHP variable values to a javascript? Here's the code: SCRIPT function btnOKClick($file) { DO STUFF TO IMAGE /SCRIPT input type=submit name=btnOK value=OK onClick=javascript:btnOKClick($txtFileName) BUTTON ID=btnCancel type=reset onClick=window.close();Cancel/BUTTON

[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

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 to post cause I can't get this one to work myself How to print tables

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. I

[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

[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

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 continue to second row below? Like in many image

[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:

[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

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

[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

[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

[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 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

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.net/manual/en/function.getimagesize.php HTH Albert

[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

[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

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 Stokes wrote: Hello, My ISP updated

[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

[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

[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:

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_jouk

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.php

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 :) Even so,

[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

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 values (dd.mm.yyy). When I read

[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

[PHP] Re: sort by date

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 lot -Will William Stokes [EMAIL PROTECTED] kirjoitti

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

  1   2   >