Search DaniWeb - msql

msql data transer problems 20 Years Ago by flameifrit I am tring to complete a project for university using msql, php, apache and phpmyadmin(local) The main basis for this …;php 4.3.9 >phpmyadmin 2.6.1 >msql servers and clients 3.23.49 >apache http server… MSQL SELECT MAX(sup_id) where data type is char(7) (Plz Help me Out)) 13 Years Ago by Moss ali i want to select MAX Id where i have the list database s001.1 s001.2 s001.3 s001.4 s002.1 s002.2 s002.3 s002.4 upto so On my field type is char(7) MSQL SELECT MAX(sup_id) where data type is char(7) plz help me out to perform this query in SQL. how to view image in Msql 17 Years Ago by mrcniceguy … can view the images which i sent to msql database, i open the msql console, and type the folowing but nothing displayed…,6,7,8,9 numbers of images i sent to msql. But Image diplayed nothing. I need help in this. If… Re: how to view image in Msql 17 Years Ago by mrcniceguy …> <head> <title>view images from MSQL</title> <meta http-equiv="Content-Type… sorting msql on VB.net 14 Years Ago by ninjatalon … clicks on "sort" it will alphabetically sort the msql table by last name and reupdate that on the Combobox… Want a totally free excel convert to MSQL program anybody know? 14 Years Ago by dgcerk369 I have a webmaster that got a problem converting excel to Msql and i want to help him along with a software or other solution that converts excel to msql database. thanks SQL Server vs MYSQL vs MSQL (i'm stopping now) 23 Years Ago by AlPhA So... what is better, SQL, MYSQL, MSQL, POSTRESQL, and etc for a fast database that must be used in conjunction with asp and php. For now, i'm looking for the easiest database to be used in conjunction with ASP. Any suggestions? [flash]http://www.geocities.com/cyberpitstop/footer.swf[/flash] Chat Codes + Sign up MSQL help 14 Years Ago by dyla123 …. I have the form but i am not good with MSQL and a DB. I have a host that supports all… Multiple image upload into server using msql. 12 Years Ago by moblyft … images. I want to save the image name into my msql database and save the actual image into a folder in… Re: Multiple image upload into server using msql. 12 Years Ago by moblyft The pgp manual doesnt really explain how to save the images into the msql and server folder it seems. Converting website to Wordpress - now no clickable images using php msql 12 Years Ago by arjay1 … non-clickable images and poorly aligned display. Since the php, msql, array etc all run OK and every image is displayed… Re: Converting website to Wordpress - now no clickable images using php msql 12 Years Ago by LastMitch **@arjay1** >Converting website to Wordpress - now no clickable images using php msql Have you post this on the **Wordpress** forum? The reason why I ask it's because it's their products. **Wordpress** has forum for issues/questions related to webpages/templates and their platform. How to make notification when msql column reach a certain number? 11 Years Ago by logicaweb Hello, I'm trying to make notification when msql column reach a certain number. For exemple, I have table &… Unable to connect to MSQL 9 Years Ago by Stephano … they login, they get this "Unable to Connect to Msql" error. this also happens when i login to th… Re: MSQL SELECT MAX(sup_id) where data type is char(7) (Plz Help me Out)) 13 Years Ago by tjaank try this: [CODE] declare @temp TABLE (this char(7)) INSERT INTO @temp VALUES('s001.1') INSERT INTO @temp VALUES('s001.2') INSERT INTO @temp VALUES('s001.3') INSERT INTO @temp VALUES('s001.4') INSERT INTO @temp VALUES('s002.2') INSERT INTO @temp VALUES('s002.3') INSERT INTO @temp VALUES('s003.3') SELECT 's' + CAST(MAX(SUBSTRING(this, 2,… Re: MSQL SELECT MAX(sup_id) where data type is char(7) (Plz Help me Out)) 13 Years Ago by Moss ali Thank you so much. Re: MSQL SELECT MAX(sup_id) where data type is char(7) (Plz Help me Out)) 13 Years Ago by Moss ali When it return max in this condition s003.3.Then i want to increment in S003.3 S003.4 and so on dynamically parametrically.Please give me suggestion how to achieve.Thanks Re: MSQL SELECT MAX(sup_id) where data type is char(7) (Plz Help me Out)) 13 Years Ago by tjaank i did'nt understand what do you want. but may be u want something like this: [CODE]declare @temp TABLE (this char(7)) INSERT INTO @temp VALUES('s001.1') INSERT INTO @temp VALUES('s001.2') INSERT INTO @temp VALUES('s001.3') INSERT INTO @temp VALUES('s001.4') INSERT INTO @temp VALUES('s002.2') INSERT INTO @temp VALUES('s002.3') INSERT INTO… Re: How to display part of text from msql 16 Years Ago by Martin59 Hi, I having the same problem with displaying text from msql. ex: i have a file called language_pt.php, inside i … Re: import csv pdo msql 10 Years Ago by cereal Add `errorInfo()` as suggested in my [**first post.**](https://www.daniweb.com/web-development/php/threads/481885/import-csv-pdo-msql#post2107312) From there you can see why the query fails. Msql. Insert data depending on which form field is filled out. 16 Years Ago by stevehart808 Hi, Just hoping someone could point out how to do this: Users can either [COLOR="Red"]insert a link to audio or upload audio[/COLOR]. Rather than have 2 separate fields in my mysql table (that would lead to more probs) I want to insert depending on which form field has been entered. ie if I upload the audio, then php inserts the … Re: Msql. Insert data depending on which form field is filled out. 16 Years Ago by scaraffe You could use the isset() function of php. You have to check which post variable is set like isset($_POST[var]). This returns 1 if the values is set else it returns a 0. Before inserting it in the db u could check which option the user has chosen. Re: Msql. Insert data depending on which form field is filled out. 16 Years Ago by almostbob examine the data validate it to your requirements if a file or url check whether it exists if a file upload to temporary space on the server if a file check whether it is an appropriate file type, not just an appropriate filename if a url ensure that it is a media file, on a server that permits off site linking then create a query and … Re: Msql. Insert data depending on which form field is filled out. 16 Years Ago by jrdark13 Like what I think is stated above, you probably want to go by upload first meaning [CODE] //Before should be all other variables like $site,$containingfolder, etc if(isset($_FILES['uploadedfile']['tmp_name'])){ $url = $site.$containingfolder.$_FILES['uploadedfile']['tmp_name']; }elseif(isset($_POST['url'])){ $url = $_POST['url']; }else{… msql problem 14 Years Ago by kgizo hi i'm new to php, i already have a database called msansi its table called provinces i've already created a drop down list of all my nine provinces now what i want to do is, i want the cities associated with the provinces to display on the same page as the drop down list i.e if you click on gauteng the cities in gauteng have to appear on the same … Re: msql problem 14 Years Ago by jrotunda85 If I understand you correctly, you are trying to populate a drop down list from your database? If so, try this: [CODE=php]<select name="xx" value="xx"> <?php $con = mysql_connect('localhost','root',''); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db('msansi', $con); $query =… Re: msql problem 14 Years Ago by stefh Hi, if i understand well the options of the select contain the names of the provinces, and you want the name of the cities related to the selected province to be displayed on the same page when the user makes a choice in the dropdown menu... That's correct? You need to use javascript, and certainly php. That means [URL="http://www.w3schools.… Re: msql problem 14 Years Ago by kgizo thanxx @ jrotunda85 i'm sorry i'm only replyin to your response i'm gonna try the code out now. @ stefh your correct thats exactly what i want to do but i cant use ajax cause i'm using codelobster and it doesn't support ajax, and the name of the cities are stored under the column name BODY in the database table.thanxx 4 showing interest @ stefh Re: msql problem 14 Years Ago by kgizo Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in C:\xampp\htdocs\CodeIgniter_1.7.3\system\application\views\ndivhuhoview.php on line 47 which is line 19 on your code i do have an id field which is my primary key i tried changing value to id and $row['value'] to $row['id'] but it still shows the same error, my id field … Re: msql problem 14 Years Ago by jrotunda85 [QUOTE=kgizo;1489143]Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in C:\xampp\htdocs\CodeIgniter_1.7.3\system\application\views\ndivhuhoview.php on line 47 which is line 19 on your code i do have an id field which is my primary key i tried changing value to id and $row['value'] to $row['id'] but it still shows the same …