703 Topics

Member Avatar for
Member Avatar for lcfjoertoft

I'm creating a search function for my program, and need some help with SQL. Until now I have been using simple SQL query like [CODE] "SELECT post1 FROW table1 WHERE a=b" [/CODE] and put it into arrays. Then using that info to do another query, put it into arrays, and …

Member Avatar for hericles
0
146
Member Avatar for RazorRamon

Ok i'm trying to build a forum with jquery ajax characteristics. Below is the html/jquery coding. And i know jquery is loaded because I did the [ICODE]alert(1);[/ICODE] inside the document ready and it worked. [CODE] <!doctype> <html> <head> <title>Shouts!</title> <script src="jquery.js"></script> <script> $(document).ready(function() { $("#messages").load(function('loadchat.php'); $("#post").submit(function(){ return false; }); }); …

Member Avatar for xylude
0
550
Member Avatar for RazorRamon

Can you all tell me the difference in these 2 codes? I'm trying to learn JQuery and ive seen this code below in the tutorials. [CODE] $DB->Query("Select * FROM time"); [/CODE] I'm use to coding queries like this. [CODE] $res = mysql_query("SELECT timestamp, name FROM time ORDER BY timestamp DESC"); …

Member Avatar for P0lT10n
0
147
Member Avatar for navybofus

Hello everyone! I have a problem trying to get a user to be able to query the database with only the fields and specifics they want. Basically... User logs in, browses through record entries and then wants to see how many of the entries are under the age of 21 …

Member Avatar for navybofus
0
263
Member Avatar for RazorRamon

I built a quick date time test page. The coding is below followed by its results. I'm entering the raw timestamp into table time because i want to be able to manipulate it once i show it (say if i want to show time and date using the same timestamp). …

Member Avatar for RazorRamon
0
306
Member Avatar for b89smith

I have a table similar to the one below: Month | Item | Qty | Cost of Items purchased Jun | 1 | 10 | 50 May | 1 | 5 | 0 Apr | 1 | 5 | -18 Mar | 1 | 7 | 0 Feb | 1 …

Member Avatar for b89smith
0
81
Member Avatar for joshuasanders

I'm trying to formulate the proper SQL query to pull a roster up on this database I was asked to produce for my kids' HS band. Arrghh. Any help would be great. I have 3 tables. [CODE][U]student[/U] student_ID {PK} first_name last_name email family_ID {FK} [U]family[/U] family_ID {PK} family_phone [U]adult[/U] adult_ID …

Member Avatar for joshuasanders
0
195
Member Avatar for daz_omega

I have had a look within daniweb and done google searches on this problem so hopefully I am not wasting anybodys time with this. The problem I am facing is that currently I am getting the results from a mysql database using an associative array but i need to be …

Member Avatar for daz_omega
0
1K
Member Avatar for arsalanghouri

what query should i write in c# with backend sql server for finding all purchases i did from george in a date range. from purchases table.

Member Avatar for hericles
0
64
Member Avatar for b89smith

I have a table with entries for different accounts and each account has different products listed in it with a date next to each entry. An example of the structure is below. Account | Product | Holding | Date A1 | Car1 | 2 | 2010-12-31 A1 | Car2 | …

Member Avatar for Ezzaral
0
172
Member Avatar for atfOnly

Hello people :) i'm trying to insert query result into 2 dimensional array i have tried the following way.. [CODE] $query=mysql_query("..."); while($row=mysql_fetch_array($query)){ for($i=0;$i<=$index;$i++){ if(isset($myarray[$i]['array1'])|| isset($myarray[$i]['array2'])){ array_unshift($myarray[$i]['array1'],$row['study_period']); array_unshift($myarray[$i]['array2'],$row['test']); }//endif }//endfor }//endwhile [/CODE] But, it failed i also tried.. [CODE] $query=mysql_query("..."); while($row=mysql_fetch_array($query)){ $myarray=array( array("array1"=>$row['study_period'],"array2"=>$row['test']) ); }//endwhile [/CODE] it failed too since it …

Member Avatar for atfOnly
0
255
Member Avatar for RazorRamon

Hello all, I'm trying to build a forum site. The code below works fine but I dont know how to catch it from the address bar. I'm having trouble finding tutorials to help me with this. viewtopics.php [CODE] echo "<tr bgcolor='#6698FF' ><td><a href='viewcomments.php?id=".$rows['topic']."'> ".$rows['topic']."</a></td><td>".$rows['username']."</td><td>".$rows['timestamp']."</td></tr>"; [/CODE] Address Bar [CODE] http://localhost/testsite/viewcomments.php?id=Cowboys%20Dancehall [/CODE] …

Member Avatar for RazorRamon
0
283
Member Avatar for knitex

So i have this problem with a database. Under a section Date of Birth there are about 110000 entries. There are some that just have the year, for example 1978, I'm wondering if there is a way where it can automatically put in /00/00 after the 1978? so it would …

