Jump to content

Enormity

New Members
  • Posts

    9
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Enormity's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Well, I ended up fixing it... I just took out the delimiter... I don't know why that would work, or why I didn't try that before. The query looks like this now. $db->Q(" CREATE PROCEDURE `Database`.`Procedure_Name`(in sp_uid mediumint(20) unsigned, in sp_user varchar(15), in sp_pass varchar(20), in sp_email varchar(30)) BEGIN Insert Into Table Values (sp_uid, sp_user, md5(sp_pass), sp_email, '1', '1', '0'); Select true; END ");
  2. Yes, but the error is of no help. 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 'DELIMITER $$ CREATE PROCEDURE `U_C_D`.`Admin_Login_Create`(in sp_uid mediumin' at line 1
  3. I am trying to make a setup file for a website I'm developing, and am having the database tables and stored procedures created automatically. However, I'm having issue getting the stored procedures to be created. Here is my code: $db->Q(" DELIMITER $$ CREATE PROCEDURE `Database`.`Procedure_Name`(in sp_uid mediumint(20) unsigned, in sp_user varchar(15), in sp_pass varchar(20), in sp_email varchar(30)) BEGIN Insert Into Table Values (sp_uid, sp_user, md5(sp_pass), sp_email, '1', '1', '0'); Select true; END$$ "); Assume that the "$db->Q()" works just fine, as I'm having issues no where else with it. This automatically connects to the database and runs a query with whatever is inside the "()". The tables are being created just fine, but no stored procedures are being created. I've tried everything I can think of, and googled my question many different ways without finding an answer or work-through. Does anyone know what I am doing wrong? Thanks in advance.
  4. You want the entire script for the form as well as the entire code for the page that handles it?
  5. Are you trying to get this form to submit itself to index.php? Or do you mean you just need to be redirected back to the index page once the script you are sending the form information to runs?
  6. Wow... That's not cool. So then destroying the element completely and recreating it would be the only way on IE to make the type "password"?
  7. Hi, I am using the following code on my website (temporarily set up at partyparadiseohio.com) to change the input element's type for my password field, and to change the value to nothing. (Right now, it says "Password" in the input box.) document.getElementById(obj).value = ""; document.getElementById(obj).type = "password"; This code works just fine on Firefox (of course), but does not change the element type on Internet Explorer. Looking up other examples, they all show to do it like I have. Can IE just not do this for some reason, or is there other code to do this on IE? Thanks in advance.
  8. If that was the case, shouldn't there be a way that I can change my script to be processed more efficiently by the browsers so that it would eliminate the lagged scrolling?
  9. Alright, I have a problem with my website where it scrolls really slow. It's as it there is too much information for the web browser to process all at once. When I am on windows, it works fine for me, but when I am on fedora, it is slow. Others have also told me that it goes really slow for them. I am thinking that it has something to do with the way I am using variables, but I am not sure. My other sites do not have this problem, and I do not use variables or databases on them. They are just static sites. So I figure if it is not the variables, it is the SQL calls. Can someone tell me how I would check these to find out what is slowing my site down so much? For reference, my website is http://vgt-central.com Thanks for any help you are able to provide.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.