mysql select query with join not showing the results of multiple rows

Have a different question to ask? Start New Discussion Reply to this Discussion 9 Hours Ago 0

I am trying to create a search form for my database where a user can search for a customer name and all of that customers addresses will be displayed. my structure looks like this

Customer table

ID First Name Last name Company Name

Address Table

ID line 1 post code town Customer_ID

Site Table

ID Address_ID notes

I take either the first, last, or company name as an input($field) and store this as a variable along with which column they want to search in($query) then I use the following query to check the database for matching criteria

$data

Grade program

Have a different question to ask? Start New Discussion Reply to this Discussion 8 Hours Ago 0

I need help with this program. It take in a number from the user and displays their grade. For example. If the user inputs 77. The program prints out "Your grade is a C"

jmp firstLine ; m1 dw ? prompt db 'Enter a number between 1 to 100: ' promptLen

Hide folder so its not viewable inside

Have a different question to ask? Start New Discussion Reply to this Discussion 8 Hours Ago 0

How do I make it so the folder isn't viewable to the outside world. I created a login page which is login.php but when you type in examplesite.com/admin it shows everything inside the folder.. How would I hide all that? - Is that a .htaccess thing?

xbat Light Poster 31 posts since Jun 2012 Reputation Points: 0 Solved Threads: 0   Related Article: Adding my images I found this code that looks like i will be able to add and delete pictures on the fly. What I would like to know is. How can I get the code to take pictures from my folder instead of the way they have it. Thanks in advance.

Graph maker in PHP

Have a different question to ask? Start New Discussion Reply to this Discussion 8 Hours Ago 0

Hi everyone,

I'm just looking for some graph makers for the data we have in our database. We would like to analyse the data taken out of the database and present it in a graph format to see who has got low/high ranks.

Is there any free API that we can use? if you know any, please do suggest it with a little mention about how difficult/easy to use it.

That will be so much appreciated.

rotten69 Posting Pro in Training 401 posts since May 2011 Reputation Points: 13 Solved Threads: 18   Related Article: The requested URL /cgi-bin/php/myscript.php was not foun Hello, I'm having this error in a new hosting where I just uploaded my website. I didn't have this problem in my old hosting: 404 Not Found Not Found The requested URL /cgi-bin/php/myscript.php was not found on this server. Do you know what could be causing the error? It is ... Post:Markdown Syntax: Formatting Help Bold Italic Code Inline Code Link Quote Heading Sub-Heading # List • List Undo Redo Insert Code Snippet (Alt

Helped with type declaration in named tuple

Have a different question to ask? Start New Discussion Reply to this Discussion 7 Hours Ago Show Comments -1

Hi,

I have been subclassing namedtuple to handle my custom data type:

fields

PHP Error

Have a different question to ask? Start New Discussion Reply to this Discussion 7 Hours Ago 0

Hi I am having trouble with this code:

Getting Audio From Laptop to Receiver

Have a different question to ask? Start New Discussion Reply to this Discussion 7 Hours Ago 0

I have a question for you. I have a Sony Vaio Laptop and I am inquiring about connecting an Audio cord to my Yamaha Receiver (RX-V471BL AV RECEIVER W/USB), for streaming Netflix. How do I do this? I Connected a HDMI cord from the laptop to the receiver, but it only gives me a picture, no audio.

eposner Newbie Poster 6 posts since Jul 2012 Reputation Points: 0 Solved Threads: 0   6 Hours Ago 0

you need to go into audio device options and choose the hdmi as the default ,i think ,go to start ,control panel and open Sound icon ,you will need to set the laptop speacker back when finished with the hdmi

caperjack I hate 20 Questions Team Colleague 13,170 posts since Aug 2003 Reputation Points: 1,064 Solved Threads: 819   5 Hours Ago 0

Ok AMD HDMI Output. I will try this. Thank you.

eposner Newbie Poster 6 posts since Jul 2012 Reputation Points: 0 Solved Threads: 0   5 Hours Ago 0

Yep, that was it. Thank you so much. I had been listening to Pandora/Grooveshark via RCA/single headphone male and R/L RCA to AUX into the receiver. Wow, So much better via HDMI. I am really diggin DaniWeb. Thanks Again!

eposner Newbie Poster 6 posts since Jul 2012 Reputation Points: 0 Solved Threads: 0   Related Article: Laptop touch pad problem The right click on my laptop has stopped working properly. You can drag and highlight things with it but no normal right click functionality. This occurs with the touch pad and when a USB mouse is plugged in also. No problem when in administrator account. All settings are default nothing ... Post:Markdown Syntax: Formatting Help Bold Italic Code Inline Code Link Quote Heading Sub-Heading # List • List Undo Redo Insert Code Snippet (Alt