Jump to content

gluck

Members
  • Posts

    216
  • Joined

  • Last visited

    Never

Everything posted by gluck

  1. If the user chooses to make the browser remember his username you wouldn't be able to do much.
  2. gluck

    query problem

    You can't do that. What are you planning to order the result set by? Can you explain what you want from the query?
  3. I think you should redesign your database. You can easily eliminate the two category_cross tables. Just add a foreign key in the artist and image tables as someone suggested. Actually you need 3 master tables - Artist, Image and Category. One cross table where you associate artists with images. Add category id just to image master table. Also I would keep image urls should in images because an artist will have multiple images.
  4. Normally you should get an API which would explain the process. Typically you need to create a request and send it to the url mentioned in the api. check this: http://www.ozekisms.com/php-sms-api-asp-sms-api/index_p_php_q_ow_page_number_e_327opt.html
  5. Ideally you should but not many of us do it. Guess thats why we are coding in php not Java.
  6. It looks that your insert is off on the column count.
  7. you can either build from source or use package manager: yum update should get your updates.
  8. www.esangum.com Any feedback would be welcome.
  9. http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html HERE IT IS: For all of you getting "can't return a result set in the given context" errors when using PHP to execute stored procedures, the mysql_connect flag is: mysql_connect( host, databaseuser,password,TRUE, 131074) Worked with mysql 5.0.20 and PHP 5.1.4 Also, stored procedures seem to close the connection when they've finished running in PHP. Can be fixed using mysql_ping( db_resource_id ) to reinstate lost connections
  10. Read on how to define mysql column names
  11. Not sure what you want to do but it seems all you need is either a temp table that can store CustID, ProductID, NUSDiscount, and OrderQuantity from the ShopCat and the OrderID. Once you are done with the transaction just select the record details from the temp table and insert them into your orders or whatever table and delete the temp entries.
  12. So what is the problem? All you need is the DB server name which was localhost before and would be yr DB-servername now. Create a DB user and set the access level based on your requirements. For the Java app. develop an app that is located on the Application server connecting to your DB server.
  13. gluck

    my.ini

    dude it depends what os you have. Just search for it if it is a windows box.. If linux use locate.. create a php file and use phpinfo() - this will return every thing about yr ini file.
  14. Someone can't download the php files without hacking or getting the credentials of your server. If you are worried about you page source then you can also encrypt the display.
  15. Dude I don't think you can do it with the mysql version you have. This needs to involve a programming language for that. Now with triggers you will looking at a before insert/update stmt. If you are firing an insert I believe you can just insert FULL and not AM/PM You know what just ensure the integrity via the programming language through the queries you fire.
  16. Check out the REPLACE stmt: http://dev.mysql.com/doc/refman/5.0/en/replace.html This does what you need. Your IF ELSE stmts are confusing.
  17. gluck

    Install mysql

    looks like you don't need to configure. Did you read the install file with the distribution? Normally it will have all the instructions.
  18. mwasif is correct .. I meant to type count(*)
  19. SELECT COUNT(*) AS countreservations,reserveddate,resourceid FROM RESERVATIONS_reservedresources GROUP BY reserveddate,resourceid having count(countreservations) > 1
  20. You need to join on a common field. Your security table and personal table should have a common field for the join to work. I assume in this case member id is the field. so your joining condition should have this: personal.member_id = security.member_id which means display the matching records in both tables for a particular id. SELECT * FROM personal A, security B WHERE A.member_id = B.member_id and B.member_id = '$SESS_MEMBER_ID' OR SELECT * FROM personal A join security B on A.member_id = B.member_id where B.member_id = '$SESS_MEMBER_ID' Use Aliases: A, B for tables.. this will make reading easy.
×
×
  • 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.