help with mysql+php

[xNuminous]

im wondering if anybody could help me... I need to make a page that displays data from a database, these are tables town and price.

Eg
Town            | Price
stevenage        5
Hitchin            6
Letchworth      10
thats how it would be displayed

i also need a page to edit/add data to this

if anyone could help/assist it would be much appreciated and credit will be given

thanks in advance, xNuminous.

[jsladek]

Not much info there. Are town and price two different tables?

[xNuminous]

yeah, i just need a basic php page that will display it as shown like in a html table or something

and as for the edit/add page anything will do i just need to be able to add/edit/delete towns/prices from the 2 tables

thanks, xNuminous

[jsladek]

post the sql to create the tables and I'll give you 1 script for each table, that might help you get started.

[xNuminous]

i already have the tables created i just need to be able to display it edit/add/delete

[jsladek]

You have the tables but I do not, I can hook you up with some code to do the basic CRUD functions for each table but I would need to create the tables in my MySql database.  If the information is coming out of two tables then what I was planning on doing for you is probably not exactly what you are looking for anyhow but it would be a good start.

I don't suspect anyone here is going to be able to give you exactly what you are looking for with the info you have provided..

Regards,
John Sladek

[Caesar]

If Town and Price are two diferent tables in your database, I'm curious as to how on earth you're relating the price to each town.  ;) Unless you're leaving something else out. I suggest you go do some reading before tackling these things. And not just jump in blind. Doing that, will actually slow down the learning process.

Anyway, you want something to tie the two together. In this very simple example, you have two tables, where records can relate to each other via a unique identifyer such as an id.

Table = "town"
====================
[color=blue][u]      id      [/u]|[u]      town      [/u]
      1      |    Compton
      2      |    Watts
      3      |    San Diego
      4      |    Long Beach[/color]
====================

Table = "price"
====================
[color=blue][u]      id      [/u]|[u]      price      [/u]
      1      |      10
      2      |      5
      3      |      20
      4      |      15[/color]
====================

[code]<?php

  $query = $db->query("SELECT * FROM price WHERE id = '$town[id]'");
  $price = $db->fetch_array($query);

?>[/code]

I hope you can understand why I showed the above examples. And you need to write seperate functions to edit/delete. Querying the database for displaying it, is only part of what you want to do. Short of someone here doing it for you, we can't do much more than point you in the right direction. (http://www.php.net)

[xNuminous]

hm... yeah i dunno how to explain it any better

1 database - mysql called database1

2 tables - town and price

but caesar what you said is right, sorry im not entirely sure what other information to give you

i just need the 2 tables displayed next to each other like caesars example but both next to each other

sorry for the hassle everyone and thanks for the help

[xNuminous]

friendly bump...

[jpratt]

my question is this: is there a relation between town and price? can each town have many prices? or does one town have one price and one price have one town? I am failing to understand what you are doing with town and price.

[xNuminous]

1 town has 1 price
eg
stevenage - 12 etc

kinda like how was said before where each town and each price has an id and they need to be displayed next to each other

[jpratt]

why do you need two tables then? what would be the purpose? Why not have 1 table with 3 fields?

[xNuminous]

sorry im not very good with php and mysql its for a company to do with driving lessons, its done in several areas and the prices changes now and again and as you can see im not very good with php/mysql so more  than anything we need a way of editing/adding/deleting the feilds like a very simple version of phpadmin

sorry for all the problems but thanks for the help

[Caesar]

I'll code it & do the database design for a percentage of your fee. :-P

[jpratt]

This would be a very simple app. Would only need a few simple SELECT, UPDATE, and DELETE statements and a few pages. nothing to difficult. Just read up on some simple principles of mysql and read up on php and how to interact with a mysql db and you should not have any problems with it. A day or two worth of reading should have you up and going.

[xNuminous]

would anyone be able to help code this? its for a project so it wont be used for the real thing but ill still give you credit

[craygo]

We would be able to help no problem, but as stated before, there is no relation from the town table to the price table

you say

stevenage - 12

but how is that going to happen. You may know stevenage is 12 but there is no way the query will know. In order for it to work you would have to create a relation

table 1 "town"
====================
      id      |      town          | priceid   
      1      |    Compton      |  1
      2      |    Watts          |  3
      3      |    San Diego    |  2
      4      |    Long Beach  |  2
====================

Table = "price"
====================
      id      |      price     
      1      |      10
      2      |      5
      3      |      20
      4      |      15
====================

now you can see that Compton is priceid 1 which is 10 and Watts is priceid 3 which is 20 and so on. You just cannot make a query with 2 tables without relating them.

Ray

[jpratt]

or just create one table as that is how they belong.

[xNuminous]

if it is easier as said before to put it in 1 table with 2 fields? and thank you i appreciate your help

[xNuminous]

friendly bump... =]

[jpratt]

I would not have the time for this until monday as I am going out of town. Please let me know if you still need it then.

[trq]

What was the bump for? What part exactly are you stuck on?

[jsladek]

"like a very simple version of phpadmin"

Please try this..  http://www.iobe.net/proj/

If you need help with it, let me know... I have an in with the developer....

When I asked you to post the SQL to create the tables this is what I was going to run for you....


-Regards
John Sladek