Jump to content

gluck

Members
  • Posts

    216
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

gluck's Achievements

Newbie

Newbie (1/5)

0

Reputation

  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.
×
×
  • 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.