10,932 Topics
 | |
| | 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>'; } … |
| | <?php echo "<html> <head><title>comment box</title></head> <body> <hr width=1000>"; require('connect.php'); if(isset($_POST['submit'])) { $name = $_POST['name']; $comment = $_POST['comment']; echo "<font color=white><center>"; $result= mysql_query(" INSERT INTO COMMENT (name,comment) VALUES ('$name','$comment')") or die(mysql_error()); while($row = mysql_fetch_array($result)) { echo "<tr> <th>ID</th> <th>Name</th> <th>Comment</th></tr>"; echo "<tr>"; echo '<td>' . $row['name'] . '</td>'; echo '<td>' . … |
| | |
| | Hi friends! i have a drop down combo box which holds names of persons with php mysql order by asc query like a's name put in 1st and after b's and c's and in last it shows z's name now i want that if it will show tahir name in …  |
| | $dbQuery="select id, name from artists where name like '$keyword%' order by name asc limit 15"; $dbResult=mysql_query($dbQuery); echo mysql_num_rows($dbResult)."\n"; while ($dbRow=mysql_fetch_array($dbResult)) { // for each artist, return the number of albums belonging to that artist // use a separate query here to obtain the number // return the number after the … |
| | Guys I am having a problem on how can I display array of records using mysql_num_rows, I cant use mysql_fetch_array because the format like this [CODE]$row['MR_no'];[/CODE] that encloses the name of the field inside brackets in my SQL codes this is my codes: [CODE]<?php $username = $_SESSION['username']; $query = "select … |
 | please help me to this issue. its driving me nuts for an hour :( Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web033/b336/ipg.asiahomecom/tile/tilesCollection.php on line 16 my line 16 code: while($row=mysql_fetch_array($a)){ my code.. --------------------tileVerification.php---------------------- <?php session_start(); if (!$_SESSION['user']){ header('location: tiles.php'); exit(); } ?> ---------------------connectionIn.php------------------------- $con = … |
| | I have a project in which i have two roles : Student Teacher I have already created a login page but i cant figure out how to redirect them to different pages according to their Roles...  |
| | Hey got a big issue i need to resolve if i have a table that records two distinct values entered by user.. NC001 OR TE001 Equipment_id | Serial | location -------------------------------- NC001 | if i have a php based form how can i tell it that if a user select … |
The End.