Member Avatar for chuckc
0
270
Member Avatar for RazorRamon

Ok I am stumped. I am inserting the data fine into the table and database so i know its not the config.php nor opendb.php. I used a code like this before and it work, i've only altered the $sql, the td's, and the $rows[]. Table name is hotspots (all lower …

Member Avatar for IIM
0
623
Member Avatar for rpv_sen

Hi Friends i have some problem in update my dynamic text box value for particular id alone, i want to update only the 2 column fields into my database, i have used the below code. i am not able update the fields into my DB. Please help me to solve …

Member Avatar for rpv_sen
0
2K
Member Avatar for aspkiddy

Hi, I have some difficulty with my 'select' In my select/menu, I display all the options come from a table (table_db_email) in my database In this table ([B]tb_code_prmtn11_email[/B]) I have two field : [B]fld_email_id fld_name_email[/B] It works here is a code [CODE]<select name="email_adress_menu" id="email_adress_menu" class="valid" onchange="submit()"> <?php echo "<option selected=\"selected\" …

0
101
Member Avatar for drewpark88

Hey Guys, I have an "events" table in my DB and a "default_events" table also. Every day I display one event. I check to see if any rows in the "events" table match todays date and then display that event, if no events match by date, I check the "default_events" …

Member Avatar for drewpark88
1
115
Member Avatar for NuGG

I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!) Now I am trying to create a query that can add these spaces in automatically …

Member Avatar for ChrisPadgham
0
359
Member Avatar for c++_fem

Hi, Does anyone know how too solve this: I want to delete a row from database and I keep getting this error: [B]The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except when these data types are used with the LIKE …

Member Avatar for zmeditation1
0
137
Member Avatar for jeevanism

The case scenario is like I have to check all available usernames/names from the databases whenever I type the letters instanly. For example:- When type "je" in the userfield, it should show all combination of names starting with "je" inline. I am attaching a picture as sample. Its indian railway …

Member Avatar for urtrivedi
0
201
Member Avatar for sim08u

Hi guys i have an assignment and it's asking me to let the user enter data into one of three text boxes to search for something in a database it also has to show the results in a table and be hyperlinked to the next page being bookingdetail.php and the …

Member Avatar for urtrivedi
0
818
Member Avatar for tjfitz68

Hello, List below is a query that I need to somehow be able to modify so my results do not double the tblWorkOrder.iWorkOrderID rows. The reason it's happening is because the INNER join for the tblTechnician causes it to double the iWorkOrderID's when there are two or more technicians that …

Member Avatar for BitBlt
0
113
Member Avatar for StephNicolaou

Hey all, I have split an Access database not on the server. I have decided to VBA code the links, however I have reached a stall when attempted to VBA code the update query; updating the remote table with data from the local temporary table. I have tried multiple things …

Member Avatar for StephNicolaou
0
877
Member Avatar for Tunnleram

I've setup the ability for members to select their favorite games. I probably could have built this better from a database design point of view so I'm open to suggestions there. Aside from that I'm trying to build a query that provides me with counts of the games so I …

Member Avatar for pratik_garg
0
86
Member Avatar for hermanSA

Hi all, Sorry for the long post but i need to describe my problem properly to avoid confusion, i hope I have a table with users, and every user has a specific latitude and longitude coordinate. let say user Test_User is logged in and then he decides he wants to …

Member Avatar for hermanSA
0
180
Member Avatar for AMADH

Hello, I have a query, that I am trying to have a conditional statement for a variable that I will pass into the query. If I use one of the conditions it works, but if I try both I can't get it to work. I would appreciate any help. Thanks, …

Member Avatar for AMADH
0
123
Member Avatar for keyroche

This question is more specific than general. I understand SQL a good amount, and understand JOINs and UNIONs etc, but I am having a real problem with a query I need. I have three tables: [CODE] ITEM: ITEM_ID ITEM_NAME WISH: ITEM_ID CUST_ID SELL: ITEM_ID CUST_ID [/CODE] What I need from …

Member Avatar for keyroche
0
107
Member Avatar for michaelzip

Hi. I'm having a problem on deleting a record using a function on SQL. DELETE FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG' This query shows and error saying: Cannot group on fields selected with '*'. I tried adding a specific field, like this: DELETE ServiceID FROM tblServices GROUP BY ServiceID …

Member Avatar for crishlay
0
117
Member Avatar for doomfrawen

Hello friends. :(I have a problem but i don't know how to implement a solution. The problem is that the HDD's from two Windows Servers got corrupted [COLOR="red"](1.- Site Server, 2.- File Server)[/COLOR] and all the files PDF's and the main site(ASP) were unaccesible for a while, now i recovered …

Member Avatar for jkon
0
109
Member Avatar for klemme

Looking for an answer about how I can use relations in my DB, when a link is clicked. I have the main navigation in the top of the page, the table is called:"SUBJECTS", primary key is ID. I also have a local navigation in the left side of the page. …

Member Avatar for madCoder
0
155

The End.