18,960 Topics
Hey guys.. going crazy over this :'( This is my form [CODE] echo "<form action='addwebsitekeywordsscript.php' method='post'>"; echo "<input type='hidden' value='" . $currentwebsite . "' name='id' /><br />"; echo "<div class='kywrdformcontnr'><div class='kywrdform'>מילת מפתח:</div> <input type='text' name='keyword[]' class='kywrd1' /></div>"; echo "<div class='kywrdformcontnr'><div class='kywrdform'>חיפושים:</div> <input type='text' name='keywordSearch[]' class='kywrdsrc1' /></div>"; echo "<div class='kywrdformcontnr'><div class='kywrdform'>שפה:</div> …
Alright so whatever i do i cant get this to work. Now...im not a wizzard or anything but why does it have to be so damn hard to find out if its more than 2 minutes or more in difference by the time in database to now. The "timed" in …
I am fresher in Database Design I want to Design a Database for an online Auditing Tool...for Auditor and Project Managers.. so far I have the following tables... Employee (EmpID , EmpName,EmpLname ,Phone) Administrator( AdminID ,EmpID, AdminEmail) Company(CompanyID, CompanyName,ProjectID) Auditor( AuditorID, Name, LastName) Questions(QuestionID, Question) Results(QuestionID,Result,CompanyID,ProjectID) User One Auditor: will …
Hi, I am new to php development! I have email table in my database which has email records. On the page read_emails.php, i have two buttons, one is of Reply and second is of Delete. My delete button is not deleting the email record in the database.[B] Please help me …
My code: [CODE] from MySQLdb import * sql_q = '("6 bandicoot crescent doolandella brisbane qld","inala","3","7"),("inala brisbane","forest lake brisbane","3","9")' connection = connect(host = 'localhost', user = 'python', passwd = '******', port = 3306, db = 'logbook') cursor = connection.cursor() cursor.execute('INSERT INTO log VALUES' + sql_q) cursor.commit() [/CODE] I seem to get …
Hello all, I have a database which has 10 tables. Each table has an id, a title and a date. Now i'm having difficulty finding the best way to extract the [B]latest date[/B] from each unique table, while also doing a count(*) attribute to show how many rows I have …
hi everyone i have a problem how to connect sql database with html and must display the columns and rows of the database to html template...
What I have is a button, and whenever a user clicks it a MySQL database field gets updated and the value is displayed to the user. I'm polling every 800 milliseconds and it's very laggy/glitchy. Sometimes when clicking the button it doesn't register it. And I actually need to be …
Hello everybody, So this week I am coming up with two questions, they are probably silly questions but I have googled and come up with nothing. [B]1)[/B]Figured out number 1 by myself, accidently had a / where it wasn't supposed to be. [B]2)[/B]This one I have not tried to hard …
I have written some sql codes in a file named sql.sql and I want to install my database using this file. How can I do it? Please help me out.... here is the sql code from the file sql.sql [CODE] CREATE DATABASE IF NOT EXISTS wm; USE wm; CREATE TABLE …
Hi, Although I'm not really a novice when talking about web development, I'm not really used to writing MySQL queries that are a bit more advanced than the absolute basic SELECT/INSERT/UPDATE/DELETE queries. Anyway, currently I started working on a project that shows relevant items to the user: A 'you might …
I need a simple solution I have invoice that i want to always diplay 10 rows, but if there is data in mysql it must first put those rows with data in on the invoice then subtract the number of rows and the difference will be the blank rows it …
[B]Hi... I have a table named empl with following fields(eid,ename,esal) I had inserted the following records to empl table 1 Govind Raj 20000 2 GovindRaj 600000 3 Govindraj 10000 4 govindraj 50000 5 Govind.Raj 50000 6 Govind-Raj 20000 7 Govind_raj 2000 8 Govind.raj.3000 9 govind,raj. 4000 10 Govind'raj 6000 11 …
how to connect mysql databse into html and must display the rows and columns of the database to html template
Hi all, Sorry if I post duplicate thread. I'm using windows batch program and still very beginner. I'm having a problem to read record from database. I'm planning to automated read folder name(folder name as reference number of project) from specific root folder and compare the folder name whether exist …
My table gets its information from a Mysql database online. I'm not sure which would be quicker to retrieve the row that contains the information specified. EG. table1 Name________Age John_________5 Joe__________20 At this moment i have a while loop that looks for john and gives me the row. But is …
Hi everyone! I have a problem updating my table named 'friend'. This is where I save my friend requests and updates it when a user accepts the request. My problem is when I accept a request, only one query updates. Separately, they work. But when I try to use the …
I have a html form on another page that is automatically filled from data from the table. I then run the the following script on submit to update the row if any information is changed. Here is the code [CODE] <?php $db=mysql_connect ("connection info") or die ('I cannot connect to …
Hello! I want to create a script which mails emails to subscribers. I'm almost done, but I'd like it to say "Sent to # people". I've tried using: [CODE]<?php $dbc = mysqli_connect('localhost', 'username', 'password', 'database') or die('Error: Could not connect to database'); $query = mysql_query("SELECT * FROM table"); $number = …
Hey Guys, I have an "events" table in my DB and a "default_events" table also. Every day I display one event. I check to see if any rows in the "events" table match todays date and then display that event, if no events match by date, I check the "default_events" …
hI all. I have a similar problem to another thread in this forum which did help somewhat but in my case all my records are updating and I cannot get it fixed despite searching around the web... I have searched and tried different things but am not getting anywhere. Maybe …
Hi all, I am trying a scenario for calling a shell script when ever a trigger is called. Can some one guide me how to achive this scenario. Also it should passes the value from the table to the shell script. Can some one explain me along with the example. …
[CODE]<?php if (isset($_POST['submit'])) { if ($_POST['lang']=="") { echo "Dictionary name can't be emptry!"; } else { $name=mysql_real_escape_string($_POST['lang']); include('db.php'); [B]$check=mysql_query("SELECT * FROM information_schema.tables WHERE table_name = '$name'"); echo $count=mysql_num_rows($check);[/B] if ($count>0) { echo "That dictionary name already exists!"; } else { $go=mysql_query("CREATE TABLE IF NOT EXISTS $name ( `id` int(11) NOT …
hi, i have in a table"visitdate1, visitdate2, visitdate3 and visitdate4" i also have in this table address fields of "housenumber, street, city, zip" i want to run a query which shows me the amount of visits to a house. should these be stored in different tables? thanks
Hey guys.. could someone please help me with.. What wrong with this: [CODE] echo "<td width='25%'><img src='images/Lock.png' title='" . $row['username'] . "' - '" . $row['password'] . "'></td>";[/CODE] i Get only the username.. Cheers, Sagive
I have developed a program where I do some database connections and send some queries with JDBC to MySQL database called ANU. I have used NetBeans 6.9 under Ubuntu 11.04 as platform. When I run the app from NetBeans, it works perfectly but when I try to run it from …
I have what should be an easy question but for the life of me can not find the answer. where/how does Moodle store Paypal course prices. So I have Moodle setup for a client and he wants a custom page that will display all courses he offers in Moodle. So …
Hi everyone! So I'm finishing a shopping cart, and there is just one thing that annoys me - the currency is on the left side. Its like this: $10, but I want it to be like this: 10$. Is there any way that I can do this? Thanks!
Hi everyone. I need a shopping cart script that uses PHP and MySQL that can be incorporated into site. I've already tried the PlainCart and seriously, that script just has too many issues that need to be solved, and I don't have the time. Also making my own is not …
Dear All, I have a big table of poi's based on latitude and longitude. So then based on a given latitude and longitude I would like to find the nearest point in my poi table. Can I use some mysql functionality to do to be best optimize way. The problem …
hello, I have found a set of functions to return values from mysql queries. I have the array filled but I am not sure how I am going to display the data. Any help is greatly appreciated. [CODE] $db->select('awf_users'); print_r($db->result); [/CODE] my result is: Array ( [0] => Array ( …
can anyone can help how to create a live search in vb.net 2008 using combo box. example when i try to search a name then a press a then there should be a drop-down with a list of suggestions of name. here is my code [CODE] Private Sub ComboBox4_SelectedIndexChanged(ByVal sender …
Hi, I am doing a window service application using C#. I wants to select many columns from many table and print into text file. Below is my coding: [CODE] protected override void OnStart(string[] args) { try { base.OnStart(args); Access_Db.OpenTransaction(); Access_Db.BeginTransaction(); DataTable dtPartNo = new DataTable(); SQLStr = "SELECT IDTbl.ModelID,WIPTbl.WIP FROM …
I need help : i have listbox1 and listbox2, fill listbox1 via SQL queries. When i selected items in listbox1 in listbox2 most show another table.How i to do that?
Hi All! I have a zip code table that has the zip code, city, state and various other info in each row. The problem is that if I pull up all the cities in a zip code (say 33308) I get the same city spelled twice like this: [CODE]Fort Lauderdale …
Hello everyone! I've created a mailing list where users can subscribe with a form, and the results are added to a MySQL database. They can also unsubscribe. The subscribe/unsubscribe pages work GREAT, but the page where I send out the email is giving me some trouble. It says that the …
[CODE] <?php echo '<script type="text/javascript"> if(confirm("Your time has expired. Do you want to logout?")) alert("Five minutes were added on too your session"); //User will five minutes added on else alert("You are logged out"); //User will be loged out </script>'; ?> [/CODE] How do I put in PHP code inside the …
Good morning everyone, I could be crazy but I am starting to work more on both my php skills and my mySQL skills, forgive me if I am asking the wrong question in the right forum or vice versa. [B]My objective[/B] I am building a script so when I log …
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 There. I have a property website, which already has some extensive search criteria for users to filter which properties they would like to see. I need to add to the search queries that fact that only properties which are within 21 days from the date they were submitted should …
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 …
OK, I'm making items in webbased game and dunno how to design the db well to be able to use well this is the one i made but dunno its nice or no, gonna be hard to use anyway, what i need it item type which is Potion,Gem,or equipment ... …
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 …
Does anyone else see the problem here? i get ""userdetails did not match"" But the $myusername is set correct. [CODE]error_reporting(E_ALL); if($_POST['tSubmit']){ $points = $_POST['pointamount']; $price = $_POST['price']; $reciever = $_POST['reciever']; $mypassword = $_POST['mypassword']; $myusername = $_POST['myusername']; include "../db_connect.inc.php"; $sql= "SELECT password, loginid FROM login WHERE username = '$myusername'"; $result = …
Afternoon, I am currently the Webminister for [url]http://www.calontir.org/[/url] and am overseeing the transfer of our Web site from [url]http://www.calontir.info[/url] to our new address. I am having issues with moving our Order of Precedence (OP) database. The original OP database: [url]http://calontir.info/herald/op/[/url] The original pages work fine with the exception of one …
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){ …
Greetings! I'm trying to solve a little problem that occurs when I try to kinda make an associative array out of an associative array. I wish to associate 2 fields coming from mySQL so I can make a simple associated print for the records I want (and I do not …
The End.