-
Posts
216 -
Joined
-
Last visited
Never
Everything posted by gluck
-
If the user chooses to make the browser remember his username you wouldn't be able to do much.
-
You can't do that. What are you planning to order the result set by? Can you explain what you want from the query?
-
[SOLVED] Joing tables using a classs in the Zend Framework?
gluck replied to littlevisuals's topic in Frameworks
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. -
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
-
Ideally you should but not many of us do it. Guess thats why we are coding in php not Java.
-
i need the sql code for importing a .doc file into my database.
gluck replied to Orionsbelter's topic in MySQL Help
why did you save as a doc. rename as .sql and import -
[SOLVED] Importing CSV file exported from Excel Using phpMyAdmin
gluck replied to toxictoad's topic in MySQL Help
It looks that your insert is off on the column count. -
get LAMP on your local machine.
-
you can either build from source or use package manager: yum update should get your updates.
-
Easy problem for anyone familiar with PHP.
gluck replied to mat420's topic in PHP Installation and Configuration
Pick a tutorial or a book to kickstart. -
www.esangum.com Any feedback would be welcome.
-
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
-
Read on how to define mysql column names
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
looks like you don't need to configure. Did you read the install file with the distribution? Normally it will have all the instructions.
-
mwasif is correct .. I meant to type count(*)
-
SELECT COUNT(*) AS countreservations,reserveddate,resourceid FROM RESERVATIONS_reservedresources GROUP BY reserveddate,resourceid having count(countreservations) > 1
-
Use having clause
-
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.