39,323 Topics

Member Avatar for
Member Avatar for daniel36

I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- #1066 - Not unique table/alias: 'topics' .i am unable to understand the problem.

Member Avatar for yamahaszr660
0
163
Member Avatar for ak47carbon

when i send email from php mial funtion it working best in yahoo and gmail acounts but images and background images is not showing in outlook 2007,tell me what is solution and better way to show image in oulook <?php // multiple recipients (note the commas) $to = "zohaib@sikone.com, "; …

Member Avatar for Citytech.tester
0
2K
Member Avatar for Awah Mohamed

hi guys, i am making a new app in cakephp (and i am new to the framework.. learned how to use it last night).. and i am supposed to make a signup system and login system but i am stuck in the signup. i Worte the models and controllers and …

Member Avatar for Citytech.tester
0
150
Member Avatar for Buppy

Hi, I want to set up pagination in CakePHP 2.0. The base page url is routed to be like this - '/mypage'.However, the paginator sets links to this - '/controller/mypage/page:2'. How do I configure this so the controller name isn't added in the beginning? I prefer URLs like these - …

Member Avatar for Citytech.tester
0
103
Member Avatar for johndohmen1963

i have the folowing code <?php $datumeind = date("Y-m-d");// current date $datumverleden = strtotime(date("Y-m-d", strtotime($datumeind)) . " -99 year");//current date -99 years $datumbegin = date('Y-m-d', $datumverleden); if(isset($_POST['zenden'])) { if($geboorte_datum <= $datumbegin && $inleven_dood == 'In leven' ){ ?> <script type="text/javascript"> <!-- var r=confirm("Klik ok als In Leven."); if (r==true) ("<?php …

Member Avatar for Citytech.tester
0
202
Member Avatar for dourvas

hallo there i read an excel file using excel_reader library. The excel file contains greek characters. i get the data and store it into arrays (it is a common xls file that contains names, lastnames and fathersnames) using characters set utf-8. the code works fine //i uploaded the xls file …

Member Avatar for blocblue
0
128
Member Avatar for chandbasha

Hi All, I have hosed my site on Amazon and my IP is 175.41.140.91 and domain name is 100bestbuy.com But when i am typing in browser its not giving any response But is pinging and connecting through fillezilla and putty. Please can any one help me. C:\Users\chand>ping 100bestbuy.com Pinging 100bestbuy.com …

Member Avatar for c-tech
0
313
Member Avatar for simplypixie

