kamal213

Kool will giv it a try. Hav a nice weekend

Hi WebStyles, How have u been longtime no speak lol. Just change in the database from varchar to date. I have tried to post 02/09/2011 to the database but the date comes up as 0000-00-00. Do I also have to change the format of my php script as well? was kinda hoping I wouldnt have to do that

Hi Guys, I am to ordering list things by date from my database i.e. from 01/08/2011 to 31/08/2011. I now have dates which are next years date such as 05/01/2012 and 09/01/2011 and this is causing problems it doesnt order correctly. The date 05/01/2012 come right after 04/08/2011 and 09/01/2012 comes right after 08/08/2011 which is not what I want it to do. Is there any way I can put the dates in the proper order so the dates for next year appear mixed up with these years dates. Thanks

Kool I'll give it a go - fingers crossed it works Thanks

Thanks for your reply. Heres the error: Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 69 bytes) in C:\xampp\phpMyAdmin\libraries\PHPExcel\PHPExcel\Worksheet.php on line 983

Apologies I forgot to add that am using a xampp server as well. Thanks for you help

Hi Guys, I'm try to import a 1.7MB excel file in phpmyadmin but to no avail as it exceeds the max limit. I also have tried converting it to an CSV file but it says my field names are too long. Is there a way I increase the limit size in phpmyadmin to help me or any other ideas or am I just pretty much doomed? Thanks.

Its called a date picker..Thanks for that! it will help my search. Thanks

Hi Guys, Was wondering if you could help. I am trying to find on google, how to make a system where by you have a text field called date, you click on it and a pop-up callender appears asking you to choice/pick a date. Please can you tell me what its called and advice on getting one. Thanks

Oh go it working..the input name has to be the same for all three!! Thanks guys you are all masters!!! I salute sensei's!! Takecare!!!!

Sold!!!! I would rather prefer radio button. I suppose my next question would be how do you do this - since am an empty barrel lol Thanks

Hi guys, I am planing to use a 3 checkboxes e.g. (Yes, No, Maybe). Is it possible to make to if a user checks on one box e.g 'Yes' they cannot then check 'No and Maybe' i.e. disable two other boxes if one is selected for example. If its possible I would appreciate your help. Thanks alot

Correct! I just tried it out and I have been able to import!!!!!!! Thanks for your help

Thanks for your reply. Do I need to create another table in my database which has the field indentical to the excel file or is a case of clicking on LOAD DATA and it imports automatically? Thanks

Hi Guys, I would like to know if it is even possible to import an EXCEL file into you mysql database table. Thanks

Got ya, Thanks alot for you help

Thanks Webstyles, Assuming I get stuck would it be possible to send you a message if you won't be online?

Kool Webstyles, Do I also need to makesure the username is set by using the isset, or is this unnecesssary?

Thanks webstyles Can you help with ideas on how to code for this. would it be something along the line like this: <?php if(isset($_GET['user'])){ $user = preg_replace('#[^0-9]#i', '', $_GET['iser']); sql = mysql_query("SELECT * FROM preference WHERE user ='$user' LIMIT 1") } ?>

My situation is number 2 - Users can change their preferences to select their homepage (store selected page in database) How would I store the pages? by creating fields?

Hi Webstyle, Do you mean create fields for each page?

Hi webstyles, Yes ideally other user should have their own landing page. I guess your worked out my problems..I figured if I know how to do for 1 user I can do for all lol.

Hi guys, I have this login script below which redirects to the home page if the username and password are correct. <?php session_start(); if (!isset($_SESSION["manager"])) { header("location: user_login.php"); exit(); } // Be sure to check that this user SESSION value is in fact in the database $managerID = preg_replace('#[^0-9]#i', '', $_SESSION["id"]); // filter everything but numbers and letters $manager = preg_replace('#[^A-Za-z0-9]#i', '', $_SESSION["manager"]); // filter everything but numbers and letters $password = preg_replace('#[^A-Za-z0-9]#i', '', $_SESSION["password"]); // filter everything but numbers and letters // Run mySQL query to be sure that this person is an admin and that their password session var equals the database information // Connect to the MySQL database include "leadscript/connect_to_mysql.php"; $userdisplay = ""; $sql = mysql_query("SELECT * FROM user WHERE id='$managerID' AND username='$manager' AND password='$password' LIMIT 1"); // query the person // ------- MAKE SURE PERSON EXISTS IN DATABASE --------- $existCount = mysql_num_rows($sql); // count the row nums if ($existCount > 0) { // evaluate the count while($row = mysql_fetch_array($sql)){ $managerID = $row['id']; $manager = $row['username']; $userdisplay .= 'HELLO ' . $manager . ''; } } else { echo "No Permitted To Perform This Task Next."; exit(); } ?> Is it possible to make it redirect to another page if a specific user is login? and to the home page for other user. Thanks guys look forward to your help.

Muddy_Funster you are a genius problem solved! And agian I wasnt aware of the rules coz I didnt read them properly when I joined..am sure am not the only one tho, its like term and conditions not everyone reads all 2/3pages. I should have read the rules, I broke the rules and apologies to you and every1 in PHP Freaks including the staff. If you look at my POST you'll find I dont usually break rules and am not here to make trouble simply get advise. My problem is solved and again apologies for the confusion i cause u or any1 before thing get outta hand. Thanks

Never mind my code its not really important..I just wanted to know if it was possible. Seen it is possible.. How would you do it. Is it another SELECT sql query?