1,257 Posted Topics
 | <?php $comma=""; while ($row = mysql_fetch_array($result)){ echo $comma.'["' .$row[1]. '",' .$row[2].']'; $comma=", "; } // end while ?>  |
| | var beaches = [ ['Miskolci road / Shell Station', <?php echo $row[2]; ?> , 4], |
| | http://www.electrictoolbox.com/pad-number-zeroes-javascript/ |
| | http://papermashup.com/read-url-get-variables-withjavascript/ |
| | http://phpsense.com/2007/php-pagination-script/ see this , this is nice way to do it |
| | |
| | you can write whatever way u comfortable, sql have allow both option with and without aliases, uses of alias in my view 1) so many times query use function and expression having so many columns involved, that is to be named with some alias to refer in better way in … |
| | http://www.geekinterview.com/quiz/SQLQuiz.html http://www.programmerinterview.com/index.php/database-sql/practice-interview-question-1/ |
| | what is in time, is it same for all or is it diffent for all |
| | Re: PHP echo in HTML http://www.w3schools.com/php/php_mysql_select.asp look at this, try your code and then tell your problem |
| | what error u getting? eroor message or record not inserting? |
| | where will come first, and order by later SELECT * FROM questions WHERE (evaluationid=".$evaluationid.") ORDER BY id ASC LIMIT 1"  |
| | where is code for testtwopart1.php, post it here |
| | try to add following css styles to ur footer bottom:0px; z-index:50; position:fixed; |
| | |
| | 1 what is table structure? 2 what are records? 3 how you want to display that records? 4 what do u mean by hourly, another daily, and other weekly (all in one query or u want in different pages?) |
| | get html code of the url, paste it here, then we can try some regex on it for price |
| | Re: Little Help SELECT * FROM cms_vouchers where voucher_code =0; this query will show only vouchers not used |
| | use declare work after begin CREATE PROCEDURE sp1 (x VARCHAR(5)) BEGIN DECLARE xname VARCHAR(5) DEFAULT 'bob'; DECLARE newname VARCHAR(5); DECLARE xid INT; SELECT xname,id INTO newname,xid FROM table1 WHERE xname = xname; SELECT newname; END; |
 | http://www.w3schools.com/php/php_file_upload.asp?output=print |
| | Re: contact mailing do u have mail server configured in ur network, you need to set smtp mail server in php.ini file for sending mail  |
| | You have written select * ..... NOW * MEANS it will select columns itself and php array is case sensitive, look into your mysql table and see case of all column, it am sure it is no Hw_tag. just use rows['case sensivite spelling as same in mysql '] OR manauly … |
| | when u upload any file, from your computer say c:\abcfolder\myfile.doc so myfile.doc will be saved in variable file['name'] when you submit file to upload, this file is copied to temp folder on server say /tmp/xyzzfile this is stored in file['tmp_name'] u can move this file from temp folder to folder … |
 | This is photogallery managment link, you may like to see http://coppermine-gallery.net/ |
| | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Stocklist update</title> <link href="../css/gallery_submit.css" rel="stylesheet" type="text/css" /> <link href="../css/template.css" rel="stylesheet" type="text/css" /> <body> <div class="span4"> <p>Remove Livestock</p> </div> <?php include 'connect.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { if (isset($_POST['next'])) { $selected_radio = $_POST['delete']; ?> <form … |
| | you need to learn JSON 1) in showdat return data in json format 2) take xmlhttp.responseText in some object 3) evaluate json object and copy fields to html fields http://www.w3schools.com/json/default.asp |
| | inner join not need, just make ur where proper UPDATE Table3.newone p, Table1 a, Table2 b SET p.ID = a.ID WHERE a.Title = b.Title |
 | I assume you have only 3 columns as u said name, last and comments, so you can try following if($tdcount==1) $width="30px"; else if ($tdcount==2) $width="50px"; else if ($tdcount==3) $width="100px"; else $width="50px"; echo "<td ".$tdclass."style='padding:.4em';width:'{$width}' >" . htmlspecialchars($cell) . "</td>"; $tdcount++; |
 | delete must be done on primary key only, if you dont have primary key, then u must add one, i guess stud_id is good choice for pk, then use only stud_id in where condtion to delte record |
