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

On Mon, Sep 5, 2011 at 3:49 PM, Gabriel Solberg 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 5.0 and > MySQL 5.0)

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 (h

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

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

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

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. ".print_r($_GET,true).""); $sql = "SELECT store_id, store_subject, store_comments

Re: [PHP-DB] foreign key

store_subject = 'Bella Roe 4980 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,

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

[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] Left Join

>On Sun, Aug 7, 2011 at 3:00 PM, Peter Lind 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 each table that h

[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

[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 (`post

[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 cho

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 co

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: http://www.php.n

Re: [PHP-DB] radio form submission

On Thu, Jun 23, 2011 at 2:49 PM, Daniel P. Brown wrote: > On Thu, Jun 23, 2011 at 15:46, Chris Stinemetz > wrote: >>> >>>    Use an if or a switch.  For example: >>> >> >> I think your suggestions are exactly what I am looking for. I am not >

[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] ORDER BY DESC

On Mon, Jun 20, 2011 at 3:49 PM, Karl DeSaulniers 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 = " > .mysql_real_esc

[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:

[PHP-DB] Re: delete message function

On Tue, Jun 14, 2011 at 12:31 AM, Chris Stinemetz 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 me

[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] 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 Date

[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

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

On Wed, Apr 13, 2011 at 11:08 AM, Jim Giner 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 updating the > table? Yes. > I

[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 remote

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 http://www.w3.org/TR/html4/strict.dtd";> Edit Record '.$error.''; } ?> ID: First Name: * L

[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] Re: jpgraph and mysql passing array

On Sat, Mar 26, 2011 at 9:44 PM, Brian Smither 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 = ("SELECT * FROM evd

[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 it