cristi08

I don't understand why I canot $_POST $row[Oras]. I get UNDEFINED VARIABLE :[CODE] <p><?php $qorase="SELECT Oras FROM oras"; if (isset($qorase) && !empty($qorase)) { echo"<!--" . $qorase . "-->"; $result = mysql_query($qorase) or die ("invalid query 4: " . mysql_error ());} ?> <select name="option" > <?php while ($row = mysql_fetch_array($result)){ echo …

[CODE] $id_subramura1=$row['id_subramura1']; $display_block.="<li><a href=\"".$_SERVER["PHP_SELF"]."?id_subramura1=" .$id_subramura1."\">".$Denumire_Subramura1."</a></strong></li>"; print_r($_GET); if($_GET["id_subramura1"] === "") echo "a is an empty string\n"; if($_GET["id_subramura1"] === false) echo "a is false\n"; if($_GET["id_subramura1"] === null) echo "a is null\n"; if(isset($_GET["id_subramura1"])) echo "a is set\n"; if(!empty($_GET["id_subramura1"])) echo "a is not empty";[/CODE] How it possible to echo "a is null" when is …

I have: tbl CATEGORIE with column: id_categorie ,Name; Tbl Subramura1 with columns:id_subramura1, id_categorie, Name_subramura1; Tbl Subramura2 with columns:id_subramura2, id_subramura1, Name_subramura2; Tbl Subramura3 with columns:id_subramura3, id_subramura2, Name_subramura3; Complete name=id_subramura1+id_subramura2+id_subramura3; How to make a tree navigation for a catalog list? I Try with $_SERVER['PHP SELF'] and GET but it not working.

My tree for navigation it not showing the third level [CODE] $display_block.="<li><a href=\"".$_SERVER["PHP_SELF"]."?id_subramura1=" .$id_subramura1."\">".$Denumire_Subramura1."</a></strong></li>"; } if (isset($_GET["id_subramura1"])) { if($_GET['id_subramura1']==$id_subramura1) $query2 = "SELECT * FROM subramura_2 where id_subramura1='".$id_subramura1."' order by Denumire_Subramura2"; if(isset($query2) && !empty($query2)) { echo"<!--" . $query2. "-->"; $result2= mysql_query($query2) or die ("invalid query 4: " . mysql_error());} $display_block .="<ul>"; …

I have a tree that is not working to third level....something it wrong with the $_GET id_subramura1 [CODE] $display_block.="<li><a href=\"".$_SERVER["PHP_SELF"]."?id_subramura1=" .$id_subramura1."\">".$Denumire_Subramura1."</a></strong></li>"; } [COLOR="Green"] if (isset($_GET["id_subramura1"])) { if($_GET['id_subramura1']==$id_subramura1)[/COLOR] $query2 = "SELECT * FROM subramura_2 where id_subramura1='".$id_subramura1."' order by Denumire_Subramura2"; if(isset($query2) && !empty($query2)) { echo"<!--" . $query2. "-->"; $result2= mysql_query($query2) or die …

Why the browser output blank page on index.ph?

Hellow everybodi... I succed to finish my first web site on local machine and i bought a host services and a domain name. After uploading files and mysql database I have only a huge blank page on index ....something it not wright.... Please help ....

Hello I have a form for a shoping cart that input even the value 0. How can i program php to not insert into table the products [CODE]$row['Denumire_produs'][/CODE] where the quantyti=$cantitate is 0 Here is the form input[CODE]$query="select*from produse"; ?> <form action="cumpar.php" method="post"> <td><input type="text" name="cantitate[]" value=" " size="1"/></td></tr> <input …

Hellow peoplw. I have an update syntax that is doing something else than I expect. I want to update a table with price of the products for a selected user the form is ok but when I click update the order update only the last price inserted.Why? [CODE]p> Here you …

What it want from me? [CODE]<?php if (isset($_POST['submit']) && $_POST['submit'] == "Update") { $query_update = "UPDATE preturi SET preturi = '" . $_POST['preturi'] . "' WHERE username = '" . $_SESSION['user_logged'] . "' AND password = '" . $_SESSION['user_password'] ."'"; $result_update = mysql_query($query_update) or die(mysql_error()); $query = "SELECT * FROM …

Hellow programmers, today I stuk on a new one,This time is a $_Get sintax that give me error like so :"invalid query 4: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''36''' at …

Who can repair this it really a wizard. I try to add a column to an existing table. It a compound foreign key column from ather two. [CODE]ALTER TABLE valoare_lucrari ADD COLUMN id_oferta FOREIGN KEY (id_ofertant, id_proiect) REFERENCES valoare_lucrari(id_ofertant, id_proiect)[/CODE] It may be a problem of sintax or even it …

I have a table with two columns and I need to set a new foreign key or compound column like: [CODE]COMPOUND COLUMN 1 2 1 a B 1 a B 2 a C 2 a C 3 b D [/CODE]

what is wrong here? [CODE]ALTER TABLE valoare_lucrari( ADD CONSTRAINT fk_oferta FOREIGN KEY (id_ofertant,id_proiect)references(id_ofertant,id_proiect))[/CODE]

Hellow programmers, I have a table with two columns as foreign keys and I need to obtain a composite foreign key. what is the correct sintax? Alter table..... Thank you in advance

ex: If user=1 send to user1.php page or if user=2 send to user2.php. else redirect to user page login page.

Example of GRAND TOTAL, TOTAL1 TOTAL2 TOTAL 3 SUBTOTAL 1, SUBTOTAL 2 SUBTOTAL 3 How many chairs we have in our village? Grand total chairs in houses =total chair in house A + total chair in house B Total chair in house A = TOTAL CHAIR IN ROOM 1 + …

I have tbl 1 id_column(1 2 3 ) tbl 2 id_column(1 1 1 2 2 3 3 3) I need result tbl2 join with tbl 1 values (3 3 3) Thank you in advance i'm strugling from two days for this.

I have tbl 1 id_column(1 2 3 ) tbl 2 id_column(1 1 1 2 2 3 3 3) I need result tbl2 join with tbl 1 values (3 3 3) Thank you in advance i'm strugling from two days for this.

IT NOT WORKING :(( [CODE] $igletuire="INSERT INTO valoare_lucrari (id_ofertant, id_manopera, id_camera Denumire_camera, um, Cantitate, Pret_manopera, Total )VALUES( '" . $row['id_ofertant']. "', '" . $row['id_manopera'] . "', '" . $row['id_camera'] . "', '" . $row['Denumire_camera'] . "', '" . $row['um'] . "', '" . $row['Sgletuire'] . "', '" . $row['Pret_manopera'] . …

Why the checkbox is not working? it echoing "interest Array" [code] $_POST['interest'] ; foreach($_POST as $field => $Value) { echo "$field,$Value<br>"; }[/code]

What the best choice for speed, but for security? It very important to know because I do not know how large this online database will be, and can be very unplesent to discover after one week from going uploaded that the aplication has crash.

Today is a long day ! I wish to replace the entire old data from a table with new one. Update is not helping me cause i do not have an autoincrement field. What to do? Thank you in advance

It sais Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given on line74 and I tried a lot of things. here is code [$query="SELECT * FROM specificati,ofertant,suprafete,preturi,manopera WHERE ofertant.id_ofertant=preturi.id_ofertant AND preturi.id_manopera='Montaj parchet' AND preturi.id_manopera=manopera.id_manopera AND specificati.id_camera=suprafete.id_camera "; if (isset($query) && !empty($query)) { echo"<!--" . $query . "-->"; $result=mysql_query($query) or …