[mysql] Forum Topics

How to do the code for design and develop an PHP/MySQL application involves insert, view, search, delete, update/modify a record from a database

Hi guys, I've created a simple plugin for Wordpress that interacts with an API in the backend. The problem is that everything is inserted twice in the database, and I cannot figure out why. The form is submiting only once, not twice. What could it be ? Redirects from my …

I have these templates: temp1(id,country_id,county_id,town_id,location_id,street_id) country(country_id, language,country_name) county(county_id, language,county_name) town(town_id, language,town_name) location(location_id, language,location_name) street(street_id, language,street_name) For now i am joining all these for the selected language to find the names of temp1 id's location. Is there a better way to retrieve the informations? Would be better to make a table …

i am new to study web development..can anyone help me to how i can connect my website with the database..what are the requirements..very basic please.!!

Hi there, I have a really irritating site problem that I just can't get my head around. I only have fairly basic coding skills and hope that someone here can help crack my issue. I own a small php/mySQL based job board which I have moved from hosting to hosting …

Hi All, I am currently working on a MySQL database, and am using mySQL Workbench to create a local server. From this computer(the one that is hosting the server) i have no problem connecting to the mysql server through 127.0.0.1:3306, however when I try to connect from another computer, I …

I have a mysql query that seperates an array of variables and uses each variables to compare inside the database. The query uses a OR clause and I want to make it so it can also use an AND clause. The trick is I want the left side of the …

Hi, - Why use paging? It's not really cool to print out all 2000 rows you have in a table to the page, so it'd be nice to page them. Special cases? Yeah, if you have 1000 rows.. and you've set the maximum row per page to 20, well.. you're …

Hello, I have a members area on my website. I'm trying to check if a user with a specific username and id has logged in, and then echo a string of text on page B (members area page) if its them. The user logs in on page A (login page). …

Hi I have a php header file that displays a random image from a mysql table each time the page is reloaded. I have done this just using rand() in the query. But doing it like this means that the same image could come up 3,4,5 times in a row! …

I need the steps to make an daily Back Up to my data base i am using SQL 2008 and when i do the backup job it gives me an error unsuccessfull complete , any one can tell me why ??

can you help me in 1 cell in a row can handle many data ? for example in the picture for costumer 1, he order a banana, it cost 50 apple, it cost 60 orange, it cost 70 and my program will retrieve the datas and it will get the …

<?php $mysql_host = "***"; $mysql_database = "***"; $mysql_user = "***"; $mysql_password = "***"; mysql_connect($mysql_host,$mysql_user,$mysql_password); mysql_select_db($mysql_database); $query = "SELECT * FROM people coming"; $result = mysql_query($query); while($w=mysql_fetch_array($result)) { echo $w['Name']; } ?> this doesnt work--Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource y?

Hi All, I have a table of about 120,000 records which are mostly chemical products all with 100 byte varchar for the 'name'. I've indexed the 'name' and looked at the list here http://www.ajaxline.com/32-tips-to-speed-up-your-mysql-queries for ideas. But can't really find a solution because it's taking about 20 seconds to retrieve …

i have database with tables like these: t_09_students t_10_students t_11_students where 09, 10, 11 show year and this table will increase over the year. how do i select all the data from the tables (using union) with flexible table name? ask me, if it is not clear yet

it is possible for the database that a certain id number will handle or occupy 2 or more rows and then when it called it will take both rows like on the picture .[Click Here](https://fbcdn-sphotos-h-a.akamaihd.net/hphotos-ak-frc3/v/1056791_636382299706472_1144322928_n.jpg?oh=7160bd41f914616aa1a0c59be0821a9a&oe=51F21D0D&__gda__=1374895465_5046fd7250a283eac7faabc35a10c324)

So here is what I want. if (tracks, the db) (user_id, the row) for '".$_SESSION['user']['id']."' = equal (tracks, row) in (users, the db) for '".$_SESSION['user']['id']."' exit else update (users, the db) (tracks, the row) to match. This isn't the script as I don't know where to start but I am …

i am building a message system for website.i have two table one store user_detail and other store message sent to each other users. you can see main.jpg file where inbox sent etc.. will be display and action takes accordingly. $query='select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, user_detail.user_id as userid, user_detail.username …

I am working in a dataware house and few things are not clear to me that is why I wanna discus here. For example, I have 10 MS Access files, and each of they have more than 5000658 number of rows, and data is in such a format like **Plz …

hello fellas i'm stuck in this function: function getDataForPagination() { $sql = "select * from t_book limit 1, 15; $result = mysql_query($sql); if (!$result) return false; $num_rows = mysql_num_rows($result); if ($num_rows == 0) return false; $result = dbResultToArray2($result); return $result; } i want to make the above function more flexible …

Hopefully this will make sense and there is a solution in a single query... if not, I'm sure i can do it using multiple queries. I wrote a query that I thought would work, but didn't take into consideration that some of the records won't have data coming from one …

Hi Folks, Recently I installed WAMP server for web development, during my first run I tried My Sql Console, but I was gettting error while creating a new table. I am surely missing something. I googled for it but cannot get what i was looking for . . . Am …

Hi I have been trying for about a week to connect VB6 to MySQL and have so far been unsuccessful. What I am trying to do is have a login system in VB6 which, when the login button is pressed, searches the "userlogin" table in MySQL. If a matching result …

Hello, What's mysql syntax to delete all tables from database1 ?

this code runs at my other sample prog. but when I try to use it to my actual prog., it wont work. (variables changed, connection's ok) . . . cant show data at listview [CODE] Imports MySql.Data.MySqlClient Public Class Form1 Public sconnection As New MySqlConnection Private Sub Form1_Load() If sconnection.State …

I am trying to learn MySQL to, '1 call all records from base '2 count number of records and store number as maxID, '3 display 1st record set by the ID number, '4 -A - add one to ID number- display record set in frame1 :(working_on_page_refresh -B - mins one …

I want to backup my database from vb.net 2010 and i am able to do this using mysqldump through vb.net 2010, but i want to backup my mysql database without useing mysqldump only by vb.net code. please help me ???

hi i am new to php and mysql, i am experimenting with a script for saving data to mysql database. and fetch the data on other page, i managed to get both of them without any trouble. But Here is the one problem. I added a additional input function to …

<?php $mysqli = mysqli_init(); $mysqli->real_connect("mysq.x.com","me","wordup","inthekitchin"); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $res = $mysqli->query("UPDATE plate1 SET potatoes =('$_POST[potatoes]') WHERE id =('$_POST[id]')"); $row = $res->fetch_assoc(); ?> returnes error `Fatal error: Call to a member function fetch_assoc() on a non-object …

i have created a database with username,age,contact,email.now i want a column in which we can show whether the user is active or not.what sholud we do?if we create a column named as status,what sholud be type of column?boolean or binary or something else...??? i am using php to edit delete …