Re: [PHP-DB] Compatibility with PHP and MySQL

On Mon, Sep 5, 2011 at 3:49 PM, Gabriel Solberg solbergdes...@gmail.com wrote: Will installing the most recent XMAPP to install PHP MySQL and Apache to create a development environment on my local computer affect how everything runs when I upload it to the server (My web host 1and1.com runs php

[PHP-DB] foreign key

Okay. I am pretty new to mysql so this may seem like a ridiculous question to some people. I am trying to use a LEFT JOIN query, but the results I am finding unusual. For every record occurrence there is for the query, the results are duplicated by that amount. So if there are 3 records from the

Re: [PHP-DB] foreign key

Is users.user_id unique? yes it is. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] foreign key

Roe Blvd' ORDER BY stores.store_date DESC Chris Stinemetz 08-09-2011 02:08PM600kbps-3.8mbps testChris Stinemetz 08-09-2011 02:07PM0-250kbps test1Reply: Bella Roe 4980 Roe BlvdSELECT stores.store_subject, stores.store_comments, stores.store_date, stores.store_tptest, stores.store_by, users.user_id

Re: [PHP-DB] foreign key

Okay. I just validated it is not in the left join query, but in my php. I was able to build the correct relations. Does anyone see any think in the php code below that may cause duplicate table rows? Thank you all. ?php //store.php include_once 'includes/connect.php'; include_once

[PHP-DB] Re: php-db foreign key

| chrisstinemetz | Chris | Stinemetz | | Bella Roe 4980 Roe Blvd | test1 | 2011-08-09 14:07:49 | 0-250kbps |1 | 1 | chrisstinemetz | Chris | Stinemetz

Re: [PHP-DB] Re: php-db foreign key

Your php code had more than one query running (one inside the other). It's the outer query that runs twice, not the inner one returning double the results Thanks Peter, Do you have any suggestions on how to fix this? Thank you, Chris -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] Re: php-db foreign key

Yes, debug your code and figure out why it's looping twice instead. For instance, try the other query in the mysql console. Thank you! It was the first query. I put a LIMIT 1 on it and now it is working correctly. I appreciate your help! Thank you, Chris -- PHP Database Mailing List

[PHP-DB] Left Join

I am tyring to build a query that will take the most recent stores.store_date column then join it with store_list.store_name where store_list.store_name and stores.store_subject match then return the most recent stores.store_date. I am guessing this will require some sort of join. I have been

Re: [PHP-DB] Left Join

On Sun, Aug 7, 2011 at 3:00 PM, Peter Lind peter.e.l...@gmail.com wrote: Maybe it's just me, but I can't see anything that would work as foreign key for you to join on - neither table seems to have a foreign key Sorry for my ignorance. How do I create the foreign key? The two columns from

[PHP-DB] Insert query error

I am getting the following error trying to run the below query. Any suggestions on what I am doing wrong? Thank you, Something went wrong while inserting your store visitCannot add or update a child row: a foreign key constraint fails (`store`.`posts`, CONSTRAINT `posts_ibfk_1` FOREIGN KEY

[PHP-DB] cascading select

I am trying to create a cascading seletct with 3 menu choices. For some reason my third select menu is not populating. It does not seem like my ajax is correctly sending $_post values to the final query in my PHP class I built. By the time I make it to the final (third) select menu there are no

Re: [PHP-DB] Re: radio form submission

Thanks everyone. If there is no purpose, I would make the values of the inputs the values you want to store in your database. Muuch easier.. So I am trying to keep this simple and just assign the value with the radio button and then insert it into mysql database, but with the following code

[PHP-DB] radio form submission

So far I am good on creating the form and submitting it to mysql database and calling the submitting value from a different script. My question is: How can I make it so when a user selects radio option value 1 it will then be displayed as 0-250kbps when I call it the value in the bottom script?

Re: [PHP-DB] radio form submission

On Thu, Jun 23, 2011 at 2:49 PM, Daniel P. Brown daniel.br...@parasane.net wrote: On Thu, Jun 23, 2011 at 15:46, Chris Stinemetz chrisstinem...@gmail.com wrote:    Use an if or a switch.  For example: I think your suggestions are exactly what I am looking for. I am not sure exactly where

Re: [PHP-DB] radio form submission

   Use an if or a switch.  For example: I think your suggestions are exactly what I am looking for. I am not sure exactly where to place it. Do I insert it after the query statment? Thank you, Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] ORDER BY DESC

