0
votes
0answers
9 views
Google Charts + MySQL & PHP
Im using a sample page I used from another user here in stackoverflow to connect to mysql and retrieve data to display with google charts.
Here is the code http://pastebin.com/3e2Up24Z
However I ...
0
votes
1answer
21 views
How to sanitize user-submitted mysql queries
I have never asked a question before because I tend to always find what I need either here or in nixcraft.
I was hoping for a little guidance regarding an application that will be consumed only by ...
2
votes
1answer
20 views
MySQL PDO count function returning incorrect with multiple WHERE criteria
As long as I only specify one item in the WHERE clause, this function works fine. If there's more than one, it always returns 0.
Here's the function:
function count_rows($table, $where=array()){
...
-5
votes
1answer
32 views
Creating Forum Database: Are these all the tables and fields I'll need? [closed]
Can't think of anything else at the moment. Is there a simpler way to handle threads and posts?
people: id email email2 username password salt first_name last_name dob access_level
admins: id ...
0
votes
1answer
24 views
Switching views on ios
I have a story board that have 4 screens
welcome
sign up
sign in
dashboard
on welcome screen there are two buttons
sign up
sign in
i want when user click the sign in then it will move to that ...
0
votes
3answers
26 views
php Mail sending double content
I am working on a massmail script which sends an e-mail to every e-mail id present in a particular database.
But there is some issue.
Like I have following database:
id email link
1 ...
0
votes
0answers
26 views
UPDATE not updating via script yet variables exist
I have the following code which should result in an UPDATE occuring yet I see no change on the table row. Any clues as to why? Below the code I list what I have tried. I've stared at this code for ...
0
votes
1answer
25 views
Handling monthly occurances with PHP
I have a website where people record (or log) the distance of their runs. I want to create a leader board that will automatically reset to zero after the month is over. If I could save their total ...
1
vote
2answers
27 views
POST request not working using JQuery AJAX
I am trying to use JQuery AJAX to allow the user to input information into a form in a pop-over box, and then the information gets added to a MySQL database.
However, for some reason, when I use the ...
0
votes
0answers
14 views
How does joomla 2.5 mvc work?
I am really struggling to create a custom component. I found how the joomla mvc works but that was outdated. Can someone show me and example of a simple component getting data from the database, with ...
0
votes
2answers
36 views
understanding php die with mysql_error
I have 4 queries that run on a post. I've noticed that not all the queries are working if one of the first queries have no work to do.
Here are my queries
mysql_query("UPDATE invoice SET ...
-3
votes
1answer
31 views
mysql_result error within function [closed]
Im using a few functions in order to log users into the website. I first made a login() which looks like this:
function login($username, $password){
$id = user_id_from_username($username);
$username ...
0
votes
1answer
57 views
Mysql 5.6 doesn't want to set a column to NULL
I am about 98% sure this query has been working properly on mysql 5.1. We have upgraded one of our machines to mysql 5.6 and I am running an update and its getting a database error with this query:
...
0
votes
2answers
16 views
phpMyAdmin password change on Mac
How can I change the password of phpMyAdmin on Mac 10.7.5?
I tried with this: http://en.kioskea.net/faq/630-mysql-reset-the-root-password
But I get this error:
-bash: syntax error near unexpected ...
0
votes
1answer
45 views
navigating an array of objects in javascript
Need help forming javascript objects from MySQL rows of data. I'm using IE9 and Chrome on Windows-7.
I've managed to get what I believe to be an array (of objects) in Javascript from mySQL data. I ...
