10,945 Topics
 | |
| | Hi, I am new to PHP Development. I am retrieving data from my database table clf_email. I am having a mysql_num_rows error in results. I cannot understand where i am going wrong and what error i am doing in the code. Please help in removing this error. [CODE] <?php require_once("../db.php"); … |
| | Hi, I am a beginner in php and mysql. Someone pls be kind to help me the following if possible. 1. I know the host name, database name, table name 2. The table has 3 fields-State, Name, Specialty. 3. I want to have a drop down list name ‘State’. In … |
| | How does one create a dynamic table (meaning that it expands as information is automatically put in) with data coming from a MySQL database? I'm pulling information from a private school's "stock" database and need to fill in a table with information such as the date of the stock, the … |
| | So i've got a little problem. I'm just running a website for fun, got it from a friend because he didn't need it anymore. Site is called: fapperd.nl Now i'm really happy with me installing a phpbb forum on my server and made a button for the forum as you … |
 | This question seems to always have 2 sides to it. If I make a [COLOR="Red"]register.php[/COLOR] with the registration form, should I have it submit to [COLOR="green"]processreg.php[/COLOR] or should it just process all on the same page? Same thing for login. I have read that it may e more secure to … |
| | Hello, I am trying this code out but has error. Please help, This is my code. <?php include 'dbFunctions.php'; $result = mysql_query('select * from criteria_m'); if (!$result){ die('Query failed: ' . mysql_error()); } $i = 0; while ($i < mysql_num_fields($result)){ echo"information for column $i:<br />\n"; $meta = mysql_fetch_field($result, $i); if(!$meta){ … |
 | 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.  |
The End.