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.