26 Topics

Member Avatar for
Member Avatar for nander

Hello I am trying to query a database to show records only for the current user using variable I get the correct data but only 1 row with results any guidance? // Query database to retrieve records associated with the user $sql = "SELECT * FROM table_name WHERE variable_name = …

0
31
Member Avatar for emiola

Hello, kindly look at my php code to insert registration data into a MySQL database. Here is the code below and further below, the error response I keep getting. <?php error_reporting(E_ALL); ini_set('display_errors', 1); $servername = "localhost"; $username = "emiola"; $password = "emmybaba2020"; $dbname = "tutors"; // Create connection $conn = …

Member Avatar for AndreRet
0
107
Member Avatar for Izzah_2

ive been develop a project known as ordering system i need to delete data from db by clicking the button ive follow a tutorial from utube and to the exact same code he been used error "object reference not set to an instance of an object" ive double check my …

Member Avatar for Santanu.Das
0
819
Member Avatar for k_manimuthu

SAMPLE TABLE 1 =================================== product Division sales % =================================== product1 divsion1 99 product2 divsion1 51 product3 divsion1 50 product4 divsion2 98 product5 divsion2 41 product6 divsion2 40 product7 divsion3 97 product8 divsion3 31 product9 divsion3 30 =================================== Expected output 1 =================================== product2 divsion1 51 product3 divsion1 50 product5 divsion2 41 …

Member Avatar for diafol
0
549
Member Avatar for vitaquous

there are five tables (personTb, addressTb,churchTb) each holds data pertinent to an individual; (personAddress,personChurch) each hold the primary key for the person table and corresponding table IE personAddress holds primary key for addressTb. ​ both snippets work, my question is;** Is my join correctly formatted? ** select concat(personTb.p_fName,' ',personTb.p_mName,'. ',personTb.p_lName) …

Member Avatar for rubberman
0
304
Member Avatar for prakash2813

Hello, please check the attachment for details. What i need is : The sum of all the full_trade_amount for that route The list of routes that share a customer with that route The number customers shared with that route The number of columns with data can vary so a route …

Member Avatar for lukerobi
-2
167
Member Avatar for mexabet

I wrote a modify password file, but unfortunately, the MySQL query is throwing error: Warning: mysql_query() expects at most 2 parameters, 3 given in admin\modify-password.php on line 40 This is the PHP code: if (mysql_query("UPDATE admin SET hash = ? WHERE admin_id = ?", crypt($_POST["newpassword"]), $_SESSION["admin_id"]) === false) I modified …

Member Avatar for mexabet
0
343
Member Avatar for SirMahlon

<html> <body> <?php $username = 'root'; $password = ''; $hostname = 'localhost'; //connection to the database $con = mysql_connect($hostname, $username, $password,'contactmanager') or die('Unable to connect to MySQL'); echo 'Connected to MySQL<br>'.'<p>'; mysql_query($con,'INSERT INTO Personalinformation(Name, YearOfBirth, Email,Location,PhoneNumber) VALUES(Peter,2008-03-05,peter@hotmail.com,kasland,0269015748)'); mysql_close($con); ?> </body> </html>

Member Avatar for SirMahlon
0
5K
Member Avatar for Lomholdt

Please help. I am trying to change data in my MySql database. I am able to input new data, but when i try to change anything, it doesn't work. Here is my code: <?php $id = $_REQUEST['id']; $newname = $_REQUEST['newname']; $newemail = $_REQUEST['newemail']; $newpassword = $_REQUEST['newpassword']; mysql_connect("localhost", "root", "") or …

Member Avatar for Lomholdt
0
139
Member Avatar for gk1993

$u = mysql_real_escape_string($_POST["username"]); $p = sha1($_POST["passwd"]); $q = "SELECT * FROM profile WHERE email=`$u` AND passwd=`$p`"; $run = mysql_query($q); if(!$run){ echo mysql_error(); } this creates *Unknown column 'mymail@gmail.com' in 'where clause'* error. This code is from a tutorial and a piece of a submit-new-post php page.

Member Avatar for gk1993
0
154
Member Avatar for Anark10n

#include <stdio.h> #include <mysql.h> #include <string.h> int main(int argc, char **argv) { MYSQL *conn; MYSQL_RES *result; MYSQL_ROW row; int num_fields; int i; char user_query[100]; char word[10]; printf("Enter word: "); scanf("%s", word); sprintf(user_query, "select * from english where word = %s", word); printf("%s\n", user_query); conn = mysql_init(NULL); mysql_real_connect(conn, "localhost", "root", "123", …

Member Avatar for Anark10n
0
145
Member Avatar for afrogfx