I am not new to OOP I am tidying up a very large site of mine and trying to create a much better structure (more in keeping with the whole point of OOP). I have decided to use mysqli (please don't suggest PDO as I have decided againast it) which …

Member Avatar for simplypixie
0
2K
Member Avatar for cguan_77

hi guys, need your help on this. had a form on html and saving data to mysql but it's not working here's the html code: <html> <body> <table width="300" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td><form name="form1" method="post" action="insertac.php"> <table width="100%" border="0" cellspacing="1" cellpadding="3"> <tr> <td colspan="3"><strong>Insert Data Into mySQL Database …

Member Avatar for cguan_77
0
266
Member Avatar for titosd

Hello, I trying to post a string, but ihave a problem When I post the string in chrome, the string length that i post it is more than the realy string that i send, but in firefox and IE the post is working correctly, what is the reason for this …

Member Avatar for almostbob
0
144
Member Avatar for Marty1963

Hope someone can help he because I'm at a loss. I'm trying to set up a PHP local server on my new machine using ISS7 and Windows 7 I seem to have PHP installed correctly and it's linked with the ISS Manager. All of the necessary Window Features are turned …

Member Avatar for diafol
0
425
Member Avatar for bulqr4eto

Hello everyone, I have a website with admin panel...the admin can upload news and I want the users to be able to submit news like me but after theyr news are reviewed and approved from me how can I do this I will show my upload script from the admin …

Member Avatar for baig772
0
337
Member Avatar for reco21

HEllo. If I do this.. <div>value | number</div> <?php $arr = array(10, 7, 2, 4); $i = 0; foreach ($arr as $value) { $i++; echo "<p>" . $value . " | " . $i; } ?> ill get something like number | value 1 | 10 2 | 7 3 …

Member Avatar for reco21
0
151
Member Avatar for afroo.gfx

**i have this connection** <?php $db_host = 'localhost'; $db_user = 'root'; $db_pass = ''; $db_name = 'databasename'; $conn = mysql_connect($db_host,$db_user,$db_pass) or die(mysql_error()); mysql_select_db($db_name,$conn); mysql_query("SET NAMES 'utf8'"); mysql_query('SET CHARACTER SET utf8'); ?> **but my old connection dosen't work with this code** //connect to database $link = mysqli_connect('localhost','root',''); mysqli_select_db($link,'databasename'); //get all rows …

Member Avatar for DarkMonarch
0
611
Member Avatar for scholarwithfire

Hello, i'm having some problem when comparing date (from user input) with the date inside database. The format of both dates are the same (YYYY-MM-DD). This is the error it shows > You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version …

Member Avatar for diafol
0
108
Member Avatar for AlTaylorParker

I'm trying to create a function that builds the content of a page and add database info at a specific point in the process. I get this error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\EasyPHP-5.3.8.0\www\test\dukejets\view\pagecreator82812.php on line 20 This is line 20: "\t\t\t …

Member Avatar for diafol
0
191
Member Avatar for cip6791

Hello, I am trying to add a few custom modifications to a classifieds theme for Wordpress. It uses custom fields to get all the information in a post. Phone number, location, price, etc. It was designed to send an email to the user, the user clicks a confirmation link which …

Member Avatar for Bluestacks
0
259
Member Avatar for bvk008

<textarea name="primary_goals[]" rows="5" cols="23" style="height:145px; width:325px;"><?php echo $primary_goals; ?></textarea> textarea value is stored in database primary_goals[] array stores the values enterd in textarea.. how can i display this value again in this text area

Member Avatar for diafol
0
1K
Member Avatar for abhi10kumar

I have a website plus database with details like username, password and database name. Now I want to connect and use this database into another website. I tried to include, for example include('http://domainname.com/connect/db.php'); but unable to run query. How I can do this ?

Member Avatar for urtrivedi
0
279
Member Avatar for davy_yg

Hello, I am receiving this error while trying to save information in admin page: http://localhost/RustoleumCustomCMS/administrator/%3Cbr%20/%3E%3Cb%3ENotice%3C/Masterlink/cgoods/PHP_SELF%20in%20%3Cb%3EC:%5Cxampp%5Chtdocs%5CRustoleumCustomCMS%5Cadministrator%5Cinput_berita_static.php%3C/b%3E%20on%20line%20%3Cb%3E174%3C/b%3E%3Cbr%20/%3E Object not found! The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error. If …

Member Avatar for davy_yg
0
242
Member Avatar for SimonFrance

Hi, Can anyone help me to remove form field validation for "quantity" field? I want to make it optional. Here is the code. http://paste2.org/p/2168944 I tried to remove myself but got error "Sorry some error occurred and unable to...". I will be very thankful for your help. Regards, Simon

Member Avatar for urtrivedi
0
121
Member Avatar for cguan_77

hi guys, I had installed WAMP on my win 7 workstation, the PHP file is not executed or run in IE and firefox but works fine in Google Chrome. any ideas is greatly appreciated. Thanks.

Member Avatar for cguan_77
0
192
Member Avatar for Khav

Hi Guys I have a script on my linux server.However i am having an issue with php-fpm ...whatever configuration i put , the php pages take time to load.For some configuration , the php files load fast at start and over time they become slow ...after 5-9 hours its 404 …

Member Avatar for Khav
0
325
Member Avatar for monsterpot

Apologies first if this is covered elsewhere - I searched but could not find. I am looking for a way to search the web for the presence of a JavaScript code snippet within the HTML <body> of a web page. I would specify the code snippet and send the bot …

Member Avatar for aqeel.mmd
0
940
Member Avatar for PHPuss

I have code , and I need to change color row when in last column 'status' appears value = 'error' <?php //first, get the file... $file = file('log.txt'); //now count the lines .. $lines = count($file); //start the table here.. echo '</br>'; echo'<table border="1" width="600">'; echo ' <td width="400">Date</td>'; echo …

Member Avatar for simplypixie
0
167
Member Avatar for garyjohnson

I have a hosting account through godaddy and im trying to make a php upload file so users can upload files to my site, but the php file upload I have found on the internet wont work, here is the html code <html> <body> <form action="upload_file.php" method="post" enctype="multipart/form-data"> <label for="file">Filename:</label> …

Member Avatar for urtrivedi
0
696
Member Avatar for AMADH

Hello, I was wondering if somone might be able to help me. I have a txt file, it looks like this ID1|NAME1|URL1|EMAIL1|LOGO1|ADTEXT1|ADTEXT1|CATEGORY1|PUBDATE1 ID2|NAME2|URL2|EMAIL2|LOGO2|ADTEXT2|ADTEXT2|CATEGORY2|PUBDATE2 ID3|NAME3|URL3|EMAIL3|LOGO3|ADTEXT3|ADTEXT3|CATEGORY3|PUBDATE3 This is my php code // initial database stuff $host = "localhost"; $user = "root"; $pass = "root"; $db = "database"; $connection = mysql_connect($host, $user, $pass) …

Member Avatar for cereal
0
6K
Member Avatar for ckchaudhary

sorry couldn't frame a better title. So here's the problem i have a function inside functions.php function show_news(){ $id_counter = 1; $json_news = array( "id" => 0, "title" => "" ); $json_o = json_decode(file_get_contents(JSON_DATA_FOLDER.'news.json')); foreach ($json_o as $id => $news_category) { echo '<h2>'.$id.'<h2>'; foreach ($news_category as $news) { if(IsNullOrEmptyString($news->id)){$json_news['id'] = …

Member Avatar for diafol
0
214
Member Avatar for arif.ctg.ns

whenever I am running this code <?php $db=mysql_connect('localhost','root',''); mysql_select_db('moviesite',$db); $query= 'SELECT * FROM movie'; $result=mysql_query($query,$db) or die(mysql_error($db)); while ($row=mysql_fetch_assoc($result)) echo '<tr>'; { foreach ($row as $value) { echo $value; } } ?> everything ok, properoutput........... but after that I typed this code of the output in table <?php $db=mysql_connect('localhost','root',''); mysql_select_db('moviesite',$db); …

Member Avatar for pritaeas
0
87
Member Avatar for debal

<?php $con = mysql_connect("localhost","root","12345"); if (!$con) { die('Could not connect: ' . mysql_error()); } echo "connection made"; if(isset($_POST['nw_update'])){ echo("You clicked nw_update!"); } else { echo" dhur"; } ?> <html> <body> <form action="<?php echo $_SERVER(PHP_SELF); ?>" method="POST" > <input type="button" id="nw_update" value="NW_Update"/> </form> </body> </html> In the above code when the …

Member Avatar for simplypixie
0
10K

The End.