| | Have a look at the link http://www.tuxradar.com/practicalphp/10/1/0 |
| | > DB2.Col_2=DB1.Col_1 you are joining letter to number, it will never return any result > select Db1.Col_1 AS 'test1' here you selecting col_1 in query and in expected result you showing col_2 ouput, its totally confusing. Modify your requirement, so tell us just in simple english what u want from …  |
| | Try to cover $_POST in {} as shown below if(isset($_POST['submit'])){ $nypost = mysql_query("INSERT INTO arkentider (typ) VALUES('{$_POST[typ]}')") or die("Kunde inte lägga till ny räkning:<br />".mysql_error()); } |
 | you can write query without ` and purely in mysql rather than using part of php $query = "SELECT * FROM Humeur_log WHERE prenom = '".$prenom."' AND nom = '".$nom."' AND current_timestamp >= date_add(datelog,interval 24 hour) "; |
| | Method 1) I assume that you must be having job_master table, so you can join that table on job_id and display job description from job_master table (hope fully same as "Shipping" and "Marketting Man" Method 2) If you dont have job master table you can use case when then clause … |
| | I think following library is simple to manage mails with attachment After uploading file to your server, you can add it path to attachment in email. here is the link http://phpmailer.worxware.com/ |
| | |
| | you can use jquery for it. Scroll bar doesnot look good option, rather you can set button or linke for next or previous kind of navigation |
| | Problem is not clearly stated.  |
| | onmousemove="javascript:loadcomms() this is causing repeat execution, so remove this. when u move mouse over div it will execute. you want to call it once, then just at the end of page write this lines <script lang='javascript'> loadcomms(); </script> |
| | $result = mysql_query("SELECT courses.id AS cid, courses.title, courses.subjectsid, subjects.id AS sid, subjects.subjectname, requestrecord.status FROM courses JOIN subjects ON courses.subjectsid = subjects.id LEFT JOIN requestrecord ON courses.id = requestrecord.coursesid AND requestrecord.accountsid=".$_SESSION['id']." WHERE requestrecord.status!='accepted' "); ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ I have replaced AND with WHERE in last line, if you put AND, it will become … |
 | You said "practicing a MLM Project". Personally I feel MLM is really complicated kind of data and calcuations, having lots of scope for error if db not designed properly. I would like to know that have u pracitsed (insert, update, calculate) on normal database table structures, if not you start … |
| | afte foreach statment you must use curly braces to cover all below code, right now $query="select * from wed_sweets"; statement will be called in loop. <?php mysql_connect("localhost","root","")or die(mysql_error()); //echo"connection with mysql"; mysql_select_db("cater") or die(mysql_error()); //echo"database cater connected"; foreach ($_POST['check'] as $k=>$c) { //i added this brace $query="select * from wed_sweets"; …  |
| | Javascript selection bunch of fiels and creating zip in harddisk, then uploading to server, It looks securit issue. It will depend on users permissions in brwoser. Don not tamper system for users. Educate them. Majority users are foolish, we can not drive as they say always. |
| | I am not sure, but can you try that query withou colon (:). I mean remove colon from begning of $username in query string. |
| | First of all you must fix search text box name to something (dont use dollor sign) line 2 in index.php must look like (without dollor in name) <label>Search For: </label><input type="text" name="res" /> in search.php, you query is failing becaseu i guess you using res word in query, it shold … |
| | I am adding 4 lines following line between line 11 and 14 in your update_success.php before update query, you do same mysql_select_db("$db_name")or die("cannot select DB"); $titel=$_POST['titel']; $ingrediens=$_POST['ingrediens']; $pris=$_POST['pris']; $id=$_POST['id']; $sql="UPDATE pizza_menu SET titel='$titel', ingrediens='$ingrediens', pris='$pris' WHERE id='$id'"; $result=mysql_query($sql); |
| | post here sturcture of all table related to your qery then post sample data here and then tell us what output u expect from that sample data. |
| | is your post handler page is same or anohther? |
| | |
| | I added line at line between 58 and 59 like following, copy that output of query, run that in phpmyadmin directly $query_Recordset1 = sprintf("select * from Item where ItemID=%i",$_GET['id']); echo $query_Recordset1; $Recordset1 = mysql_query($query_Recordset1, $con) or die(mysql_error()); |
The End.