Solution For 'repetition Control' (slideshow App. For Web)
Im currently developing a web portal wich will serve, as part, as a customizable slideshow presentation.
The user will have the option to select multiple galleries of images of different subjects, each gallery containing several images.
The slideshow's 'playlist' function plays a certain number of images from one gallery then moves on to the next on. I.e., the playlist have 200 galleries, and will display 5 images per gallery.
Its imperative to the system to have a 'image repetition free environment', to assure that, when a gallery that was previously displayed shows up again in the playlist, the next 5 images of that gallery wont be the same as the ones previously played.
Code:
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Database Solution
I volunteer for a non-for profit group and they have alot of names in a multiple databases. the problem is that some people are in multiple databases. and if they send out a mailing from multiple databases some people get 2 and 3 of the same thing. my idea was to either make or find a program that has everyone is 1 database and then make the people part of multiple groups. (ex: bill is part of group a and b and im doing a mailing from both group i only want 1 piece of mail to go to him). It can be a separate program or with access. that use access now but i cant figure out how to make my idea work.
View Replies !
View Related
Best Solution For Unique ID
For any db where you will be entering tons of data and want to create a unique ID for each row, whats the best way of creating a full proof unique ID. Ive used auto incr and md5 hash, I prefer using the auto incr since there are less characters to deal with. Id like to see what other people think
View Replies !
View Related
Solution For Installing MySQL On Mac OS X
Just in case anyone has the same problem. After a few hours, I found the solution for installing MySQL on Mac OS X. As well as a ton of other people, I was getting the error... Can't connect to local MySQL server through socket '/tmp/mysql.sock' Its a problem with permissions. Try this from the terminal, it worked for me... sudo chmod 1777 /tmp and sudo chown -R mysql:mysql /usr/local/mysql/data
View Replies !
View Related
Elegant MySQL Solution
This may be in the wrong forum, so if it is I apologize. I am trying to update multiple tables at once and was wondering if there is an easy way to combine three actions into one SQL statement. Below are examples of the three actions I am performing: mysql_query("UPDATE listings SET col1='value',col2='value2',col3='value3' WHERE id='4'"); mysql_query("DELETE FROM keywords WHERE id='15' AND id='16' AND id='17'"); mysql_query("INSERT INTO keywords (keyword,listing_id,added_on) VALUES ('key1','4','june 13, 2006'); As you can see, two tables, listings and keywords. Listings has a foreign key relationship with listings. Basically what is happening here is that people are updating a listing as well as the keywords associated with that listing.
View Replies !
View Related
WAMP Server Solution
I have been working as a LAMP Solution Developer where my technical specifications for the LAMP solutions are: Database backend server is MY SQL running in HP-UX (Hewlett Packard UniX) where I database composed of 9GB. My web server is running on WAMP’s version of Apache HTTP Web Server and my application server is running on WAMP’s PHP version and the platform running on the Web Server is Windows XP on the staging or testing environment. References I use is the wampserver.org The problem is when the client processes some reports from the Database by the PHP Web Page and generates reports through the Php, after 1 hour of validating it expires. Is there a script or an accelerator where I can use to increase the speed of the Php Page without having a page expire or the mysql table itself must be reduced so it can be easily accessed by a Php?
View Replies !
View Related
Duplicate Column Titles From Separate Tables.....solution Ideas?
The mysql query grabs a row of data from two tables, (1. content, 2. categories) the only problem is, the 'content' table contains a column called 'title' BUT the table 'categories' also contains a column called 'title' which contains different data. The mysql query is: SELECT a.*, cc.title FROM content AS a INNER JOIN categories AS cc ON cc.id = a.catid I'm using $row->title to grab the data but what i really need is something like: $row->a.title $row->cc.title I need to turn cc.title into something like cc.cat_title so i can have the data from a.title and cc.title separately.
View Replies !
View Related
Control Centre 0.8.10
I'm running mySQL V4.1 on XP Pro. I'm also using mySQL Control Centre 0.8.10 beta. I can shut a server down, but there's no UI (that I can find) to start it again. If I go run services.msc I can't get mySQL to stop, or restart as it times out.
View Replies !
View Related
Control Center
Getting the following message when I click on the MySQL shortcut on my desk top: Error Starting Program The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion numbers. A device attached to the system is not functioning. Have gotten both Dll's and stuck em in the system and program directory... nothing happening there. Would like to find out what "Rtlgetntversion numbers" is all about.
View Replies !
View Related
Control Max Time
Does anyone know of any parameters that can be set to control the maximum time limit mysql will allow a single query to run before timing out etc? Rather than let badly written queries run for long periods I would like to just abort them if they exceed a set amount of time. I know the php calling script should/could handle this with defensive coding etc. However, I'm not always in control of how other users write their scripts that interact with mysql.
View Replies !
View Related
Control Panel
i'm having some problems with my MySQL install. Firstlty when I installed MySQL I never got an icon of any kind within the control panel. I've been looking at tutorials of how to create a database and many of them use the control panel option as a starting point but I can't because MySQL is not present within the cPanel. Also when I click on the MySQLadmin.exe in the bin it does not open probably. It opens briefly- shows a black screen with decending text. It then dissappears completely after several seconds. It cannot be seen or opened in the tray
View Replies !
View Related
Transaction Control
I am a recent user in mysql and I'd like to know if I need control the transactions in java when I am using mysql. I am asking it because I have read the mysql already control the transactions automatically, that is, it automatically control the commit and roolback commands.
View Replies !
View Related
Flow Control
I worked with MSSQL, where I could easily do things like inserting a new record into a teble if the table is empty and updating an existing record otherwise. Is it possible in MySQL, and how? From what I have read about the IF operator, it does nothing but choose which result to return. But I need a branching operator that would choose which piece of code (SQL Script) to execute.
View Replies !
View Related
Remote Control
I have MySQL running on a desktop computer that I log into through logmein.com and this is not the best solution. How can I connect remotely to use the MySQL Command Line Client on my desktop so I don't have to wait so long for each line to appear? I should also point out that this computer is on my LAN, so I shouldn't have to configure the router. One problem I am running into right now is that when I try to make a new table, I keep getting error 1064 (42000) and I'm not sure why because everything looks correct. Code:
View Replies !
View Related
Revision Control
I've been searching the mysql forums and documentation for anwers to this to no avail..Is there any facility for revision control within mysql? I need to be able to have snapshots of a mysql database that users can modify, later merging those modifications in with the main database, similar to branching in cvs. Does something like this exist already? Is it doable by copying the database and then logging edit transactions on the copy? What about using the storage engine plugin for tracking modifications?
View Replies !
View Related
Control Flow
I am having a hard time with Control Flows which is what i think I need to solve my current problem. Below is a sample query dynamically built based on user screen selections. Notice that it attempts to JOIN 5 tables to fscenario. My problem is that fscenario.`fsce_comp` may or may not be NULL. Either way I need the record retrieved if all other criteria is met. If fscenario.`fsce_comp` is not NULL I want to display the corresponding fcomponent.`fcom_name`. If fscenario.`fsce_comp` is NULL, I still want to retrieve the record displaying nothing for the name. Bad explanation, so I hope you follow? Using the manual (http://dev.mysql.com/doc/refman/4.1/en/control-flow-functions.html) I have tried several IF, CASE, IFNULL structures. They all return records where fscenario.`fsce_comp` is populated and exclude the records where fscenario.`fsce_comp` is NULL. I guess I am not understanding how to implement the syntax......
View Replies !
View Related
Control Center On MAC OS
I am running MAC OS X 10.5. I am learning PHP and bought build your own database driven website using php & mysql. In this book they tell me to download the mysql cc - but it is old and outdated and i can't get it to work properly.
View Replies !
View Related
MySql Control Center
I am new to using the Control Center-0.9.2-beta. My problem is that I cannot seem to display more than 1000 rows in my result set when I know that there is 1534 rows. I know that it is a setting somewhere, but is it in MySql or in the Control Center somewhere. I am running this on a Windows 2000 machine.
View Replies !
View Related
Start Control Center
Getting the following message when I click on the MySQL shortcut on my desk top: Error Starting Program The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion numbers. A device attached to the system is not functioning. Have gotten both Dll's and stuck em in the system and program directory... nothing happening there. Would like to find out what "Rtlgetntversion numbers" is all about.
View Replies !
View Related
Control Flow Functions Using IF
In my table entries I have three columns - entid, userid and service and each time a user uses a service a new entry in the table is created. So the table could look something like this: Code: entid userid service 1 12 auto 2 12 comp 3 45 lubid 4 12 comp 5 67 vote I want to create an SQL statement that lets me select all the users that have entered the service comp >=1 times, and auto >=1 times. So with the above data only userid 12 should be returned. At present I have the SQL: Code: SELECT userid, count(service) as servicecount WHERE entid > 0 GROUP BY userid,service Then in a while loop I only select the userid's that have a count of comp >=1 and auto >=1. This takes a long time on big sets of data. Is there a way I can do this all in the SQL? I was looking into Code: COUNT(IF(service>1,1,NULL)) However can't specify which service this is....
View Replies !
View Related
Hosts Control Panel
I am using my hosts control panel to run a mysql sql statement to create a stored procedure. CREATE PROCEDURE usp_testerproc1() BEGIN SELECT * FROM tbl_users; END It returns the following error. #1064 - 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 'PROCEDURE usp_testerproc1() BEGIN SELECT * FROM tbl_users' at NOTE: I am writing this test sql due to the upload of my mysql.sql file failing on DROP PROCEDURE IF EXISTS 'usp_getusers'; It gave me pretty much the same error as above. The hosts are using mysql 4.x on their servers.
View Replies !
View Related
Control Query Parameters
save myself a lot of php by do something like as follows: if form values are a > 1 and b =1, then do the mysql query using 'a' value else if form values are a = 1 and b > 1, then do the mysql query using 'b' value else if form values are a=1 and b =1, then return value: " try again". Below, slightly more fully roughed out. If $_GET['keyword1']>1 & $_GET['keyword2=1'], do query "select * from content where '$_GET['keyword1']' = something " elseif $_GET['keyword1']=1 & $_GET['keyword2>1'], do query "select * from content where '$_GET['keyword2']' = somethingelse " elseif $_GET['keyword1']=1 & $_GET['keyword2=1'], return value " try again" Can this be done via mysql rather than rubbishing around w PHP, wh I like to keep to an absolute minimum.
View Replies !
View Related
Control Center :: Stuck And Hangs
I am trying to install MySQL Control Center for the first time (the latest version). I am using Windows XP. When I try running the setup routine, I get through all the prompts and when it starts to install, it gets stuck at the 'Initializing... ' screen. And it does not go any further. I cannot even cancel. the operation.
View Replies !
View Related
Control Center Confusing Hosts
I've got control center installed on my localhost machine where I piddle around with db's on my machine. Today I attempted to connect to another server to assist others in their db work. I inserted xxx.xxx.x.xx for my IP address (obviously I'm susbstituting my actual IP) and when I selected "text", I was echoed back the string: ERROR 1045: Access denied for user: 'xxxx@ooo.ooo.o.ooo' (using password: YES) The complex issue is this, I inserted xxx.xxx.x.xx as my host IP, but instead of using my host IP to test the connection, control center used my localhost IP.
View Replies !
View Related
Permissions In Mysql Control Center
I need to allow 3 different servers to access my MySQL Server. How do I do this? Also, I was told that having MySQL configured so it doesn't restrict access is bad - how do I make sure that's not the case?I feel like I know what they're saying, but I don't know how to actually implement this in the Control Center, and I must be using the wrong keywords because when I look it up, all I find is stuff on how to connect to the MySQL Server from my web page using php (which is what I'm using and already doing).
View Replies !
View Related
Could Not Connect To The Service Control Manager
I'm trying to run MySQL Server 4.1 on Windows Vista Beta 2. I was able to install the server before. But when I uninstalled and tried reinstalling, I got the following message at the end of the Instance Configuration Wizard: Could not connect to the Service Control Manager I got this message once before when I first tried to install MySQL on Vista Beta 1. Can anyone help me diagnose the problem?
View Replies !
View Related
How To Control Mysql In Hosting Server
I am a ASP programmer. I use MS Access for quite some time, and I am to switch to MySQL. The way I use Access is create tables in my computer and upload it. When I want to do backup, I will download it and make another copy locally. 1. How to create a MySQL DB and Upload it? 2. How to modify the DB structure? For example, create index for certain field? do I have to download it and change it locally? 2. How to download and make backup?
View Replies !
View Related
Any Db Design Of FIFO For Inventory Control
I am asked to do a job that's creating fifo (first in first out) for inventory control. There are many kinds of transaction such as: Goods purchasing, Return Goods Purchased, Moving Goods from one warehouse to another one, change the goods name (like from fresh tomatoes to rotten tomatoes), Selling (Invoice) and Credit Invoice (Return for Sales). I was so confused and I did a table like this: ...
View Replies !
View Related
Importing Tables Using MySQL Control Center
I am using Dreamweaver MX to create a data-driven web site. With the VPS hosting plan we're on, our remote FreeBSD server only supports the PHP application server. PHP requires MySql. Thus, I installed a copy of MySQL Control Center 0.9.2 beta. (I prefer a GUI and not command prompts unless necessary.) The information I plan on using in developing this site will be derived from a contact management program called GoldMine. The records will be exported into DBase tables, and somehow imported into the MySQL/PHP/Dreamweaver environment. From what I can gather so far, the MySQL environment I'm working under will not work with Access or DBase tables. Thus, I've created a new table in MySQL and re-created the various fields to match what I have in the DBase table. Now I want to import all the records I have in my DBase table. In fact, I will need to update the MySQL database weekly. So far, I have been successful in making all the connections work, except for importing the table into MySQL. In the MySQL Control Center, once you connect to the database, there is an option to import, but it is dimmed out. How do I make it work?
View Replies !
View Related
Control Center Showing Only 1000 Rows
I am new to using the Control Center-0.9.2-beta. My problem is that I cannot seem to display more than 1000 rows in my result set when I know that there is 1534 rows. I know that it is a setting somewhere, but is it in MySql or in the Control Center somewhere. I am running this on a Windows 2000 machine.
View Replies !
View Related
Speeding Up Boolean Search Control Syntax
When doing a FULLTEXT search on a table I have noticed that on average introducing wildcard boolean search control syntax slows down searches by up to 10-20 times longer than without it. For instance, if I want to search for both "keyboard" and "keyboards" so I perform a match against 'keyboard*' then just making that "s" optional takes my previously 0.08 second query to 2.6 seconds. Is there any way to speed up MySQL 5.0 so that such simple touches for improving result relevancy doesn't cause such a drain on the server and our visitor's patience?
View Replies !
View Related
What Parameter Control Mysql-bin Logs Size?
ls -althr Unix file system listing of bin files. 1.1G Mar 27 08:53 mysql-bin.000010 1.1G Mar 27 19:48 mysql-bin.000011 1.1G Mar 28 01:28 mysql-bin.000012 I see ALL my mysql-bin logs are about 1.1Gb in size and there must be an parameter that tell them to switch when It reaches this value but I can not see which parameter that controls this in ‘show variables’ or my.ctf - I would suspect it was max_binlog_size but the value does not come close to 1.1.G – do ANYBODY know what tells them to be 1.1G in size? mysql> show variables like '%bin%' ; ....
View Replies !
View Related
ERROR 1045 When Testing In The Control Center
In the MySQL Control Center 0.9.4-beta, I right click the top level server name and choose the Edit option. Then I have entered a User Name and a Password in the General TAB. I then mark the option "Promt for Password" and hit the "Test" button. I get a small window where I should enter the password for User name@Host name. I enter the password and hit the OK button. Now I get the error message "ERROR 1045; Access denied for user; 'User name@Host name' (Using password: YES)" When looking in the Help menu, the Contents - F1 is not activated, so I can't get any online help. I'm just wondering why the test for the password failed and why there are no online help in the consol?
View Replies !
View Related
Control Center Connect Network/router
I can access my MySQL database with MySQL Control Center from a computer with a direct connection to the internet, but I can't do it from my other computer on a network. Is there a way to use MySQL Command Center through a network/router? I'm unable to find any connection settings options in the program.
View Replies !
View Related
How To Control Number Decimal Places Displayed?
I would like to select the value of a decimal(7,2) column and display it as either int or decimal(7,2), based on the value of another column. It seems that either the cast or the format function should do that for me. But both functions seem to require a constant for the second argument. select format(m,2) from foo; # works select format(m,sf) from foo; # error select cast(n2 AS decimal(9,1)) from foo; # works select cast(m AS decimal(9,sf)) from foo; # error It seems strange to me that these functions demand a constant. How can I accomplish this? Do I have to convert to string and use string search and replace functions (ugly).
View Replies !
View Related
Local Remote Command Control For Mysql?
ok, My website is hosted remotely onto my Web Hosting company. and i want to control MySQL remotely or locally in my computer without using PHPMyAdmin. I notice using PHPMyAdmin is very tiresome and also i'm thinking if there is a good alternative for PHPMyadmin so that i don't need to enter my CPANEL website everytime i do the work using PHPMyadmin. I'm thinking perhaps just like Microsoft Express/Outlook functionality instead of opening my Yahoo emaail account they will be sending the incoming and outgoing messages into my email automatically. This are the features that i'm looking for as an alternative for PHPMyAdmin.
View Replies !
View Related
Access Control Via A Role Based Security Model
I am trying to develop a web based database application to manage a Scout group. I need to control the level of access different visitors to the site are allowed to different parts of the database. I need to provide public information, including some contact details from the database, to unauthenticated (non-member) users and to provide a scale of access to more information for authenticated members. The access model would be similar to the following: Role name Access public group leader contact details member read own details, update some details, read contact information for all other members leader as for member plus update youth member progress records mmbrship secy update financial details for all members group leader access all areas The mySQL manual shows this can be managed by granting privileges to individual users based on columns in the various tables. Can I do it using a role-based model where I assign one or more of the above roles to a user and grant the privileges to the role?
View Replies !
View Related
Control Center :: GUI To Connect To A Remote Mysql Database
I'm trying to get the GUI to connect to a remote mysql database from my client machine. What is the proper syntax for this in the GUI? I have tried everything with no luck: using the ip of the host, using the complete dns hostname of the host, using root as the user, using root@hostname as the user. I keep getting access denied for every attempt. I'm sure I am using the correct password.
View Replies !
View Related
|
TRACKER
