10,940 Topics
 | |
| | Hi! I need to know if theres a function that is simmilar to mysql_insert_id function where it gets the last inserted id but the thing is my id is not auto increment i tried doing the select statement but not working my scenario is: i am updating a record from …  |
| | [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 … |
 | |
 | how to get mysql username and password using java of the MySQL install on system.  |
| | 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, I'm creating a web page which links to a mysql database. I have managed to get all of the data to appear in a table and i have also been able to get the combobox to be populated based on a table in the database. The part which I … |
| | i try to put picture in mysql with vb.net, first i convert with this function : [CODE]Public Function convertImage(ByVal myImage As Image) As Byte() Dim mStream As New MemoryStream() myImage.Save(mStream, System.Drawing.Imaging.ImageFormat.Jpeg) Dim myBytes(mStream.Length = 1) As Byte mStream.Position = 0 mStream.Read(myBytes, 0, mStream.Length) Return myBytes End Function[/CODE] i try to …  |
| | 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 … |
| | I have a time stored in table 8:00AM-9:30AM TTH . I want to check time range, if user selected 9:00am-10:30am Thursday comes in between time 8:00AM -9:30AM TTH? How to trap it out in php. Time is stored in table as below Time Day 8:00AM -9:30AM TTH 10:30AM -12:00PM MW … |
| | [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, I'm currently working on a school project ..i was wondering if someone can help, i'm creating a system which get's data from a database and creates a CSV file ..i Google a lot none of it helps, i want to get several rows from a table and write it … |
| | GOOD DAY. Is there any application that would convert my MS Access database to MySQL? It takes time for me to reconstruct my tables in Access to MySQL. If there is/are application that would make my work easier, please let me know. Thanks |
| | 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] |
The End.