I am querying a MYSQL database and would like to return the results so that all of the job numbers that are the same are grouped together and expandable when clicking on the common name. so when the bag loads all you see is a list of job numbers. I have tried lots but nothing seems to work please help. Code is attached along with screen shot of MYSQL data <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>IPL - International Procurement And Logistics</title> <link rel="stylesheet" href="../styles/login.css" media="all" /> </head> <body> <div …

Member Avatar
Member Avatar
+0 forum 2

Hi there I'm creating an invoice generator program, first the user must enter the number of products to diplay on a pdf file, below are my codes. My proble is, this if statement does not run as expected Private Sub Add_New_Order_Item_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim sNumber As String Dim iNumber As Integer sNumber = InputBox("Enter a number", "Numbers Only", iNumber) If IsNumeric(iNumber = 1) Then GroupBox1.Visible = True ElseIf IsNumeric(iNumber = 2) Then GroupBox1.Visible = True GroupBox2.Visible = True ElseIf IsNumeric(iNumber = 2) Then GroupBox1.Visible = True GroupBox2.Visible = True GroupBox3.Visible = True ElseIf …

Member Avatar
Member Avatar
+0 forum 4

I'm not going to rave or rant about these results, just present them: ![election.PNG](/attachments/large/0/f75f76bdc2b7331e408e8157d9bb4cf7.PNG "align-center") There are 650 seats in the House of Commons: * 18 for Northen Ireland * 59 for Scotland * 40 for Wales * 553 for England One country voted for this Conservative government. We're all getting what they deserve, like it or not. If this isn't a premise for the break up of the UK I don't know what is.

Member Avatar
Member Avatar
+0 forum 15

Is anyone annoyed by google results as regularly as I am? We are approaching a sum "0" when it comes to search engines, I'd hate to see google fall by the way of Wal-mart in that it's the only choice and it sucks. With that premiss, shouldn't we have ways to filter our searches? For example; if you're searching for hints on php programming, you will undoubtedly get some good results from stackoverflow, but in this case the information is too technical for your inquiry, it would be nice if you could do a search with omissions. Furthermore, it goes …

Member Avatar
Member Avatar
+0 forum 5

