Search results for query: *

Hi! Any ideas why this: mysql_select_db($database_MARTIN, $MARTIN); $query_CallsAssignedCount = "SELECT StaffID, count(CallID) FROM callinfo WHERE callinfo.StaffID = '$row_Leader1[StaffID]' GROUP BY StaffID ORDER BY CallID ASC"; $CallsAssignedCount = mysql_query($query_CallsAssignedCount...

Hi! Any ideas why this: mysql_select_db($database_MARTIN, $MARTIN); $query_CallsAssignedCount = "SELECT StaffID, count(CallID) FROM callinfo WHERE callinfo.StaffID = '$row_Leader1[StaffID]' GROUP BY StaffID ORDER BY CallID ASC"; $CallsAssignedCount = mysql_query($query_CallsAssignedCount...

Hi! Any ideas why this: mysql_select_db($database_MARTIN, $MARTIN); $query_CallsAssignedCount = "SELECT StaffID, count(CallID) FROM callinfo WHERE callinfo.StaffID = '$row_Leader1[StaffID]' GROUP BY StaffID ORDER BY CallID ASC"; $CallsAssignedCount = mysql_query($query_CallsAssignedCount...

Hello all, ok I want to query mySQL database for my web site. I have the columns StaffID, CallID and status in the DB. Status is either open or closed. StaffID is a list off all users, and finally callID is the call number they closed i.e. whether they closed call 1 or call 2 etc. So in my...

Is there a command in Dreamweaver MX that compares 2 text boxes, which will contain dates that are stored in MySQL. It will then print out all the dates that are inbetween them preferably underneath or on the next page. Cheers!

I have the following code: <script> if ViewRedCalls.fields.item("StaffID").value = "unassigned" then <tr bgcolor=red> else <tr> end if </script> What I want is for any records in my dinamic table (ViewRedCalls) that say "unassigned" to be written in RED. This code doesnt appear to be working...

Hello. I have a dynamic table that displays all calls that have been assigned a RED priority. There is a field in this table that show to whom the call has been assigned to. I want all records that say unassigned in this coloumn to be in RED. I thought this code would do it: <?php if...

If u use dynamic tables in Dreamwaever is there a way to say, IF a field in a row is called "unassigned" then change the text colour to red????????

Hello all! ok not sure if I am in the correct forum for this but I currently have a Voodoo 4 graphics card, not the best I know, I want to upgrade but I am VERY limited with money so aroung £60 is about right for me if not slightly cheaper!!!! My current graphics card has buffer errors etc when...

Not sure if I am on the correct forum here but I am using Dreamweaver MX. Anyway the problem is that I have a list of all the calls opened by users on the screen, all brought up from the DB using the Dynamic Table option. It all works great, I have 3 options at the end of each row: Modify...

Not sure if I am on the correct forum here but I am using Dreamweaver MX. Anyway the problem is that I have a list of all the calls opened by users on the screen, all brought up from the DB using the Dynamic Table option. It all works great, I have 3 options at the end of each row: Modify...

Any ideas how I create a BASIC datagrid, well at least I presume its a datagrid anyway, what I want is a list of all users in my database and then next to that an option to edit and delete them, is this easy and quick? I really could do with something like this? any ideas anyone! cheers all!

Is there a way to display all the records in the DB in a list/table and then having an option next to them to edit or delete them, I have heard its possible but really dunno how at all! cheers all!

Hello all! Back in thread434-775341 I was shown how to organise my code more efficiently, this helped a lot, however I am now having trouble reorganising another page to look similar to this one. I want the error messages to display when the user enters the information in incorrectly but its...

Every page appears to be working apart from one, it wont display the Client_ID cookie which is being passed through the pages, all other pages have no problems but this, I cannot locate the problem...? The page is designed so that the user can edit information stored in the DB about themselves...

Does anyone know wheather you can create graphs using PHP with your MySQL statistics? Just thinking of including something like this if possible, if it isnt is their any other method that can easily do this?

I want the user to be able to change their password if they choose too. I can get most of it working i.e. the user enters a new password (CPassword) and then confirms their password (ConfirmPassword) but I want to have the feature where they can put in their existing password as well (called...

I am not too good with javascript. How do I get the pages to come up if a user selects a particular list item. Each item has a different address. For example if the user selects &quot;Personnel Information&quot; then they will be directed to &quot;http://ModifyPersonnelInformation.php&quot...

Ok I am really stuck. I have posted this question b4 but I am still puzzled how to get this going. Basically I have a MYSql Database, I want the users details crossed checked against the database and then if correct have them logged in through sessions. However, I can do one or another but I...

Hopefully I can explain this question correctly. Ok I have a page with a list menu, from this list the user can select an option of which area they want to modify i.e. there personnel details, there hardware information etc. I want there selection to appear on the same page e.g. if they select...