I'm Beginner. I need help, please. I am having a small problem in the script I am have in this script ( admin folder) Add contain articles (This page is working to add threads only) My problem in the Page (read_mor.php) i make a query with the database to bring …

Member Avatar for afrogfx
0
6K
Member Avatar for sammry

lastlogin is getting saved as time() in my mysql table and it is varchar mode. querying the database to send out emails to remind my users that they have not logged in from past 30 days SELECT * FROM members WHERE lastlogin = DATE_SUB(CURDATE(), INTERVAL 30 DAY) i tried with …

Member Avatar for sammry
0
170
Member Avatar for Darkrellin

Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted …

Member Avatar for Darkrellin
0
316
Member Avatar for Darkrellin

Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted …

Member Avatar for macebooks
0
180
Member Avatar for kyklops

Hi everyone, I'm new to mySQL. I have a table like this one: [ICODE]+-------+-------+-------+ | date | plant | value | +-------+-------+-------+ | date1 | 1 | 10 | | date2 | 1 | 12 | | date3 | 1 | 15 | | date4 | 2 | 30 | …

Member Avatar for smantscheff
0
201
Member Avatar for naeemnur

Hi, All i want to show is the 'fr_players' to have two categories of 'fr_nations' and 'fr_clubs' and fetch the names from the foreign id... Here what i have done so far but it doesnt shows any error or return any tables either: [CODE]SELECT a.id as club_id, a.fr_name as club_name, …

Member Avatar for naeemnur
0
982
Member Avatar for Sabyre

I'm working on an auction script for a client. This portion of the script pulls all the open auctions from the database and allows bidding, but they only want bidding on auction with 30 seconds left until it ends. [CODE] $query = "select * from DSI_auctions WHERE closed='0' AND suspended='0' …

Member Avatar for pritaeas
0
130
Member Avatar for amityadav9314

I have two table named:[B] Blog[/B] for displaying blogs post and [B]comments[/B] for displaying comments section for each blog post. The fields for these are as follows: [B]For Blog:[/B] 1: blog_id 2: title 3: body 4: author 5: updated [B]For Comments:[/B] 1: comments_id 2: username 3: email 4: comment_body 5: …

Member Avatar for SANJAY26
0
341
Member Avatar for dashawk

guys, can anyone help me on this problem? i have two tables then what I want is that, when an identical item is found in table2, it will not be displayed. Example: [CODE] Table1 Table2 item1 other1 item2 other2 item3 item2 item4 item3 [/CODE] Condition: if we use this query: …

Member Avatar for Reverend Jim
0
249
Member Avatar for Rian19

Hi I'm just starting with php programming and need some help. This is just a test script I'm writing to see how it works. I'm trying to search for phone of a certain make and price using a different search box for Make and price. I want the results to …

Member Avatar for cwarn23
0
232
Member Avatar for designalex

Please correct my syntax: im including a file with the following constants [CODE] define('IPADDRESS', $_SERVER['REMOTE_ADDR'] ); define('BROWSER', @$HTTP_USER_AGENT ); define('REFERER', @$HTTP_REFERER ); [/CODE] if i echo IPADDRESS; i get the ip address (127.0.2) so the include is fine. My mysql instruction is as follows: [CODE] $update = mysql_query("UPDATE login_errors SET …

Member Avatar for designalex
0
179
Member Avatar for jenthevb

Hello, I have a problem with this script when i will check it in the browser, the output is : "Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\doto\php\new_case.php on line 8 FOUT SELECT * FROM disp_type ORDER BY t_naam ASC Resource id #3" [CODE]<?php $host="localhost"; $username="TEST"; …

Member Avatar for ariese
0
409
Member Avatar for davefitze

w whyhi i keep getting this warning and i dont know why [QUOTE]Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /users/2014/daf1/public_html/cs1109/lab18/adding.php on line 13[/QUOTE] [CODE]$add_topic_res = mysql_query($dbconnection, $add_topic_sql) or die(mysql_error($dbconnection));[/CODE] if anyone could help me it would be great cheers

Member Avatar for davefitze
0
138
Member Avatar for GrahamLawton

I'm sure this is stupidly simple, but I havent been able to figure it out with lots of Google searching and pouring through tutorials. I'm building a simple computer trade-in value calculator PHP app. Using a form to select the type of computer and the various specs, I need it …

Member Avatar for diafol
0
152
Member Avatar for doctorphp

Hi everyone I am trying to develop a friend system where you can view friends who you are friends with. I have been able to get it to show one result but it wont show any other. Please can someone tell me what I am doing wrong. Here is the …

Member Avatar for doctorphp
0
147

The End.