7,368 Topics
| |
Alright, for some odd reason, the below syntax is incorrect. I have successfully connected to the database on previous lines, now i'm trying to create a table. The error I get is: [QUOTE]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … | |
Hi I am having a bad day! I am running an INSERT INTO and SELECT query which is working. One of the SELECT parts is: [CODE](SELECT title FROM exp_forum_topics WHERE topic_id = p.topic_id) AS post_subject,[/CODE] which brings back a title. What I want to do is prefix this title with … | |
hi all, i need to display time table for students and staff my table design looks like --------------| timtable --------------| classid hour subjectcode day --------------| --------------| Working hours --------------| hour starttime endtime --------------| --------------| timtable --------------| classid hour subject code day --------------| --------------| subjectmaster --------------| subjectcode subjectname subjecttype . . … | |
Hello, First let me start of by saying that I am new to javascript and ajax, but I thing I need them to accomplish what I am trying to do and here it is. I have there search forms, 1 search owner, 2 search contractor, 3 search properity. Then I … | |
Hi I am working on web for some group, but i have problem my code is [ICODE]<?php session_start(); $username = $_POST['username']; $password = $_POST['password']; if ($username&&$password) { $connect = mysql_connect("http://mysql.ic.cz/phpmyadmin/","USERNAME","PASSWORD") or die("Nemůžu se připojit"); mysql_select_db("vy_promm") or die("Nemůžu najít databázi"); $query = mysql_query("SELECT * FROM uživatelé WHERE username='$username'"); $numrows = mysql_num_rows($query); … | |
[CODE=php] <?php include('variables/variables.php'); ?> <div id="header"> <?php include ('includes/db-zelf.php'); // define your database connection credentials mysql_connect( $db_host, $db_user, $db_password ) or die(mysql_error()); mysql_select_db( $db_database ) or die(mysql_error()); /* KUBAGES */ $Luchtvr = mysql_query("SELECT * FROM Luchtvrachtpalletten WHERE ID='1'") or die(mysql_error()); while($Luchtvra = mysql_fetch_array( $Luchtvr )) { $kuubid = $Luchtvra['ID']; $kuubvol … | |
hi all i have 2 systems connected in lan.i have to access the system 1 Database from system2 using mysql odbc connector.if i give localhost in the hostname then give username and password of system2 in the corressponding places now i can get the list of databases from system2 mysql … | |
I am attempting to send the data from a set of radio buttons to my MySQL Database so that I am able to get people to review the site. When I did my initial test with a single radio button in a test database all went well, however when I … | |
I have problem with saving entry to mysql.. first entry saved but it doesnt work with second, somehow the save_new button didnt respond at all.. then i use saveandclose button it works or after i restart the pc the save_new button function will do it job for the first entry … | |
I Need to to update multiple checkbox values on multiple records at the same time. When the form loads, it should display the sizes already selected for each style as stored in the style table and if we select or deselect any sizes on a style it should update the … | |
Good Morning. Could someone tell me how you would go about doing a query to just get records that have an email account with(hotmail.com or msn.com or live.com) I'm sure I could do it by selecting the entire DB and sorting them in PHP based on exploding the email field, … | |
| [ICODE]$w3 = mysql_query( "SELECT * FROM w3" ) or die("SELECT Error: ".mysql_error()); $worth = mysql_query( "SELECT * FROM worth" ) or die("SELECT Error: ".mysql_error()); // fetching data while ($get_w3 = mysql_fetch_assoc($w3db) && $get_worth = mysql_fetch_assoc($worth)) { // Loading Urls for Comparing echo $w3url=$get_w3['domain']; // cant echo echo $worthurl=$get_worth['domain']; // ok … |
Hi all, hope I can get some help. I am very very new to PHP so bare with me. I am doing a system that has information about cars. My drop downs are populated with MySQL data (working ok) I want to have one drop down for Make of car, … | |
Hey I have to make statistics to call from base I have for example one line of [CODE]<p>Mesna zajednica <select name="mesto"> <option value="donji_grad">Donji Grad</option> <option value="karadjordjev_dud">Karadjordjev Dud</option> <option value="plavinac">Plavinac</option> <option value="seone">Seone</option> <option value="ladna_voda">Ladna Voda</option> <option value="lestar">Lestar</option> <option value="zlatno_brdo">Zlatno Brdo</option> <option value="slavija">Slavija</option> <option value="papazovac">Papazovac</option> <option value="carina">Carina</option> <option value="sveti_sava">Sveti Sava</option> <option value="25maj">25. … | |
hello how can distinct data of select mutiple column having repeated data. example id name city locality 1 deep b 11 2 rohit b 11 3 deep c 12 4 mohit c 11 5 rohit a 13 6 moni a 13 from above table, what query i used to fetch … | |
Hi, i recently found an sql injection vulnerability on a server, In the db, there's a table named users and inside there's the username: admin and password : ******* Is knowing this password enough to hack the server ? Thanks | |
Hi I tried to insert russian language to mysql db but after inserting ,I am getting some strange things in database INSERT INTO table(adtex) VALUES('1с бухгалтерия 7 Cкидка 42% на 1С:Предприятие 8 базовые версии!'); Output adtex | +----------------------------------------------------+ | 1? ??????????? 7 C????? 42% ?? 1?:??????????? 8 ?? Plz guide … | |
| [CODE]include ("config.php"); // select data from database $w3db = mysql_query( "SELECT * FROM w3dbx" ) or die("SELECT Error: ".mysql_error()); $worth = mysql_query( "SELECT * FROM worth" ) or die("SELECT Error: ".mysql_error()); $w3db_rows = mysql_query($w3db); $worth_rows = mysql_query($worth); // fetching data //while ($get_infox = mysql_fetch_assoc($resultx) && $get_info = mysql_fetch_assoc($result)) while ($get_w3db … |
For a couple of months now I've been working on a community website; however I haven't got past the registaration because MYSQL can't connect to my HTML and PHP codes.Also my laptop treats .PHP documents as text documents and I can't open them, is this related? Thanks in advance :D. | |
Can anybody tell me how many storage engines are there in MySQL and which engine is the default engine in MySQL? Kindly post answer if know it | |
Hi All! I'm trying to read ms word documents stored in my dataBase in a BLOB column. However, concerning the encodings there are issues with characters. My web application can read the ms word documents the to an iframe with POIFSFileSystem without problems. [CODE] File docFile = null; [COLOR="Green"]WordExtractor[/COLOR] docExtractor … | |
Hello! On my website I'm looking to create a dynamic HTML table from the contents of a MySQL database. I have no idea how many rows there will be, and I need it to look a bit like an iPhone home screen. Here is some code: v1: // Make a … | |
I was browsing a MySql database using phpMyAdmin and I have probably inadverdently changed a setting. I have a field which contains quite large text entries. Before this problem arose the display showed just a few words of the text entry followed by a "...". Now the display shows the … | |
Hi Everyone, I have been trying to understand mysql a little further - with some small steps in the right direction. but I have come across a problem I am unable to fix / get working. I have a form, that has a variable $country - I am trying to … | |
So I've got this piece of code: [CODE=php] /* BEGIN ZENDINGEN */ $zendingheader = mysql_query("SELECT z.ID, z.Bestemming, z.Datum, m.Aantal_Duiven, s.Aantal_Manden FROM Shipments AS s JOIN Zendingen AS z ON s.Zending_ID = z.ID JOIN Manden AS m ON s.Mand_ID = m.ID WHERE z.Actief = 1 order by s.Aantal_Manden, m.Aantal_Duiven ASC LIMIT … | |
I am trying to create at user search for my website and I'm not sure where to start. My table name is users with user_id, user_name, name I'd like to be to search and have a page come up with the top 5 closest results. Sorry if this question has … | |
hi friends.. I need an alternate query without using UNION for below query.. [CODE]select DIST_NO from acquired_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' union select DIST_NO from transfrd_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched'[/CODE] | |
I have 2 tables: 1. users - user_id(PK), firstname, middlename, lastname 2. user_shift_schedule - shift_code(PK), user_id(FK), effectivity_date I want to get all rows with the latest effectivity_date for each user_id. This is what I've got so far: [CODE]SELECT users.user_id ,users.firstname ,users.middlename ,users.lastname ,user_shift_schedule.shift_id ,MAX(user_shift_schedule.effectivity_date) FROM users JOIN user_shift_schedule ON users.user_id=user_shift_schedule.user_id … |
The End.