10,944 Topics

Member Avatar for
Member Avatar for 1stoptutorials

Hey Everyone, hope all good. i have a problem with some php that is not randomly selecting an ip. I will try to explain my problem below. I have a state form [CODE] <select name="State"> <option value="0" selected="selected">Select a State</option> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> etc..... </select>[/CODE] …

Member Avatar for samueal
0
373
Member Avatar for Shodow

help me update my database.. when i click edit it will add a new record.. i want to update a record.. to edit a new record it will be base on the cutsomer's nameu [CODE]Dim conn As ADODB.Connection Dim RS As New ADODB.Recordset Set conn = New ADODB.Connection conn.ConnectionString = …

Member Avatar for Shodow
0
2K
Member Avatar for violette

Hye , I am having this kind of problem. Could anyone please help me why I am getting this error? [CODE]UPDATE company_alert SET company_alert.alert_value = company_financial.receivable FROM company_alert INNER JOIN company_financial ON company_alert.stock_code=company_financial.stock_code WHERE company_financial.year_id=company_alert.year_id[/CODE] You have an error in your SQL syntax; check the manual that corresponds to your …

Member Avatar for simplypixie
0
136
Member Avatar for RazorRamon

Ok I am stumped so bad. I am using a form to insert a topic and comment into a table and if the topic is new it creates a new table specific to that topic. So I pass the topic name through the url and Im trying to retrieve it …

Member Avatar for Stefano Mtangoo
0
8K
Member Avatar for komara

pls help i am beginner and i am trying to create a simple Guestbook but i got error "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /index.php on line 43" here is the code i use : <?php require ($_SERVER["DOCUMENT_ROOT"]."/komara/config/db_config.php"); $connection = @mysql_connect($db_host, $db_user, $db_password) or die …

Member Avatar for pritaeas
0
230
Member Avatar for gikonyo

am geting this error while testing the login panel of my website that am currently developing. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smartie1/public_html/checklog.php on line 43 which is in red this is the php script used for login <?php session_start(); function session_defaults() { $_SESSION['logged'] …

Member Avatar for gikonyo
0
298
Member Avatar for ebanbury

Hi When I load my renew.php page - the following warning appears. However when I click the 'renew' button in the page, the code below still works, but only when I click the 'renew' button twice. I can't find what is wrong with the code to cause the error message …

Member Avatar for ebanbury
0
4K
Member Avatar for super9876

Hi. I'd like to add time (and no date, and not a timestamp) data to a field in MySQL through a PHP form. I've been having problems, as the date is also included. But I only want the time (I want to be able to sort the data by the …

Member Avatar for super9876
0
166
Member Avatar for Awah Mohamed

hi guys, well.. i run my php program and the page just displays the following: [CODE]Parse error: syntax error, unexpected ';' in C:\xampp\htdocs\Azone\Azone\profile.php on line 160[/CODE] i checked line 160 more than 1,000,000 times and i got nothing to change! here is the whole code of the page, please help …

Member Avatar for Stefano Mtangoo
0
137
Member Avatar for bhuvan83

hi every1 i m using mysql as my back end and it runs on whole on intranet in my office. the error i m getting is Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) mESSAGE Too many connections when users r trying to access the webpage. how can i remove the error. plz …

Member Avatar for Dr AKM
0
349
Member Avatar for veledrom

Hi, If any combination of these 3 (Name, Surname, DoB, Nationality) user inputs matches to database records then the query shouldn't stop to avoid duplication. If there any special function in MySQL because running 12 query wouldn't be nice for it! Thanks in advance

Member Avatar for smantscheff
0
130
Member Avatar for tatarao25

SELECT ExtractValue(bulk_custom_field_string,"//CustomFieldValue")as CatalogValues FROM candidate_work_profiles i am getting output as 'false No 36 January 2007 January 2010' i want output as Separate Column false|No|36|January 2007|January 2010 please help me

Member Avatar for catherine sea
0
75
Member Avatar for eLu-sive

hi, am working on a bigger project than this, only using this as an example because i do not want to waste a lot of your time. i have this code, its supposed to write to the database, but have no idea as to what i should put under action= …

0
87
Member Avatar for solomon_13000

I attempted to get the records from the MySQL database and display it on a Grid View but nothing appeared. The code is below: [ICODE] using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using MySql.Data.MySqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) …

Member Avatar for crishlay
0
444
Member Avatar for jacksantho

