10,945 Topics
 | |
| | Hello community, can anyone provide me the answers please? I am not a MySQL guy, i know that this is not an excuse, but this is how it is. Thanks in advance. [CODE]Employee (**Employee ID**, Employee Name, Employee Last Name) Director (**Employee Code**) Cashier (**Employee Code**) Customer (**Code Card**, Customer … |
| | Where can I get a free mysql thesaurus database? I would literally like to download a .sql file, and just upload it straight to my mysql host. I would just want in the thesaurus... Word Synonym #1 It would be great if it also had... Part of Speech Synonym #2 … |
| | hello guys i am working on DATABASE and teacher me to make header and sub header tables in it...i am not getting it that wot are header and sub headers |
| | <?php // Inialize session session_start(); include('config.inc'); // Check, if username session is NOT set then this page will jump to login page if (!isset($_SESSION['username'])) { header('Location: index.php'); } ?> <html> <head> <title>Secured Page</title> </head> <body> <?php $result = mysql_query("SELECT user.password, data1.dob FROM user INNER JOIN data1 ON user.username = data1.username …  |
| | [B]Problem:[/B] I have a zip_code/city/state table that has full names and abbreviations for some common things like FT (FORT) and IS (ISLAND). So, I may have a record something like this: zip = '31522' city = '[COLOR="red"]IS [/COLOR]HARBOR POINTE' locationtext = 'Is Harbor Pointe' location = 'US-GA-[COLOR="red"]IS [/COLOR]HARBOR POINTE' and … |
| | 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> … |
| | |
| | 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...  |
 | 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 … |
| | 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 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 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. …  |
| | hi , i ma using the reporting service in MS SQL express 2008. but in the company i don't have the admin previlages to upload and create reports to the server. if i was to ask from the administrator to grant me the previlages what previlages does he have to … |
| | [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 …  |
| | 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! |
| | 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 … |
| | 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 …  |
| | 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 … |
The End.