10,940 Topics
 | |
 | POSTBACK.php [CODE=PHP] <?php $q=$_GET['q']; $words=explode(' ',$q); //$words2 = "'%".implode("%','%",$words)."%'"; //echo $words2; $con = mysql_connect('localhost', 'root', '')or die('Could not connect: ' . mysql_error()); mysql_select_db("ajax_demo", $con)or die('cannot connect'); //$sql = 'SELECT * FROM `ajax_demo_table` WHERE `FirstName` LIKE CONVERT(_utf8 '%'.$q.'%' USING latin1) COLLATE latin1_swedish_ci OR `LastName` LIKE CONVERT(_utf8 '%'.$q.'%' USING latin1) COLLATE latin1_swedish_ci'; … |
| | Its kind of complicated.well iam trying to create a search form,where the output will be like : Found (a number) results: Name: Surname: [View Button1] Name: Surname: [View Button2] and so on,depented on the results of query. i am calling a fun on pageload.in that i create the buttons,and i … |
 | I recently moved a script I created for Google Maps over from my development site and I changed the information in the mysqli line and now I'm recieving an error mesage -- any idea what's going on here? Here's the error message: [CODE]Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user … |
| | I'm looking to select almost duplicate rows in a table. I initially just sorted all the rows by name and picked out the duplicates manually (took a while), but I'm wondering if there's a "real" way to go about doing this. Problem is that the duplicate names can slightly differ. … |
| | Hi all, Can anybody help me out how to export multiple excel sheets in a single xls file using php and taking datas from mysql table. thank you |
| | how to find the last dml action held on which row in a table using mysql plz do me a favour , tanks in advance.. |
| | Hi, i have a login page which i designed in dreamweaver. When i connect my php to the dreamweaver everything is ok. Here i need help when i press on my login button, currently when i click it, it takes me to another blank page and says login successful. But … |
 | Alright, so I am embarking on a fairly large project that is complete with user profiles. My question is, what's the fastest, most efficient way to store user meta like books, movies, etc. I was planning: metaid | userid | firstname | lastname | movies | books | biography | … |
| | Hi, I seem to have an issue with this code...its giving me an error at this line: lblDB.Text = currentRecord.ToString(); The error is [B]System.NullReferenceException was unhandled by user code[/B] I have debugged and connection to DB is working and the dataReader does have the record in it but I am … |
 | this has got me stumped, i have a simple few text boxes that users type in the hotel name. Some names have special char in them like: L 'Ermitage I have two tables, the Top3 table has data that i display to users The details are where the main data … |
| | Hi there, I am currently facing some problems with return carriages. I have an address already in a table in the database which has return carriages. Now when you echo the address out it will loose the return carriages and instead will put it all on one line. I have … |
| | Hi, I am using the twitter api to retrieve some data. I'd like store my followers latest status tweet containing that hashtag #RT and the mention of my name. The staus ID can be retrieved via $xml->status->id. In the code below I'd like to php to search for certain words … |
| | Hi, im currently designing a form on dreamweaver and it allows a client to enter their Name, Email and Comments. At the same time i want this data to store in my mysql database which i created. The php code that i used is shown below, but the problem is … |
| | Hello guys, i am a very beginner php developer (i know only the basics) and i am trying to create a website about betting which will retrieve info from mySql databases. the problem is that i have stored some variables (which are written in greek) in databases and then when … |
| | I've been trying to solve SQL exercises from [url]http://www.sql-ex.ru/[/url] for some time. You can find database description below: Short database description "Computer firm": The database scheme consists of four tables: Product(maker, model, type) PC(code, model, speed, ram, hd, cd, price) Laptop(code, model, speed, ram, hd, screen, price) Printer(code, model, color, … |
| | i got something really stange going on with mysql.look [CODE] <?php $numid=$_POST['numid']; $query1="select * FROM datatable LEFT JOIN datatable2 ON datatable.numid=datatable2.numid WHERE "; $connect=mysql_connect("xxx","xxx","xxx") or die ("Check your server connection"); $db_found = mysql_select_db("mydb",$connect); if ($db_found) { echo "Database FOUND <br>"; if (strlen($numid)>0){ $query1.="numid='$numid' AND "; } $query1=substr($query1,0,(strlen($query1)-4)); $result = mysql_query($query1); … |
 | EDIT* Sorry I didn't mean to add that error message in the topic title. Hey guys, I'm new to PHP and MYSQL and I have been searching for hours for a way to copy the data from a row in one table (all columns) and insert it into another table … |
| | Im thinking about taking on a chat room php based project. I want to make sure my logic is right though. This is very raw so please feel free to contribute if you see any problems that might occur. [B][U]MYSQL[/U][/B] [U]TABLES[/U] Username chatroom1 chatroom2 etc.. [B][U]PHP[/U][/B] [U]Sign up.php[/U] Insert username … |
| | Hi, When I run query below I get duplicated records. Instead of 2, I get 4 records. I guess there is a problem with JOIN because when I remove [B]image JOIN[/B], it works fine but without [B]image JOIN[/B], the query is helpless for me. Please help, thanks in advance [B]QUERY[/B] … |
| | So I have this code for my webpage but whenever I put in the "include" php code [CODE]<?php include('include/mysqli.inc'); ?>[/CODE] everything below that disappears. Basically I'm trying to enter in the appropriate variable data from the quotes database that I'm using into the correct table fields. But I can't do … |
| | Hello all In my table mytable I have Date column. how is the query to find the nearest date in mytable to current date ? thank you denny |
| | [code=text]mysql_query() [[url]http://www.mysql.com/doc]:[/url] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into kiwanis_info ( 'identity', 'firstnam', 'lastnam', 'phonenum', 'emailaddr', ' at line 1[/code] Above is waht I get when inserting into a file from … |
| | Hi there. I'm having a problem getting values from a drop down to insert into a table. What I want to do is get the key for the value and then insert that. For example: I have a table called format which holds an auto incremented ID key and a … |
| | Can you show me the way about storing the special characters into mysql database using php. Actually,I'm working on such a website where user can upload text and programming codes into mysql. Thank you in advance.  |
| | Hi All , I tried to update the field RANGE_ALLOC_BLOCK_SIZE in table GLOBAL_VARIABLES of information_schema database.But i face the error Access denied for the root user.Can anyone help me to update the field. Thanks, Arun T |
 | Hey Guys, I have a quick question for you. I display a new event every day that allows users to attend that event. The event id and user id are added to an event participants table. I have 3 tables in my DB: "userinfo" which holds stuff like id, Name, … |
| | Hi everyone, Can anyone tell my why this does not work? I created a stored procedure that uses a variable / input value as table name, but it does not do what it's supposed to do. Here is the code: [CODE] delimiter // DROP PROCEDURE IF EXISTS userpages.respondtoconnectionrequest// CREATE DEFINER … |
| | Hi guys i have an assignment and it's asking me to let the user enter data into one of three text boxes to search for something in a database it also has to show the results in a table and be hyperlinked to the next page being bookingdetail.php and the … |
| | I'm having trouble getting my queries to insert properly. this is my table structure books(ISBN(pk), authorID(fk), formatID(fk), publisherID(fk), titleID(fk), yearPublished) the ISBN and year are past directly via a form but the foreign keys are all auto incremented in their own tables. I was trying this: [code] mysql_query("insert into authors(authorName, … |
| | Hello people, When I call my function ReadMyTable::readAdmin(); i get an error where it says I have not the right to use self::admin within that function, please, help me to fix this problem ! here is my code : [CODE]<?php class ReadMyTable{ public static $admin="admin"; public static $presentation="presentation"; public static … |
The End.