eskimmer

i have a column in a table which is varchar format but contains timedate type data eg. '24/7/07 05:32 PM'. I'm trying to run a query which uses a where clause to only return the rows where this column is equal to the most recent date. I've tried using the MAX() function which returns a valid result but not the most recent date.

Hi all!does any know how to load file into blob filed by sql script?

HiWhats the best way of stopping a double post from occurring? Re-directs?I was hoping that there was another way because I am using smarty and with the current setup of my site implementing redirects would be a right pain.Thanks for any help.

I need to add a facility on my customer's website so his clients can send him jobs, typically 5mb - 50mb. I've looked around the web and researched this, and tried a few tests (failed), but my brain's beginning to hurt. Could someone please tell me the best way to go about this, please. The site is done in Flash, but I'm sure a link to an html page would be ok if necessary.

I have package 1.Could you activate TOMCAT 5 for me, because i develop aplication with jsp and servlets Thank you in advance!

I'd like to have a postcode (zipcode for you US people) lookup automatically after a person enters a suburb (city) and state into a form. I can handle the mysql query and php code but how do I make the code execute _after_ the user enters the suburb and postcode but before they submit the form? Is there a way to control when the code executes so the user doesnt' have to submit before the code runs? I'd like them just to enter the suburb and then state and then have the post code enter automatically. Is this possible? Hints appreciated.

On an intranet I'm running php. apache and mysql. We use Windows logins. I have a form that users can submit. This will require a login. I would prefer to use the windows login and passwords. can I link to the windows authentication? The issue I see is when a user changes the password. My link would need to update the password

Hi,I have VPS (virtual private server) and I have access to php.ini file.Is there any script that will show that fsockopen function is enabled or where do I have to enable it?Searched google and here and couldn't find anything.Thanks!

Hi,I have apacher server installed already and was wondering if I can use it for Eclipse php testing. Is there a away to tell Eclipse php to use existing apache? I've looked in the preference of Eclipse and I can't find a standard apacher server (Apache HTTP Server Version 2.2); it has like tom cat and other servers.

Is there a good and efficient way of searching within previously searched records using PHP/MySql? I tried searching on google with several keywords like nested search, search within results, recursive search with PHP and MySql, haven't got a clue so far yet. But I thought it might be just storing previously queried sql statements and to a select on it each time the search button is called? Any ideas?

I want to use a different character set to allow my database to be used in Russian.Doing SHOW VARIABLES shows the character set koi8_ru is included. I tried to create a table using this but failed. I then tried an experiment and copied the following from the MYSQL online manual:CREATE DATABASE abcd CHARACTER SET latin1This also failed and gave me an error. I've tried every combination of quote marks and capitals and nothing works. Anyone any ideas?

Can database column names start with a number or must they start with a letter like php vars? Like my_table.1fieldname ?Does this vary from db system to db system? Is it considered good/bad form?

hi there,im working on a performance request system, and i have three tables that im working with right now. the performances table holds the info about the performance (date, times, status, etc.), and has two columns, org_type and org_id, which both hold an int value to tell me where the organization info is. there are two org types which have respective tables, because we collect different information based on the type of org that is registering. is there any way to select info from all three tables (dynamically selecting between the two org tables based on org_type, then selecting the proper org info based on org_id) in one query?what im using:mysql 5.0, MyISAM tablesphp 5.2

have a form that has a multiple select choice, like this: <form method="post" action="display.php"<select multiple name="selectsort[]"><option value="code">Code</option><option value="amount">Amount</option><option value="dateammended">Date Ammended</option><option value="expreviewdate">Expiration/Review Date</option><option value="effectivedate">Effective Date</option><option value="expired">Expired</option><option value="team">Issuing Team</option><option value="originate">OSL Originate</option></select></form> The display.php file runs a query that sorts the results based on the selection (sometimes multiple) made in the form. The display.php file looks something like this: $selectsort = $_POST['selectsort'];if( isset( $_POST['selectsort'] )) {$query = "SELECT * FROM contracts ORDER BY '{$_POST['selectsort']}' DESC";}$result = mysql_query($query); I then echo the information in a table. I get results, but it doesn't pay attention to multiple selections. It only orders by the last selection made. I can echo out the various selections and can see that the select part is working. echo "$selectsort[0] , $selectsort[1] , $selectsort[2], ........"How can use the selectsort[] array to order by the multiple selections? Notice from Plenoptic: ALL code posted must be put into [ CODE ] tags. Please review the Xisto ReadMe for more rules and guidelines as to not receive warnings.

