10,940 Topics
 | |
 | Hi everyone! So, I'm trying to create a program which users can add, update, delete, view, and search records but I am having a hard time about updating records in my database. In my Update form, I've got 1 dropdown menu or option that contains ID number and when I … |
| | I'm using int type in my database, what I should put in order to catch the input data by users? mysql_real_escape_string is not working because I think he can cater only the string values. here is my codes. [CODE]<?php /* NEW.PHP Allows user to create a new entry in the … |
| | Hey everyone, I am trying to develop an addon for my admin area to send a text to my clients. I am trying to populate a select menu that will list clients that have added their mobile phones. I am using the following tables. [LIST] [*]tblclients [*]tblcustomfields [*]tblcustomfieldsvalues [/LIST] At … |
 | Any tips on how to connect them? COmments are highly appreciated. Thanks! |
| | Hi can anyone tell me how I add a row to a database table (gamescores) that will record a userID and the number of points they have gained. I also have to update two session variables and use them to update values that appear on the screen by adding code …  |
| | How to get last auto number? I've got 2 tables I.e. booking and booking membership One person is the leader of a booking, but many people can be members of that Still, when I inse the booking I want to also do an insert into the bookingmembership table. The booking … |
| | Hi guys! I have company website created using PHP and mysql database. I am not a programmer but know few things about ftp transfer etc. We happen to change our web server and for that had to transfer the file to new location. All the files are intact and even … |
| | When People are trying to insert an sql inection, that time mysql errors displays the table name with the column names, how can I turn off this, My site is built in MVC framework, and this is how developers have queried the database, [CODE] $offset=0; if(isset( $_GET['offset'])) $offset=$_GET['offset']; $array_list=$DB->q("select *,users.user_list_id … |
| | Hi was just wanting to know that if your using variables do you write it like this: INSERT INTO table_name VALUES ($name) or do you leave the $ out? |
| | Hello Everyone, I am having a very basic problem in PHP MYSQL. My requirement is to add images in MYSQL through PHP along with the username. I have managed to store images in MYSQL but I dont know how to store username along with that image uploading query. Just like …  |
 | Hello, how to create mysql database and grant privileges via php code I need to created a new database with new user and to set privileges for this user within my php script, how can i do this? Regards, TitoSd |
| | Good Afternoon, I have a bit of a dilema, maybe 2 or 3... I have a members table in MySql, that includes a field called join_date which is designated as DATE type field I have 7 position tables named position_1 thru position_7 These each have a field called create_date which … |
| | Dear all, Am half way through my computer lab management project. to generate the timetable automatically i've written an algorithm. and for it to work i need an sql query that can : table-> ttprofile: id lab_name subject_name. now i looked every where, is there a command to take the … |
| | Well I have build a program until now with an MySql database. The programs add records for the customers and the products of the company(Its works perfect).. I am trying to build now the Orders the last part of my project but I have a little problem.. First of all … |
| | I Have a problem with syntax error on the following code [code] $myregion = $_POST['region'];echo $myregion;$names = mysql_query("SELECT * FROM course_name WHERE Region=$myregion"); while($row = mysql_fetch_array($names)) {echo $row['Name_of_Course'], " " , $row['Region'], " " , $row['Price'],"<br>";}$myregion = $_POST['region']; echo $myregion; $names = mysql_query("SELECT * FROM course_name WHERE Region=$myregion"); while($row = … |
| | the below table is order by rank .. however i want order by in a way that 'Cpl' comes first. 'lcpl' comes second and 'pte' come last.. if i use ascending or descending it will order by a random manner.  |
| | I am a nood forgive me if all my code is messy, and evrything I know is self taught so my knowledge is not that great. I have an issue, I created an insert record form and in it there is title, price, 8 file upload fields and other fields. … |
| | Say i have a series of items , so items have multiple people associated with them Item_id type_id person_id 1 1 1,2 2 1 3,4 3 2 1,3 Will this work when i search for them in php say display people with item one person 1 and person 2 |
| | Primarily, I need a table of employees with the following fields: Name, Photo(s), and Bio. So the rest should be easy enough, but I know nothing about databases.... so the photo field I'm assuming should be of the blob type, however I need to have a primary photo, and then … |
| | Hello, I am currently building a site for friends that would like to have 1 site but have 4 separate blogs on it. I have created a basic php admin section which allows 1 user to go in and add posts, manage posts and delete posts. What i would like … |
| | Dear users, I am new to PHP5. My LAMP is working just fine.I made small database connect scripts and they just worked as it should.Then I tried the following code and run the mysql.php but showing me following error: [CODE]Could not run query: Access denied for user 'www-data'@'localhost' (using password: …  |
 | Dear Experts, Thanks for your time. I have to creat a dynamic table through asp.net in database. On page there is a table Row with text and column with text. There is button Edit above the table: User press + to add a row or colum Column and row is … |
| | I have a MySQL table table with two fields: id and name. id is primary key with auto_increment. The thing is when I insert a record and then empty the table, and insert a record again, the id value does not start from 1, it keeps increasing even though the … |
| | Hi,guys,i cant solve this insert query into ,this is my query,i want it to insert it to another new table.How to solve this query?thank Q very for the help...cheers [CODE] SELECT adp.adsPageId,adp.adsSpaceId, DATE_FORMAT(adp.dayClick, '%Y-%m-%d') AS dateReport, (SELECT COUNT(*) FROM ads_display att WHERE att.adsSpaceId = adp.adsSpaceId AND att.adsPageId = adp.adsPageId AND … |
 | can anybody tell me what is wrong with my sql statement because it runs well if their is only one or but when I put another or it gives nothing to display [CODE]"SELECT * FROM tbldoctor_info i, tblmonday m, tbltuesday t, tblwednesday w, tblthursday h, tblfriday f, tblsaturday a, tblsunday … |
| | Hi, I have created a database, where it is possible to create posts and see them on a different page. On the page where it's possible to see all the records I want to create a delete link so it is possible to delete the record where you have pressed … |
| | I've been looking for a answer for this for some time but no luck. Does anyone know how do I check if the mysql db is full? I'll trigger an email in PHP to myself if the db is full cos I cannot check it constantly manually. Thanks |
| | Hi everyone, The following code is returning the error message "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/numyspace.co.uk/web_users/home/~unn_u011067/public_html/displayclassbooks.php on line 24" and I'm not sure why? Basically I have a list of classifications (for a book catalogue) and all the options work except for DISPLAY … |
| | Hi to all, Can anyone help me to show the code how to save multiple data into mysql via PHP? Thanks in advance. Here's some code [code] <?php echo "<form action='savetoanothertable.php' method='post'>"; $query = mysql_query("SELECT * FROM tbl_student"); while($result = mysql_fetch_array($query) { echo "<input type='text' name='studname' value='$result[studentname]'>"; echo "<input type='text' … |
| | Hi guys Can someone please point me in the right direct. cant seem to get round the error on the `$r = mysql_query()` line. <?php require_once ('../mysql.php'); if(isset($_GET['delete'])) { $id = (int)$_GET['delete']; $r = mysql_query ($dbc,"DELETE FROM customer WHERE id = {$id}"); if(mysql_affected_rows($dbc) ==1){ $message = '<p>Record deleted succefully</p>'; } … |
The End.