lional
-
Posts
271 -
Joined
-
Last visited
Everything posted by lional
-
They are runninh PHP5 with mysql version 4.1 What do you mean by sharing the code, I am fairly new to php so please explain Thanks a stack Lional
-
Hi All I have got the calendar to work but I have a small problem. The site I wrote is www.paternosterdunes.co.za. On the booking button there is a button to check for availability. This brings up this calendar program. My problem is that the live site does not go to the next month when the next button is pressed and the same for the previous button, but it works perfectly on my localhost. Any ideas what the problem can be, thanks Lional
-
Is it possible to do a join on more than one table eg $query = "SELECT * from personal_details JOIN ra_card_1 ON personal_details.member_no = ra_card_1.member_no AND form1.form1 ON personal_details.member_no = form.member_no WHERE form1.chapter_no = '$chapnum AND form1.form1 = 0'"; What I am trying to do is to select the member from personal_details table where that member is a member of a specific chapter that is specified in ra_card_1 table, but I also want to check if they have submitted their information and that is stored in the form1 table Is this possible and if it is, please give me some pointers on how to do it Thanks Lional
-
Hi All Just a quick question. I know it is possible to add formating to a telephone number, number but is it possible to remove formatting. I would like to take a number for example (011)555-5555 and change it to 115555555. is this possible Thanks Lional
-
Yes I am writing a web app and I do not want users going directly to the page by typing in the entire url, this way they will bypass the logging in phase Thanks Lional
-
Hi all I am trying to redirect but I do not want the address to be visible in the address bar. The user must not be able to see the address in any way. is it possibe, please see code below <? if ($username_out == $un && $password_out == $pw && $chapt_out == $ch && $lev < 5) { header ("Location: annual_return.php?source=1"); } else { header ("Location: index_failure.php"); } } ?> Any help will be appreciated Thanks Lional
-
Hi All I am trying to create a form that has five fields, when all the fields have been filled in and either tab or enter is hit, a new line must appear with the same 5 fields.. I would like the name and id of each input to be dynamically assigned. I am very new to javascript so i have no idea where to start. Could somebody please point me in the right direction here is my code so far: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Returns</title> </head> <body> <table summary=""> <tr> <td>Name</td> <td>Address</td> <td>Tel</td> <td>Fax</td> <td>Email Address</td> </tr> <tr> <td><input id="name" name="name" type="text" value=""></td> <td><input id="address" name="address" type="text"value=""></td> <td><input id="tel" name="tel" type="text"value=""></td> <td><input id="fax" name="fax" type="text"value=""></td> <td><input id="mail" name="mail" type="text"value=""></td> </tr> <td><input type="submit" name="submit" value="Submit" </table> </body> </html> Thanks Lional
-
Hi all, I am trying to create a form that will only display one line at a time, and when the user presses the enter key, a new line will appear if the previous one is completed. I have name. address, phone number one one line. Is there any way in php to accomplish this Thanks Lional
-
Hi All I need a bit of help I wrote a script to send mails using the php mail function. This was working fine until the service providers changed their security policies. The say I must add smtp authentication to my script, is this possible Appreciate any help Thanks Lional
-
Hi All I am trying to create a page that will run 4 seperate banners that must rotate every time the page s loaded. I would like the banners to e pulled from a Mysql database. I as thinking of having the database table with the following two fields banner number and banner file name Is this possible Thanks Lional
-
Hi All I am trying to write a page where I have a series of banners that I would like to change from one banner to the next after a predetermined time. Is this possible in PHP Thanks Lional
-
Goodday I would like to know if it is possible to write a script in PHP that will update the contacts in microsoft outlook. I am pulling company contact details from a mysql into a php page. I would like to have a button to update the outlook contacts. is this possible Thanks Lional
-
Is there another solution without using javascript. Let me explain the structure how it runs si far. 1) the user selects the category and subcategory and submits it to a page. If there are more than 6 listings on the new page the user can then streamline their search by entering the state/province. I would however only like to show the cities that are applicable to a state/proince but this must work everytime so I do not think that javascript is an option
-
If somebody turns off javascript o their browser will this ten stop functioning
-
Hi All I would like to write a little application where people enter their details in a catagory and a sub-category. They then enter their state/province as well as their city. What I want to write is to have two drop-down boxes, one with the state/province and another one with the city. It must only show the state/province for the selected category and sub-category, and it in turn must only how the cities for the state/province that has been selected. Can anyone give me some advice Thanks Lional
-
I am trying to create a drop-down box where the variables are pulled from a mysql table. The drop-down box is for cities that the client exists. The roblem that I am having is that there may be more than one entry of the same city if more than one client exists in the same city, but I only want one to appear in the drop-down box. How do I use PHP to only show one entry n the drop_down when multiple entries exist. Thanks Lional
-
Hi All I am trying to write a web application that will only run on 1 pc as a small Intranet that keeps a record of all clients. I would also like to store all notes, folders, images and voice messages in a folder for each client. Can PHP browse to a directory, to view the files in that directory and if a file is opened can it use the program that is associated with that file type to run that file. Windows XP is being used as the operating system Thanks Lional
-
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '\'deon\', \'gavin\', \'Room1\', \'Room2\', \'Room3\', \'Room4\'
-
Hi All I am getting this error #1064 - You have an error in your SQL syntax. I exported my database because I had to reload my machine, now when I want to import the data I get the following error. This happening with all of my databases. Please help Thanks Lional
-
Thanks Gingerrobot. It almost works, except if thjere is a booing for say 2006-10-27, 2006-10-28, and 2006-10-29 an I make a booking for 2006-10-28, 2006-10-29, and 2006-10-30, then it will accept the booking because the last dayis open. Am I doig something stupid Thanks Lional
-
Barend showed me how to update the database on July 02. Will your method stll do this or will it only take one day into account thanks lional
-
Thanks for the info Barand, it worked well for me The last check that I need to make, is that for every new booking I would first like to check on the database if the room is not already booked for and of the requested days. I have been trying my if statement but it is not working too well. Regards Lional
-
I want the background to be colored and not the font. Thanks for your reply but the problem I am having with the method you showed is that it only picks up the last date of the query as the one overwrites the previous one. Maybe I am doing something wrong Thanks lional
-
Thanks redarrow, I used that calender but the only probem I am still having is the changing of the backgroud colors. when I query the database, only the last date is shown because the pevious is overwritten by the new one. I am fairly new to PHP and I m sure that it is something small that I am doing wrong. please find a portion of my code include 'includes/conn_db.php'; $query = "SELECT * from availability"; $result = mysql_query($query, $conn); while ($row = mysql_fetch_array($result)){ $date_out = $row["booking_date"]; print $date_out; } if ($full_date_out == $date_out[date]) { echo "<td bgcolor=red><b> $day </b></td>"; } else { echo "<td bgcolor=#74f874><b> $day </b></td>"; } Thanks Lional
-
I fel the same ay, but I am nt sre how t pul a aray fom mysql. Cold you be so king to pint me in the right direction. thanks a lot Lional