from what i was reading what it does is, say if you had a column called cust_num and wanted to display this to someone who has not set the table up and did not know what the column names where for or...

found out what it means now it is pseudo names for the columns. What it does is gives the names of the columns being used more suitable names to make it easier for people to know what data the...

i have just had to go into the backend of an old site to fix the mysql db as some had deleted the wrong db. i have got most of it working again now but did not know what this line of code is doing....

thanks for the reply you are also a great help

thanks for the reply. sorry i took so long to get back i am in the middle of creating a user guide for the email system. so if i run that code and where it says local host could i change that to...

is it possible to create a new db on the server with a new user name and password without having to login to the phpmyadmin section on the control panel on the server?

i have had a look around but...

i am just trying to replicate the error now i will get post my results back in a minute.

when i didint have the mysql_errno in and just the mysql_error it was saying that the error was on line 15 which was the fourth one down in the table create syntax. i got the tables set up in the...

i am trying to set up this db and i am getting a parse error which it says it is on line 24 i cannot see the error. help need

$sql="CREATE TABLE IF NOT EXISTS `merc_users` (

`****` int...

have had to move some file across from one server to another and i am now getting access denied for user. it also says it could not connect to the server.

i have changed the site path so it is...

the end code look like this

$query = "SELECT sent_messages FROM email_count"or die(mysql_error());
$results = mysql_query($query);
$arr = mysql_fetch_array($results);
$sent_mail = $arr[0];
...

yes sorry i worke it out before then got distracted with something else here is the code that i ended up with.

mysql_query("UPDATE email_count SET sent_messages = sent_messages + $i")

i have...

is it possible to add a number to a number that is stored in mysql db without extracting the stored number first.

i have a count and i am updating the count periodically but i would like to know...

i got the code working using this

$query = "SELECT sent_messages FROM email_count"or die(mysql_error());
$results = mysql_query($query);
$arr = mysql_fetch_array($results);
$sent_mail = $arr[0];

i have created a table to store the number of a count which i need for some subtraction at a later date. when i try to get the information out of the table instead of getting the number 5 i am...

is it correct and this is why i get no reply. or is no one playing out?

after i have run my query on a mysql db how can i set the result to equal a variable that i will use later on in the page.

i have set the query up like this

<?php
$rand = rand (0, 100); ...

is it possible to only truncate one row from a table or can this only be done with the whole table.

thanks for the help.

this is were my problem lies though. i have been able to hard code images in to the html code and send this out as an email newsletter but when the images from the database are used they do not show...

it is possible to display images in an email i have already got some of them to display on the email that is being sent out but none of the images from the databases will display within the email.
...

i am trying to send out an email which contains images from a database of images that have been uploaded. when i send the email out only the text and any images that have been hard codeing in using...

that is working like a dream now thanks for all your help with this it would have been very hard without your help.

if you ever in Liverpool, England let me know i will take you out for a drink...

i was looking at the truncate table command but it is just as easy to do either i think and it would have the same outcome would it not.

if i create a page which deletes the tables and only...

would this be the correct code to use t drop the table and then create the table after it has been dropped.

IF EXISTS DROP TABLE images_tad;

$sql="CREATE TABLE IF NOT EXISTS `images_tad` (...

the problem i am having with the tables is that the data inside them is getting duplicated each the user enters a new image and it is then displaying the images more than once on the screen. could i...

when i set up the table it looked like this

`id` INT NOT NULL AUTO_INCREMENT,
`broad1` varchar (250) not null,
`broad2` varchar(250) not null,
primary key (id)

so when i set the where clause...

that code now gives me the error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

it does not like the while loop for some reason.

line 58 is the while loop line

i have changed the code now so it is only trying to display one row from the table but i am getting an error which is as follows but do you no what this means.


Wrong parameter count for...

i have set an id counter but when i try to set the where clause to id=1 it does not like the while loop on the preview page. the path is being stored to the database fine but i think it is storing...

on the preview page the code used to display the image which is

$query = "SELECT * FROM images_broad";
$result=mysql_query($query);

while($row=mysql_fetch_array($result, MYSQL_ASSOC)){...

the changes made to the code on the last thread do not work it just keeps throwing up errors.

should the where clause look something like this

$sql="UPDATE images_broad SET broad1='$broad1name2' WHERE broad1=`1`";

if this line is correct it is effecting the preview page. when that...

i have set my tables up so that each image that is uploaded has its own column. as it has its own column should it still need a where clause because there should only be one record in each column.

the problem i am getting now is that on the other pages that i have just set up it is not storing anything to the mysql tables. i have created the tables on a new php page and set them to only...

no if the name file is changed then the browse button disappears. the reason for the images getting replaced must have something to do with how the mysql is displaying them.

the type=file part of the form does this not mean that this is a browse button i have not changed this yet but if i put [icode]type=file1[/code] would the file browse button still appear?

i will...

each file upload has its own page so would this the name file matter or does this need to be different each time a new upload it completed.

if you go to www.acmert.co.uk/mercury this is what i have been working on. not all of it is set up yet but if you login (i will give you the password in a private message) and then click on the...