Search Result

Grimmerson · Jun 7 '12, 01:18 PM

I have a piece of code that isn't working. I'm trying to upload a few pictures to my database code is as follows:

Upload Form:

Code:

<input type="hidden" name="supplier_number" value="<? echo ''.$_REQUEST["supplier_name"].'' ?>" />
<tr>
<td>Picture 1:
<td><input type="file" name="image1[]" />
<tr>

...

newbie93 · Jun 4 '12, 08:30 PM

Hey guys. I'm working on a database with 3 tables, some with overlapping information. A few columns from each table can be updated by the user via the web app that I am creating. But... There is an issue. Not sure what it is, but my updates aren't happening. I am wondering if something is wrong with my query. (Actually, after debugging, I am quite certain there is).

Code:

	if (empty($errors)) { 	
		$query1 = "UPDATE owner SET

...

newbie93 · May 31 '12, 04:01 PM

Hi everyone - I need a way to turn a column in my table into a list. Basically, my table consists of: userId, name, and "role" (0 or 1). I want to write a function that outputs a list of usernames. This is what I have:

Code:

 
         function checking_query() {
		global $connection;
		$query = "SELECT GROUP_CONCAT(userId) FROM owner";
		$result = mysql_query($query, $connection);
		confirm_query($result);

...

Hatem Salem · May 28 '12, 09:53 AM

Hi

Am trying to create a table called (sub_categories ). This table have two columns :

sub_category_id : Primary (int)
parent_category id: not null (int)

Both tables reference the column (id) from categories table. When i try to creating the table it gives me the error :

ERROR 1005: Can't create table 'shoppingcart.s ub_categories' (errno: 150)

Here is the SQL syntax...

thelionheart · May 25 '12, 10:33 AM

Please help i got a problem in visual basic .net and im using visual studio 2010
when I run program to display records from database to listview i encountered a problem in immediate window and it says:

A first chance exception of type 'System.Reflect ion.AmbiguousMa tchException' occurred in Microsoft.Visua lBasic.dll

I encountered that problem when one of my data field in recordset is null and the program doesn't display...

newbie93 · May 22 '12, 08:46 PM

Hello everyone,
I am wondering if it is possible to check *which* rows were updated when a user edits a field.
This is my problem: I have a list of users and it is important that no usernames are repeated. I have already created a function that checks if the username already exists in the database when a user is intially added. However, I am not sure how I can check if, once the username field is *updated*, if the newly updated field...

ridwan · May 16 '12, 06:12 AM

Is there any way the table data in Mysql will be automatically updated from the Access database after exporting the first time?
My Access table is updated every hour. How can i synchronize the transfer of data between the two database?

newbie93 · May 14 '12, 07:41 PM

Hi, so this issue has been driving me crazy for the entire workday. I hope someone can help; I am sure it is trivial.
I am trying to access a user in a database based on their id. The id is auto incremented and thus unknown to the person accessing the user. I have created the functions below for accessing user information:

Code:

	function get_user_by_id($user) {
		global $connection;
		$query = "SELECT * ";

...

chocomon · May 13 '12, 07:34 PM

Hi, i want to code a .php file that will take information from an sql database based on a search query and then put the retrieved data into an html table that i've created within another file

essentially, i'm trying to 'add students' into a club table...

my current php code posts my collected data

Code:

<?php

mysql_connect ("localhost", "testuser","")  or die (mysql_error());

...

newbie93 · May 11 '12, 03:33 PM

Hi experts,
I am working with a table in a database (mysql) that keeps track of the users. The table fields are id, privilege (ie person's position in a committee -- a number mapping to a position name), username, and first and last name.

The privilege field is to be a scroll-down menu. I have created a simple one in HTML (let me know if you'd like me to post code), but then I realised that the selected item will not actually...

charles07 · May 4 '12, 04:23 AM

how can i get records by the latest date. ie. select last inserted records. mysql db structure below

Code:

timestamp  method  id comment
2009-01-10 getThud 16 "....."
2009-01-10 getFoo  12 "....."
2009-01-10 getBar  12 "....."
2009-01-11 getFoo  12 "....."
2009-01-11 getBar  12 "....."

desired results

Code:

timestamp  method  id comment

...

selvasoft · May 2 '12, 08:59 AM

I want to display all images from my MYSQL database using PHP coding.The table having name,size,type, content fields. Please any one help me.

Code:

while($row=mysql_fetch_row($imgresult))
{
	header("Content-type: image/jpeg");
	echo "$row[0]";
}

Am using above code to display one image from table. But i dont know to display more than one images on browser. Please any one help...

sreesrinivas1 · Apr 25 '12, 05:45 AM

Code:

<?php
$todb            = 'localhost';
$fromdb          = 'test1.deftlogic.com';
$smstable        = sms;
$paid_bribetable = bd_paidabribe;
$countertable    = tab3;

//connecting to the local database
$con = mysql_pconnect($todb, 'dtestfor_ipab', 'IaMzieU3#b%$'); //servername,username,password
if (!$con) {
    die("couldn't connect");
}

mysql_select_db("dtestfor_IPAB_db",

...

sreesrinivas1 · Apr 24 '12, 09:37 AM

hi all i have two servers each having a table in them, i'm able to connect to them using php. But when i try to select the values from one table of a server to insert them into another table in another server that is not working even i had given all the privileges can one show me how to do that.....

Code:

<?php

$dblink2 = mysql_pconnect('test1.deftlogic.com', 'dtestone_ipab','!*D-pD)g5)FJ'); // connect server 2

...

richardsith · Apr 23 '12, 10:10 AM

Hello everyone,
I've a problem with 2 select form and MySQL.
The first one lists all items, using 2 buttons I can transfer 'n remove items on the second form. The transfer works well, I'd have to record more idems(array) sent to second form on a db MySQL.
If I select just 1 element I see it on db, but if the selection is more then 2 items I see only the last one selected.
I don't know how to correct that, may you help me...

Search Result

uploading pictures to Mysql with PHP.

Is something wrong with my query?

clarification on GROUP_CONCAT()

error 150: Can't create table

A first chance exception of type 'System.Reflection.AmbiguousMatchException' occurred

Is it possible to check which fields were changed?

auto table update of mysql database from access database

Undefined index

How to put information from sql database into html table

keeping track of user input

select records by latest date

How to display all images from MYSQL using PHP

mysql-php error message

selecting values from a table of one server to insert them into another server by php

sending items to db MySQL from the second select form