Hello I am trying to write a script whereby I can pull an image out of one database table and display it in relation to its category_id in another table. I am using a my_sql join function that is joining the tables correctly, however it only shows the one same image from the top field of those combined rows on every single page. I need it display the image according to its category_id for that particular page. I am thinking I need to set variables to represent those specific rows but I'm not sure how to do that. Here is my code {$result = mysql_query("SELECTplacing_item_bid.category_id, category_master.icon_1FROMschool_auction.category_master, school_auction.placing_item_bidWHEREplacing_item_bid.category_id=category_master.category_id andcategory_master.icon_1=category_master.icon_1");$row = mysql_fetch_array( $result );$img=$row['icon_1'];list($width, $height, $type, $attr) = getimagesize("images/$img");$h=$height;$w=$width;if($h>200){$nh=200;$nw=($w/$h)*$nh;$h=$nh;$w=$nw;}if($w>160){$nw=160;$nh=($h/$w)*$nw;$h=$nh;$w=$nw;}?><img name="runimg" src="images/<? echo $row['icon_1'];?>"border=1 width=<?= $w; ?> height=<?=$h?> > Notice from Plenoptic: Xisto ReadMe Make sure that all code is put into the proper BBCode Tags.

Just thought this would be of extreme help to those who are planning to migrate to php5 and still continue using MySQL same way as before:.... to get mysql work with the php 5 copy /dll/libmySQL.dll to the directory where php 5 resides and copy the /extensions/php_mysql.dll to the directory where php.exe resides.(if you can't find the two above files probably you are using an old release of php 5.you should check for latest at :http://forums.xisto.com/no_longer_exists/) in additon uncomment extension line in php.ini and add the following code to a gnereal database file(dbcon.php) in my case and include it in each file which needs access to datanase. if (!class_exists('mysql')) {if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN')dl('php_mysql.dll');elsedl('php_mysql.so');} I tried to eliminate above code and leave php_mysql.dll in extensions directory. But it didn't work shouting the familiar dialouge: Unable to load ......

Hello, I want to know what permissions for PHP pages should be given on Apache web server so that PHP pages can be executed. If PHP pages are in a folder, what permissions should be given for that folder?

Hi all, I am sure all of you are great programers but First i am no code programmer i am just trying to learn to run my sites, will the problem is i got a code from the web to protect my files ,1st i want to know how to work it out then i will try other things but can't let it go without a fight thanx all php: <?php if ( ! defined( 'myname' ) ) { print "You cannot access this file directly."; exit(); } customer data here ?> now i can't access my files what is the method to access them all i want is to protect the file not to be opened directly but how to implement it in a frame or something like display the contents in a frame or echo the source code as the file is a customer data please i am stuck and can't launch this small site thanx in advance Notice from truefusion: All coding must go into the CODE bbcode

How should I hash passwords? Just use crypt? Use crypt with one of the other encryptions? Something else?

Hi, first, sorry about my english. i am a beginner with php and i have some question about writing files using php in a shared hosting. is a risk?, use database to store data is a better way? i just want make an interface (in php) that write the data in a .html extension file to show to everybody the html page and just the php interface is to the content manager. thanks in advance

I am relatively new with web design so I don't even know exactly what to ask here, but this can't be as hard as I am making it. I am a merchant and I want to pass just a few simple strings to the credit card processor: my merchant ID and pin, as well as a price and a few other simple variables. I want the merchant ID and pin to be invisible to the user.