Search results

im storing them as strings. cause if i store as integers they wont register the 0 infront.

if you use int the zeros infront will not appear

Hello. i have a column in my database which stores values starting with 0. i've used varchar to store it so the zero shows up. however everytime i backup my database table using CSV for microsoft excel, the file opens without the zero infront. Is there any way i can prevent this so that when i...

ok thank you so much for your replies. i will study them carefully. thanks!

Hi, i was wondering if it is possible to use a php include within a while loop. like this. i tried it but the results are not showing. i only get the first result from the query. <?php while($data = mysql_fetch_array($result)) {?> <div id="resultswrapper"> <?php $path =...

thanks for correcting my mistakes. i will look through everything you posted thoroughly again.

Thank you so much for replying. i've written a code to prevent session hijacking but it doesnt seem to be working. everytime a user succesfully logs in this script is executed. $session = uniqid(); $_SESSION['session'] = $session; $query = " UPDATE table SET session =...

hi i have been thinking about this for quite some time. can session variables be tampered with? if i have a code like this on any members page if (!isset($_SESSION['userid']) {echo 'You need to log in first before viewing this page';} will this be anyway subjected to any form of unwanted...

Thank you so much for taking time to reply my questions. i've learnt a great deal. thank you.

Hi i've came across several threads but couldnt really find the answers. there are quite a few doubts i have regarding mysql injections. pardon me if the questions seem too easy or stupid. here are some examples. 1. Are queries comparatively safer from sql injections if the parameters are...

Sorry i thought since you all were on this topic, i shouldnt create a new similar thread. i will keep that in mind.

thanks for the reply. im using version 4.1.249.1045. i managed to solve the problem with the random question script though. thank you so much for your time.

pardon me for the intrusion. im just wondering that is it only with GET methods from url or values you retrieve from submitted forms to make a query that Sql injection occurs? if a page only connects to the database to retrieve information but doesnt allow the user to key in any values of any...

hello. i was thinking of adding the random question script to my website's registration page as found in the search function of this forum. however i noticed something amiss. whenever i view the source code, the random question in the source code is different from the one displayed in the...

sorry so much for the trouble and confusion. i've solved it. thank you very much for your replies.

hi im new to web designing. i've created a website with multiple sub-folders. for all the webpages i have a navigation bar which contains images. i've tired using SSI to link the navigation.shtml file but didnt work. php include worked for me. however the images dont appear correctly since...

Ok thank you so much for your replies. =)

Hi im creating a comment page for my website using php. i've been using mysql_real_escape_string. i know this isnt enough to prevent mysql injection but is there a way i could go about doing this cause words like member's gets escaped with a backslash when i show the comment. thanks...

hi i've submitted a support ticket using my premium account more than 12 hrs ago regarding the transfer of my database from the free hosting account to the premium account and i have yet to recieve any reply. my ticket number is #893515 could someone please help me in this. thank you very much.

ok thank you very much for your reply.