10,940 Topics
 | |
| | Hello. I am kind of new to PHP and mysql, and I am wondering on how I would go about coding up a system that would allow me to save multiple values to one row in a mysql database, and later read each separately. I am coding up a mac … |
| | I have a machine logging production info to a database whenever certain conditions change state, so pretty much randomly throughout the day. The plant runs 24/7 so data is continuously flowing into it with about 500 entries in a 24 hour cycle. The shifts are strictly time based and are … |
| | Hi I am a bit rusty with SQL, not used it for about 8 years so would appreciate a bit of help. I have three tables, normalised, organisation, stores org_name and org_id ativities stores activity_name and ativity_id org_activity stores org_id and activity_id I need to get a list that contains … |
| | hi, i'm using phpmyadmin & would like to create an additional field in the following table. Field // Type Collation Attributes Null Default Extra Action user_id // int(10) first_name //varchar(20) last_name // varchar(40) email // varchar(80) pass // char(40) user_level //tinyint(1) active // char(32) registration_date// datetime the field would be … |
| | I'm trying to create an object derived from the MySQLi object to easier handle database connections for my application. The thing is that I do not know how I shall be able to initalize the connection and keep it contained in the object. Let me illustrate what I mean: [CODE] … |
| | Hi, i have four tables:books, info, autor, publisher and columns under tables; books........... info............ autor............. publisher ------------... -------------... ---------------... -------------- id............. id............... id.................id bookname .......type .............name ..............publisher name autor_id .......year .............second name .......quantity publisher_id ...autor............. year..............country I tried with this relations but it did not work (is this normalization ok) … |
 | Hi Guys, Can anyone help me out about displaying 10 data from my database?My codes goes like this. I have 4 fields (id, local_title, local_desc, local_date ) [CODE] <?php $last_date = ""; $result = mysql_query("SELECT * FROM tbl_localnews ORDER BY local_date DESC"); while ($row = mysql_fetch_array($result)) { for($i=0; $i<10; $i++){ … |
 | Hi All, Im accessing a function with paticular parameters, but my response is not recognising the parameter of the count value. If I change the variable in the COUNT part of the query to a static value it works fine, but if i use the variable name it returns "undefined … |
| | Hello i've got a problem here, i want to insert some data into my table and everything is all right for the first 3 or 4 but the last does not work [CODE]<?php // include("config.php"); // $db_connection = mysql_connect($db_host, $db_user, $db_slaptazodis); mysql_select_db($db_table, $db_connection); // if ($id == "") { // … |
 | [url]http://www.mycircle.freevar.com[/url] This is my website. Whenever a user logs in using correct username and password, a field(flag=1) in the database is updated to show that the user is online(for chat). When user logs out, it is set to flag=0 to indicate offline. This works properly. Consider the situation. The user …  |
| | Hi all, I have the following code:[CODE]$Connection = mysql_connect("127.0.0.1", "user", "pass") or die(mysql_error()); $Database = mysql_select_db('db', $Connection) or die(mysql_error()); $Url = mysql_real_escape_string("exampleurlwithonlycharacters"); $Query = "SELECT `col` FROM `table` WHERE `url` = '$Url';"; $Resource = mysql_query($Query, $Connection) or die(mysql_error()); $Result = mysql_fetch_object($Resource); var_dump($Result);[/CODE]and was expecting to see the Col => 1 …  |
| | Hi, i am new on vb.net and MySql, and i have a problem. My database name is "plant3", i have a table named "itemlist" which has a field named "itemname", "task", and "status". I want to show the itemname on combobox and when user choice an itemname the program will … |
| | I'm working on a mysql server 5.0.45 hosted on linux RHEL 5.0. 1. I've 2-tables as below: [INDENT]table1: acct_no VARCHAR(15) column1 varchar(10) table2: acct_no VARCHAR(12) column2 varchar(10)[/INDENT] In both the tables, there are many rows with identical A/c nos. 2. Of the below 2-queries, only the second one works. [INDENT][COLOR="maroon"]SELECT … |
| | hi guys, i am struggling with cross tab query in mysql. if you have any idea could you please help me? basically i have data into the table like... cid | Q# | marks c1 | 1| 50 c1 | 2 | 50 c1 | 3 | 50 but i …  |
| | Hi, I am a PHP beginner, I am working this code and I need help, And kinda stack of it. I have a database with 5 fields(id, date, time , title and description). This is what I want to do; I want my script to go into the database fetch … |
| | Hello Everyone, i am wanting to build a leaderboard for my site for the members gamerscore on Xbox LIVE. I know how to fech from a MySQL database, etc but this is the hard bit. So the users table in MySQL contains their gamertag and i want to pull that … |
| | hi can anyone help me with this ive trying for 2days to get this sorted but cant figure it out. i want to be able to list my data in the table which works fine then i want a link next to each data line to amend it heres my … |
| | [CODE]SELECT t1.name AS lev1, t2.name as lev2, t3.name as lev3, t4.name as lev4,t5.name as lev5 FROM members AS t1 LEFT JOIN members AS t2 ON t2.upline_id = t1.member_id LEFT JOIN members AS t3 ON t3.upline_id = t2.member_id LEFT JOIN members AS t4 ON t4.upline_id = t3.member_id LEFT JOIN members AS … |
| | Wasn't sure whether to put this with PHP or Mysql I'm having trouble with the below code, it only does the inner while loop once, while still cycling past it every time. It should update the "favourite" integer column in each "link" by checking if it's in the favourites of … |
| | Good day all: I have a mysql insert statement inserting data to db. The value of one of the variables is: [code] ' $_POST[servicedesc]')[/code] I want to be able to append the current date and time in front of this value and then insert into the db. This value will … |
 | I have two tables in my db. One table contains portfolio images with a primay key set to AI. The other table contains all of the thumbnails that need to be associated with each portfolio image with no primary key. I'm trying to grab the last inserted id of the … |
| | Hello Could help me get the right MySQL on my computer. I had it installed but it was a couple years ago. My cp crashed. I can't remeber how or what to install. All I have left is the script I used. I was running the command window one. that … |
| | I'm having trouble displaying results when i connect to 2 databases. My connection script seems to be working fine and returns no errors; [CODE]$connect1 = mysql_connect("localhost","user","pass", true); $connect2 = mysql_connect("localhost","user","pass", true); $db_selected = mysql_select_db("database1", $connect1); $db_selected = mysql_select_db("database2", $connect2);[/CODE] When i run the queries, however, I'm only managing to get … |
| | I have dtpker1 and dtpker2 to choose from the date and I want to display in Listview. the problem with this code is that it cannot display dates from the listview. Please help me with the right syntax plzzzzzzzz.........:) Thank you so much!![code]Option Explicit Dim rs As New Recordset Dim …  |
| | Hello Everyone, I hava design just a register page and a login page ,a user can register then login..during registration i used the password() for password field insert value to database. During login I used as password('_POST[pass]') and comparing with the inserted value but its not working .... I just … |
| | Thanks for taking the time to read this. Let me start by saying I'm a php newb so be gentle! I have a form that is used to insert data into my database to display info and images in a portfolio section on my site. In the form, the input … |
| | Hi, I need some guidence or some tutorials which will teach me how to do , i am not sure is this the correct forum i am in. i need a way to upload any kind of file from the fileUpload control to MySQL server how can i do this, … |
| | Hi, I am a PHP developer I never learned much JS but there is no way to accomplish this function using only PHP without a refresh. I am trying to adapt a script that did the basics. [CODE] <script language="JavaScript"> function som() { var First, Last, Full; First = document.Credit.First.value; …  |
| | [code=sql]DELIMITER $$ DROP PROCEDURE IF EXISTS `hrprocess_temp`.`sp_alltabinsert1` $$ CREATE DEFINER=`invensis`@`%` PROCEDURE `sp_alltabinsert1`(empid varchar(10),fname varchar(45),lname varchar(45), fathername varchar(30),dob varchar(20),gender varchar(6),maritalstatus varchar(9),spousename varchar(15),children varchar(8), commadd varchar(250),permadd varchar(250),mobileno varchar(15),landlineno varchar(15),email varchar(40), languages varchar(25),nationality varchar(25),bloodgroup varchar(5),drivingno varchar(20),panno varchar(15), passportno varchar(15),imagepath varchar(100),resumepath varchar(1000),skill varchar(250),deptname varchar(30), Course varchar(20),Specialize varchar(35),institute varchar(25),PassYear varchar(10), Organization varchar(25),Designation varchar(25),FromDt varchar(15),ToDt varchar(15),ReasonsChange …  |
| | please help me it usually gives me error ( it says cant enter the values ) [CODE] <?php $host = "localhost"; $con = mysql_connect("localhost","awah","password") or die ("error to connect to the server"); // contact the table and enter the form mysql_select_db("kigalifinders_clanteam_admin", $con); $query = mysql_query("INSERT INTO contacts(from, subject, message) value('$_POST[email]','$_POST[subject]','$_POST[messgae]')"); … |
The End.