so, im trying to make a simple funtion to see if there is a file in a folder. been looking everywhere but havent found one that worked out. annnnnnnnnnnnnd code snippet: ` WIN32_FIND_DATA FindFileData; HANDLE hFind; hFind = FindFirstFile(_T"C:\\Dev-Cpp\\notes", &FindFileData); if (hFind == INVALID_HANDLE_VALUE) { cout << "No File found\n"; } else { cout << "Guess I found a File\n"; } well, the function comes up with no errors but if the file is empty it says that it found a file. can someone tell me what am i not seeing?

Member Avatar
Member Avatar
+0 forum 7

Hi there, I have 3 tables to extract data from. My query thus far is: SELECT `ministry`.`pm_name` AS 'Name', DATE_FORMAT(`ministry`.`min_begin`, '%Y') AS 'Election Year', `ministry`.`party` AS 'Party Led', `deputy_name` AS 'Deputy PM', COUNT(DISTINCT `ministry`.`min_begin`) AS 'Times Elected PM', `GG_name` as 'GG Name', `gg_title` as 'GG Title' FROM `ministry` JOIN `deputy_pm` ON `ministry`.`min_nr` = `deputy_pm`.`min_nr` LEFT JOIN `governor_general` ON `ministry`.`pm_name` = `governor_general`.`pm_name` WHERE `min_begin` <= '1930-01-01' AND `ministry`.`party` <> 'ALP' GROUP BY `ministry`.`pm_name` Which returns the correct results of 7 rows. However the 7th row, in the GG_name and GG_title fields are null. This is because in the governor_general table there …

Member Avatar
Member Avatar
+0 forum 1

Hello, i want to change te result of showing in the browser, now it shows this when i click 2 3 4 or next. Search+source+code&page=36 Search+source+code&page=72 Search+source+code&page=108 and i want to change it to this, Search+source+code&page=2 Search+source+code&page=3 Search+source+code&page=4 If i change $per_page = 36; to $per_page = 1; than works everything fine but than i dont have 36 videos but 1. and i want to show 36 videos, here below is the complete script. <?php $button = $_GET ["submit"]; $search = $_GET ["search"]; if(strlen($search)<=1) echo "Search term too short"; else{ echo "You searched for <b>$search</b> <hr size='1'></br>"; mysql_connect("mysql_host_name","mysql_username","mysql_password"); mysql_select_db("database_name"); $search_exploded …

Member Avatar
Member Avatar
+0 forum 9

The question of what actually triggers a 7-result SERP is definitely complicated, especially as Google expands into Knowledge Graph and advanced forms of entity association. There's definitely no simple on-page SEO trick to get the 7-result SERP

Member Avatar
Member Avatar
+0 forum 6

Okay, I dont have any code for this I am just not sure at all on how to do what I want. I have a website which displays pictures. There are albums and when you search the album it brings up all the pictures of that album. Now lets say my website only displays 12 images on my wesbite, but the album contains 20 pictures. How can I get the extra 8 images to be placed on a second result page so when they click page 2 of 2 it displays the other 8 images?

Member Avatar
Member Avatar
+0 forum 7

Hi all, I'm currently putting together a search engine for my website, and so far, everything is going pretty smoothly. The only thing left that I would like to do is when the search results are displayed, I want to be able to highlight the search term entered in the page that displays the results of the query. For example, if I search for the term "dog grooming", here is a possible result, with the term "dog grooming" bolded: > "Acme **Dog Grooming** offers the finest and most affordable **dog grooming** service in your area. Contact us at (555)123-4567 for …

Member Avatar
Member Avatar
+0 forum 4

SELECT t.* FROM (SELECT * FROM jobs WHERE `status` IN (0,1,2,3) ORDER BY `status` DESC, job_datetime LIMIT 11, 20) AS t That's a cut down sample of my sql. It was more complicated, but I've pared it down to this just to see why I was getting some strange numbers for pagination (e.g. 10 records per page). The above returns 12 records. With the LIMIT clause on the outside, it works as expected, but that's not something I'm able to do as I need to limit the subquery for additional joins later on. Can somebody shed some light on this …

Member Avatar
Member Avatar
+0 forum 3

when i search something in the database it doesn't show me what is in the databese how to connect into it or it doesnt show what is in it????

Member Avatar
Member Avatar
-2 forum 20

So im trying to make a password login and im getting errors. i got past my Unable to jump to row 0 error with this: **mysql_num_rows($result) >= 1** but now it wont jump to the row when the password is correct ether :/ here is the code; whats wrong with it? $result = mysql_query("SELECT * FROM users WHERE CallSign LIKE '".$_POST['signin']."'"); $result1 = mysql_query("SELECT * FROM users WHERE Password1 LIKE '".$_POST['password']."'"); if (mysql_num_rows($result) >= 1 || mysql_num_rows($result1) >= 1) { die('Could not connect: ' . mysql_error()); } else if (mysql_result($result, 0) == mysql_result($result1, 0)) { echo "<br>CallSign matches password"; setcookie("user", …

Member Avatar
Member Avatar
+0 forum 3

Hi all, I'm having difficulty with a function I've written. What it does, is creates a standardised list of Options Value's in a Selector for HTML. The value of the MySQL query is then used as the value, but for some reason, I'm getting an error in the code. If you could take a look and try to make sense of it; that would be extremely awesome. The error seems to be that $optionVal appears to already have a value - as though it's the last result pulled from the database. The ORIGINAL function (see below) works perfectly on the …

Member Avatar
Member Avatar
+1 forum 2

hello ! I'm working on a Registry page for my webSite in ASP and I'm trying to get results of a prcedure from my database which is checking if there is any duplicates of loginNames or emails when there is inserting to Dbase. The problem is I can't finde any functions to get this results in asp.ne/C#t. Have any one such a problem, or knows how to do this ? Thanks for any help.

Member Avatar
Member Avatar
+0 forum 2

Hey Everyone. Im using jquery's Validation plugin to check post values before I submit a form. Im trying to check a mysql table column to match user name to check for a duplicate name before submitting. This snippet of code below works as expected.. [CODE]<?php $request = trim(strtolower($_REQUEST['login'])); //sleep(2); usleep(150000); $users = array('asdf', 'Peter', 'Peter2', 'George'); $valid = 'true'; foreach($users as $user) { if( strtolower($user) == $request ) $valid = 'false'; } echo $valid; ?>[/CODE] Im just wondering how I could get mysql results into that array there. Ive tried something like below.. [CODE] $request = trim(strtolower($_REQUEST['login'])); //sleep(2); usleep(150000); $users …

Member Avatar
Member Avatar
+0 forum 2

Good Morning, I have an ever growing member database that is currently at around 6000 (developed over the past 2 weeks), and expect it to be in the hundreds of thousands within a few more weeks... My problem is that alot of members are using a single email address for multiple members, and I would like to limit the emails that we send out to just 1 per email address to save on the email load and time... Here is my query: SELECT user, pass, email FROM members WHERE mem_status <>'T' ORDER BY email asc"; What do I need to …

Member Avatar
Member Avatar
+0 forum 3

Hi everyone, I need a wee bit of help with the following. I am calling all country names from a db table and echo-ing out each country name in a list format. $query = "select * from countries order by Country Desc"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo $row['Country']; echo "<br />"; } this gives me a list of country names from the database, what I would like to do is have the list look like the following. ["country name 1", "country name 2", "country name 3", "country name 4"] How can I acheive this, thanks

Member Avatar
Member Avatar
+0 forum 2

Hi i was just wondering how i would do this task. It seems fairly simple but i dont no how to to do it. In my system i have a table where i have a total figure of the stock. what i am trying to do is when my saler order takes 5 i want it to project this in my overal amount. How would i do this. I am not asking for codes just a method of doing it Thank you

Member Avatar
Member Avatar
+0 forum 7

I have a basic search result page going right now, but i want the code to generate a html link on the search name so I can see all the data associated with the customer name. I have a simple DB set up with Customer Name, Computer type, Model, etc. The search does show the name and if there is multiple in there for the customer but I am stuck on how to make the name clickable and show all the results of the DB for that user. Here is the search code: [CODE=PHP] <?php // Get the search variable …

Member Avatar
Member Avatar
+0 forum 17

I have attached an image to the post.I want my site to come up in the search results as such ...please advise me what i should do ?

Member Avatar
Member Avatar
+0 forum 2

Here is my website [url]http://projecttower.site50.net/questions/[/url] I have a collapsible panel there that whenever it's clicked it shows a form where you add a question, answer and ID. the first form is for a file on my server called [URL="http://projecttower.site50.net/questions/questions.htm"]questions.htm[/URL] the index.htm file is a live search results page that reads question titles from a file on my server called [URL="http://projecttower.site50.net/questions/links.xml"]links.xml[/URL] In links.xml it links to questions.htm through Code: <link> <title>Question</title> <url>questions.htm#Question1</url> </link> Question1 is the ID of the Question on questions.htm In questions.htm for example in the code Code: <p><a id="Question1">Q: Do I have to change my domain name</a>A: No, …

Member Avatar
Member Avatar
+0 forum 1

Whenever I search something in Google and try clicking the links, it redirects to random advertisement websites that have nothing to do with what I searched for. This has been happening for several days and I don't know what caused it. I've installed HijackThis and here's the logfile: Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 3:47:26 PM, on 9/9/2011 Platform: Windows Vista SP2 (WinNT 6.00.1906) MSIE: Internet Explorer v8.00 (8.00.6001.19120) Boot mode: Normal Running processes: C:\Windows\system32\Dwm.exe C:\Windows\Explorer.EXE C:\Windows\system32\taskeng.exe C:\Windows\System32\igfxtray.exe C:\Windows\System32\hkcmd.exe C:\Windows\System32\igfxpers.exe C:\Windows\RtHDVCpl.exe C:\Program Files\Intel\Intel Matrix Storage Manager\IAAnotif.exe C:\Windows\system32\igfxsrvc.exe C:\Program Files\Synaptics\SynTP\SynTPEnh.exe C:\Program Files\Toshiba\Power Saver\TPwrMain.exe C:\Program Files\Toshiba\SmoothView\SmoothView.exe C:\Program Files\Toshiba\FlashCards\TCrdMain.exe C:\Program …

Member Avatar
Member Avatar
+0 forum 1

I am working on a website and I am currently trying to make it look more proffesional with the help of CSS(I am writing this all myself, not using a generator). Recently I installed something that would make a more professional. The only problem is that whenever I look at it through IE or FF the entire CSS page does not load for me. It is either the background, the buttons, or I recieve an old version of my code. How can I orginize or optimize my CSS sheet to work more properly on a webpage? [CODE] /*The CSS page …

Member Avatar
Member Avatar
+0 forum 9

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] I'm trying to use this in code below in viewcomments.php to retrieve the address info [CODE] $id = $HTTP_GET_VARS['topic']; [/CODE] I'm getting this error "Notice: Undefined variable: HTTP_GET_VARS in C:\wamp\www\testsite\viewcomments.php"

Member Avatar
Member Avatar
+0 forum 4

I have the paginated results page below, intended to show the results from a previous search page that pulls items from the database and also passes the _GET to this page. When I first submit my search, it works. But when I click on the paginated pages below, It reloads the page with out the next few entries from the database. It still shows the paginated numbers at the bottom. But I'm not sure why it's losing the database information? [CODE] <?php require ('database connection'); $display = 2; // it's intentionally only 2 for the moment to test pagination if …

Member Avatar
Member Avatar
+0 forum 1

I've searched & searched and haven't figured it out, any help is great! I need to display certain fields from my table, right now it only displays the first row of the table. I need to display all rows in the table. Code I have right now [CODE]$query = "SELECT name, desc, city FROM table"; $result = mysql_query($query) or die('Could not find info'); $row = mysql_fetch_array($result, MYSQL_ASSOC) or die('No records retrieved'); { $name = $row['name']; $desc = $row['desc']; $city = $row['city']; } echo $name . "\n" blah blah blah[/CODE] How do you display all info from all rows in database …

Member Avatar
Member Avatar
+0 forum 2

Hi All I have an XML output that looks similar to the below ... [CODE]<ELEC01_SOWaitingParts3> <JobOper_JobNum><![CDATA[019564]]></JobOper_JobNum> <JobOper_OprSeq><![CDATA[60]]></JobOper_OprSeq> <JobOper_OpCode><![CDATA[A/W]]></JobOper_OpCode> <JobOper_OpDesc><![CDATA[ACID/WASH]]></JobOper_OpDesc> <JobOper_OpComplete><![CDATA[No]]></JobOper_OpComplete> <JobOper_QtyCompleted><![CDATA[0.00]]></JobOper_QtyCompleted> </ELEC01_SOWaitingParts3> <ELEC01_SOWaitingParts3> <JobOper_JobNum><![CDATA[019564]]></JobOper_JobNum> <JobOper_OprSeq><![CDATA[70]]></JobOper_OprSeq> <JobOper_OpCode><![CDATA[INSP A/W]]></JobOper_OpCode> <JobOper_OpDesc><![CDATA[INSP ACID/WASH]]></JobOper_OpDesc> <JobOper_OpComplete><![CDATA[No]]></JobOper_OpComplete> <JobOper_QtyCompleted><![CDATA[0.00]]></JobOper_QtyCompleted> </ELEC01_SOWaitingParts3> <ELEC01_SOWaitingParts3> <JobOper_JobNum><![CDATA[019564]]></JobOper_JobNum> <JobOper_OprSeq><![CDATA[80]]></JobOper_OprSeq> <JobOper_OpCode><![CDATA[GET F/L]]></JobOper_OpCode> <JobOper_OpDesc><![CDATA[GET FITTING LID]]></JobOper_OpDesc> <JobOper_OpComplete><![CDATA[No]]></JobOper_OpComplete> <JobOper_QtyCompleted><![CDATA[0.00]]></JobOper_QtyCompleted> </ELEC01_SOWaitingParts3> <ELEC01_SOWaitingParts3> <JobOper_JobNum><![CDATA[019564]]></JobOper_JobNum> <JobOper_OprSeq><![CDATA[90]]></JobOper_OprSeq> <JobOper_OpCode><![CDATA[KIT F/L]]></JobOper_OpCode> <JobOper_OpDesc><![CDATA[KIT FITTING LID]]></JobOper_OpDesc> <JobOper_OpComplete><![CDATA[No]]></JobOper_OpComplete> <JobOper_QtyCompleted><![CDATA[0.00]]></JobOper_QtyCompleted> </ELEC01_SOWaitingParts3>[/CODE] As you can see, the JobOper_JobNum is the same for each of the above (bear in mind this is only an extract, the full XML contains lots of different JobOper_JobNum's). In the second line you can see 'JobOper_OprSeq' - 60, 70, 80, 90 However when the …

Member Avatar
Member Avatar
+0 forum 16

Hi I want to store query result in single variable like if query is "select count(*) from tablename" , and it return suppose 21 records (integer value) then I want to save this value in my database during insertion of record what should i write in place of question mark sign in below code... [code] string qry; qry = "insert into General values(@Gno,@GRno,@Fname,@Mname,@Lname,@Sex,@Bdate,@Pass,@Mono,@OtherNo,@Photo,@Role,@GCID)"; SqlCommand cmd = new SqlCommand(qry, cn); cmd.Parameters.AddWithValue("@Gno",[COLOR="red"]???????????[/COLOR] ); cmd.Parameters.AddWithValue("@GRno", TxtAddress.Text); cmd.Parameters.AddWithValue("@Fname", RadioButtonList1.SelectedItem.Text); cmd.Parameters.AddWithValue("@Mname", DrpDwnDD.SelectedItem.Text); cmd.Parameters.AddWithValue("@Lname", DrpDwnMM.SelectedItem.Text); cmd.Parameters.AddWithValue("@Sex", DrpDwnYY.SelectedItem.Text); cmd.Parameters.AddWithValue("@Bdate", TxtUserName.Text); cmd.Parameters.AddWithValue("@Pass", TxtPassword.Text); cmd.Parameters.AddWithValue("@Mono", TxtEmail.Text); cmd.Parameters.AddWithValue("@OtherNo", DrpDwnCountry.SelectedItem.Text); cmd.Parameters.AddWithValue("@Photo", "~/Photo/" + FileUpload1.FileName); cmd.Parameters.AddWithValue("@Role", DroDpwnPerque.SelectedItem.Text); cmd.Parameters.AddWithValue("@GCID", TxtAns.Text); FileUpload1.SaveAs(Server.MapPath("~/Photo/" + FileUpload1.FileName)); …

Member Avatar
Member Avatar
+0 forum 5

Hi Members, Did you get results like this till today while searching on Google for something ? Only 1 result . please check this link => [URL="http://www.google.co.in/search?hl=en&rlz=1B3GGLL_enIN382IN382&q=helciona+pune&btnG=Search&aq=f&aqi=&aql=&oq="]http://www.google.co.in/search?hl=en&rlz=1B3GGLL_enIN382IN382&q=helciona+pune&btnG=Search&aq=f&aqi=&aql=&oq=[/URL] How it is possible? anybody here , I am waiting for a answer.

Member Avatar
Member Avatar
+0 forum 2

The End.