Search results for query: *

Thanks for the quick responses, il give sleipnir214's suggestion a shot and see how it goes. Cheers

I have a page with a coulple of forms which contain everything from radio buttons, check boxes, select lists and text boxes. I would like the user to have the option to save and exit at anytime, so if they have only done half a form they can save what they have done into the database and exit...

Thanks for the quick replies, i got it sorted with, $replace = str_replace("SA", "", $OldQuestionNumber);

I have variables pulled from a db which are similar to, SA1 SA2 SA3 i am trying to remove the SA from the variable so im just left with 1,2 etc Ive had a look at trim and split but unable to find a relevant example. Are those the correct methods to go about it and if so how? Thanks

I'm trying to find a way of receiving an 'ascii file' and transferring this automatically into an MySQL database, in order to form the basis for a web reporting webpage. Can this be done and if so how? Cheers

Thanks sleipnir214 for the code, i just added the select closing tag </select> at the end and it worked fine with the rest of the page. Thanks

I have a form starting with a drop down menu i.e. <select name="gangs" onchange="submit()"> <option value="">Select Gang...</option> <option value="A1">HanA - Shop 1</option> <option value="A2">HanA - Shop 2</option> <option value="B1">HanB - Shop 1</option> <option...

Thanks Itshim that done the trick. Have a star!

Thanks for the quick responses, Itshim, i have tried using it your way and it works ok if u change the status for every row but if you just change one row it resets the rows that were not set back to nothing? as the query returns UPDATE joblist SET LostTime = '' WHERE jobCode = 'RS976' Any...

I have 2 pages one displaying a form from a database, which allows a user to change the status of a job via a drop down box, see Page1.php code below Page1.php while($row = mysql_fetch_array($result)) { echo "<tr align='center'>\n"; extract($row); echo '<td> <select...

Sorry for the numerous postings but im tearing my hair out and i cant figure out why its not working, the output to the query $qry->numRows() in, MySQL = 1 (Which is what i expect) Oracle it returns Object id #6 (?) Thanks

How could i get around it? i have tried to use elseif ($qry->numRows() == -1) but to no avail...

Hi sem, It does not seem to fail it just seems to bypass the code, the line above has error checking with regards to the sql statement i.e. $qry = $db->query($sql); // Execute the query. if (DB::iserror($qry)) { die($qry->getMessage()); } but after that it just bybasses the statement...

No Problem, the table is customer with columns customerID and (clear-text) password, i.e. $sql = "SELECT * FROM customer WHERE customerID = '{$_SERVER['PHP_AUTH_USER']}' AND password = '{$_SERVER['PHP_AUTH_PW']}'"; Thanks

Im not to familiar with Oracle but i think the answer to what your asking is SQL*Plus...

Ok i will give it a shot, The SQL statement queries the username and password in the database if it can not find a match in any row (the number of rows = 0) and throws up an error {Script shown above works fine in MySQL} if it is correct, the number of rows = 1 and contiunes processing Cheers

I currently use the following bit of code to validate a user login which works fine in MySQL but to no avail in Oracle, could anyone tell me what the equilivent in oracle is of the line, if ($qry->numRows() == 0) if ($qry->numRows() == 0) //WORKS in MySQL { echo "Logon Failure\n"...

Ok i will look into it, thanks everyone.

So i presume this is where the problem lies!

There is not one with LoadModule and php in the same line, here is what there is. LoadModule access_module modules/mod_access.so LoadModule actions_module modules/mod_actions.so LoadModule alias_module modules/mod_alias.so LoadModule asis_module modules/mod_asis.so LoadModule auth_module...