Experts,
Quick function syntax question...
I know that the MIN function can return the lowest number.
Select MIN(Score) from tblTEST where ID = $ID;
How would I modify the above funct...
How do I write this query correctly for the attached dataset?
I want to select TEXT from ANSWER where R_NUMBER = 5 and Q_ID = 'Q_41' or Q_ID = 'Q_42' (i will have several more of these, but...
Hello,
I want to insert information input from a PHP form into 2 different DB table using ; mysql_query("INSERT INTO table name (column name) VALUES (column value)");
One will put all of...
I have 3 tables,
Customer
-----------
customer_id
name
Custom_Fields
-----------
field_id
name_of_field
Saved_Customer_Fields
-----------
id
field_id
customer_id
data
Im...
I've got a line returned from a query that will not return while inside of a text area, but will appear if queried for outside of the textarea. Is my formatting within the textarea properties...
My website that uses drupal has been down since yesterday and all it displays is this error:
Fatal error: Duplicate entry 'b7c59e0ea3545b9b42b8372e87cee12e' for key 1 query: INSERT INTO ses...
Hi!
I have a file with usernames, one on each line. Around 1500-2000 usernames in the file.
I need the following PHP script to be done:
The script makes a connection to mySQL, and creates...
hi experts,
I am trying to get result from 2 tables as shown in the code snippet
how can I do that plz?
thx.
My website is not working, you can see the error at www.exactreplicas.com and www.exactreplicas.com/admin. Let me know what is wrong
Hi,
I have a mysql db on the site server, and add/update it thru a php webpage, two of the db fields are time related, I put the 'datetime' for the type, but it becomes cumbersome to each t...
I'm trying to build search bar, which narrows down results by country, province and then city,
In the countries table I have only 2 countries, 2 provinces and 4 cities. It's not too big, how...
when a user logs onto a forum how could i show them/find out that a new post has been made since there last visit...
ok i store the users last post time exct in db... so im not sure how to ...
that what simple i need ! to display one decimal only how can i do it , thanks.
I have a script that lists transactions grouped by entity. I would like total for expenses after each group. I tried the following but I get the error message Incorrect usage of UNION and OR...
I've attached my code, the problem is
.$row['dated'].
turns in Aug - 1st, 2008, I would like it to be 08/01/2008 or something similar...
I am creating a form to add records to a database, I am creating 2 identical drop down menu's created from the same data from a database. One of them works, the other doesn't however they are ...
Hi,
I want to display a list of articles I have stored in a database in groups of 10 on the website... like this:
Article 1
Article 2
.....
Article 10
Next (link)
Article 11
.....
I have four tables that have same fields
field names are field1 , field2, field3, field 4
I need to count the number of rows in all the tables and then I need to do some calculations on ...
I have this code that I am trying to get the daa out of. The problem is that its not giving me any values. I need some help with syntax here
Thanks
The following Error Messages appear in Firefox:
missing ; before statement
var liste2=new Array(6);n for(var i=0...te2[i]=new Array(2);n liste2[0][0]='1';\n
update_suchbegriff2 is not de...
Hi
I don't have console or command line access to my DB host server, but I can install any web based solution or desktop solution.
I am looking for a tool that will allow me to move DB's e...
I've attached to pics. one with the iE view of my form and one is the FF view. How to do i get the radio buttons to appear as they do in the IE view? The code used to rendor the buttons the...
Hello,
I am trying to verify whether input from a text field matches an item in a list of acceptable values.
Unfortunately, I can't use a list in the form because the field needs to be ver...
I have the current code in my page that automatically displays the matching image. I neeed to build php code so that it also checks for and displays a <img> tage for additional photos appende...
I have the function below. When I enter it in the form without using function my values for the dropdown menu get recorded in db. However when I try to use it in function like this
<?php drop...
