10,938 Topics
 | |
 | here my username is know as callsign there is a problem somewhere that i cant find and i present the code: $callsign = mysql_real_escape_string($_POST["CallSign"]); $result = mysql_query("SELECT * FROM users WHERE CallSign = '$callsign'"); $row = mysql_fetch_array($result); echo $row['CallSign'] . "<br>"; $sql = "SELECT COUNT(*) FROM users WHERE CallSign = …  |
| | my code is messing up. help: if (mysql_query("CREATE DATABASE $dbname",$con)) { echo "Database Created<br>"; $dbase = $_POST["CallSign"]."char"; mysql_select_db($dbase, $con); $sql = "SELECT * FROM $dbase"; $result = mysql_query($sql); if ($result) { echo "CallSign Accepted<br>"; mysql_select_db("my_db", $con); $sql="INSERT INTO users ( CallSign, Email, FirstName, MiddleName, LastName, Gender, BirthMonth, BirthDay, BirthYear, Location, … |
 | Hello everyone! :) Could you please help me? I am still a noob and I'm having a hard time about displaying selected values from mysql database into popup window? This is my code where user can see the table of the electoral officials: -----CUT----- <div id="page"> <div id="blanket" style="display:none;"></div> <div … |
| | So im trying to make a password login and im getting errors. i got past my Unable to jump to row 0 error with this: **mysql_num_rows($result) >= 1** but now it wont jump to the row when the password is correct ether :/ here is the code; whats wrong with … |
 | Hello,I cant access my two table date together in one search option.like table name: name_search & skill_search.here is the code.please check it and if possible solve it. <?php $connect=mysql_connect('localhost','root',''); $mysql_db=mysql_select_db('my_database',$connect) or die(mysql_error()); if (isset($_POST['search_name']) && isset($_POST['search_skill'])) { $search_name= $_POST['search_name']; $search_skill= $_POST['search_skill']; if(!empty($search_name) && !empty($search_skill)){ if(strlen($search_name,$search_skill)>=4){ $query = "SELECT name FROM … |
| | Hi guys i first thank you for helps. and i have a script i use that for application authentication In fact the users must use your user name and password to use that App then after authentication of they user and pass passed they allow to use that application. and …  |
| | Hey evryone. For some reason, I can't seem to insert anything into this table that I have in a database It connects just fine and the variables that I'm retrieving are just fine, which leads me to believe that my INSERT statement is incorrect. Any ideas? Here's the code: function … |
| | I am getting data from my order table in a html form, with its id under checkbox, now i want to select some id by checkbox & want to get the total quantity from the mysql table in a new html form/page. I hope, i am able to make u …  |
| | Im not seeing it but its not working here is the code: mysql_select_db("my_db", $con); $sql = "CREATE TABLE stream ( waveID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(gameID), userID int, wave varchar(25), waveTime TIMESTAMP DEFAULT NOW() )"; // Execute query if(!mysql_query($sql)) { echo "Couldn't do it"; } else { echo "alright"; … |
| | I am using mysql to fetch this result from the database.I need to caluclate the rank of a prticular user id from this result.What is the easy and smart way of doing it? SELECT a.UserId,d.AreaId,d.SubjectId, SUM( a.Marks ) AS sum, COUNT( a.Marks ) AS count, SUM( a.Marks ) / COUNT( … |
| | i have a lot of mysql data (2 Lakhs data) how to collect data with in a seconds ? any idea thanks in advance |
| | Hi every one I have a very simple form and it just will not submit to the db. Could some one please tell me where I am going wrong? <?php if ( $_SESSION['logged_in'] ): ?> (1) <?php endif; ?> <?php if($_POST['formSubmit'] == "Submit") { $errorMessage = ""; if(empty($_POST['social_media'])) { $errorMessage … |
| | Hi, please first you visit this site http://www.webdo.x10.mx/ this is my practice site.I just starting my php carrer.here i create a search option with button but its not working as my expectation.i think its code is OK".here the code.. <?php $connect=mysql_connect('localhost','root',''); $mysql_db=mysql_select_db('my_database',$connect) or die(mysql_error()); //db name:my_database if (isset($_POST['search_name'])) { $search_name= … |
| | Hi, This is my first post.I just starting php Hope everyone reply me as possible as. I have signup problem.When i filled the form and click sign up button then it nothing show any result i mean its not home.php "welcome" message and also not store date in my mysql … |
| | We are running a C program where for every one second there is a function callback. Below is the snippet of the code listed. It is ran over every second without missing so we notice sometimes when is busy doing the insert part and the next select is up and … |
| | Here are my two pages I am using to edit. One is the HTML form and the next is the code to insert the changes. I have looked overthis code for a few hours and have not seen anything wrong. I hope it is not something super simple or I … |
 | Hi all, I realise that this has been asked probably many times. I have searched but have not been able to find the relative answer - most likely not searching properly?? Anyway, what I would like to do is to display multiple images relating to one topic, ie. One member … |
| | I need to store both text and images to be stored in the same field? How can this be implemented in php using a mysql database? I have used BLOB to store images in the past . Which datatype should I use for this problem? And how will this work...? … |
| | Hello Everyone, I am trying to pull some info from a MySQL database. The problem is that, for every four rows that are fetched, I need to add a div tage before and after, so here is an example of what I want: This is the static way I have … |
| | Hi, I'm new to php and i'm trying to build simple database and I having a problem with getting id value with $_GET here is snippet of my code: $id = (int)$_GET['id']; echo $id; if(isset($_POST['upd'])){ $sql = "UPDATE dvds SET title = ?, folder = ?, spot = ? WHERE …  |
| | Hi i'm doing an android app which requires that i retrieve data from a MySql database stored in a webserver I am using a rest approach to do this the data is being retrieved through a json object. I would like to ensure once the data is retrieved its handled … |
| | Hello all, I have a drop down that is populated using php and mysql. when the user makes a selection, I run the function showUser(), however, nothing happens when i make a selection, can anyone help with what I'm doing wrong? The JS [CODE] <script type="text/javascript"> function showUser(str) { if … |
 | I want to have a list of months and years when content was posted to my website. Example: /// **Archive** *July 2012 June 2012 May 2012 April 2012* /// Then, clicking one of list items takes you to a page with every post from that month. I know I should … |
 | hi all, i just want to ask if its possible to have a two or even more database connection in a php run application like db_connect---db1 fetch data db_connect--db2 fetch data db_close --db2 if its not possible. how can i get data from other database table appriciate youre answers. |
| | My question requires a little background first: I'm working on a Web project where there are four theatres owned by a single company, so not only will the four theatres each need their own Website (each with its own unique branding), but the umbrella company will need one as well. … |
| | hi need to show the duplicates on a column table when they have two other values in common on other column. form_name + field_value name1 | value_x name2 | value_y how can i create the query to search when values x, y, etc have form_name name1 and name2 ? thanks |
| | Hi, I’m making an online database (with some help). What I’m having trouble figuring out is how it might be possible to sell ‘records’…or rather the ability to add records. I would sell access to the database based on the number of records a user buys. Once you buy a … |
 | Hi! I'm hoping someone can help me here, I've been looking at highcharts as a way of graphing my dynamic data from my sql db....What I've come up with so far is below, it's strange, it seems correct, the data is correct, however, I can't get my chart to render, … |
| | Dear all, i am new to php and i am trying to update db table through php form ... there is a form that takes inputs from php form and then update the db ... Below is the update php page ... <?php $host="localhost"; // Host name $username="lpr"; // Mysql …  |
| | I'm trying to create a PHP script, which would be added to .php files (articles) on my website. This script would automatically add the article in question to a previously created database (and would subseqgently be used to timestamp articles). What would a script like that look like? |
The End.