Hi, I was trying to import the excel values in mysql DB. While trying, am facing this error. Please help me out: [CODE]Fatal error: Call to undefined function mysql_real_espace_string() in E:\xampp\htdocs\read.php on line 49[/CODE] CODING: [CODE]<?php ini_set('memory_limit', '16M'); set_time_limit(0); require_once("E:/xampp/htdocs/phpexcel/Classes/PHPExcel.php"); $inputFileName='./xls/test_data.xls'; /** Identify the type of $inputFileName **/ $inputFileType=PHPExcel_IOFactory::identify($inputFileName); /** …

Member Avatar for jacksantho
0
999
Member Avatar for Nahiyan

Hello, I want to fetch data from a MySQL database's table and order the selected data by date. Which data format is ordered most precisely by MySQL? I also want the date format to be unique. Please express the format just like PHP's one, example: h:i:s. Thanks, Nahiyan

Member Avatar for diafol
0
119
Member Avatar for bangla

Hi, I have two tables. Payment and expense. 1. select sum(amount) from payment gives me total payment amount 2. select sum(amount) from expense gives me total expense. 3. I want to join payment and expense table. How can i subtract query1 minus query2 in one join query? Thanks.

Member Avatar for MeSampath
0
99
Member Avatar for dd2308

Hello Everyone , I have developed a windows application with mysql database server. i have installed it to client machine also. Now,the problem comes when i restart mysql server or server computer. After i restart server,client application can not able connect to server . if i disable network and enable …

Member Avatar for dd2308
0
159
Member Avatar for ShadyTyrant

I have a theory about the design of a new site I am working on. If a user accounts table is in one database, and the site content tables in another database, then it would be impossible for a hacker to use SQL injections in a form unrelated to the …

Member Avatar for joehms22
0
138
Member Avatar for naui95

Help, I have a big probem. I wanto to read data from an mysql table and then write this data into a form so that the user can update this data. The code could seem somethin like this, but it doesn't work [code] <?php include 'complete.php'; $user_name = "exa"; $password …

Member Avatar for naui95
0
330
Member Avatar for Dumb Fish

hey...i need to ask ..how to put two field in one column? let say, i have one field call Quantity for weight. Now i need to put the quantity unit which is store in other field call unit. how i concat two field in one column....?

Member Avatar for Dumb Fish
0
94
Member Avatar for newbie26

i need help with my database. i always backup my database everyday.. but whenever i am doing this and when the backup is ongoing, all the system which connects to this database server always encounters hanging. now, i have no choice to stop backuping the database so that the users …

Member Avatar for newbie26
0
117
Member Avatar for calebcook

Hi. I'm trying to create a function which connects to a database, and then displays rows in it. I'm trying to use a function to connect, but it's not working. Here's my first code: [CODE]<?php define("SERVER", "mysql.example.com"); define("USERNAME", "username"); define("PASSWORD", "********"); define("DATABASE", "db"); function displayFunction() { $dbc = @mysqli_connect(SERVER, USERNAME, …

Member Avatar for calebcook
0
136
Member Avatar for ptara1

So I'm trying to transfer a longblob from one data table to another. All the other data is transferring however the longblob isn't. I know it is getting up loaded to the temp table because the longblob column show s there is data in it. here is the snippet of …

Member Avatar for sjsnider
0
1K
Member Avatar for gikonyo

am designing a database of which i want to increment no starting 70000 ever time a new record is updated in the table. i have the following columns order_no,urgency,cost_per_item,total_cost. therefore i want the order_no to be generated automatically starting from 70000. how do i set the database to auto increment.

Member Avatar for smantscheff
0
73
Member Avatar for 9tontruck

Hi, I am using Korean based windows7 and have been playing with wordpress. And I just noticed my mysql (localhost) does not sotre any languages except english!! Every foreign language turns into "????". What should I do to fix it??

Member Avatar for smantscheff
0
87
Member Avatar for rahulroshan

Hi, I was making PHP-SQL code to automatically update the database by using the webpage interface, Eg: To evaluate answer sheets, 1)So from the database automatically the row (Questions and answers) are fetched from database 2)The evaluator evaluates and enter the marks and it gets updated in database. The problem …

0
63
Member Avatar for RicardoE

Hello dear community, I have a problem which I have no idea how to walk around, see I have a really large database, with france zip codes, I imported this data from excel. the thing is that when it imported all the zip codes starting by 0 are not starting …

Member Avatar for smantscheff
0
143
Member Avatar for Pragati.rch

trigger i am wrting on mysql table i have a tool in which i am calcultaing marks 140 atomic questions and now i want add 4 questions marks and assign to one major questions. how should i approach it. begin ("$value.governance and accountability") = ("$value.existence of a governing board") + …

Member Avatar for smantscheff
0
317
Member Avatar for jakeray

This is basically what i need. I need users to select a manufacturer to post on a classified ad. When the users make the selection I need that information processed and sent to the page I point it to permanently for other users to see. The same for any user …

Member Avatar for kevindougans
0
142

The End.