I have the bellow sql query. What is the correct way to add ORDER BY posts.post_date DESC I would like to add it to the end of my query, but I am just getting a blank page or my added query doesn't work echo: The posts could not be displayed, please try again later. The query is:

Re: [PHP-DB] ORDER BY DESC

On Mon, Jun 20, 2011 at 3:49 PM, Karl DeSaulniers k...@designdrumm.com wrote: Try.. $posts_sql = SELECT posts.post_store, posts.post_content, posts.post_date, posts.post_by, users.user_id, users.user_name FROM posts LEFT JOIN users ON osts.post_by = users.user_id WHERE posts.post_store =

[PHP-DB] delete message function

I created the below delete function, but it doesn't seem to be working correctly. When I enter the correct password it get my echo Incorrect Password Did not Delete! When I leave the password blank the message will delete from mysql table. Am I missing something?? Thanks in advance, Chris

[PHP-DB] Re: delete message function

On Tue, Jun 14, 2011 at 12:31 AM, Chris Stinemetz chrisstinem...@gmail.com wrote: I created the below delete function, but it doesn't seem to be working correctly. When I enter the correct password it get my echo Incorrect Password Did not Delete! When I leave the password blank the message

[PHP-DB] mysql_query

Hello all, Not sure what I am doing wrong. I have a simple form that populate the variables in a mysql query. I know the selected values are making it to the form porcessing script because I can echo them on the processing script as indicated below. You Selected Cell_Sect = 1_1 You Selected

[PHP-DB] Event Calendar tutorial

Hello all, I am curious if anyone knows of a good tutorial to build an event calendar? Thank you, Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP Delete confirmation

I have been trying to figure out how to add delete confirmation for the bellow snippet of code. I would prefer not to use javascript. Can anyone offer any advise on how to right the delete confirmation in PHP? Thank you in advance. P.S. I apologize for the indention. For some reason gmail messes

[PHP-DB] automactic email notification

I have an all-in-one form which allows record edits, adds and deletes in a mysql table. I would like to add the ability to automatically send email update to a distribution list whenever a record is edited, deleted, or added. I won't be hosting my own mail server so instead I will be using

Re: [PHP-DB] Re: automactic email notification

On Wed, Apr 13, 2011 at 11:08 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Without looking at your HUGE code stream, I'm curious what your question really is.  If you know how to send an email, and you know how to update your table, then isn't your task simply to send an email after

[PHP-DB] error

I am getting the following error when I try to use my edit.php script: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 I can't seem to find anything wrong with my syntax below. Has anyone ever had

Re: [PHP-DB] error

I am pretty sure it is in my code. I am just getting an error form one of my echoes. Still can't get it to work correctly though. Any help is greatly appreciated. Thank you, Chris ?php /* EDIT.PHP Allows user to edit specific entry in database */ // creates the edit record form // since

Re: [PHP-DB] Re: jpgraph and mysql passing array

On Sat, Mar 26, 2011 at 9:44 PM, Brian Smither bhsmit...@gmail.com wrote: Would you try an experiment? Thanks for for the suggestion but this didn't seem to work. I beleive it is a header conflict based on what I have researched. I just can't seem to find a solution. In this line: $sql =

[PHP-DB] jpgraph and mysql passing array

Hello, I hope you can help me. The Jpgraph forum seems to be pretty uneventful with participation. I am trying to pass arrays through the image tag to populate my variables for my graph. I keep getting an error that there is no input. Do you have any suggestions? I would greatly appreciate